CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • DB Error
Pages: [1]

Author Topic: DB Error  (Read 1455 times)

vasacampana

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.5.4
  • CMS version: Joomla 3
  • MySQL version: 5.5
  • PHP version: 5.3
DB Error
October 12, 2011, 01:05:01 am
civicrm-3.3.6-joomla installed on
PHP Built On                               Linux wh03.spin.it 2.6.26-1-xen-686 #1 SMP Fri Mar 13 22:30:40 UTC 2009 i686
Database Version                    5.0.51a-24+lenny5-log
Database Collation                  utf8_general_ci
PHP Version                            5.2.6-1+lenny13
Web Server                                    Apache
WebServer to PHP Interface    cgi-fcgi
Joomla! Version                            Joomla! 1.7.1 Stable [ Ember ] 26-Sep-2011 14:00 GMT
Joomla! Platform Version            Joomla Platform 11.2.0 Stable+Modified [ Omar ] 27-Jul-2011 00:00 GMT
User Agent                                    Mozilla/5.0 (X11; Linux i686; rv:7.0) Gecko/20100101 Firefox/7.0

Installation was OK, and db upgrade OK.
Configuration setting works fine.
But when I try to add/edit contacts I get the following error message:
Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
Error Details
Return to home page.
No more detail. But the contact has been added/modified.

When I try to sync joomla users with CiviCRM I get the following
Sorry. A non-recoverable error has occurred.
DB Error: no such table
Error Details
Return to home page.
And no user added.
Thank you for reply.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: DB Error
October 12, 2011, 02:42:58 am
Quote
Installation was OK, and db upgrade OK.
Configuration setting works fine.
But when I try to add/edit contacts I get the following error message:
Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
Error Details
Return to home page.
No more detail. But the contact has been added/modified.

We will need more info on this, what DB contraint error. Did you try logout / login

Quote
When I try to sync joomla users with CiviCRM I get the following
Sorry. A non-recoverable error has occurred.
DB Error: no such table
Error Details
Return to home page.
And no user added.

Can you make sure you have correctly set joomla user table. Administrator >> Configure >> Global Settings >> CMS integration

HTh
Kurund
Found this reply helpful? Support CiviCRM

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: DB Error
October 12, 2011, 01:46:04 pm
So did you fix your user table name? If yes did it solve your problem?

Kurund
Found this reply helpful? Support CiviCRM
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • DB Error

This forum was archived on 2017-11-26.