Seems to be working great. Thanks, Tammy!

I just deleted all this dbquery("alter table ".$tableprefix."fanfiction_blocks drop index block_name;");dbquery("alter tabl...

This is the line I deleted dbquery("alter table ".$tableprefix."fanfiction_blocks drop index block_name;");I created the tables by...

I get this nowA fatal MySQL error was encountered.Query: alter table bah1fanfiction_blocks add unique index block_name (block_name);Error: (1062) Dupl...

I get thisA fatal MySQL error was encountered.Query: alter table bah1fanfiction_authorinfo add primary key(uid,field);Error: (1068) Multiple primary k...

I had to go and manually rename them all with the prefix. This got the site running but still getting this error message when I go to upgrade from 3.0...

Ok...my other  problem is fixed. I recreated the tables, got the site up and running again, deleted primary from admin/update.php...now get thisA...

...only thing I can think I did was put the table prefix as bah1 (it was blank) The original table should have been bah

*head desk* I am such an idiot...only thing I can think I did was put the table prefix as bah1 (it was blank) I got a warning, created the table, now ...

After I click update I get:A fatal MySQL error was encountered.Query: alter table fanfiction_authorinfo add primary key(uid,field);Error: (1068) Multi...