Hello
This is getting confuse.
This is the entry in my last backup of my little forum, using the 'Backup' feature:
#
# mlf2_temp_infos
#
TRUNCATE TABLE mlf2_temp_infos;
INSERT INTO mlf2_temp_infos VALUES ('last_changes', '1598868462', '2020-08-31 13:07:42');
Ok, there is only this one entry ('last_changes', '1598868462', '2020-08-31 13:07:42') in the table mlf2_temp_infos
? No entry for the version number? No entry for the latest version check?
And this is the entry in my last backup of my little forum, using the server's cpanel:
--
-- Table structure for table `mlf2_temp_infos`
--
DROP TABLE IF EXISTS `mlf2_temp_infos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
Delete an possibly existing table of the name mlf2_temp_infos
.
CREATE TABLE `mlf2_temp_infos` (
`name` VARCHAR(50) NOT NULL,
`value` VARCHAR(255) NOT NULL,
`time` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
That's the same create statement than the one from the installation script.
LOCK TABLES `mlf2_temp_infos` WRITE;
/*!40000 ALTER TABLE `mlf2_temp_infos` DISABLE KEYS */;
INSERT INTO `mlf2_temp_infos` (`name`, `value`, `time`) VALUES ('last_changes','1598868462','2020-08-31 10:07:42');
/*!40000 ALTER TABLE `mlf2_temp_infos` ENABLE KEYS */;
UNLOCK TABLES;
Ok, the one dataset from above ('last_changes','1598868462','2020-08-31 10:07:42', the ony difference is the time (zone)) seems to be really the only entry in the table. So far so good (but disturbing).
It looks OK. So I tried to restore again using my little forum 'Restore', and I got a new error!
:
Error!
MySQL error: Column count doesn't match value count at row 1
Oh, that is definitely another statement. Because the forum entries are gone I guess it's the statement for the table mlf2_entries
. The statement for the table mlf2_temp_infos
implicitely specifies three columns (with not naming them, there are only three columns in the table (`name`, `value`, `time`)) and provides data for three columns ('last_changes', '1598868462', '2020-08-31 13:07:42').
it's getting interesting... BTW - The 'Restore' simply erased all entries in my Forum!
I hope, you have a working backup and did the tests in a non productive copy of your real forum. I will definitely dig into it.
Tschö, Auge