no database after server move

[skipper_2]

Hi,
Hope someone can help me with this. I moved my zencart store from one server to another following the instructions in the tutorials.

I backed up the old database tables with phpmyadmin and repopulated the new database with the sql file. All seems ok with the database as it has the same amount of tables as the old one.

I have checked both the configure files and they have the correct paths. I have also run the fix cache key and that is reporting the correct path. Thing is when I open the site there are no products although the database is fully populated with over 100 products. Also when I log into admin, it says 0 products but the sessions path is correct

site address is http://www.directtropicals.co.uk.

I would be most grateful if someone can help as it is beyond my knowledge on what it could be.

Thanks
Skip

[Chuckl]

You should have a look at the products and categories tables with phpMyAdmin or similar, and see if the tables have anything in them.

[skipper_2]

Thanks for the advice, I had a look and there is no products in there. Am I doing something wrong when I import the database?

[Chuckl]

Check the SQL backup/export file from your original database. There is sometimes a 'USE database_name' included, which would obviously be the original database, not the new one. If so, change it to the new one, comment it out or delete it.

[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.