Critical error on search page after upgrade to 1.5.20

[St. Anger]

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:

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.

[Brooklyn]

Access /cpg/error_log and/or forum/error_log and post the data contained therein.

[Jeff Bailey]

You could also turn on debug mode to see the full error.

[St. Anger]

Here's the error from the log:

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.

[Jeff Bailey]

Looks as if it's working now. Did you change something?
Nevermind, didn't look as close as I needed too.

[Jeff Bailey]

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?

[St. Anger]

I assume you have localhost as the dbserver?

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

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.

[Joe Carver]

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

Is it also a 'www' address?

[St. Anger]

Is it also a 'www' address?

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

[St. Anger]

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.

[St. Anger]

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

[Αndré]

That's an MySQL permission issue. Your Coppermine database user isn't allowed to use the SELECT command on your board's database:

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

[St. Anger]

Seems to be fixed now, thanks