I'm using PHP Version 5.2.17. When I search my gallery, I get an error:
Critical error
There was an error while processing a database query
The error log says:
Nov 03, 2012 at 02:00 AM - While executing query 'SELECT COUNT(*) FROM cpg15x_pictures AS p
LEFT JOIN `hcdz_phpn1`.phpbb_users AS u ON p.owner_id = u.user_id
WHERE ((title LIKE '%5/2/11%' OR caption LIKE '%5/2/11%' OR keywords LIKE '%5/2/11%')) AND approved = 'YES' ' in include/search.inc.php on line 266 the following error was encountered:
SELECT command denied to user 'hcdz_cppr1'@'localhost' for table 'phpbb_users'
Link to gallery: http://www.beyondbeautifuljlo.com/gallery/
It is bridged with my phpbb3 forum.
It looks like the error goes all the way back to September when the gallery was first created.
Please turn on debug mode.
also check the mysql permissions for hcdz_cppr1
Quote from: Angel_Eyez on November 03, 2012, 09:34:47 PM
SELECT command denied to user 'hcdz_cppr1'@'localhost' for table 'phpbb_users'
OK, I enabled debug mode.
Permissions is "All privileges".
Thanks in advance!
Quote from: Angel_Eyez on November 06, 2012, 02:21:43 AM
Permissions is "All privileges".
Is this true for both your Coppermine database and your phpBB database?
You obviously have SELECT privileges in CPG, otherwise there would be plenty more problems.
Yes, All privileges on both.
Does it work when bridging is disabled?
Hi Jeff,
I just tried, and it works when bridging is disabled.
Please follow all the steps here:
http://documentation.coppermine-gallery.net/en/bridging.htm#integrating_support_start
Hopefully one fixes the issue.
I did some searching realizing it could be a bridging issue and found that the fix was here: http://coppermine.svn.sourceforge.net/viewvc/coppermine?view=revision&revision=8391
I updated the files and it works properly now! Thanks for your help!!! :D
Great! Glad you found the answer.
Please resolve your thread.
Quote from: Joachim Müller on September 28, 2008, 12:46:26 PM
Resolve your threads
If you have found an answer to your question, resolve your thread. Don't just post "I have found the answer", but tell others what you actually did to solve your issues. Posting a link to the page where you found the answer might help. Describing what you did might help as well. Finally, you can 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.