Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical error when searching  (Read 8226 times)

0 Members and 1 Guest are viewing this topic.

Angel_Eyez

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Critical error when searching
« 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.
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error when searching
« Reply #1 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'
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Angel_Eyez

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical error when searching
« Reply #2 on: November 06, 2012, 02:21:43 am »

OK, I enabled debug mode.

Permissions is "All privileges".

Thanks in advance!
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error when searching
« Reply #3 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.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Angel_Eyez

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical error when searching
« Reply #4 on: November 07, 2012, 01:13:54 am »

Yes, All privileges on both.
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error when searching
« Reply #5 on: November 07, 2012, 10:31:57 pm »

Does it work when bridging is disabled?
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Angel_Eyez

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical error when searching
« Reply #6 on: November 08, 2012, 01:22:52 am »

Hi Jeff,

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

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error when searching
« Reply #7 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.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Angel_Eyez

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical error when searching
« Reply #8 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
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error when searching
« Reply #9 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.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford
Pages: [1]   Go Up
 

Page created in 0.11 seconds with 20 queries.