Help Desk Help Desk   Live Chat Live Chat   Phone +1 (917) 409-7605 M-F 9am-6pm EST
Home
Features
Screenshots
Live Demo
Free Trial
Pricing
Client Login
Help Desk
Search:
Help Desk » Errors and Troubleshooting » Column count doesn't match value count
Column count doesn't match value count

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:

 

  1. Download the latest copy of the PHP Live! system from the client area and update your existing PHP Live! files on your server.
  2. In most cases, the new file upload should fix the issue.

 

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