vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Database error while making post - PLEASE HELP (https://vborg.vbsupport.ru/showthread.php?t=315535)

XYZ500 11-21-2014 10:12 PM
Database error while making post - PLEASE HELP
 
I am getting a database error on my forum whenever any user (including admins) try to make a post. Surfing the forum seems to be fine, but whenever a user tries to make a post, this error appears and this is not letting anyone make a post.

Here is the screenshot of the error. Just blacked out the website URL and IP.

https://vborg.vbsupport.ru/external/2014/11/14.png

Following is error that is shown in that yellowish box. In the brackets I have written what is shown there, also made that text bold.

Quote:
Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO bocetapost
(showsignature, allowsmilie, htmlstate, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, 'on_nl2br', '(forum username trying to post)', 26828, '(thread title)', '(post content)', 0, 1, 1416614576, '39.32.208.108', 0, 165544);

MySQL Error : Duplicate entry '1133455' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, November 21st 2014 @ 06:02:56 PM
Error Date : Friday, November 21st 2014 @ 06:02:56 PM
Script : http://domain.com/newthread.php?do=postthread&f=89
Referrer : http://domain.com/newthread.php?do=newthread&f=89
IP Address : 39.32.xxx.xxx
Username : (forum username trying to post)
Classname : vB_Database
MySQL Version : 5.1.69



PLEASE TELL ME HOW TO FIX THIS ERROR ASAP.

squidsk 11-22-2014 12:22 PM
A quick guess would be someone/something has played around with the autoincrement postid value for the post table.

To check this issue the following two mysql commands:

Code:
select max(postid) from bocetapost
and

Code:
SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = "DATABASE NAME"
AND TABLE_NAME = "bocetapost"
Note: Don't forget for the second query to change the db name to the one for your db.

If the second number is less than or equal to the first, take note of the postid from the first and run the following query:

Code:
ALTER TABLE bocetapost AUTO_INCREMENT = postid + 1;

Lynne 11-22-2014 06:10 PM
You can try doing an optimize/repair on the bocetapost table under Maintenance > Optimize/Repair > select the table > Continue

Paul M 11-22-2014 10:48 PM
Run a repair on the "bocetapost" table.


All times are GMT. The time now is 10:43 AM.

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.01162 seconds
  • Memory Usage 1,719KB
  • 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
  • (3)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete