[Paul M]

Originally Posted by Romeos Tune

Hey Paul,

I'm running VB3.03 and the latest FlashChat.... For some reason I'm getting this error. It's adding an extra vb3_ it seems when doing the queries.... I'm still too new to figure this out I guess..... Any help would be appreciated.....

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb3_vb3__fc_connections as connections
LEFT JOIN vb3_vb3__fc_rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN vb3_user as user ON(connections.userid = user.userid)
LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start
mysql error: Table 'vb.vb3_vb3__fc_connections' doesn't exist

mysql error number: 1146

Which versions of flashchat, and this hack are you using ?

The 'vb3_' is your vB table prefix, because it assumes the flashchat tables were also created with this prefix. On top of this there is also a flashchat prefix which was added in 4.0.x which has complicated matters. Does your chat actually work ? What are you flashchat tables actually called ? What prefix (pref) is defined in your flashchat config.srv.php ?