I've been running my gallery just fine for months now... I have my gallery and phpBB forum intergrated... so their in the same database. I've been doing some mods to my phpBB forum, and I just realised that sudnelly my coppermine is broke. I have no idea why... the mods shoulden't have touched any of the coppermine tables... I can find the 2 or so mods that did database changes if you would like... anyways here is the error i'm getting...
While executing query "SELECT count(*) FROM cpg132_pictures WHERE 1" on 0
mySQL error: Access denied for user: 'pcguy@localhost' (Using password: NO)
On this page...
http://www.spudfiles.com/gallery/Why in the heck does it say using no password?
I'm not sure what to check... but I did a DB backup just a day or 2 ago when it all worked... I was looking at the cpg132_pictures table structure (since it mentions it in the error) and I found there are 2 differences from when I backed it up the other day from today when it's not working... both of these have been added
`lasthit_ip` tinytext,
and
KEY `owner_id_2` (`owner_id`),
*beep* is going on? Is there a way I could sort of have it rebuild that table so it works again?
Edit - I looked through the mods i've done so far and there were 2 php files that I had to run to edit the DB. Here they both are in this ZIP...
http://www.spudfiles.com/changes.zipAfter testing I don't believe that it was log_actions_db_update.php that did it, because that mod came with a DB Uninstaller, I ran it and I still had the error, so it must be title_install.php
Also this is from the debug...
==========================
VERSION INFO :
------------------
PHP version: 4.3.9 - OK
------------------
<br />
<b>Warning</b>: mysql_query(): Access denied for user: 'pcguy@localhost' (Using password: NO) in <b>/home/pcguy/public_html/gallery/include/functions.inc.php</b> on line <b>1524</b><br />
<br />
<b>Warning</b>: mysql_query(): A link to the server could not be established in <b>/home/pcguy/public_html/gallery/include/functions.inc.php</b> on line <b>1524</b><br />
<br />
<b>Warning</b>: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in <b>/home/pcguy/public_html/gallery/include/functions.inc.php</b> on line <b>1525</b><br />
mySQL version:
------------------
Coppermine version: 1.3.2
Hehe... everything still uploads fine and such... it's just that large error right there :p
I've checked the config file and everything in there is correct, and I checked the CHMODing on the 2 folders and they are both correct.
I'm stumped.... hopefully one of you guys can tell me *beep* happened... I don't see how premission is being denied but everything is still working fine???