Update to 1.5 from 1.4.2 Failed...

[Thomas]

I'm getting the following error:

Failed to execute DB schema transformations. MySQL said: Unknown column 'is_order_by_asc' in 'og_reports'

Any suggestions appreciated,
Thomas

[Number8]

Probably related, if not the same:
http://forums.opengoo.org/index.php?topic=2277.0

[ignacio]

Thomas, if you can, do the following:

1) restore version 1.4.2 from a backup
2) Add these lines to file 'public/upgrade/scripts/FigazzaUpgradeScript.class.php' on line 189 (before if($this->executeMultipleQueries...)

Code: [Select]

if (!$this->checkColumnExists(TABLE_PREFIX.'reports', 'is_order_by_asc', $this->database_connection)) {
$upgrade_script = "
ALTER TABLE `".TABLE_PREFIX."reports` ADD COLUMN `is_order_by_asc` TINYINT(1) $default_collation NOT NULL DEFAULT 1;
$upgrade_script
";
}3) Try upgrading again

If you can't restore version 1.4.2 check the thread that Number8 posted.