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]

Originally Posted by 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?

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]

Originally Posted by 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 ;

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]

Originally Posted by ForceHSS

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 [DATE]1429291943[/DATE] at [TIME]1429291943[/TIME] ---------------

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