LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 08-16-2006, 09:29 PM   #1
w0lv3r1ne
LQ Newbie
 
Registered: Aug 2006
Posts: 1

Rep: Reputation: 0
Mysql Error: Duplicate entry '0' for key 1


I moved my MYBB forum to a new server. I imported the DB with phpmyadmin but am getting an error when trying to post a new thread (the forum displays correctly, and users can login fine).

The error is:

Code:
mySQL error: 1062
Duplicate entry '0' for key 1
Query: INSERT INTO mybb_threads (fid, subject, icon, uid, username, dateline, lastpost, lastposter, views, replies, visible) VALUES ('9', 'test', '0', '1', 'tta-admin', '1155781406', '1155781406', 'tta-admin', '0', '0', '1');
Note: tta-admin is my username

What can I do to fix this error? On the server im trying to import to, im running MySQL version 4 and phpMyAdmin 2.8.0.2.
 
Old 08-17-2006, 03:30 AM   #2
spirit receiver
Member
 
Registered: May 2006
Location: Frankfurt, Germany
Distribution: SUSE 10.2
Posts: 424

Rep: Reputation: 33
Please post the result of
Code:
DESCRIBE mybb_threads;
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to restore mysql dump, error 1062: Duplicate entry mackdav Linux - Software 1 04-25-2006 03:02 AM
Bad Key / No Key Error MySql wasabi Linux - Software 1 04-19-2005 06:06 PM
Im getting a mysql_error Duplicate entry? blanderson Linux - Newbie 0 10-17-2003 12:29 PM
mysql dupe entry error, how to avoid? hydro Linux - Software 0 09-20-2003 12:08 PM
Error: Acct: Couldn't insert SQL accounting START record - Duplicate entry '15212' fo ethanchic Linux - Software 0 04-11-2003 10:48 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:49 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration