DB Error Upgrading from 3.0.6

[ekool]

As seen in this thread: http://www.vbulletin.com/forum/showthread.php?p=1153822#post1153822

I am having the same issue. I have not modified the file, I have uploaded it twice and I have done NUMEROUS upgrades.

I ran a grep on the file and also have found that the sql statement does not exist, yet there is the error.

I removed my forums directory and uploaded ONLY the 3.6b3 files and yet the error persisted.

Uploading 3.5 worked fine... so I believe it to be a 3.6 problem.

[Colin F]

I'm pretty sure this is a bug in the new upgrade functions.
Please report this in the bug tracker.

[zetetic]

As explained in my thread I started a bug report about this and Freddie directed me to this report (http://www.vbulletin.com/forum/bugs36.php?do=view&bugid=287) of the same bug. The solution is in Freddie's last post on that thread, just make sure to change "datatype datatype" to "datatype" if you use his code or query to fix it.