Ran the upgrade script to upgrade from 1.0.1 to 1.1.0 and it said
Database error in vBulletin 3.0.3:
Invalid SQL: alter table vb3_vbchat_datastore
add d_smiliedisplay tinyint(2) not null default '1',
add d_smilieamount int(15) not null default '10',
add d_allowbantag tinyint(2) not null default '1',
add d_chatrooms text not null default '',
add d_maxrooms int(15) not null default '5';
mysql error: Table 'kiareese_uof.vb3_vbchat_datastore' doesn't exist
This was when clicking the "Apply database modifications"
hmm, now the chat window comes up with
Quote:
Database error in vBulletin 3.0.3:
Invalid SQL: select m.*,u.* from vbchat_store m
left join user u on (u.userid = m.s_postby) where m.s_forroom = '0' order by m.s_postime desc limit 0,15
mysql error: Unknown column 'm.s_forroom' in 'where clause'
mysql error number: 1054
|