Current time: 07-30-2014, 05:00 AM Hello There, Guest! (LoginRegister)


SQL Error: 1062 ?
03-22-2011, 03:32 PM (This post was last modified: 03-22-2011 04:08 PM by sia1.)
Post: #1
Not Solved SQL Error: 1062 ?
hello
i have this problem
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
Code:
SQL Error:
1062 - Duplicate entry '23259' for key 1
Query:
INSERT INTO mybb_users (`username`,`password`,`salt`,`loginkey`,`email`,`postnum`,`avatar`,`avatartype`​,`usergroup`,`additionalgroups`,`displaygroup`,`usertitle`,`regdate`,`lastactive​`,`lastvisit`,`website`,`icq`,`aim`,`yahoo`,`msn`,`birthday`,`signature`,`allown​otices`,`hideemail`,`subscriptionmethod`,`receivepms`,`pmnotice`,`pmnotify`,`rem​ember`,`showsigs`,`showavatars`,`showquickreply`,`showredirect`,`tpp`,`ppp`,`inv​isible`,`style`,`timezone`,`dstcorrection`,`threadmode`,`daysprune`,`dateformat`​,`timeformat`,`regip`,`longregip`,`language`,`showcodebuttons`,`away`,`awaydate`​,`returndate`,`awayreason`,`notepad`,`referrer`,`buddylist`,`ignorelist`,`pmfold​ers`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensi​ontime`,`coppauser`,`classicpostbit`) VALUES ('test4','dc4bd9a397235b2c3289d9eed7d6c0ee','QNFicoiQ','FSw53exQKYOpXRgLgLL6IMQn​ICaKZKHaHhaqzBMqmUZs4rte7Q','[email protected]','0','','','5','','0','','1300807131'​,'1300807131','1300807131','','0','','','','','','1','0','0','1','1','0','1','1'​,'1','1','1','0','0','0','0','3.5','2','linear','0','','','109.225.160.205','184​3503309','','1','0','0','0','','','0','','','','0','0','0','0','0','0','1')
Please contact the MyBB Group for support.
when user come to register in my forum
i have also this error
SQL Error:
1030 - Got error 134 from storage engine
when i try to edite or delete user

please help me
site:www.civilstars.com

http://www.civilstars.com
engineering forum
Find all posts by this user
03-23-2011, 12:42 AM
Post: #2
Not Solved RE: SQL Error: 1062 ?
It seems like your db has some crashed tables.

Log in to phpmyadmin, analyze and repair the database to fix the tables.
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication