CiviCRM Community Forums (archive)

I have a site with Drupal 6 and CiviCRM 4.1.5. When someone logs in they see:

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT GROUP_CONCAT(contact_id) as contactStr
FROM   civicrm_group_contact
WHERE  group_id = 297
AND    status = 'Added'
AND    contact_id IN ( c )
 [nativecode=1054 ** Unknown column 'c' in 'where clause']
    [type] => DB_Error
    [user_info] =>
SELECT GROUP_CONCAT(contact_id) as contactStr
FROM   civicrm_group_contact
WHERE  group_id = 297
AND    status = 'Added'
AND    contact_id IN ( c )
 [nativecode=1054 ** Unknown column 'c' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT GROUP_CONCAT(contact_id) as contactStr
FROM   civicrm_group_contact
WHERE  group_id = 297
AND    status = 'Added'
AND    contact_id IN ( c )
 [nativecode=1054 ** Unknown column 'c' in 'where clause']"]
)
I am uncertain as to why. I thought perhaps we could empty the User-Contact table (uf_match) and then run the Synch tool and see if that helps, but the uf_join also has a lot of data and I'm not sure if that would be rebuilt. I would of course like to upgrade this site, but I think we should fix this issue first.

Anyhow, any ideas about the error above?