Critical error when trying to use search

[vic9128]

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 Expand

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'

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

Any suggestions on how to fix this?


thanks,
Victor

[phill104]

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?

[Αndré]

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

[vic9128]

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

[Αndré]

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.

[vic9128]

That fixed it. Thank you for the assistance!

regards,
Victor

[Αndré]

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.