I've had someone look into my database b/c I was getting high loads for no apparent reason and they said some of the tables were a bit screwed up. We tried to do a fresh install and move over the users, threads/replies, and forums over but we kept getting db errors:
Before we tried to move the tables over, we first uninstalled all of the mods I had installed. The fresh install didn't have any mods either.
I just want to make sure everything is running tiptop so is there any reason as to what is causing this or is the a solution on how move users/usergroups, threads, and forum categories over? I really could care less about anything else such as infractions (since I see that mentioned in the error).
More information on my situation; I had originally converted from IPB to vB, so I'm assuming that some of the problems with my tables may lie there.
Code:
<!-- Database error in vBulletin 3.6.8: Invalid SQL: SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1188406362 ORDER BY username ASC; MySQL Error : Unknown column 'infractiongroupid' in 'field list' Error Number : 1054 Date : Wednesday, August 29th 2007 @ 12:07:42 PM Script : http://www.***.com/forums2/ Referrer : http://www.***.com/forums2/ IP Address : *** Username : Unregistered Classname : vb_database -->
I just want to make sure everything is running tiptop so is there any reason as to what is causing this or is the a solution on how move users/usergroups, threads, and forum categories over? I really could care less about anything else such as infractions (since I see that mentioned in the error).
More information on my situation; I had originally converted from IPB to vB, so I'm assuming that some of the problems with my tables may lie there.
Comment