Critical error on search page

[wuschel_lux]

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 Expand

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,

[mboesen]

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/

[Αndré]

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.

[mboesen]

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

[wuschel_lux]

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.

[Αndré]

Fix committed in SVN revision 8580.