[brianstevz]

Originally Posted by bitg

I made the mistake of attempting to upgrade from 1.0.0 to 1.1.1 using the upgrade script (1.1.0-1.1.1). I did not seem to have a problem when running the install script even though it was obviously it is the wrong script. Anyway, when I update my "vBChat Options" I get the following database error:

Database error in vBulletin 3.0.1:

Invalid SQL: update vbchat_datastore set d_online='yes',d_allowbbcode='yes',d_bannedgroups='1|3|8|11',d_bannedusers='',d_chat_order='bottom',d_smiliedisplay='1',d_smilieamount='10',d_allowbantag='1',d_maxrooms='5',d_smilequery='0',d_autoprune='1',d_autoprunedays='1' where did='1'
mysql error: Unknown column 'd_chat_order' in 'field list'

mysql error number: 1054

Ideas?

I did the same thing. You need to go to your SQL tables and drop anything with VBChat in it. There should be two user files and two main files. Then try to install. You should get another error since the SQL tables are now gone. I did that and it installed fine.