fix_cache_key.php - ERROR

[imfsub12]

Yes after using the fix_cache_key.php

I get this error


1146 Table 'sal0824606335219.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]


This is after I uploaded to a new SERVER.. last step....

[DrByte]

Sounds like you've missed some other steps in the setup ... namely ensuring that all your DB_xxxxx information is set correctly in your new server's configure.php files.

[imfsub12]

i found this file..
https://www.zen-cart.com/tutorials/i...hp?article=100

and should I REDO this???

a. Use either the "Backup MySQL Database" contribution to do the backup of your database, or use phpMyAdmin to export your entire database ... include the "DROP" tables command, and under Data, choose "Complete Inserts" and "Extended Inserts".
Save the SQL file to your PC for later.
b. Download all your old site's files via FTP (or if you have the option, zip them up on the server and download the zip)

4. Now upload your OLD files over the NEW files on the NEW server, WITH TWO EXCEPTIONS: Don't overwrite the /includes/configure.php and /admin/includes/configure.php files on the NEW server.

I'm a little LOST in the include the "DROP" tables command, and under Data, choose "Complete Inserts" and "Extended Inserts"?????

I"m not a DB expert, by all means...

[imfsub12]

oh the first DB that i TRIED was creating one in mysqladmin .... like I SAID i tried..

should i use the one that I BACKED up from my GODADDY control pannel...????? will this one be more complete..

[imfsub12]

DrByte - My Site was working fine till I usde the fix_Cache file????

SO this is what i did now went to my sqladmin and DROPED all the TABLES again.. re-uploaed my BACKUP FILE and i still get the same error.. when i just preview my site..

ME LOST!!!

[imfsub12]

Ok I SOlved the Mistery.. I dind't put in the ZEN_ for the prefix.. OPPS.. you nee that bold.. my bad..

Next my site works great.. now.. but when i go and run the fix_cache_key.php file NOTHING happens.. doesn't show anything on the screen..

what could this be..

Did it work?

[imfsub12]

I forgot to mention on my reinstall I choosed - under Database OPTIONAL settings

SQL Cache METHOD: DATABASE (instead of FILE)

WOuld this be why the fix_cache isn't working.. as i'm not sure how it was orignaly installed on godaddy.. it was a pre install module...