SQL Import problem

[DrByte]

This is likely a result of not importing all the related tables together.
You're better off moving the entire database, rather than selective files.

If you insist that you must do individual tables, you can do a selective import using this list as a guide:
http://www.zen-cart.com/wiki/index.p...atabase_Schema

[quantum]

Hi Dr Byte,

I actually just found http://www.zen-cart.com/wiki/index.p...Switch_Servers about an hour ago and am working through that at the moment. I hadn't realised that I could do the whole lot at once, which is much better!

As I have gone to run the fix_chache_key.php, I am getting the following error:

1054 Unknown column 'startdate' in 'field list'
in:
[select startdate, counter, session_counter from counter_history where startdate='20060722']

So trying to work out why that is happening at the moment...

[DrByte]

1054 Unknown column 'startdate' in 'field list'
in:
[select startdate, counter, session_counter from counter_history where startdate='20060722']

That means you're trying to run 1.3 code using a 1.2 database.
Go to the zc_install folder and run database-upgrade to bring it up-to-date.

[quantum]

Hi Dr Byte,

Thanks very much!! That fixed the problem. This was the first time I had done this, and I was very amused to see that it allows me to add a table prefix on in this update. I had just finished manually adding the prefix in phpadmin for each table! So much fun! :o/

Is it normal after this db update that the shop front looks like it no longer as the style sheet controlling the look and feel?

[DrByte]

Is it normal after this db update that the shop front looks like it no longer as the style sheet controlling the look and feel?

There are a lot of visual differences as a result of the template overhaul that happened in 1.3.
Your best choice is to rebuild the template. There are some good examples in the "Contributed Templates" area of the forum, with discussion on using them.

[quantum]

Hi Dr Byte,

I actually built this in 1.3, and just realised that it was reverting to a different template in admin, which was stored in the database! It is all good now.

Thank you so much for your help, I would have been stuffed with out it! :)