Switching Server Hell

[Lost and Confused]

Can someone please help me. I am switching my server from 1and1 to justhost. The installation of zencart seems to be fine. However, when I use the fix cache key I run into all sorts of problems. The prefix on the install of the DB was always " " but with the new install it becomes "zen_". So I switch it back to the orginal methods and now I get the following:

1146 Table 'XXXXXXX_zc1.sessions' doesn't exist
in:
[select value from sessions where sesskey = '334fec8e718e36409ff4c0ac54793c14' and expiry > '1270824861']

How do I begin to fix this problem?

[DrByte]

If you do the install by hand, then you can specify the appropriate prefix during the zc_install step where you enter database details.
That gives you the most control over how it behaves, and will remove a lot of your stress.

This FAQ article was written with that purpose in mind: https://www.zen-cart.com/tutorials/i...hp?article=100

[Lost and Confused]

I did the install by hand and then I had a blank screen. Either way, I don't think it's a problem with the install. It seems to be something with the database and fixing cache.

[schoolboy]

As Dr Byte says... If you perform a manual install, then YOU have the option of assigning a prefix. If you don't assign a prefix during the manual install, the database tables will not have a prefix.

Typically, a "fantastico" install WILL automatically assign the zen_ prefix, so I have to conclude that you did not actually do a manual install, but used either fantastico or another server-side install script to do the install for you.

[DrByte]

Your database table names need to reflect the same DB_PREFIX you've specified during installation.
If you're getting "table doesn't exist" errors, then you've got one or the other wrong.

If you're getting blank screens, then you need to fix the PHP errors that are causing those:
https://www.zen-cart.com/tutorials/index.php?article=82
https://www.zen-cart.com/tutorials/index.php?article=87

[schoolboy]

OK, I'm going to make some assumptions here about the technique you used to move to the new host.

1. You backed up everything on the old server and/or then downloaded copies.

2. You set up a database on the new server and then imported the old database into it (so you have a database without any table prefixes).

3. You created another database in order to run a fantastico install, and within a minute or two, fantastico had a fresh installation for you.

3. You then edited the fantastico installation's configure.php files to point the site to the copied database.

4. you then experienced problems...

Try this...

Go into the two configure.php files and remove zen_ from the defines which state this parameter.

[Lost and Confused]

Yes Schoolboy, you nailed what I did exactly. Anyway, it was a nightmare. I server was down since Friday. I believe that the problem resulted because the new host had the same issue as the old host. When I tried to upload my old database it kept getting a time out error so only upload portions of my database up to P. Everything else was not uploaded. Overall, I just canceled the entire thing and stayed with my horrible host. I didn't have the time required to invest in making the new host work. My server was down all weekend. Just came back up today as a result of the transfer. Absolute nightmare. All in all, I'll be stuck with my host for the next year.