forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: ScHwErV on November 29, 2005, 02:53:42 am

Title: Critical Error
Post by: ScHwErV on November 29, 2005, 02:53:42 am

There was an error while processing a database query.

I enabled debug mode as another user was instructed and here is the error I got.

While executing query "SELECT id as user_id,name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg140_albums AS a INNER JOIN `eoutdoor_forum`.ibf_members as u on u.id+10000=a.category LEFT JOIN cpg140_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 12 " on 0

mySQL error:

ScHwErV

Title: Re: Critical Error
Post by: Nibbler on November 29, 2005, 10:32:22 am

Pickup this updated version of the bridge core:

http://forum.coppermine-gallery.net/index.php?topic=24212.msg111706#msg111706

Title: Re: Critical Error
Post by: ScHwErV on November 29, 2005, 01:11:50 pm

Perfect, excellent, stupendous.

Many thanks.

ScHwErV   8)