forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: wuschel_lux on June 14, 2013, 10:23:48 am

Title: Critical error on search page
Post by: wuschel_lux on June 14, 2013, 10:23:48 am

Hi all,
I have a problem with the search page. I always get a critical database query error, when searching on a "Title"...
Here in the forum I found some similar problems, but they were related on bridged mode.

I am running a 1.5.24 release.
URL to the live site: www.volleyball.lu/fotogallery/

Here the error message, debug file is attached:

Code: [Select]

Critical error
There was an error while processing a database query.

While executing query 'SELECT COUNT(*) FROM cpg15x_pictures AS p
            LEFT JOIN `web858u1`.cpg15x_users AS u ON p.owner_id = u.user_id
            WHERE ((title LIKE '%RSRW%' OR caption LIKE '%RSRW%' OR keywords LIKE '%RSRW%')) AND approved = 'YES' ' in include/search.inc.php on line 267

mySQL error: Column 'title' in where clause is ambiguous
Hope someone could help me.
Thank's and regards,

Title: Re: Critical error on search page
Post by: mboesen on August 22, 2013, 11:52:46 am

I am having the same problem. Critical Error when searching. If I turn TITLE off it works fine.

Have been looking for a solution in the Forum, but can't seem til locate it and I have been trying to find a place to exclude Title from the search options. Haven't found that either.

Any help?!

My webshop is located here:
http://www.boesenfoto.dk/gallery/

Title: Re: Critical error on search page
Post by: Αndré on August 22, 2013, 04:42:24 pm

As the users table doesn't contain a "title" column by default, I assume some plugin has added it.

mboesen, do you use one or more of the following plugins?

• onlinestats
• final extract
• keyboard navigation
• cpgshop
• html 5 upload
• external tracker
• file replacer

I suspect the cpgshop plugin, but I haven't checked all the plugins.

Title: Re: Critical error on search page
Post by: mboesen on August 23, 2013, 08:04:02 am

André...

I do use cpgshop!

I did find the following

http://forum.coppermine-gallery.net/index.php/topic,75955.msg366487.html#msg366487

and it seems to work

Title: Re: Critical error on search page
Post by: wuschel_lux on August 23, 2013, 08:22:32 am

Hi André and mboesen,

thank's for the hint! I think the common plugin is the cgpshop, and with the code change mboesen refered to, I can confirm that my search is working again without problems.

Many thanks guys.

Title: Re: Critical error on search page
Post by: Αndré on August 26, 2013, 10:07:46 am

Fix committed in SVN revision 8580.