Field count doesn't match value count in user table during installation

Hi,

In the timesheet.sql there are totally 9 fields, however, in INSTALL.txt step #5,

######################################################
Set the admin password for TimesheetNextGen, by running the following SQL command:

INSERT INTO user VALUES ('admin', 10, PASSWORD('mypassword'), '.*', 'Timesheet', 'Admin', '', '', '0.00', '', 'OUT', '1');
#######################################################

There are totally 12 fields in this command. Thus mysql returns ERROR 1136 (21S01): Column count doesn't match value count at row 1.

What is the reason? What should I do? Please advice! Thank you.

‹ Printing reports Moving from PHP4 to PHP5 ›
Submitted by Anonymous on 2 June 2009 - 11:43pm
Tags:
»

Comments

#1 tommo

timesheet.sql is correct, and install.txt is out of date. There are nine fields in the user table now. If you need to add an admin user by hand try this:

#####
INSERT INTO __TABLE_PREFIX__user (username,level,password,first_name,last_name) VALUES ('admin',10,__DBPASSWORDFUNCTION__('password'),'Timesheet','Admin');
#####

3 Jun 2009 - 8:47am