FORUMS CLOSED DUE TO SPAM. YOU STILL CAN ADD POST!

Forums → Upgrade →

Upgrade from 0.9.2 to 0.9.3 from SVN?

Feed 12 posts, 6 voices

Avatar
David
1493 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.
 
Avatar
Bdesign
343 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.
 
Avatar
Andy
257 posts

David - did you have any luck with this? I am experiencing the same problem...
 
Avatar
David
1493 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!
 
Avatar
Andy
257 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...
 
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!
 
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!
 
Avatar
gido
51 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!
 
Avatar
gido
51 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