THELIA Forum

Welcome to the THELIA support and discusssion forum

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.


CQFDev | Sites, boutiques, modules, développement et intégration pour Thelia 1 et 2

Offline


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