Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2015, 08:25 PM
Elizabeth_1977 Elizabeth_1977 is offline
 
Join Date: Oct 2009
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error (when trying to post)

How do I get rid of this?

I started getting it after I added the following plugin:

https://vborg.vbsupport.ru/showthread.php?t=320877
Attached Images
File Type: jpg database error.jpg (61.2 KB, 0 views)
Reply With Quote
  #2  
Old 11-23-2015, 08:29 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That plugin shouldn't be the cause of it.
Could you post the full error you're receiving in that yellow area here?
Reply With Quote
  #3  
Old 11-23-2015, 08:33 PM
Elizabeth_1977 Elizabeth_1977 is offline
 
Join Date: Oct 2009
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It was fine prior to that. I had already posted twice without a problem.

I tried to copy the text in the yellow box, but it just wouldn't let me for some strange reason.
Reply With Quote
  #4  
Old 11-23-2015, 08:43 PM
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Posts: 969
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Right click on the page and click view page source then find the error message and copy it to here.
Reply With Quote
  #5  
Old 11-23-2015, 08:46 PM
Elizabeth_1977 Elizabeth_1977 is offline
 
Join Date: Oct 2009
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Got it:

Database error in vBulletin 4.2.3:

Invalid SQL:

INSERT INTO vbpostlog
(postid, useragent, ip, dateline)
VALUES
(6, 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:41.0) Gecko/20100101 Firefox/41.0', 1289670912, 1448318724);

MySQL Error : Duplicate entry '6' for key 'PRIMARY'
Error Number : 1062
Request Date : Monday, November 23rd 2015 @ 04:45:24 PM
Error Date : Monday, November 23rd 2015 @ 04:45:25 PM
Script : http://www.woofster.net/newthread.ph...ostthread&f=70
Referrer : http://www.woofster.net/newthread.php?do=newthread&f=70
IP Address : 76.222.209.0
Username : Elizabeth
Classname : vB_Database_MySQLi
MySQL Version : 5.5.44-37.3-log
Reply With Quote
  #6  
Old 11-23-2015, 08:54 PM
Dragonsys's Avatar
Dragonsys Dragonsys is offline
 
Join Date: Jan 2008
Location: DFW, Texas
Posts: 743
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

that plugin wouldn't cause that error. Try completely refreshing the page and then post again. Looks like you have a "stuck" post in your browser cache, since the Primary Key (which should be auto generated by the DB) is complaining about being Duplicate.
Reply With Quote
  #7  
Old 11-23-2015, 08:56 PM
Elizabeth_1977 Elizabeth_1977 is offline
 
Join Date: Oct 2009
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually, I had to switch browsers to copy and paste that here because it wouldn't copy in IE. So, I used Firefox to do it.

That said, it happens regardless of what browser is used. I tried clearing things but I still get this.
Reply With Quote
  #8  
Old 11-23-2015, 09:01 PM
Dragonsys's Avatar
Dragonsys Dragonsys is offline
 
Join Date: Jan 2008
Location: DFW, Texas
Posts: 743
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well, the plugin shouldn't cause the issue, but just to test, disable that plugin and try posting again.
Reply With Quote
  #9  
Old 11-23-2015, 09:10 PM
Elizabeth_1977 Elizabeth_1977 is offline
 
Join Date: Oct 2009
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Done. Still getting the error:

Database error in vBulletin 4.2.3:

Invalid SQL:

INSERT INTO vbpostlog
(postid, useragent, ip, dateline)
VALUES
(7, 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; yie11; rv:11.0) like Gecko', 1289670912, 1448320134);

MySQL Error : Duplicate entry '7' for key 'PRIMARY'
Error Number : 1062
Request Date : Monday, November 23rd 2015 @ 05:08:54 PM
Error Date : Monday, November 23rd 2015 @ 05:08:54 PM
Script : http://www.woofster.net/newthread.ph...stthread&f=112
Referrer : http://www.woofster.net/newthread.ph...ewthread&f=112
IP Address : 76.222.209.0
Username : Elizabeth
Classname : vB_Database_MySQLi
Attached Images
File Type: jpg database error.jpg (61.9 KB, 0 views)
Reply With Quote
  #10  
Old 11-23-2015, 09:17 PM
Elizabeth_1977 Elizabeth_1977 is offline
 
Join Date: Oct 2009
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Does anyone have any thoughts or suggestions as to what's going on and how to fix it?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:35 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.10858 seconds
  • Memory Usage 2,259KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete