THELIA Forum

Welcome to the THELIA support and discusssion forum

Announcement

Rejoignez la communauté sur le Discord Thelia : https://discord.gg/YgwpYEE3y3

Offline


Im receiving lots of error working with a fresh install of thelia 2. when I register a customer the following error appear:

Sorry, an error occured: Unable to execute INSERT statement [INSERT INTO `address` (`ID`, `LABEL`, `CUSTOMER_ID`, `TITLE_ID`, `COMPANY`, `FIRSTNAME`, `LASTNAME`, `ADDRESS1`, `ZIPCODE`, `CITY`, `COUNTRY_ID`, `PHONE`, `CELLPHONE`, `IS_DEFAULT`, `CREATED_AT`, `UPDATED_AT`) VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15)]

with other functions it happens too to display problems inserting statements.
any idea?
brgds
sebastian

Offline


There is something wrong with your database. Check that the database user you're using has INSERT permissions. You may also try to recreate the database from scratch.


OpenStudio Toulouse

Offline


I checked my mysql and it seems to be STRICT_TRANS_TABLES problem. i remove that option and it works. thank you!.

Offline