mySQL Error: Table 'cpg132_albums' already exists

[jonofezz]

Ok. I've been running Coppermine with 100% success for a good 6 months at least now. Never had any problems with it.
Current setup: PHP 5.0.4, Copermine 1.3.3, Windows 2k3 (IIS 6 obviously), using GD not Imagemajick....

Anyways... upgrades have always went good with no snag. The 1.3.2 -> 1.3.3 was the easiest and greatest thing ever....
Everything was working perfectly after that..

Yesterday however I ran into some problems with my server and had to run a 'repair' on it.
Everything turned out fine except Coppermine. Now when I goto the page, it's blank.
So I deicded to try and run the install.php again - then i get the error about not being able to write to config.inc.php.
Well nothing directory permission wise should have change. I'm positive.
As well, BASE still works fine on an internal server, which is using PHP and MYSQL to... working great.
So after a lot of frustration, I went back and looked at the permission crap - Network Service had the proper permissions (Win2K3 uses Network service rather than IUSR_COMPUTERNAME). But since I was desparate... I added the IUSR_COMPUTERNAME also to have read/write perms to /include and to /albums. Ran install.php again and now I get this...
mySQL Error: Table 'cpg132_albums' already exists
Yay obviously it already exists...
Why isn't it grabbing it in the first place?
Why is the index.php coming up with NOTHING at all?
Help!

[kegobeer]

You are trying to install Coppermine in a database that already contains Coppermine tables.  That error message would be expected.  Have you used phpMyAdmin to verify the Coppermine tables exist and the data has not been corrupted?

You received an error message saying you can't write to config.inc.php?  The installer should have stopped long before that - there's a file called install.lock that the installer looks for and, if found, halts the install process.  It's a security feature to prevent people from overwriting your installation.

You say you had problems and had to run a 'repair'.  That is a broad term.  What did you repair?  Files, directories, MySQL?  What the problem was and what you did will help the Coppermine troubleshooting process.

Have you looked at the Coppermine files and made sure they exist?  If some of them are missing, the easiest thing to do is upload 1.3.3 files.  You don't have to worry about overwriting config.inc.php, because the zip file does not have that file.  If you have a custom anycontent file, make sure to back it up before uploading the files.  You also shouldn't have to upload the /albums directory.

[jonofezz]

Yes sorry, i missed a step and I never described the issue too well.

What happened was that the computer wasn't booting. It wasn't going to the RAID SCSI for some reason and couldn't find it. So I had to reinstall the CDA1000.sys scsi raid driver. To get it to copy over, I did a Windows repair.
Yes I did run into the .lock and out of frustration, deleted it and tried to re "install.php" likely due to lack of patience. Anyways... here's where I am.
The Coppermine dir looks in good shape. Nothing else isn't working... everything else all works fine. The coppermine index.php just comes up blank like its not connecting or something.
Is there some sort of debug mode? I backed up the DB a few weeks ago. But I have a feeling this isn't the issue. Looking in MYSQL it's still there. As for ALL the table and stuff, i'm not too sure. It's not PHP as test.php works fine, BASE works fine (which also uses MYSQL).

I have not used PHPMYADMIN. Should I? Any recommendations, never used before... next step i may try... will be just to reinstall 1.3.3 into it's dir as suggested.

[kegobeer]

phpMyAdmin is a great MySQL tool.  I highly recommend getting it.  Essential for checking on your databases, and allows easy editing of tables.

Upload the 1.3.3 files as I said in my previous post.  If you didn't actually open up the Coppermine files in a text editor you can't be sure those files are not corrupted.

You can send me a PM with FTP information and I can look around.

[jonofezz]

Another thing I noticed was that the three separate coppermine install dir's I have (I use it for 3 sites and wanted them all separate), none are working. Just a blank page. I'll go and install the phpmyadmin. I'll hook you up with ftp info when I reinstall an FTP server (I usually just move things to the albums dir through the internal network here at home). I gotta run out for some BEERS for the evening. Tommorrow I'll sneak you some info. Thanks for the help.

[jonofezz]

okie dokie, what should i be doing on this phpmyadmin now?
I have it nicely internally installed here.
Oh and I use textpad for all my 'editing'.

[kegobeer]

Make a database and install a new Coppermine 1.3.3 gallery in another directory.  Can you get that working?  If so, examine your config.inc.php files and make sure your database connection strings are correct.  Make sure all IIS virtual hosts (or whatever the Windows terminology is) that point to your Coppermine galleries are correct.  If you can't get a new install working, then I would assume something is amiss in your server setup.

[jonofezz]

Made a new one, same thing. I'm not using virtual anythings. The three coppermine galleries are just in children directories of the main site. www.blah.org/photo1 www.blah.org/photo2, etc.
PHP is working fine, so it's not the server setup. It's almost like its not connecting to the database. Is there a debug mode I'm missing. All I'm getting is a bloody blank screen and frustration is peaking.

[kegobeer]

When you created the new gallery, the installation went perfectly?  No error messages?

[jonofezz]

Exactly, no errors at all that I could see. Then to the main page... and its all blank.... is there not a debug mode?
www.fezz.org/photos is an example of one of the blank pages....
This is really beginnign to piss me off... sigh.

[kegobeer]

In php.ini, do you have register_long_arrays turned on?

There is a debug mode - edit the cpg132_config table and set debug_mode to 1.

[jonofezz]

register_long_arrays is already on.
I guess I'll try and go into the table and set that... never done that before!
Here goes!

update: used PHPMYSQL to change it to 1. Did nothing. I'm not getting any msgs. What else would cause index.php to show nothing at all?
Any like I said, Base and phpMySQL working both just fine.

Look at my nice html generated from index.php...
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>
stuff is working... just not doign things properly...

[kegobeer]

Made a new one, same thing. I'm not using virtual anythings. The three coppermine galleries are just in children directories of the main site. www.blah.org/photo1 www.blah.org/photo2, etc.
PHP is working fine, so it's not the server setup. It's almost like its not connecting to the database. Is there a debug mode I'm missing. All I'm getting is a bloody blank screen and frustration is peaking.

So, www.fezz.org/leanne should drop me in the Coppermine directory, correct?  It doesn't - I end up at www.fezz.org/leanne/photos.  There is no photos subdirectory (at least nothing I can see) but the Coppermine files are in there.  There is a redirect going on, and that may be part of the problem.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>

Sorry, I get <html><body></body></html>

Again, I feel this is due to your server setup but exactly what eludes me.

You can check your MySQL connection with this link: http://forum.coppermine-gallery.net/index.php?topic=16217.msg75687;topicseen#msg75687

[jonofezz]

The server hasn't changed at all the setup, since forever (minus the repair). Mhe photos gallery is the coppermine gallery. My sis has nothing in the 'root' of her named dir so i just forwarded people over to the photos (coppermine) dir. From there it should magically pic up the index.php and giver er.
The full directories are the following:
http://www.fezz.org/photos
http://www.fezz.org/leanne/photos
http://www.fezz.org/mustache/photos

All those /photos dir is where I extracted our good friend coppermine (rename of the cpg133 dir name).
And again this was working fanastic for months.
I'm going to give the link you just gave me a whirl. Thanks for all your help.

-jon

[kegobeer]

All I can think is that the repair action somehow changed something related to the webserver.  You might want to verify your PATH information (see the PHP website for IIS setup details) is correct.

If everything worked perfectly before the error and repair, logically that means something is missing/corrupted.  We eliminated the existing gallery installs by adding a new one, which doesn't work either.

So after a lot of frustration, I went back and looked at the permission crap - Network Service had the proper permissions (Win2K3 uses Network service rather than IUSR_COMPUTERNAME). But since I was desparate... I added the IUSR_COMPUTERNAME also to have read/write perms to /include and to /albums. Ran install.php again and now I get this...

Indications of problems with the network service perhaps?  I'm at a loss at this point.  I'm confident Coppermine isn't the issue, since your galleries worked before the "crash".  You can't say "this works but that doesn't, so the server is working" with 100% certainty.  You may have to reinstall the IIS service/webserver components, or even a complete OS reinstall.  You can always try an IIS reinstall, a PHP reinstall, and a MySQL reinstall before the last ditch effort.

Nothing more I can recommend I'm afraid.  You may have better luck on a Server 2003 forum, or at least get pointed in the right direction.

[jonofezz]

Now look what I found...
Turned on show_startp_errors and show_errors in php.ini
Go to the /photos dir with my broswer....

Warning: main(include/config.inc.php) [function.main]: failed to open stream: No such file or directory in F:\web\www.fezz.org\photos\include\init.inc.php on line 205

Fatal error: main() [function.require]: Failed opening required 'include/config.inc.php' (include_path='f:\php\pear') in F:\web\www.fezz.org\photos\include\init.inc.php on line 205

Any idea? config.inc.php is there!

[Nibbler]

You need to fix your include path, it must include a . in the list of paths.

[jonofezz]

SOLVED.
Chalk this one up to another solved.
I don't quite understand though. I don't think I installed PEAR until I installed phpMyAdmin.... or was it BASE (for snort). I can't quite remember. But that was the problem.
I had two lines for include_path in my php.ini. One that was commented out ;.;c:\php\include and one that PEAR must have inserted include_path="f:\php\pear". So I put it all together include_path=".;f:\php\include;f:\php\pear" and this seems to have worked. Thank you very much!