LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Mysql Error: Duplicate entry '0' for key 1 (https://www.linuxquestions.org/questions/linux-server-73/mysql-error-duplicate-entry-%270%27-for-key-1-a-474596/)

w0lv3r1ne 08-16-2006 09:29 PM

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.

spirit receiver 08-17-2006 03:30 AM

Please post the result of
Code:

DESCRIBE mybb_threads;


All times are GMT -5. The time now is 09:01 AM.