CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Temporary Table Dedupe Error
Pages: [1]

Author Topic: Temporary Table Dedupe Error  (Read 2365 times)

maiasiber

  • I’m new here
  • *
  • Posts: 18
  • Karma: 0
Temporary Table Dedupe Error
September 08, 2008, 02:26:12 pm
Hi - I am having trouble getting anonymous users to sign up for an event on CiviEvent.  Every time a user gets to the final stage of the registration process, this error comes up.  I googled the error code and can't figure out what the problem is.  I'm on Drupal 6 and CiviCRM 2.1.  I recently migrated all of my data from Joomla to Drupal.  Could there be a problem with my MySQL database tables after I migrated the data????  Any help would be greatly appreciated!!

Here's the error I receive:

    Sorry. A non-recoverable error has occurred.

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: A table must have at least 1 column, 1113

    Return to home page.

Error Details:

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

       
Code: [Select]
=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE dedupe  [nativecode=1113 ** A table must have at least 1 column]
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE dedupe  [nativecode=1113 ** A table must have at least 1 column]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE dedupe  [nativecode=1113 ** A table must have at least 1 column]"]
)

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Temporary Table Dedupe Error
September 08, 2008, 10:27:23 pm
check http://forum.civicrm.org/index.php/topic,4551.0.html

Kurund
Found this reply helpful? Support CiviCRM

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Temporary Table Dedupe Error
September 09, 2008, 03:38:30 am
This is fixed on the v2.1 branch as of r16994+r16995.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

maiasiber

  • I’m new here
  • *
  • Posts: 18
  • Karma: 0
Re: Temporary Table Dedupe Error
October 06, 2008, 11:21:05 am
Hello,

I updated my RuleGroup.php file according to your fixes, but I'm getting this error (it's different from the last one).  Is there anything I can do to fix this??? Thank you in advance!



    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.

Error Details:

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

       
Code: [Select]
=> -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']"]

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Temporary Table Dedupe Error
October 06, 2008, 12:32:18 pm

this is a mysql 4.x issue

u need mysql 5.x for civicrm 2.0 and over

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Temporary Table Dedupe Error

This forum was archived on 2017-11-26.