Which config file has info in it?

[RodG]

[01-Jul-2014 07:07:30 America/Denver] PHP Fatal error: 1146:Table 'nickhyde_zen1._zendb_cache' doesn't exist :: delete from _zendb_cache in /home2/nickhyde/public_html/bookstore/includes/classes/db/mysql/query_factory.php on line 120

There is something amiss with your DB settings.

In a previous post you stated

"define('DB_PREFIX', '_zen'); (this was zen_ and so I thought that might be the problem)"

I can't tell you with absolute certainty what your DB_PREFIX should be, but I can tell you that it *shouldn't* be "_zen"

Furthermore, this current error log is suggesting that you now have the DB_PREFIX set to "nickhyde_zen1._zendb", which is probably also incorrect.

What I'd suggest is that you log into your cPanel (not Zencart) and click on the 'MySQL databases' icon. This will show you the names of your database(s), they'll look something like

zendb_zencart
zen1_zencart
zen_zencart or perhaps even
zencart (no prefix).

Once you've determined this,d you'll need to set the DB_PREFIX setting (in both configure.php fileds) to
define('DB_PREFIX', 'zendb_')
define('DB_PREFIX', 'zen1_')
define('DB_PREFIX', 'zen_') or
define('DB_PREFIX', '')

Cheers
RodG
ps. make sure the configure files are writable before making the changes.

[motherwestwind]

I can't tell what the prefix of the database is. All I see is my user name and the names of the DB's. Where do I look on the control panel?

[motherwestwind]

my host said the correct prefix is zen_ but the same problem occurred. Could it be that the template that broke the form is still in control in the admin panel and everything is searching for the folders?

[motherwestwind]

My host brought me back to my admin screen through some magic trick. Now I'm working on everything again. Thank you so much for your help.

[motherwestwind]

My host brought me back to my admin screen through some magic trick. Now I'm working on everything again. Thank you so much for your help.

I spoke too soon. While my admin login is there I can't log in. Still there's a problem connecting to the database. Is there anything else besides the configure files that affects the connection?

[DrByte]

ok so both files should be identical?

No. They say right inside them that while they're very similar, they are NOT identical.

I spoke too soon. While my admin login is there I can't log in. Still there's a problem connecting to the database. Is there anything else besides the configure files that affects the connection?

The ONLY place where original Zen Cart code deals with database connection settings is the two configure.php files.


What about your daily and weekly backups of your site? Can you restore those 2 files from backup?

[mc12345678]

/ * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define(DIR_WS_CATALOG', '/bookstore/');
define('DIR_WS_HTTPS_CATALOG', '/bookstore/');
define('DIR_WS_IMAGES', 'images/');

Well, I guess this counts as a message worthy to be my 2000th. After all the others have reviewed what is and is not in the configure.php files, did no one catch the missing apostrophe? (') It was posted in a message on it's own before, then included in a "copy" of the entire file. I'll be honest, I stopped looking through the file once I saw this and checked the rest of the messages to see if it was reported. Nope...

So in your store's includes/configure.php the line that includes

define(DIR_WS_CATALOG', '/bookstore/');

should read:

define('DIR_WS_CATALOG', '/bookstore/');

in my mobile phone I don't know how to force it to be highlighted, sorry.

Hopefully this helps.

[RodG]

did no one catch the missing apostrophe? (')

Yeah, but that's only one character out of several thousand. What harm could it do. :-) :-) :-)

Cheers
RodG

[mc12345678]

Yeah, but that's only one character out of several thousand. What harm could it do. :-) :-) :-)

Cheers
RodG

Famous last words, right? :)

Hey Mom, watch this!

Sorrycame on a little strong with the statement. And yeah it could be juat one missing character of an unknown number of them, too. Like I said I stopped my review when I got to that missing character. Have to wait to hear the result. :)

[motherwestwind]

Well, I guess this counts as a message worthy to be my 2000th. After all the others have reviewed what is and is not in the configure.php files, did no one catch the missing apostrophe? (') It was posted in a message on it's own before, then included in a "copy" of the entire file. I'll be honest, I stopped looking through the file once I saw this and checked the rest of the messages to see if it was reported. Nope...

So in your store's includes/configure.php the line that includes

define(DIR_WS_CATALOG', '/bookstore/');

should read:

define('DIR_WS_CATALOG', '/bookstore/');

in my mobile phone I don't know how to force it to be highlighted, sorry.

Hopefully this helps.

I changed it but it didn't help but thanks it got me to look once again at the files to determine the differences and I found that through everything back and forth yadiyadiyada that the pathway of the admin config was different than the store config so joyously I changed it but that didn't fix the problem. However I am becoming more familiar with the files so I guess this is the whole purpose of errors.

Beth