SQLSTATE[42000]: Syntax error or access violation - datetime(1)

[johnearnshaw]

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_date datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1