database duplicate entry
 

Hello.

I have transfered all of my data from old server to new server.
on both servers i have Cpanel, So it was not a problem for me to transfer the data and import it into Cpanel on new server.

But on new server its giving data base error when some one try to reply a Post or send a new post.

Error is as follow:

Quote:
Database error in vBulletin 3.7.3:

Invalid SQL:
INSERT INTO vbtesttable_post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(0, 1, 'Salman Ahmed', 1, '', 'test', 0, 1, 230867, 64500, 1247688292, '95.172.239.38', 0);

MySQL Error : Duplicate entry '454679' for key 1
Error Number : 1062
Request Date : Wednesday, July 15th 2009 @ 09:04:52 PM
Error Date : Wednesday, July 15th 2009 @ 09:04:52 PM
Script : http://urdustar.com/home/newreply.ph...treply&t=64500
Referrer : http://urdustar.com/home/qawaneen-ai...hannels-3.html
IP Address : 95.172.239.38
Username : Salman Ahmed
Classname : vB_Database_MySQLi
MySQL Version : 5.0.81-community
on another side , i will receie this message in my admin Email from vbulletin:



Quote:
Database error in vBulletin 3.7.3:

Invalid SQL:
INSERT INTO vbtesttable_post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(0, 1, 'Salman Ahmed', 1, '', 'test', 0, 1, 230867, 64500, 1247688292, '95.172.239.38', 0);

MySQL Error : Duplicate entry '454679' for key 1
Error Number : 1062
Request Date : Wednesday, July 15th 2009 @ 09:04:52 PM
Error Date : Wednesday, July 15th 2009 @ 09:04:52 PM
Script : http://urdustar.com/home/newreply.ph...treply&t=64500
Referrer : http://urdustar.com/home/qawaneen-ai...hannels-3.html
IP Address : 95.172.123.12
Username : Salman Ahmed
Classname : vB_Database_MySQLi
MySQL Version : 5.0.81-community
Can someone please tell me the solution for this ?

Thank you very much.

Salman.