URGENT DB Connection Issue - site broken by installing zenmagick

[autoace]

I have frustrating problem and am hoping someone might know what can be done!

Some preface...
I had installed a a copy of zenmagick (############################) on my site at mydomain.com/zm - just wanted to see what it was like. Well unfortunately when I did that it seems to have broken the database connection of my ZC store at mydomain.com!

So I made some forum posts here and at zm. Unfortunately, I should have done that before, because the head guy at zm did not think it was a wise thing to do - he did not know how 'smart' the ZM installer was (or wasn't)!

So I then made a backup of my zm db and files and preceded to delete that database and the files from my hosting account.

I then uploaded fresh copies of both configure (checking for accuracy of db name and UN/PW) files for both admin and includes, hoping that would resolve the issue - well sad to say that it hasn't and now I am lost

The error message that I get when I bring up my ZC admin login page is:

0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

When I go to my storefront at mydomain.com, the nddbc.html file comes up.

When I go to phpmyadmin via my control panel, my ZC db is still there with all the tables and data. To verify that, I exported a copy of it via phpmyadmin per the instructions in the tutorials section, saved it to my pc, unzipped it, opened up the file and looked at the contents! All the data DOES seem to be there.

I looked at both configure files (admin and includes) and the DB name, UN and PW are correct.

I have 2 thoughts at what can be done:
1. Would it help at all to re-upload the zc_install folder and run thru the install script again?

2. Install a fresh copy of ZC and run thru the installer script to have a fresh, functioning and CONNECTED ZC install. Then re-upload my custom ZC install over the fresh install (overwritting) and then import a copy of my custom ZC db into the fresh db.

Which is the better idea? Any other suggestions? Thank you for your time and effort.

[DrByte]

I looked at both configure files (admin and includes) and the DB name, UN and PW are correct.

But, the servername or the table-prefixes might not be.

1. Would it help at all to re-upload the zc_install folder and run thru the install script again?

Sure. That'll happily wipe out your database too though, so you'll want to be sure to have a backup.

2. Install a fresh copy of ZC and run thru the installer script to have a fresh, functioning and CONNECTED ZC install. Then re-upload my custom ZC install over the fresh install (overwritting) and then import a copy of my custom ZC db into the fresh db.

You could do that too.

[autoace]

But, the servername or the table-prefixes might not be.

Sure. That'll happily wipe out your database too though, so you'll want to be sure to have a backup.

You could do that too.

@ DrByte
I did not specify any table-prefixes when I installed ZC, so that should not be the issue.

Where can I find out about the servername that is in my db? If the servername is wrong, how do I go about fixing that?

In your opinion, which option do you think is the best one to try? I have backups of everything.

I don't want to do #2 if there is a less complicated fix. Thanks for your help.

[DrByte]

In your opinion, which option do you think is the best one to try? I have backups of everything.

If you have backups, just go grab the configure.php files from your backup and compare them against your live site.

Better yet, just in case whatever that other mess screwed up also touched some of your regular files, why not do a thorough compare of *all* the files on your server against your last good backup from before you toyed with it.
That's less work than either option you proposed.
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

[autoace]

If you have backups, just go grab the configure.php files from your backup and compare them against your live site.

Better yet, just in case whatever that other mess screwed up also touched some of your regular files, why not do a thorough compare of *all* the files on your server against your last good backup from before you toyed with it.
That's less work than either option you proposed.
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

I've already compared my backup config files to what is on the server - same data.

I'll do the file compare to see if there have been any changes.

As a last resort, do you believe option 2 will work?

[DrByte]

As a last resort, do you believe option 2 will work?

A definite "maybe"

[autoace]

Well not knowing what the ZM installer has done to my files or db (unable to find the cause of the problem) I've decided to do the prudent thing and do a complete re-install of my store. Fortunately I have an almost up-to-date backup of my db (only missing 2 tables from 2 recent mod installs). Unfortunately I don't have a current backup of my store. I have backups, just not recent enough. This has taught me to now keep daily backups. Fortunately, though, I do have all files needed to completely bring my store backup, just have to manually do it instead of restoring a backup file. Another good thing, is that I have not yet 'launched' my store. Coming soon tho....

Lessons learned (1) daily backups (instead of weekly) for both site and db and (2) Stick with ZC - ZC works!!

BTW, I am no longer curious about ZM.