error when moving to a new server

[gjh42]

I'm not a database expert, but I believe that 'DB_PREFIX', 'model_' means that the tables inside the db are prefixed with model_, not that that is added to the db name. The db name is model_boxes.

Prefixes are useful if you need to use one database for more than one program (like two different ZC stores), but not otherwise.

When you first installed Zen Cart, did you specify a prefix of model_? If not, use ('DB_PREFIX', '')

[blind1]

I didnt think I set a prefix but even without I get this error:

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

[kobra]

When in phpmyadmin did you look at the table names?
Were they like "admin" or "model_admin"
Square this piece of info away and either specify a pre fix or none.
From what you posted and accounting for the above you should end up with:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'model_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'model_Username);
define('DB_SERVER_PASSWORD', 'MyPassword');
define('DB_DATABASE', 'model_boxes');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

[kuroi]

The information from gjh42 and Kobra is correct and will certainly move you in the right directory, but there is one important piece of information that I have been unable to glean from this thread, and that is the actual names of your tables. Could you go into phpMyAdmin and post some example of the actual table names. The configuration table would be a good one!

[blind1]

Hi Kurio and Kobra.
Thank you for your assistance

In pHPMAdmin, up the top in the box when I select the database it says:
_boxes (93)

The list of tables below look like this
# boxesbanners_history
# boxescategories
# boxescategories_description
# boxesconfiguration
I am pretty sure i didnt select a prefix but on other database on this host it uses a prefix zc_

I am pretty sure i tried the comination above. But going to try again now

[blind1]

I tried that combination but no go, however there is an error when i selected the congiguration table.

i took a picture

[kobra]

If that pic is the database in question then there is no prefix and where did you get:

The list of tables below look like this
# boxesbanners_history
# boxescategories
# boxescategories_description
# boxesconfiguration

as the ones in the pic look like this:

banners_history
categories
categories_description
configuration

try this:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'model_Username);
define('DB_SERVER_PASSWORD', 'MyPassword');
define('DB_DATABASE', 'model_boxes');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

[blind1]

I really appreciate your persistance with this. I have tried that too and re-imported the database several times too.

Nothing is working.
Could it be the way I am exporting the database?
I am just floored how difficult it has been to get this site up and if I cant do this right this time I wont be able to do any more. I just cant see what is not correct. It all looks fine but won't connect

the database name is model_boxes