Trouble upgrading - database won't upgrade!

[AlexanderK]

Hello Zenners,

I have a slight problem.

I have experienced trouble upgrading from 1.3.8 to 1.3.9d. I have backups of both the database and all the files.

What I then proceeded to do was to simply upload all the new files and let them overwrite everything.

Then I went to /zc_install/index.php and followed the steps. My admin is named "adm" so I got some errors with files inside "admin" not existing or being unwritable. Fair enough - wrong directory name!

I went on and took the steps to upgrade. When I got to the final step and tried to upgrade the db, I just got a page with this:

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 then hit the back button and tried to view the site etc. anyway. At the top of both the site and the admin part, a box with this text is to be found:
Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

I went to see and yes, "Zen Cart 1.3.9d" but "Database Patch Level: 1.3.8".

I have then tried a couple of different things, renaming "adm" back to "admin" for instance. But I must admit that I am a bit lost in this matter!

The url is http://www.sogrenibikes.com/, but I guess that it is closed for maintenance at the moment for the public.

If anyone could help out, I would be forever grateful.

Thank you!

[DrByte]

Sounds like your database itself is set to utf8 and so is your connection to it.

So, try this:
Edit /zc_install/includes/installer_params.php
Change define('DB_CHARSET', 'latin1'); to define('DB_CHARSET', 'utf8');

[AlexanderK]

Great, it works! Database upgraded just as it should.

Only trouble now is that I get a blank page when I try to add a product to the cart... New thread, perhaps?

Anyway, thank you so much

[DrByte]

Great -- glad it sorted it out for you.

Yes, a new thread for the other issues would be appropriate