CiviCRM Community Forums (archive)

Drupal 6.10 and Civi 2.1.4

I've seen this error on two different parts of my website today.. registering for an event, and trying to modify a custom listing in a user profile.. it's totally re-producable... as in, broken!..   I am not a database expert but I am trying to track this down.. I don't know if it's a database issue, or a profile issue or.. both?

Sorry. A non-recoverable error has occurred.

DB Error: no such field

Database Error Code: Unknown column 'id' in 'from clause', 1054

Return to home page.

 

Also, this script appears above the message:

 

backTrace

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138

, handle,

/home/tacs/www/www/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966

/home/tacs/www/www/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394

/home/tacs/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1587

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 144

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Dedupe/Finder.php, query, 97

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Event/Form/Registration/Confirm.php, dupesByParams, 708

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Event/Form/Registration/Confirm.php, updateContactFields, 372

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63

/home/tacs/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203

/home/tacs/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232

/home/tacs/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197

/home/tacs/www/www/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315

, civicrm_invoke,

/home/tacs/www/www/includes/menu.inc, call_user_func_array, 348

/home/tacs/www/www/index.php, menu_execute_active_handler, 18

 

And this script appears below the message:

 

Error Details:

Array

(

    [callback] => Array

        (

            

• => CRM_Core_Error
[1] => handle

        )

 

    

=> -19

    [message] => DB Error: no such field

    [mode] => 16

    [debug_info] => SELECT id

                FROM dedupe JOIN civicrm_contact USING (id)

                WHERE contact_type = 'Individual'

                GROUP BY id HAVING SUM(weight) >= 10

                ORDER BY SUM(weight) desc [nativecode=1054 ** Unknown column 'id' in 'from clause']

    [type] => DB_Error

    [user_info] => SELECT id

                FROM dedupe JOIN civicrm_contact USING (id)

                WHERE contact_type = 'Individual'

                GROUP BY id HAVING SUM(weight) >= 10

                ORDER BY SUM(weight) desc [nativecode=1054 ** Unknown column 'id' in 'from clause']

    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id

                FROM dedupe JOIN civicrm_contact USING (id)

                WHERE contact_type = 'Individual'

                GROUP BY id HAVING SUM(weight) >= 10

                ORDER BY SUM(weight) desc [nativecode=1054 ** Unknown column 'id' in 'from clause']"]

 



Well, I am building a whole new site on 3.x because our 2.x site is a mess and won't upgrade...  posted about it on here a while back, but got no where.. so I am doing 3.x from scratch.. but I still have this site to deal with at the moment..

MySQL is 5.0.82

This just started happening a few days ago.  The site had been working for the past year...  I haven't upgraded anything lately.  I am just trying to track this down.  I think it may be profile related but I am still unsure.