Author Topic: Getting DB Error: Syntax Error when updating Joomla user record (Read 703 times)

tso2085 · May 13, 2014, 09:47:07 pm

Joomla 2.5.18, Civi 4.3.7

Receiving error when I try to update any user record in Joomla. CiviCRM log reports the following:

Code: [Select]

May 14 00:35:53  [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]

Can someone point me to why this may be happening and what I can do to correct it?

Thanks!
Craig

CiviCRM Community Forums (archive)

News:

Author Topic: Getting DB Error: Syntax Error when updating Joomla user record (Read 703 times)

tso2085

Getting DB Error: Syntax Error when updating Joomla user record