× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Add Edit View - new entry 1062 error

  • mandalas.hotmail.co
  • Offline
More
7 years 11 months ago #3841 by mandalas.hotmail.co
Add Edit View - new entry 1062 error was created by mandalas.hotmail.co
I created a menu item for adding DB entries in front end but when I create a new record I get the following error: 1062 - Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__joodb_zitate` (`ID`,`Autor`,`Titel`,`Title`,`Format_de`,`Format_en`,`Text_deutsch`,`Text_english`) VALUES ('0','Tom Author','Toms Title','Toms Title','Buch','book','<p>Toms new book</p>','<p>Toms new book</p>')

What is it I'm doing wrong?

Please Log in to join the conversation.

More
7 years 11 months ago #3842 by Dirk
Replied by Dirk on topic Add Edit View - new entry 1062 error

mandalas.hotmail.co wrote: 1062 - Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__joodb_zitate` (`ID`)


The field ID must not only be primary field. It must be set as AUTO_INCREMENT and Primary Key for your JooDB database.

Please Log in to join the conversation.

  • mandalas.hotmail.co
  • Offline
More
7 years 11 months ago #3843 by mandalas.hotmail.co
Replied by mandalas.hotmail.co on topic Add Edit View - new entry 1062 error
That's sorted the problem. Thank you.

Please Log in to join the conversation.

Moderators: Dirk, joest