Advanced search  

News:

cpg1.5.48 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.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical error when trying to use search  (Read 5524 times)

0 Members and 1 Guest are viewing this topic.

vic9128

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Critical error when trying to use search
« on: November 29, 2012, 03:25:58 am »

When I try to use the search function in my gallery I keep getting the error message- "There was an error while processing a database query."

This is from my debug log--

Code: [Select]
While executing query 'SELECT COUNT(*) FROM cpg15x_pictures AS p
            LEFT JOIN `******_smp1`.smf_members AS u ON p.owner_id = u.id_member
            WHERE ((keywords LIKE '%constantine%' OR title LIKE '%constantine%' OR caption LIKE '%constantine%') AND (keywords LIKE '%i%' OR title LIKE '%i%' OR caption LIKE '%i%')) AND approved = 'YES' ' in include/search.inc.php on line 266

mySQL error: SELECT command denied to user '******_cpp1'@'localhost' for table 'smf_members'


Quote
File: /home2/victorsi/public_html/Gallery/include/functions.inc.php - Line: 270



Any suggestions on how to fix this?


thanks,
Victor

Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Critical error when trying to use search
« Reply #1 on: November 29, 2012, 09:02:28 am »

It looks like a permissions problem. You are using a bridged install with smf and the script is trying to search one of the smf tables. Does it work if you disable bridging?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error when trying to use search
« Reply #2 on: November 29, 2012, 09:16:01 am »

Looks like an issue that has already been fixed in our SVN repository. Try if it works when you apply these changes: http://coppermine.svn.sourceforge.net/viewvc/coppermine?view=revision&revision=8391
Logged

vic9128

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Critical error when trying to use search
« Reply #3 on: November 29, 2012, 04:13:20 pm »

Thanks for the replies and the help. I uploaded the files and at first search did not work, so I disabled bridging. Now the search function works, but whenever I go to the bridge manager I get this message-

Fatal error: Cannot redeclare get_meta_album_set() (previously declared in /home2/victorsi/public_html/Gallery/include/functions.inc.php:36) in /home2/victorsi/public_html/Gallery/bridge/functions.inc.php on line 96


Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error when trying to use search
« Reply #4 on: November 29, 2012, 04:24:51 pm »

Please undo your file replacement. Instead, just apply the changes of that revision (there are probably some other changes that conflict with other cpg1.5.20 files). Alternatively you could try to replace all Coppermine files with the latest SVN tarball.
Logged

vic9128

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Critical error when trying to use search
« Reply #5 on: November 29, 2012, 04:44:44 pm »

That fixed it. Thank you for the assistance!

regards,
Victor
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error when trying to use search
« Reply #6 on: November 29, 2012, 04:51:53 pm »

Please
tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.