Entries with ID 0 are randomly inserted.

edited August 2014 in Modules
Hey guys. I have no idea what's going on. I have been working on a site for some time and decided yesterday to upgrade it to v1.0 of the CMS. However, it seems that there are entries with id 0 inserted in various tables of the database.

I've implemented migrations this time, and set up a few tables, including a 'News' table and module. Inserted around 10 news successfully, then when creating the next article, upon clicking 'Save' it decided to insert it with id 0, and I could no longer view it in the CMS so had to change its ID via phpmyadmin.

Seems this has now occurred in the navigation as well! Been receiving "maximum nesting error" for some time when I noticed the 'fuel_navigation' table had an entry with ID 0 as well.

Any idea what might be the cause of this?

Comments

  • edited 11:18PM
    I've ran into issues in the past with MySQL inserting 0s for auto_increment values and had to restart MySQL.
  • edited 11:18PM
    Thanks. I hit "Restart all services" on WAMP, and that seemed to take care of the problem.
    * crosses fingers *
  • edited 11:18PM
    What version of MySQL are you running out of curiosity?
  • edited 11:18PM
    Sorry, forgot to reply. It's 5.6.12
Sign In or Register to comment.