How do I upgrade my database from cart 1.3.8a to 1.3.9d?

[dizzyfish]

207 tables?

Hmmmm... I show 93 or so when I do a clean install. Did you add something or?

I would need more info about your set-up before I could say what is up. Well, going to dinner, I will be back later, God Willing...

[kobra]

So I create a Mysql database, import the old database into it. then install the new version into that database?

https://www.zen-cart.com/tutorials/index.php?article=98
https://www.zen-cart.com/tutorials/i...hp?article=108

[rxalex]

Excellent Dizzy, I believe thats what I was doing wrong not dropping database. Ok but now im getting the install not upgrade

[dizzyfish]

It's enough to make ones spleen ache... But with perseverance we can over come this minor set back...

So, you dropped and then did you import the old database after?

[rxalex]

Your right, yes I dropped the tables and imported the old database, then tried to do an upgrade of the database but didnt have that option, the only option was install or upgrade cfg files.

[DrByte]

Your DB_PREFIX in the new site configure.php files is probably different from the old site. It won't work if they're different.

[rxalex]

Thanks, how do I check the difference, it would be in the configure.php file?

[rxalex]

Thanks, I changed the prefix and upgrade option appeared, but got this error

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE zen_counter_history_clean as SELECT * FROM zen_counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]

I appreciate the help

[DrByte]

Just do this: http://www.zen-cart.com/forum/showpo...48&postcount=6

[rxalex]

Thanks doc that helped. In backend and front end I get this message Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels. ok then re-ran the patch and seems that message went away. Thank you, so this means all went well...