Cant insert new products

Installing my Dolibarr
1

Hi,

I have version 3.6.1 running and I am pretty sure I have not touched anything in the backend since the install. However now when i try and enter a new product, I get an error in the top corner saying… " ErrorFailedToGetInsertedId ".
Without updating to a new version, does anybody know what the error may be?

Thanks in advance

Pièces jointes :

2

The standard approach (Below info from 3.8.0):

  1. Locate the Error Message in the Dolibar sources
root@pag-a52f:/var/www/dolibarr/htdocs# fgrep -r ErrorFailedToGetInsertedId *
product/class/product.class.php:						    $this->error='ErrorFailedToGetInsertedId';
root@pag-a52f:/var/www/dolibarr/htdocs#
  1. Look at the code in question

Though you should check your Database.

Best regards

3

Here is the Missing Attachment for Step 2.

Best regards

Pièces jointes :

4

Can you insert manually a record into table llx_product ?

5

Thanks for the quick response.

I added an entry manually into the products table and noticed the new rowid was NULL. The new product also didn’t show within the dolibarr GUI.
The table seemed to have lost the auto-increment function on the rowid when i looked a little closer so i applied the setting and all seemed to work.
Much appreciated guys

6

I may have created a new problem - once again, I don’t know how all this changed as no one has been in the back end.
I can add the products in via the GUI now but when I go to add the supplier price, I get the following error:

Cannot add or update a child row: a foreign key constraint fails (dbname_dollibar.llx_product_fournisseur_price, CONSTRAINT fk_product_fournisseur_price_fk_product FOREIGN KEY (fk_product) REFERENCES llx_product_2 (rowid))

Are you able to provide any assistance on this one - I’m not too familiar with database language.

Thanks

7

i’ve had a similar problem last week…
it was caused by a problem with database backup and restore during a migration.
the restore script failed after the creation of the tables and the insertions and though the keys were not created neither the auto-increments.
i solved this by doing the migation again in a more strict way (not with phpmyadmin).

@eldy: i dont remember exactly but there was a “CREATE ALGORITHM” stuff in the backup script before the creation of the keys and foreign constraints ! i did not investigate further but it’s not the first time i see it and do not know where it comes from.

8

phpMyAdmin must NEVER be used to make database backup. In most cases ,you won’t be able to restore your backup and a backup you can’t restore is not a backup. The only reliable method is “mysqldump” (the tool used when using first option into dolibarr backup wizard)