Forums → Upgrade →

Upgrade from 0.9.2 to 0.9.3 from SVN?

Feed 8 posts, 6 voices

Apr 1, 2008 10:42
Avatar
David
963 posts

Hi Philippe:

I just updated my localhost installation from 0.9.2 to the current version (0.9.3. v133?) from SVN. And now my pages will not save! :) I expect the db structure has changed? Do you have a mySQL query to fix this? Or something?!?

Thank you/Merci!! David.
 
Jun 17, 2008 19:04
Avatar
Bdesign
277 posts

Wooohooo. I've finally ported my live site from 0.9.2 to 0.9.3 and it works great . I'll post tomorrow the tutorial, because now it 02:03 at night in my country, so Good Night.
 
Jul 9, 2008 19:50
Avatar
Andy
159 posts

David - did you have any luck with this? I am experiencing the same problem...
 
Jul 10, 2008 09:20
Avatar
David
963 posts

I think I packed it in and simply re-installed and migrated my site manually. (There wasn't much.)

@Bdesign - did you ever write up your notes on moving from 0.9.2 > .3? That would be good to have!
 
Jul 10, 2008 19:19
Avatar
Andy
159 posts

hmm - i have a 2.9MB DB to shift ! Would be handy to see what was added to the DB in the upgrade so they can be added manually...
 
Jul 22, 2008 19:56
Avatar
siriomi
5 posts

Has anyone posted anything about this? Luckily I kept my 0.9.2 installation and re-installed it over 0.9.3...

But I'd like to update to 0.9.3 so I can have comments work properly. Anyone have an idea? Thanks!

By the way, I'm new to Frog and I'm really loving it so far. Keep up the wonderful work!
 
Aug 4, 2008 14:12
Avatar
macsmart
1 posts

I'd also like some information on the best way (if there is one) to upgrade to 0.9.3. I installed 0.9.3 over a 0.9.2 installation and everything seemed to be working corrrectly until I tried to update a page. That didn't work, and kicked back a relatively generic error message.

Any guidance would be greatly appreciated!
 
Aug 4, 2008 17:22
Avatar
gido
38 posts

I upgrade an instance of frog from 0.9.2 to 0.9.3. If you follow the svn change, you will see some small change in the database structure (in r128 and r141). This change is due to the add of keywords and description features and comments moved to a plugin.

Basically you need to follow these steps:

  1. Backup your database!!!

  2. Execute this SQL code:

    ALTER TABLE page ADD keywords VARCHAR(255) default NULL AFTER breadcrumb; ALTER TABLE page ADD description TEXT AFTER keywords;

  3. and if you not use comments you can execute this code (caution: this will remove all comments and comment status!):

    ALTER TABLE page DROP comment_status; DROP TABLE comment;

Replace the all the frog php file with the new one and your are done!
 
Aug 4, 2008 17:26
Avatar
gido
38 posts

Arf, the link to the diff are wrong, here the correct one: * in r128: add keywords and description column * in r141: remove comment_status column