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