[voter]

Originally Posted by karel1985

today i had a really major vbulletin database error,

suddenly nothings works anymore and i about one hour i got 200 error messages in my mailbox



the last line 'scipt' is always different, login, forum.php, etc...

for solving the prob i disabled all my producthacks and then enabled one by one
everything is working til the last one was this hack and when i enable it, again vb errors

any suggestion what happened???

Same staff happen to me not once.

REPLACE INTO vbguest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('27afa7c9d161e4eadc7ee2bfda9d874b', '91.103.25.142', 'Opera/9.27
(Windows NT 5.1; U; ru)', 1212415507, '', 'adv_index',
'a:6:{s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s:8:\" threadid\";i:0;s:7:\"forumid\";i:0;s:6:\"pollid\"; i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Duplicate entry '27afa7c9d161e4eadc7ee2bfda9d874b' for
key 1

I found out that it happen at same time as I was backuping my database. Seems for host server it was to much staff to do all databse replacements read etc staff at once.

Paul could it be that one escpae such errors when Duplicate entry escaped by generating the ids for guest more randomly or just escape the usage of REPLACE. INSERT will be ok and it is in not important to replace the information of already existing guests. Sure one will count them same guest more than once, but at least the error will not come out.