• Registered: 2011-03-28
  • Posts: 12

Topic: Database reported: Duplicate entry '0' for key 2 (Errno: 1062)

A few minutes ago I could post new threads

Now I see this error when creating (I turn on "DEBUG mode" in config.php)

An error was encountered

The error occurred on line 1901 in /public_html/forum/include/functions.php

Database reported: Duplicate entry '0' for key 2 (Errno: 1062).

  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: Database reported: Duplicate entry '0' for key 2 (Errno: 1062)

Check DB for errors.

3 Reply by Awilum (edited by Awilum 2011-03-28 18:56)

  • Registered: 2011-03-28
  • Posts: 12

Re: Database reported: Duplicate entry '0' for key 2 (Errno: 1062)

I try to Optimize, repair tables from PMA and nothing. And I have a same problem   sad

  • Registered: 2011-03-28
  • Posts: 12

Re: Database reported: Duplicate entry '0' for key 2 (Errno: 1062)

with define('FORUM_SHOW_QUERIES', 1);  when I try  to create a thread

Failed query: INSERT INTO topics (poster, subject, posted, last_post, last_poster, forum_id) VALUES('Awilum', 'test', 1301339646, 1301339646, 'Awilum', 4)