CiviCRM Community Forums (archive)

I was upgrading from 3.2.3 to 3.3.1 and saw this error in my logs. I'm sorry but I can't be sure whether it was during or after the upgrade. There was no error on my screen or any odd behaviour. Sorry I can't be more specific.

Dec 12 17:30: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] =>
SELECT sort_name name, cc.id
FROM civicrm_contact cc
     
WHERE cc.is_deceased = 0 AND  cc.id IN (  )
       AND cc.is_deleted = 0
LIMIT 0, 20
 [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 ')
       AND cc.is_deleted = 0
LIMIT 0, 20' at line 4]
    [type] => DB_Error
    [user_info] =>
SELECT sort_name name, cc.id
FROM civicrm_contact cc
     
WHERE cc.is_deceased = 0 AND  cc.id IN (  )
       AND cc.is_deleted = 0
LIMIT 0, 20
 [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 ')
       AND cc.is_deleted = 0
LIMIT 0, 20' at line 4]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT sort_name name, cc.id
FROM civicrm_contact cc
     
WHERE cc.is_deceased = 0 AND  cc.id IN (  )
       AND cc.is_deleted = 0
LIMIT 0, 20
 [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 ')
       AND cc.is_deleted = 0
LIMIT 0, 20' at line 4]"]
)


Dec 12 17:30:53  [info] $backTrace = /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 205
, handle,
/var/www/citybibleforum/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/var/www/citybibleforum/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2421
/var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1607
/var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 145
/var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 868
/var/www/citybibleforum/sites/all/modules/civicrm/CRM/Contact/Page/AJAX.php, executeQuery, 620
, getContactEmail,
/var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/Invoke.php, call_user_func, 186
/var/www/citybibleforum/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 356
, civicrm_invoke,
/var/www/citybibleforum/includes/menu.inc, call_user_func_array, 348
/var/www/citybibleforum/index.php, menu_execute_active_handler, 18

Ken[/code]

I also encountered a problem upgrading from 3.3beta3 to 3.3.1 - my results have been more catastrophic. When the update took much longer than usual, I stopped the process - which was a mistake. I got an error saying that there was a problem with the database that looked like a partial upgrade and now the host (with command line access) is attempting to restore the old database - which is over 300mb.

They're getting an error:

ERROR 1064 (42000) at line 3911805: 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

And they're now trying to force the import.

I'd say there's something wrong with the upgrade process - any ideas as to how to solve import of large SQL files is greatly appreciated!

@bcobin,

Your error sounds much more serious than mine.

Can I suggest you start your own thread? You might get better attention to the problem.
Can you include more detail of that error? "1064" means an SQL syntax issue, but the very helpful folks on this forum will need something more to chew on.

Ken

The problem was that I used PHPMyAdmin to export the database, which failed due to the large size of the DB. Hence I was trying to restore an incomplete database, hence the restore error.

Luckily, my host (Imageleet - they're great) was able to do restore the original database before I hosed it; I suppose I'll need to do backup (and restore, if necessary) via command line in future. (The Civi DB was about 700mb, of which only about 300mb was successfully exported.)

Still continuing on this thread, though, because the whole reason for this was that the update seemed to take much longer than usual and I think it may actually have timed out - the upgrade process usually takes less than a minute; I was hanging for about 15, as I recall.

I'll need to test the upgrade locally on sandbox "mirrors" of the production sites - I'm wary of performing this particular upgrade on "live" sites at the moment...