Failed DB update

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

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.

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

that worked. thank you for the tip.

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

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.

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. :frusty: 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. :frusty: 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. :clap: