hi everyone
i had fedora 7 running and when i'm going to run mysql < INSTALL.mysql_1_users i got this error
ERROR 1136 (21S01) at line 21: Column count doesn't match value count at row 1
i don't know what's wrong
here is the part of the script where it says the script fail
# ##########################################################
# This adds the "mysqluser" the ability to create tables.
DELETE FROM mysql.db where db = 'syslog_server';
INSERT INTO mysql.db VALUES
('localhost','root','ctdocsis',
'Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
ctdocsis is an extrauser i created
Thanks in advance
Tomas
According to mysql 5.x docs
If you do not specify a list of column names for INSERT ... VALUES..., values for every column in the table must be provided by the VALUES list
Since the mysql statement you have listed here does not have columns defined, it is expecting values for every column and is complaining that the column count does not match. i.e. the table has 15 columns and you are only passing in 13 values, or the table has 13 columns and you passed in 13 values.
How to solve this problem, would be two methods
1, compare the insert statements with actual table stucture and adjust them accordingly
2. contact the author and have him adjust the script
as a side note is 2.04 the latest version of Docsis_Server?