I am getting this same error when trying to update JoomGallery from 3.3.x to 3.6.1. We need to update to work with Joomla 3.10.11. We would like to keep existing data in Joomla if possible. Wouldn't dropping a table cause us to loose data?
What is the suggested resolution to update an existing site, when encountering the SQL error :
JInstaller: :Install: Error SQL Column count doesn't match value count at row 1
Extension Install: SQL error processing query: DB function failed with error number 1136
Column count doesn't match value count at row 1
SQL
INSERT INTO `#__joomgallery_catg` VALUES ('1', '0', 'ROOT', 'root', '0', '0', '0', '0', NULL, '1', '1', '0', '0', '', '0', NULL, '0', '', '', '', '', 0, 0, -1, -1, -1, -1, -1);