Advanced search  

News:

cpg1.5.36 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.34 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical error on search page  (Read 2619 times)

0 Members and 1 Guest are viewing this topic.

wuschel_lux

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 92
    • volleyball.lu - photo gallery & shop
Critical error on search page
« 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,
Logged

mboesen

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 104
    • Boesen Photography & Design
Re: Critical error on search page
« Reply #1 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/
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15083
Re: Critical error on search page
« Reply #2 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.
Logged

mboesen

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 104
    • Boesen Photography & Design
Re: Critical error on search page
« Reply #3 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
Logged

wuschel_lux

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 92
    • volleyball.lu - photo gallery & shop
Re: Critical error on search page
« Reply #4 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.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15083
Re: Critical error on search page
« Reply #5 on: August 26, 2013, 10:07:46 AM »

Fix committed in SVN revision 8580.
Logged
Pages: [1]   Go Up
 

Page created in 0.062 seconds with 20 queries.