Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

wuschel_lux

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 93
    • 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: 15764
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: 93
    • 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: 15764
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.05 seconds with 20 queries.