Hi Paul. I am having trouble and I hope you can point me in the right direction.
I am getting this error on the forum home page when I turn on this mod.
Quote:
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT connections.*, rooms.*, user.*
FROM flashchat_connections as connections
LEFT JOIN flashchat_rooms as rooms ON connections.roomid = rooms.id
LEFT JOIN byt_user as user ON connections.userid = user.userid
WHERE connections.userid > 0 AND connections.ip != '0.0.0.0'
AND connections.updated > DATE_SUB(NOW(),INTERVAL 60 SECOND)
ORDER BY start;
MySQL Error : Unknown column 'connections.userid' in 'where clause'
Error Number : 1054
|
Flashchat works fine (just installed the latest version) and the forum works fine when this mod is not turned on. I tried repairing tables etc and now I am helpless! LOL
My guess is there is a problem with a table? It looks like it is searching for "connections.userid'" and can not find it or it is corrupt? I have tried uninstalling and reinstalling this mod a few times. Same error.
Any help is appreciated!
Thanks!