The reason for the "Column count doesn't match value count at row 1" error is either 1) the DB was not patched properly or 2) the PHP Live! files are not current with the DB. Most likely it is due to the first situation, the DB was not patched. To correct this error, you'll want to do the following:
However, if the error persists, you will want to re-patch the system. To perform a re-patch, the following documentation details the procedure.
If the issue still persists, then it is most likely the MySQL username permissions. Typically the MySQL privileges do not change, but double check that the MySQL PHP Live! database user has the following privileges because the database structure will need to be updated during the repatch process:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
Was this helpful?
could be more helpful? let us know
4 people found this helpful