Failed DB update

[head2wind]

Hello,

I am in the process of attempting to perform a upgrade from 1.3.8a to 1.3.9f. I have followed the tutorial to the point where I am telling zc_install to do the update to the 1.3.8a DB.

I created the 1.3.8a install "raw", ran zc_install on the maually created DB, restored a copy of my production DB to this new DB, copied my modified config.php with new DB info to the "demo", and all was good (aside from the writable and zc_install notes).. so I copied /zc_install (v1.3.9f) to / of my "demo" and ran it.. and the following error is what I get:

Insight anyone?

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;]

[DrByte]

Since your database is using utf8 and not latin1, you'll need to manually edit the /zc_install/includes/install_params.php file and change the 'latin1' to 'utf8', and then run the upgrade step again.

[head2wind]

OK, thanks. In process right now, hopefully this is the only hitch.... been working WAY too long at this

[head2wind]

that worked. thank you for the tip.

now onto the file compare and "merge" processing... argh....

[woodstuff59]

Since your database is using utf8 and not latin1, you'll need to manually edit the /zc_install/includes/install_params.php file and change the 'latin1' to 'utf8', and then run the upgrade step again.

I have the same problem except that somehow, some of my tables are latin and some are utf8.

I did the change as you suggested and it finally says that my database is up to date. When I ran zcinstall, though, it did say it skipped several files. They all were tax related.

Now, the problem is that I can't access anything in the 'admin-configuration- part of my admin panel.

I've been going crazy with this for days. Please help!!

Thanks in advance.

[woodstuff59]

I have the same problem except that somehow, some of my tables are latin and some are utf8.

I did the change as you suggested and it finally says that my database is up to date. When I ran zcinstall, though, it did say it skipped several files. They all were tax related.

Now, the problem is that I can't access anything in the 'admin-configuration- part of my admin panel.

I've been going crazy with this for days. Please help!!

Thanks in advance.

Never mind. It wouldn't let me do anything because I hadn't reset the permissions on my configure files yet. So far, everything seems to be working well. Let's hope it stays that way.