Upgrade from 1.3.8a to 1.3.9h freezes with error code

[Courage9]

Upgrading from 1.3.8a to 1.3.9h and thought I followed the directions right on, but when I click on "Update Database Now" it just freezes and this is what I get:


1072 Key column 'zen_order_id' doesn't exist in table
in:
[ALTER TABLE paypal ADD INDEX idx_zen_order_id_zen ( zen_order_id ) ;]


Any idea's?

[Courage9]

Upgrading from 1.3.8a to 1.3.9h and thought I followed the directions right on, but when I click on "Update Database Now" it just freezes and this is what I get:


1072 Key column 'zen_order_id' doesn't exist in table
in:
[ALTER TABLE paypal ADD INDEX idx_zen_order_id_zen ( zen_order_id ) ;]


Any idea's?

disregard...

didn't see the other checkmark on another upgrade. removed and selected the correct one...worked!!

[Ajeh]

Thanks for the update that you now have this working correctly ...

[Courage9]

I'M A TRUE DUMMY.... I was in such a hurry to stop my post when I THOUGHT it was working...but in fact it still has a problem.

When I select "Upgrade Database" the sniffer recommends this: Upgrade DB from 1.2.4 to 1.2.5

and if I leave it and press "Update Database Now" I get this error:

1072 Key column 'zen_order_id' doesn't exist in table
in:
[ALTER TABLE paypal ADD INDEX idx_zen_order_id_zen ( zen_order_id ) ;]

If I select "Upgrade DB from 1.3.8 to 1.3.9" this is what I get:

1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary'
in:
[CREATE TABLE counter_history_clean as SELECT * FROM counter_history WHERE 1 GROUP BY startdate COLLATE utf8_general_ci;]


This is my "installer_params.php": I have tried it with 51 uncoment and with...makes no difference.
// $session_save_path = (@ini_get('session.save_path') && is_writable(ini_get('session.save_path')) ) ? ini_get('session.save_path') : realpath('../cache');

$session_save_path = (is_writable(realpath('../cache')) ) ? realpath('../cache') : ini_get('session.save_path');

define('SESSION_WRITE_DIRECTORY', $session_save_path);

define('DEBUG_LOG_FOLDER', realpath('../cache'));


// Set the following to TRUE if having problems (blank pages, etc). Best to leave at FALSE for normal use.

define('STRICT_ERROR_REPORTING', FALSE);


// optionally set this to 'utf8':

define('DB_CHARSET', 'utf8');



// optionally uncomment the following line if choosing 'utf8' or 'latin1' above are causing problems:

define('IGNORE_DB_CHARSET', TRUE);


My Database settings are as follows:
MySQL charset is UTF-8 Unicode (utf8)
My collation is utf8_bin

Not sure where to go from here. I thought I read every thread out here about this, but maybe I didn't?

[Courage9]

I have deleted and restored my database and tried it again with a fresh install. My admin shows that I have upgraded the site to 1.3.9h and that my db is only at 1.3.8. and I still get the same error as shown above when I run database upgrade...

[Courage9]

Instead of beating myself up I completely rebuilt my site with a new db and 1.3.9h...problem solved.