forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: vic9128 on November 29, 2012, 03:25:58 am

Title: Critical error when trying to use search
Post by: vic9128 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

Title: Re: Critical error when trying to use search
Post by: phill104 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?

Title: Re: Critical error when trying to use search
Post by: Αndré 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

Title: Re: Critical error when trying to use search
Post by: vic9128 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

Title: Re: Critical error when trying to use search
Post by: Αndré 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.

Title: Re: Critical error when trying to use search
Post by: vic9128 on November 29, 2012, 04:44:44 pm

That fixed it. Thank you for the assistance!

regards,
Victor

Title: Re: Critical error when trying to use search
Post by: Αndré on November 29, 2012, 04:51:53 pm

Please

Quote from: Joachim Müller on September 28, 2008, 12:46:26 pm

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.