Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Critical error on search page after upgrade to 1.5.20  (Read 5247 times)

0 Members and 1 Guest are viewing this topic.

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Critical error on search page after upgrade to 1.5.20
« on: August 27, 2012, 04:22:51 am »

I upgraded from 1.5.18 to 1.5.20 last night and bridged my gallery with IPB 3.3. Everything works as expected, except when my members try to use the search page this error is displayed when you click the submit button:

Quote
Critical error
There was an error while processing a database query

http://www.bootlegcoverart.com/gallery/search.php

The page worked fine before the upgrade.
Logged

Brooklyn

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Critical error on search page after upgrade to 1.5.20
« Reply #1 on: August 27, 2012, 07:23:57 pm »

Access /cpg/error_log and/or forum/error_log and post the data contained therein.
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 on search page after upgrade to 1.5.20
« Reply #2 on: August 27, 2012, 10:46:53 pm »

You could also turn on debug mode to see the full error.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Critical error on search page after upgrade to 1.5.20
« Reply #3 on: August 27, 2012, 11:08:41 pm »

Here's the error from the log:

Quote
Aug 27, 2012 at 04:08 PM - While executing query 'SELECT COUNT(*) FROM gallery_pictures AS p
            LEFT JOIN `forum`.members AS u ON p.owner_id = u.member_id
            WHERE ((title LIKE '%Testing%' OR caption LIKE '%Testing%' OR keywords LIKE '%Testing%' OR filename LIKE '%Testing%')) AND approved = 'YES' ' in include/search.inc.php on line 266 the following error was encountered:
SELECT command denied to user 'USER'@'alexandriaprofessional.com' for table 'members'

I changed my database username and removed the table prefixes in the above error message. I have no idea where that "alexandriaprofessional.com" is coming from, that's not my information.... What do I do about that? I just upgraded to CPG 1.5.20, so all those files should be new. My forum was upgraded maybe a month ago, though CPG 1.4.x was running for a couple weeks after the forum was upgraded. The forum and gallery were bridged during that time, but I never experienced any errors, including after I upgraded to CPG 1.5.18. This started immediately after I upgraded to CPG 1.5.20. I checked my forum and gallery config files, they have the correct database information.
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 on search page after upgrade to 1.5.20
« Reply #4 on: August 28, 2012, 12:38:16 am »

Looks as if it's working now. Did you change something?
Nevermind, didn't look as close as I needed too.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error on search page after upgrade to 1.5.20
« Reply #5 on: August 28, 2012, 01:15:43 am »

Both your website and that alexandriaprofessional.com have the same nameservers, maybe your host messed something up.
I assume you have localhost as the dbserver?
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Critical error on search page after upgrade to 1.5.20
« Reply #6 on: August 28, 2012, 01:54:22 am »

Quote
I assume you have localhost as the dbserver?

No, I have a specific MySQL URL using my domain name.

Quote
Both your website and that alexandriaprofessional.com have the same nameservers, maybe your host messed something up.

I could check with my host, I guess. Seems weird that it started right after I upgraded.
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Critical error on search page after upgrade to 1.5.20
« Reply #7 on: August 28, 2012, 02:30:41 am »

No, I have a specific MySQL URL using my domain name.

Is it also a 'www' address?

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Critical error on search page after upgrade to 1.5.20
« Reply #8 on: August 28, 2012, 02:41:09 am »

Quote
Is it also a 'www' address?

It's in this format: mysql.example.tld
Logged

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Critical error on search page after upgrade to 1.5.20
« Reply #9 on: August 29, 2012, 07:37:13 pm »

I sent a support request to my hosting provider, but they don't seem to know what's causing it and everything appears to be functioning as it should on their end.

Could my gallery have been hacked in some way? I don't understand why only the search page has this problem--the gallery obviously connects to the database fine on every other page, and my forum doesn't have any problems. I even reuploaded fresh copies of all the CPG 1.5.20 files, and the problem still exists.
Logged

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Critical error on search page after upgrade to 1.5.20
« Reply #10 on: September 03, 2012, 07:30:20 am »

I discovered that the error only happens when my gallery is bridged to my forum (IPB 3.3.4). If unbridged, the search page works fine. I tried replacing all my forum files with fresh copies, but the error still occurs. Not really sure what to do now...
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error on search page after upgrade to 1.5.20
« Reply #11 on: September 03, 2012, 03:13:22 pm »

That's an MySQL permission issue. Your Coppermine database user isn't allowed to use the SELECT command on your board's database:
Quote
SELECT command denied to user 'USER'@'alexandriaprofessional.com' for table 'members'

If I remember correctly I already fixed that issue in our SVN repository. Try to apply the changes of revision 8391: http://coppermine.svn.sourceforge.net/viewvc/coppermine?view=revision&revision=8391
Logged

St. Anger

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Critical error on search page after upgrade to 1.5.20
« Reply #12 on: September 03, 2012, 06:46:52 pm »

Seems to be fixed now, thanks
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.