Oh no... I tried to convert my forums to InnoDB, it went wrong so I switched it back.. now I get this error when I post a reply/new thread:
Have I really broken it or do I have any hope?
How can I get the keys to go back to normal?
Have I really broken it or do I have any hope?
Database error in vBulletin 3.0.5:
Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
(1733735, 0, 'Test',
'Ian Cunningham', 1, 1117874948,
'Test', 1, 1,
'xxx.xx.xxx.xxx', 0, 1, 0)
mysql error: Duplicate entry '5151714' for key 1
mysql error number: 1062
Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
(1733735, 0, 'Test',
'Ian Cunningham', 1, 1117874948,
'Test', 1, 1,
'xxx.xx.xxx.xxx', 0, 1, 0)
mysql error: Duplicate entry '5151714' for key 1
mysql error number: 1062
Comment