Upgrade from 0.8 to 0.9 broken

[videosession]

Thanks for a great application and superb feature set

I screwed up my install during upgrade from 0.8 to 0.9...

1. backed up opengoo folder, but NOT the mysql database (oopsie)
2. unzipped 0.9 archive and removed folders/files listed in the readme.txt
3. copied remaining file/folders to server without problems
4. went to /opengoo/public/upgrade and selected upgrade, EXCEPT I didn't notice the version from and version to drop down box and 0.6.4 to 0.6.6 was selected
5. got DB schema MySQL error message and notice I had the wrong versions (0.6.4 to 0.6.6) in the drop down box
6. changed dropped down box to read 0.8 to 0.9 and clicked upgrade again, but it also produced an error
7. did I hose up my install?   

Dang it, I sure hope not...oh please, oh please...

[Number8]

I have a similar problem, although I did pick the 0.8->0.9 upgrade.

I end up with this:


    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/public/files' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Table 'og_read_objects' already exists

If I delete the 'og_read_objects' table and re-run the upgrade, I get this error:
* Failed to execute DB schema transformations. MySQL said: Unknown column 'is_read' in 'field list'

[desimal]

having the same issues
Failed to execute DB schema transformations. MySQL said: Unknown column 'is_read' in 'field list'

[desimal]

ok i got it to work...
you need to run these commands in mysql..


drop table og_read_objects;

drop table og_workspace_templates;

drop table og_test_table;

drop table og_workspace_templates;

alter table og_project_milestones drop from_template_id;

alter table og_project_tasks drop from_template_id;

alter table og_mail_contents drop from_name;

alter table og_mail_contents drop state;

alter table og_mail_contents add is_read int(1) NOT NULL default '0';


not a guarantee you wont lose data, but it looks ok to me...

[videosession]

I restored my v0.8 tarball and everything seems fine, even with the failed MySQL script that ran from the /public/upgrade folder.  I did not have a backup of my database to restore, but I don't appear to need it anyway,  So, problem solved until the upgrade hiccup can be reviewed by team opengoo.

[cabeza]

Upgrade mechanism definitely needs an improvement.
A failed upgrade can leave traces and could make the DB inconsistent (which seems to be your case).
By the way, we are working trying to reproduce your installation issues. The errors you posted were produced after a second failed upgrade. The cause is to try to create a table that is already there from the first failed upgrade.
We are working on it.
Marcos

[SiliconMind]

My upgrade failed too:

Config file found and loaded.
File '/config/config.php' exists and is writable
Folder '/public/files' exists and is writable
Folder '/cache' exists and is writable
Folder '/tmp' exists and is writable
Folder '/upload' exists and is writable
Extension 'mysql' is loaded
Extension 'gd' is loaded
Extension 'simplexml' is loaded
Upgrade script has connected to the database.
Test query has been executed. Its safe to proceed with database migration.
Failed to execute DB schema transformations. MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';

-- Task or other object templates that are included in a workspace
CREATE T' at line 1

any ideas what's going on?

[desimal]

make sure your empanada.php file is correct...
attached is my copy...

\opengoo\public\upgrade\templates\db_migration\empanada.php

[SiliconMind]

make sure your empanada.php file is correct...
attached is my copy...

\opengoo\public\upgrade\templates\db_migration\empanada.php

well, great, but i didn't touch mine. just unzipped files from sourceforge.
my empanada.php seems ok. at least i can't find anything unusual there :/

I've run diff to compare my file with yours and the only difference is that your file lacks one line:

-- Task or other object templates that are included in a workspace

[desimal]

i had to manually edit my empanada.php file to get my upgrade to work...

[SiliconMind]

i had to manually edit my empanada.php file to get my upgrade to work...

ok, but what have you changed? i've run diff and the only difference is that comment from line 28

[cabeza]

Thank you Silicon Mind.
We found the bug and have just fixed it.
Version 0.9.1 will solve the issue.
Marcos

PS: the problem where 2 blank spaces after the ; in the line

Code: [Select]

ALTER TABLE `<?php echo $table_prefix ?>project_milestones` ADD COLUMN `from_template_id` INTEGER UNSIGNED NOT NULL DEFAULT 0;. Currently, queries have to end with ; with a line break inmediately after (or else the script breaks).

[SiliconMind]

Thanks Marcos! That did the trick.

[editfish]

I was looking forward to seeing the fixes in 0.9, but all these install isues have made me a bit nervous about jumping right into the update, despite the help here in the forum recommending various fixes and workarounds.

I think I'll wait for the next one...

 

[cabeza]

As 0.9.0 installation had installation problems, we released 0.9.1 with several bug fixes.
Almost no new functionality ... so as to solve the previous issues ...
Thanks for the patience,
Marcos