0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_version_

**DrByte** · 23 Aug 2012, 05:18 PM

Originally Posted by mitch2564

their control panel makes it seem as though all I needed to do to upgrade was a few clicks and voila-which was so not the case

Not surprising. I've not seen any "auto-upgrade" script ever do an upgrade correctly. They should always be avoided.

Your symptoms suggest that your DB_XXXXXX settings are pointing to an empty database, and/or specifically your DB_PREFIX contains a value that's different from the pattern of the names of the tables in your database.

**mitch2564** · 24 Aug 2012, 01:45 AM

Ok, so I have checked the database and the config folder and the prefixes are the same, the database is full of tables, I put the server name in the empty spots as suggested and still same error. I've checked each line in both config files and now I don't know what else could be the problem. Could someone please point me in the direction to try and reverse this upgrade? I was more than 70percent complete in building it, and I have a lot of things pending on the site being up and running?

**DrByte** · 24 Aug 2012, 03:15 AM

You said the storefront works fine but the admin does not?

Do you mistakenly have an /admin/includes/local/configure.php that doesn't belong on the server, since it overrides the correct one at /admin/includes/configure.php ?

Does your admin version of configure.php have the same DB_XXXXXXXX settings as your non-admin configure.php (the files are NOT totally identical, but all the DB_XXXXX settings *should* be identical). If they don't match, then I suggest copying *just* the DB_XXXXX settings from the non-admin configure.php into the admin one.

**mitch2564** · 24 Aug 2012, 07:31 PM

Do you mistakenly have an /admin/includes/local/configure.php that doesn't belong on the server, since it overrides the correct one at /admin/includes/configure.php ?

Answer: No

Does your admin version of configure.php have the same DB_XXXXXXXX settings as your non-admin configure.php (the files are NOT totally identical, but all the DB_XXXXX settings *should* be identical). If they don't match, then I suggest copying *just* the DB_XXXXX settings from the non-admin configure.php into the admin one.

Answer: Yes

I have checked your suggestions and nothing is working. I even tried deleting the config file, redoing the zc install to see if it would create another one, but file ended up empty. I put the file back in place and tried to recreate the 1.3.9 version and put it in place-nothing. I ran zc install again and now I'm getting a 500 error. Do you have any other suggestions? I am at a loss...

**DrByte** · 24 Aug 2012, 08:26 PM

Originally Posted by mitch2564

I even tried deleting the config file, redoing the zc install to see if it would create another one, but file ended up empty.

That sounds like a permissions problem. Or something really really odd with the server you're running it on.

Originally Posted by mitch2564

I put the file back in place and tried to recreate the 1.3.9 version and put it in place-nothing.

What does "nothing" mean in this context? Blank file?

Originally Posted by mitch2564

I ran zc install again and now I'm getting a 500 error.

A "500" error is a generic message that means something was refused by the server. The details are not displayed by the server because it's usually a security-related thing and of course you wouldn't want hackers to see what they just triggered so they can try to work around it. Instead you want them to go away.
So the details of the 500 error can be found in the server's apache errorlog.
http://www.zen-cart.com/content.php?...l-server-error

**mitch2564** · 26 Aug 2012, 02:25 AM

The 'nothing' meant that there was no change. I think the 500 error is probably because I still have that strict error thing still there. Other than that, I don't know what else I can do besides down grade. Do you have any other suggestions?

**DrByte** · 26 Aug 2012, 02:48 AM

You skipped the proper process of doing a staged upgrade in another folder+database, and you let some automated script make a bunch of random changes to your site's files thus probably overwriting things you had customized. You need to identify what was changed incorrectly, and fix those issues.

Yes it's unfortunately rather complicated and urgent now because your live store is impacted or even "down" because of using the automated script which knows nothing of your customizations. Sorry.

Two things I'd try if I were in your shoes:
a) a fresh install (in another folder and another database) ... to satisfy yourself that you can indeed get a working copy functioning on your server
Then once that's working, simply compare your site against the working site, and fix whatever needs fixing.

b) or just jump directly to the comparison stage: http://www.zen-cart.com/wiki/index.p...Obscure_Issues
These same steps are what one normally follows when upgrading anyway, so it won't hurt doing them.
And of course fix whatever needs fixing.

Thread: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_version_

Thread Tools

Search Thread

Display

Hybrid View

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Re: 0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_vers

Similar Threads

v139h 0 DB_ERROR_NOT_CONNECTED in: [select * from project_version WHERE project_version_key

Help! Database backup from Godaddy, now Connection error "0 DB_ERROR_NOT_CONNECTED"

select admin_id, admin_name, admin_pass from zen_admin where admin_name =

Posting Permissions