There is a syntax error in the inoerp_prod.sql import file.
datetime(1) - changing this to just datetime and re-running the query manually works for me.
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1) DEFAULT NULL,last_update_byint(12) NOT NULL,last_update_date' at line 33 The sql is: CREATE TABLEprj_role(prj_role_idint(12) UNSIGNED NOT NULL,role_namevarchar(25) NOT NULL,descriptionvarchar(255) DEFAULT NULL,user_rolevarchar(25) DEFAULT NULL,effective_fromdate DEFAULT NULL,effective_todate DEFAULT NULL,labor_cost_cbtinyint(1) DEFAULT NULL,contract_member_cbtinyint(1) DEFAULT NULL,project_member_cbtinyint(1) DEFAULT NULL,task_member_cbtinyint(1) DEFAULT NULL,scheduling_cbtinyint(1) DEFAULT NULL,min_job_levelint(4) DEFAULT NULL,max_job_levelint(4) DEFAULT NULL,hr_job_idint(12) DEFAULT NULL,created_byint(12) NOT NULL,creation_datedatetime(1) DEFAULT NULL,last_update_byint(12) NOT NULL,last_update_datedatetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1
There is a syntax error in the inoerp_prod.sql import file.
datetime(1)
- changing this to justdatetime
and re-running the query manually works for me.SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1) DEFAULT NULL,
last_update_byint(12) NOT NULL,
last_update_date' at line 33 The sql is: CREATE TABLE
prj_role(
prj_role_idint(12) UNSIGNED NOT NULL,
role_namevarchar(25) NOT NULL,
descriptionvarchar(255) DEFAULT NULL,
user_rolevarchar(25) DEFAULT NULL,
effective_fromdate DEFAULT NULL,
effective_todate DEFAULT NULL,
labor_cost_cbtinyint(1) DEFAULT NULL,
contract_member_cbtinyint(1) DEFAULT NULL,
project_member_cbtinyint(1) DEFAULT NULL,
task_member_cbtinyint(1) DEFAULT NULL,
scheduling_cbtinyint(1) DEFAULT NULL,
min_job_levelint(4) DEFAULT NULL,
max_job_levelint(4) DEFAULT NULL,
hr_job_idint(12) DEFAULT NULL,
created_byint(12) NOT NULL,
creation_datedatetime(1) DEFAULT NULL,
last_update_byint(12) NOT NULL,
last_update_datedatetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1