There's a ";" missing after the create table statement; you might want to execute the statements seperately...
That was a VERY bad idea. The upgrade notice actually provides a pointer on how to upgrade. You should NEVER delete either any files or the database table, because then s9y cannot upgrade or migrate specific things...Yes, used an old one, set it up, delted the db in the dbms, import the old one, rewrite the version to the old version, let the update roll, regenerate .htacces, import octopress articles via RSS, renew articles and now I'm here.
Even though what I wrote above should basically work, you might face further issues along the way, so let's keep this in mind
Regards,
Garvin