CiviCRM Community Forums (archive)

Hi,

I am receiving a "DB Error: Syntax Error" when updating information (such as a password change) in the Joomla User Manager.  I have listed out the CiviCRM error log below.  I am using Joomla 2.5.18, and have tried it with Joomla 2.5.19 and 2.5.20 - same problem.  I am using CiviCRM v4.3.7.
Any help to direct me to the issue would be appreciated!
-Craig

CiviCRM log:
May 18 17:33:04  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES
        ( 1, 1460, 'admin@mysite.net',  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES
        ( 1, 1460, 'admin@mysite.net',  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES
        ( 1, 1460, 'admin@mysite.net',  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2]"]
)


May 18 17:33:04  [info] $backTrace = #0 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#4 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#5 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...", "DB_Error", TRUE)
#6 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#9 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#10 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#11 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#12 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...", TRUE)
#13 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/plugins/system/civigroupsync/civigroupsync.php(77): CRM_Core_DAO::executeQuery("INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id) VALUES\n...")
#14 [internal function](): plgSystemCiviGroupSync->onUserAfterSave((Array:19), FALSE, TRUE, FALSE)
#15 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/event/event.php(71): call_user_func_array((Array:2), (Array:4))
#16 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/event/dispatcher.php(161): JEvent->update((Array:4))
#17 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/user/user.php(831): JDispatcher->trigger("onUserAfterSave", (Array:4))
#18 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_users/models/user.php(198): JUser->save()
#19 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/application/component/controllerform.php(694): UsersModelUser->save((Array:14))
#20 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_users/controllers/user.php(106): JControllerForm->save()
#21 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/application/component/controller.php(761): UsersControllerUser->save()
#22 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/components/com_users/users.php(21): JController->execute("save")
#23 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/application/component/helper.php(383): require_once("/var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/component...")
#24 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/component...")
#25 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_users")
#26 /var/www/vhosts/healthenterprisesnetwork.com/httpdocs/administrator/index.php(46): JAdministrator->dispatch()
#27 {main}