CiviCRM Community Forums (archive)

Joomla 1.5.7.
CiviCRM 2.1beta6
Joomla DB is a demo of our live site with the MySQL database build from a backup (some missing components, but nothing major)

Here is the problem; on a contribution I'm getting the following:

backTrace

/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1587
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Dedupe/Finder.php, query, 101
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php, dupesByParams, 928
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php, processOnBehalfOrganization, 420
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 247
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 197
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/admin.civicrm.php, invoke, 45
/home/pemphig1/public_html/demo/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
/home/pemphig1/public_html/demo/libraries/joomla/application/component/helper.php, require_once, 162
/home/pemphig1/public_html/demo/administrator/includes/application.php, renderComponent, 130
/home/pemphig1/public_html/demo/administrator/index.php, dispatch, 67
/home/pemphig1/public_html/demo/administrator/index2.php, include, 14

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: unknown error

    Database Error Code: Column 'id' in field list is ambiguous, 1052

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [c o d e] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT id
                FROM dedupe JOIN civicrm_contact USING (id)
                WHERE contact_type = 'Organization'
                GROUP BY id HAVING SUM(weight) >= 10
                ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]
    [type] => DB_Error
    [user_info] => SELECT id
                FROM dedupe JOIN civicrm_contact USING (id)
                WHERE contact_type = 'Organization'
                GROUP BY id HAVING SUM(weight) >= 10
                ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id
                FROM dedupe JOIN civicrm_contact USING (id)
                WHERE contact_type = 'Organization'
                GROUP BY id HAVING SUM(weight) >= 10
                ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]"]
)

You can feel free check it out at demo.pemphigus.org or the admin side at demo.pemphigus.org/administrator username: civicrm, password: civicrm

Please contact me with some ideas here.

Thanks
Will

5.2.5
No specific settings...just standard stuff I believe.


This is from my cPanel:


Hosting package   siteground
Server Name   serv01
cPanel Version   11.23.3-RELEASE
cPanel Build   25623
Theme   sg
Apache version   1.3.37 (Unix)
PHP version   5.2.5
MySQL version   4.1.22-standard-log
Architecture   i686
Operating system   Linux
Shared Ip Address   67.15.250.2
Path to sendmail   /usr/sbin/sendmail
Path to PERL   /usr/bin/perl
Kernel version   2.6.24.3-grsec-sg1
cPanel Pro   1.0 (RC1)

I'll check that out.

Question: I have several databases in use for Joomla (1.5), Wordpress 2.6.2, Moodle, and others. Will trying to upgrade my mySQL from 4 to 5 cause a problem? I know it is "depends" but do you have a best guess?

I think the value reported by Cpanel is the Mysql client version, my cpanel reports the same thing but really I have mysql 5.  Try Drupal, Reports, Status, that tells you the real version.