no database after server move

[skipper_2]

Have done that and reimported and still says products 0.

If I look at my original database it says products 0 but it is fully operational on my test site with about 200 products? Im not very good at this stuff but is that odd?

[skipper_2]

Just to add to my confusion, when I log into admin now after redoing import, all my products are in there but still no sign on the site?

[dbltoe]

could be your database setting in includes/configure.php if they show up in admin and not the cart. Make sure you set the includes/configure.php database settings the same as the ones in admin/includes/configure.php

[DrByte]

What was the DB_PREFIX setting on your old server? (in the configure.php files)
What is it on your new server?
If they're not the same, then you won't be seeing the right set of tables in the database.

[skipper_2]

Thanks for the responses, I checked both the includes/configure.php and the admin/includes/configure.php files and they both have the same database settings. However, the old servers DB_PREFIX says webstore in admin configure.php which was the folder i used for zencart and the new one says nothing, should i change the new one to webstore?

[DrByte]

The database tables are named like this:

categories
customers
orders

If you have DB_PREFIX set to something other than blank, those tables will be named differently. ie: if DB_PREFIX is set to 'something_', then the tables will have been built using these names instead:

something_categories
something_customers
something_orders

So ... since your "old" server had a certain DB_PREFIX setting, and that's the data you're carrying forward to your "new" server, you'll need to make sure the DB_PREFIX on your "new" server settings is the same as the "old" server's DB_PREFIX.

[skipper_2]

The strange thing is when I installed zencart on the old server I left the prefix blank? so I am not sure why the file is saying the prefix is webstore. Should I run a clean install on the new server and use the DB_PREFIX webstore when I set it up?