Critical error when searching

[Angel_Eyez]

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.

[Jeff Bailey]

Please turn on debug mode.

also check the mysql permissions for hcdz_cppr1

SELECT command denied to user 'hcdz_cppr1'@'localhost' for table 'phpbb_users'

[Angel_Eyez]

OK, I enabled debug mode.

Permissions is "All privileges".

Thanks in advance!

[Jeff Bailey]

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.

[Angel_Eyez]

Yes, All privileges on both.

[Jeff Bailey]

Does it work when bridging is disabled?

[Angel_Eyez]

Hi Jeff,

I just tried, and it works when bridging is disabled.

[Jeff Bailey]

Please follow all the steps here:
http://documentation.coppermine-gallery.net/en/bridging.htm#integrating_support_start

Hopefully one fixes the issue.

[Angel_Eyez]

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!!!

[Jeff Bailey]

Great! Glad you found the answer.

Please resolve your thread.

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.