SolidInvoice icon indicating copy to clipboard operation
SolidInvoice copied to clipboard

Exception throw during creating database schema

Open fd6130 opened this issue 4 years ago • 0 comments

I have mariadb in my local machine so i pick mysql driver in installation page and during creating database schema i get the following exception:

Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE recurring_invoices ADD client_id INT DEFAULT NULL, ADD status VARCHAR(25) NOT NULL, ADD terms LONGTEXT DEFAULT NULL, ADD notes LONGTEXT DEFAULT NULL, ADD total_amount INT DEFAULT NULL, ADD total_currency VARCHAR(3) DEFAULT NULL, ADD baseTotal_amount INT DEFAULT NULL, ADD baseTotal_currency VARCHAR(3) DEFAULT NULL, ADD tax_amount INT DEFAULT NULL, ADD tax_currency VARCHAR(3) DEFAULT NULL, ADD discount_value_percentage DOUBLE PRECISION DEFAULT NULL, ADD discount_type VARCHAR(255) DEFAULT NULL, ADD discount_valueMoney_amount INT DEFAULT NULL, ADD discount_valueMoney_currency VARCHAR(3) DEFAULT NULL, DROP invoice_id, DROP deleted, CHANGE date_start date_start DATE NOT NULL COMMENT '(DC2Type:date_immutable)', CHANGE date_end date_end DATE DEFAULT 'NULL' COMMENT '(DC2Type:date_immutable)'':  SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: 'NULL' for column ``.``.`date_end`

fd6130 avatar Jan 16 '21 05:01 fd6130