error

[authorzheng]

Hi Sir

Why it show error message as follow:

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_by int(12) NOT NULL, last_update_date ' at line 33 The sql is: CREATE TABLE IF NOT EXISTS prj_role ( prj_role_id int(12) unsigned NOT NULL AUTO_INCREMENT, role_name varchar(25) NOT NULL, description varchar(255) DEFAULT NULL, user_role varchar(25) DEFAULT NULL, effective_from date DEFAULT NULL, effective_to date DEFAULT NULL, labor_cost_cb tinyint(1) DEFAULT NULL, contract_member_cb tinyint(1) DEFAULT NULL, project_member_cb tinyint(1) DEFAULT NULL, task_member_cb tinyint(1) DEFAULT NULL, scheduling_cb tinyint(1) DEFAULT NULL, min_job_level int(4) DEFAULT NULL, max_job_level int(4) DEFAULT NULL, hr_job_id int(12) DEFAULT NULL, created_by int(12) NOT NULL, creation_date datetime(1) DEFAULT NULL, last_update_by int(12) NOT NULL, last_update_date datetime DEFAULT NULL, PRIMARY KEY (prj_role_id), UNIQUE KEY value_group (role_name) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'domain databased.prj_role' doesn't exist The sql is: INSERT INTO prj_role (prj_role_id, role_name, description, user_role, effective_from, effective_to, labor_cost_cb, contract_member_cb, project_member_cb, task_member_cb, scheduling_cb, min_job_level, max_job_level, hr_job_id, created_by, creation_date, last_update_by, last_update_date) VALUES (1, 'Account Manager', 'Account Manager', NULL, NULL, NULL, 1, 1, 1, NULL, 1, 10, 15, NULL, 34, '2015-06-22 05:30:08.0', 34, '2015-06-22 05:30:08'), (2, 'Administrative ', 'Administrative Work', NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 10, 15, NULL, 34, '2015-06-22 05:33:37.0', 34, '2015-06-22 05:33:37'), (3, 'Business Analyst', 'Business Analyst', NULL, NULL, NULL, 1, NULL, 1, NULL, 1, 10, 15, NULL, 34, '2015-06-22 05:34:29.0', 34, '2015-06-22 05:34:29')

if you update file, could you send to my mail [email protected]

best regard Author