vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   MySQL Error : Duplicate entry '0' for key 'PRIMARY' (https://vborg.vbsupport.ru/showthread.php?t=318272)

EvoDarrenshan 04-16-2015 06:44 PM
MySQL Error : Duplicate entry '0' for key 'PRIMARY'
 
I get this when making a new thread

Code:
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

Code:
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 04-16-2015 08:23 PM
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 04-17-2015 12:09 AM
Quote:
Originally Posted by Lynne (Post 2543269)
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 04-17-2015 01:00 AM
Run these two queries from your admincp

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

EvoDarrenshan 04-17-2015 02:27 AM
Quote:
Originally Posted by ForceHSS (Post 2543297)
Run these two queries from your admincp

Code:
ALTER TABLE `productcode`
MODIFY COLUMN `productcodeid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;
Code:
ALTER TABLE `thread`
MODIFY COLUMN `threadid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;
Done same error still occurs.

ForceHSS 04-17-2015 11:45 AM
When you ran them what did it say after you did

EvoDarrenshan 04-17-2015 01:11 PM
Code:
ALTER TABLE `productcode`
MODIFY COLUMN `productcodeid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST


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


vBulletin Message
Affected Rows: 62 (0.0137s)

ForceHSS 04-17-2015 02:35 PM
And what error messages do you get now

EvoDarrenshan 04-17-2015 02:39 PM
Quote:
Originally Posted by ForceHSS (Post 2543353)
And what error messages do you get now
Code:
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 04-17-2015 03:29 PM
Code:
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


All times are GMT. The time now is 08:14 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01125 seconds
  • Memory Usage 1,748KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (10)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete