forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 bridging => Topic started by: Angel_Eyez on November 03, 2012, 09:34:47 pm

Title: Critical error when searching
Post by: Angel_Eyez on November 03, 2012, 09:34:47 pm
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.
Title: Re: Critical error when searching
Post by: Jeff Bailey on November 05, 2012, 10:31:49 pm
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'
Title: Re: Critical error when searching
Post by: Angel_Eyez on November 06, 2012, 02:21:43 am
OK, I enabled debug mode.

Permissions is "All privileges".

Thanks in advance!
Title: Re: Critical error when searching
Post by: Jeff Bailey on November 06, 2012, 02:47:35 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.
Title: Re: Critical error when searching
Post by: Angel_Eyez on November 07, 2012, 01:13:54 am
Yes, All privileges on both.
Title: Re: Critical error when searching
Post by: Jeff Bailey on November 07, 2012, 10:31:57 pm
Does it work when bridging is disabled?
Title: Re: Critical error when searching
Post by: Angel_Eyez on November 08, 2012, 01:22:52 am
Hi Jeff,

I just tried, and it works when bridging is disabled.
Title: Re: Critical error when searching
Post by: Jeff Bailey on November 08, 2012, 01:58:14 am
Please follow all the steps here:
http://documentation.coppermine-gallery.net/en/bridging.htm#integrating_support_start

Hopefully one fixes the issue.
Title: Re: Critical error when searching
Post by: Angel_Eyez on November 09, 2012, 01:08:26 am
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
Title: Re: Critical error when searching
Post by: Jeff Bailey on November 09, 2012, 01:13:45 am
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.