dolibarr icon indicating copy to clipboard operation
dolibarr copied to clipboard

Installation fail on step2

Open tarun1982 opened this issue 1 year ago • 2 comments

Bug

SQL Error DB_ERROR_SYNTAX You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'integer DEFAULT NULL )ENGINE=innodb' at line 88

Environment Version

17.0.0-alpha

Environment OS

CentOS Linux 8.5.2111

Environment Web server

Apache

Environment PHP

7.4

Environment Database

MariaDB 10.3.28

Environment URL(s)

https://erp.projectstatus.co.in/install/step2.php

Expected and actual behavior

No response

Steps to reproduce the behavior

At the time of installation - on step 2.

Attached files

https://tinyurl.com/2pzm7bsv

tarun1982 avatar Sep 16 '22 12:09 tarun1982

Any update on this issue.. as we stuck on step2.

tarun1982 avatar Sep 19 '22 11:09 tarun1982

Hello,

Alpha versions are for developers only, it's not a priority to fix it

ksar-ksar avatar Sep 19 '22 17:09 ksar-ksar

Hello,

Problem is SQL syntax at last column, no comma separator between ( NULL fk_default_workstation ).

Create table llx_product
Request 230 : create table zl_product ( rowid integer AUTO_INCREMENT PRIMARY KEY **[SKIP]**  fk_default_bom integer DEFAULT NULL fk_default_workstation integer DEFAULT NULL );

Maybe some one can fix it and push changes. Thank you Best regards

zetaScout avatar Sep 22 '22 12:09 zetaScout