HELP - Admin section contains no info

[ERM]

Hi everybody,

I have made a backup of MySQL from my old server and transferred my site to another server. I installed ZC using fantastico on the new hosting company's server and the initial install of ZC loads fine. When I import my data via phpmyadmin, ZC takes the look of my previous store, with some minor changes that I can edit later. When I log into the admin area, NOTHING is listed in there. No customers or products. No counters, no comments, no history. Both configure.php files look normal and everything seems to be pointed in the right place. The hosting company says everything looks to be pointed in the right direction, and the database shows all of my info (customers, products...), what else can I check or do?

Thanks,
Tony

[poolprorich]

Hi everybody,

I have made a backup of MySQL from my old server and transferred my site to another server. I installed ZC using fantastico on the new hosting company's server and the initial install of ZC loads fine. When I import my data via phpmyadmin, ZC takes the look of my previous store, with some minor changes that I can edit later. When I log into the admin area, NOTHING is listed in there. No customers or products. No counters, no comments, no history. Both configure.php files look normal and everything seems to be pointed in the right place. The hosting company says everything looks to be pointed in the right direction, and the database shows all of my info (customers, products...), what else can I check or do?

Thanks,
Tony

You can do one of 2 things,

in your config files the setting for prefix,
if your old database did not have a prefix you should just be able to remove fantastico's prefix and use your tables, the prefix usualy is zen_YOUR_TABLE_NAME or zc_YOUR_TABLE_NAME

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

If this works you might want to get rid of the fantastico installed fields( fields with prefix_)

or you can open your sql backup file and add your prefix to all table statments,

[ERM]

Thank you, thank you, thank you.

That was it. The database prefix had "zen_" written it it. I can't believe that something so simple was overlooked and caused so many problems. Thank you sooooo much.

Tony

[poolprorich]

no problem
Thats why this forum is here