MYSQL error #1146 table doesn't exist - help!

[TheKenster]

Hi there,

Using Zencart version 1.5

This is hosted with hostmonster and they are unable to offer me support for the issue.

I uploaded my Zencart templated to my new hosted site as instructed then followed this in myphpadmin

You should update the tables of your Zen Cart installation database using a mysql dump file located at “\sources\dumps\zencart_short.sql” inside the unzipped template package. Contact your hosting company for assistance. This will not affect the configuration of your ZenCart installation, just overwrite MySQL rows (tables) that define the style of your ZenCart store.

I tried running the script mentioned on what i believe is the only db listed in there using phpMyAdmin and got the following error:


Error SQL query: UPDATE configuration SET configuration_value ='0' WHERE configuration_key ='SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS';

MySQL said: #1146 - Table 'mypreci4_znc1.configuration' doesn't exist

[DrByte]

"UPDATE configuration" needs to be changed to "UPDATE yourprefix_configuration", depending on whatever "yourprefix_" is for your site's configuration. When you installed Zen Cart you chose to add a database table-prefix instead of the default of leaving it blank. The zencart_short.sql that came with your template isn't smart enough to magically guess your prefix, and apparently the instructions that came with it didn't tell you about it either. If you don't know what your store's table prefix is, you'll find it in your /includes/configure.php file in the line that contains this:

define('DB_PREFIX', 'your_prefix_is_inside_these_quotes');