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:
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,
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/
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.
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
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.
Fix committed in SVN revision 8580.