UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Duplicate Entries MySQL Error for w3t_Online

This may be related to the "I've been hacked" post, but I cannot see that the config.inc.php was to blame. I was getting errors of the form:

Script: /home/forums/htdocs/ubbt.inc.php
Line#: 536
SQL Error: Duplicate entry '1huskerfan' for key 1
SQL Error #: 1062
Query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Board,O_Extra,O_Read,O_Type) VALUES ('1huskerfan','59708','1158509503','ubbthreads','','','','r')

or for other keys and the forum was unusable. I finally did a repair of the table and that fixed it (finding a bunch of duplicate entries). But I am not sure what happened in the first place and what I need to do to prevent it from happening again.

Chuck Weinstock
forumserver.twoplustwo.com
ubbt: 6.5.2 with security fixes

This can happen to the Online table from time to time, it's pretty much a temporary table and gets updated on every page load for every user. Usually a repair, as you noticed, will fix it, or you can just delete everything from it as well and that will fix it.