MySQL Error : Duplicate entry '0' for key 'PRIMARY'

[EvoDarrenshan]

I get this when making a new thread

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, dateline, open, attach, lastpost, lastposter, lastposterid, replycount, postercount, hiddencount, deletedcount, keywords)
VALUES
('', 'Silas', 1, 'fdsafdsfdsfds', 0, 1, 5, 1429216987, 1, 0, 1429216987, 'Silas', 1, 0, 1, 0, 0, 'fdsfdsfdsfsdfv, fdsafdsfdsfds');

MySQL Error : Duplicate entry '0' for key 'PRIMARY'
Error Number : 1062
Request Date : Thursday, April 16th 2015 @ 10:43:07 PM
Error Date : Thursday, April 16th 2015 @ 10:43:07 PM
Script : #/newthread.php?do=postthread&f=5
Referrer : #/newthread.php?do=newthread&f=5
IP Address : 86.179.6.189
Username : Silas
Classname : vB_Database
MySQL Version : 5.1.73

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 444
#2 vB_Database->query_write() called in [path]/includes/class_dm.php on line 740
#3 vB_DataManager->db_insert() called in [path]/includes/class_dm_threadpost.php on line 1769
#4 vB_DataManager_Thread_FirstPost->save() called in [path]/includes/functions_newpost.php on line 697
#5 build_new_post() called in [path]/newthread.php on line 237
#6 require([path]/newthread.php) called in [path]/dbseo.php on line 474

Then when making a plugin

Database error in vBulletin 4.2.2:

Invalid SQL:

INSERT INTO productcode
(productid, version, installcode, uninstallcode)
VALUES
('silent_payments',
'*',
'$path = DIR . \'/silent/payments\';\r\nif(!file_exists($path . \'/install/install.php\'))\r\n{\r\n print_dots_stop();\r\n print_cp_message($path . \'/install/install.php is missing or unreadable.\');\r\n}\r\n\r\nrequire($path . \'/install/install.php\');',
'');

MySQL Error : Duplicate entry '0' for key 'PRIMARY'
Error Number : 1062
Request Date : Thursday, April 16th 2015 @ 10:42:50 PM
Error Date : Thursday, April 16th 2015 @ 10:42:50 PM
Script : #/admincp/plugin.php?do=productimport
Referrer : #/admincp/plugin.php?do=productadd
IP Address : 86.179.6.189
Username : Silas
Classname : vB_Database
MySQL Version : 5.1.73

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 444
#2 vB_Database->query_write() called in [path]/includes/adminfunctions_plugin.php on line 1231
#3 install_product() called in [path]/admincp/plugin.php on line 1749

[Lynne]

The productcode table should have the field productcodeid set to AUTO_INCREMENT, is it?

And, the thread table should have the field threadid set to AUTO_INCREMENT, is it?

[EvoDarrenshan]

The productcode table should have the field productcodeid set to AUTO_INCREMENT, is it?

And, the thread table should have the field threadid set to AUTO_INCREMENT, is it?

Where do i find this? is this it? http://i.gyazo.com/582b49436f4e89dc003d0d4ca6923535.png

[ForceHSS]

Run these two queries from your admincp


ALTER TABLE `productcode`
MODIFY COLUMN `productcodeid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;



ALTER TABLE `thread`
MODIFY COLUMN `threadid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

[EvoDarrenshan]

Run these two queries from your admincp


ALTER TABLE `productcode`
MODIFY COLUMN `productcodeid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;



ALTER TABLE `thread`
MODIFY COLUMN `threadid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;


Done same error still occurs.

[ForceHSS]

When you ran them what did it say after you did

[EvoDarrenshan]

ALTER TABLE `productcode`
MODIFY COLUMN `productcodeid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST


vBulletin Message
Affected Rows: 45 (0.0422s)
ALTER TABLE `thread`
MODIFY COLUMN `threadid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST


vBulletin Message
Affected Rows: 62 (0.0137s)

[ForceHSS]

And what error messages do you get now

[EvoDarrenshan]

And what error messages do you get now

Database error in vBulletin 4.2.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'AP', 'admin_global', 'require(DIR . \'/silent/payments/hooks/admin_global.php\');', 'silent_payments');

MySQL Error : Duplicate entry '0' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, April 17th 2015 @ 06:38:57 PM
Error Date : Friday, April 17th 2015 @ 06:38:58 PM
Script : #/admincp/plugin.php?do=productimport
Referrer : #/admincp/plugin.php?do=productadd
IP Address : #
Username : Silas
Classname : vB_Database
MySQL Version : 5.1.73

[ForceHSS]

ALTER TABLE `plugin`
MODIFY COLUMN `pluginid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

--------------- Added 1429291943 at 1429291943 ---------------

You seem to be having a lot of problems with your tables when did this all start

[EvoDarrenshan]

ALTER TABLE `plugin`
MODIFY COLUMN `pluginid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

--------------- Added 1429291943 at 1429291943 ---------------

You seem to be having a lot of problems with your tables when did this all start


That helped with plugins but not with posts/threads but plugins are now fixed :D

[ForceHSS]

Post errors will see if I can fix more or if you want me to go over your whole db I can but you need access

[Lynne]

This doesn't suddenly happen especially to so many tables. We may just be putting a bandaid on your database. What happened just before these errors started? Do you have a database backup from before this started?