vb.org Archive - MySQL Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - MySQL Error (https://vborg.vbsupport.ru/showthread.php?t=282776)

DaChief

05-11-2012 10:49 AM

MySQL Error

Everytime a user tries to registrate on my site, I get a MySQL DB Error:

Code:

Invalid SQL:

INSERT INTO userfield

        (userid)

VALUES

        (114);



MySQL-Fehler  : Doppelter Eintrag '114' f?r Schl?ssel 'PRIMARY'

Fehler-Nr.    : 1062

Fehler-Zeit   : Friday, 11.05.2012 @ 12:09:51

Datum         : Friday, 11.05.2012 @ 12:09:51

Skript        : http://www.multirotor-community.eu/forumrunner/request.php

Referrer      : 

IP-Adresse    : 212.17.66.3

Benutzername  : test

Klassenname   : vB_Database

MySQL-Version :

This is really annoying, because users can't sign up on my site!
Can anyone help me please?
I already tried to repair/optimize tables and reset Cache.

I also went to the db via phpAdmin but can't really find the issue

kh99	05-11-2012 11:05 AM

I believe it's saying that the userfield table already has a value of 114 for the primary key (userid), and you're trying to insert another userid of 114. In other words it's trying to create a user with a duplicate userid.

It's hard to say what to do without knowing exactly what's going on, but I suppose what you want to do is figure out what the highest userid in the user table and see how that compares to the userfield table.

All times are GMT. The time now is 01:46 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01025 seconds Memory Usage 1,708KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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
Messages: