3.1

Muggle Witch, your newest reply to this thread was moved and merged with your other post nonvalid MySQL result resource. And once again as Jan_AQ stated:

Muggle Witch,

this is the update thread, so small questions pertaining to the update are okay to post here that other people will most likely have as well (as everyone will be reading this thread), but other questions may be too intensive for this thread.

You should start a new topic using the support template.

https://efiction.org/forums/index.php?topic=4121.0

Right now I have no idea what's going on with your problem, if it's a updated problem, or a bug, I have no idea.

Start a new topic, probably in Version 3.0 Installation and Upgrade Support.

Please do not ask for support within any of the news topics.

jrabbit, I tried running your

create temporary table t (uid int, field int, info varchar(255), id int);

ect...

But I got an error.

Error

SQL query:

ALTER TABLE fanfiction_authorinfo ADD COLUMN id int NOT NULL KEY AUTO_INCREMENT ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'key auto_increment' at line 1

You might want to check over it, unless it was something I did?

which version of mysql do you run?

looking at the manual for older versions of mysql, changing the order of the keywords and explicitly defining the key as primary may help.

ALTER TABLE fanfiction_authorinfo ADD COLUMN id int NOT NULL AUTO_INCREMENT PRIMARY KEY;