AFIK you're on the safe side if you do an update to 1.6 (not 1.8) before you turn to 1.9. The major redesign of the database (that's the bottleneck) is done in 1.6.

Please do report on this topic what you have tried and how it worked out.

Good luck

I just upgraded a 0.9.2 blog directly to 1.9.3 without issue. There is no reason that I know of to use any intermediate step. I'd especially avoid stepping to 1.6.* because it was a really bad step along the path. If anything, go to 0.9.2 then all the way up.

Well, I'm partway there. :) I tried going directly to 1.9.3 (aw what the hell).

I backed up my MySQL database, my current /blog directory, renamed /blog then installed the new /blog clean per the instructions. I ran /install/, re-entered my config stuff, and everything upgraded OK. Pruned off /install/ once it was done.

The admin back-end seems ok. My skin (fplanque2002) wasn't on the new skin list so I figured I'd try going through the manual changes [url=http://manual.b2evolution.net/Upgrade_from_0.9.x_to_1.8.x]outlined here[/url].

Figured I got everything, then gave it a whirl. Got the error:

Parse error: syntax error, unexpected ',' in /blahblahblah/blog/skins/fplanque2002/_main.php on line 187

In looking at _main.php, those lines are as follows:

			<li><a href="<?php $Blog->disp( 'staticurl', 'raw' ) ?>"><strong><?php echo T_('Recently') ?></strong></a> <span class="dimmed"><?php echo T_('(cached)') ?></span></li>
			<li><a href="<?php $Blog->disp( 'dynurl', 'raw' ) ?>"><strong><?php echo T_('Recently') ?></strong></a> <span class="dimmed"><?php echo T_('(no cache)') ?></span></li>
		</ul>
		<?php
   // -------------------------- CALENDAR INCLUDED HERE -----------------------------
   // Call the Calendar plugin:
   $Plugins->call_by_code( 'evo_Calr', array(	// Params follow:
       'block_start'=>,
       'block_end'=>,
       'title'=>,			// No title.
     ) );
   // -------------------------------- END OF CALENDAR ----------------------------------
 ?>
		<ul>
			<li><a href="<?php $Blog->disp( 'lastcommentsurl', 'raw' ) ?>"><strong><?php echo T_('Last comments') ?></strong></a></li>
		</ul>
	</div>

If you're counting, line 187 is the 'block_start' line. I copied and pasted exactly from the online document, and it looks correct to me. Can someone check my work here? Thanks!

 <?php
   // -------------------------- CALENDAR INCLUDED HERE -----------------------------
   // Call the Calendar plugin:
   $Plugins->call_by_code( 'evo_Calr', array(	// Params follow:
       'block_start'=> '',
       'block_end'=> '',
       'title'=> '',			// No title.
     ) );
   // -------------------------------- END OF CALENDAR ----------------------------------
 ?>

¥

Cool thanks, that made it happy for that bit... now it's saying Parse error: syntax error, unexpected '?' for that line with lastcommentsurl. Strange as that's not even a line I changed... trying to figure out what might have messed up the parsing but not seeing it... :(

fplanque2002 for 1.9.* should be up on the skins site. ah here it is http://skins.b2evolution.net/index.php/2007/03/08/fplanque2002_2

hope it helps

Haha, well that was certainly a lot easier. I feel dumb... didn't even think to look there (figured if it still existed it'd still be bundled).

All is well now and my weblog seems to work just fine on a full direct upgrade. Now to poke around the other themes... I wouldn't mind an upgrade, but it's hard to find a full-width reflowing theme that looks good. Everyone's about the fixed-width these days. :(

On the skins site check out either "floating" or "variable" for the skins width (sidebar - categories) to get away from the fixed width skins. FYI "variable" means at least one part of the page will expand it's width based on font size selection.

Yeah I'm not a fan of fixed width stuff. Especially all the oldies that were new when 800 wide was normal. I'm thinking 1024 wide is the norm these days, so the 800 wide skins are wasting a lot of real estate. Such is life eh?

I tried updating from 0.9.0.12 straight to 1.93 and I'm definitely running into problems. I get to the part where it asks me to convert my old database, then gives me an error message after it tries "Creating table for active sessions..."

It says Additional information about this error:

MySQL error!

Table 'evo_sessions' already exists(Errno=1050)

Your query:

CREATE TABLE evo_sessions (
sess_ID INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
sess_key CHAR(32) NULL,
sess_lastseen DATETIME NOT NULL,
sess_ipaddress VARCHAR(15) NOT NULL DEFAULT '',
sess_user_ID INT(10) DEFAULT NULL,
sess_agnt_ID INT UNSIGNED NULL,
sess_data TEXT DEFAULT NULL,
PRIMARY KEY( sess_ID )
)

Any ideas? I tried repairing the tables, but it doesn't seem to change anything. Please speak slowly, as I am kind of a newbie. I did back up everything.

Thanks

Just an update: I upgraded first to 0.9.2 with no problems. My database schema is now 8066.

Then I tried to go from 0.9.2 to 1.9.3 and am getting the same error I was getting before (see above)...

Any thoughts?

Thanks

Seeing as you have a backup, try this :-

Delete table evo_sessions from your database
Do an upgrade and see if you still get errors

¥

Ok, I followed your advice. After I "dropped" that table in PHPMyAdmin and tried to upgrade, it gave me the same message about table evo_usersettings. So I dropped that one. Then it gave me the same message about evo_poststatuses. So I dropped it. Then evo_plugins. ETC etc etc... So each drop seemed to temporarily work, but each time it found a new one that already existed.

Well if anyone cares, I ended up dropping every single table that didn't have any data in it. This seemed to work. I tried this with version 1.8.7 actually, so I ended up going from 0.9.0.12 to 0.9.2 to 1.8.7 to 1.9.3

Hey, whatever works I guess.