0 DB_ERROR_NOT_CONNECTED in [select * from znc_project_version WHERE project_version_

[mitch2564]

"0 DB_ERROR_NOT_CONNECTED
in:
[select * from znc_project_version WHERE project_version_key = 'Zen-Cart Database' ]"

this is after I enabled the strict error reporting. I understand that its something to do with the database, but what and where and how are the questions I have. So far I have made sure that the config files (both of them) are pointing at the correct database. I don't know how to check for the database password. I didn't properly save or back-up before I upgraded as I found out after everything went crazy. I am with Bluehost and 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, ergo why I am here pleading for help.

I am not sure if the admin config file is correct neither. I feel like it could be something wrong with the following:

define('HTTP_SERVER', 'http://localhost');
define('HTTPS_SERVER', 'https://localhost');
define('HTTP_CATALOG_SERVER', 'http://localhost');
define('HTTPS_CATALOG_SERVER', 'https://localhost');

and....

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', $p1) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', $p2) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
define('DIR_WS_HTTPS_CATALOG', '/');

should I replace or add something here or is it suppose to be this way?

[dbltoe]

If you are on your host's server localhost is definitely incorrect in the four defines you listed. It MIGHT be correct for the database but you need to fix the others first. You didn't use an auto loader to install ZC did you?

[DrByte]

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]

dbltoe,
Yes I did. The site comes up fine, but the admin is trying to take me to h-e-doublehockeysticks. I refuse to go. Just visiting though.

[mitch2564]

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]

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]

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]

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.

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?

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]

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]

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.