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 Calvin 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