I think I found the reason for the backup error (Features)

by Auge ⌂, Tuesday, September 08, 2020, 09:57 (1412 days ago) @ shian


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,
PRIMARY KEY (`name`)
/*!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 */;

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! :-D :


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

Trenne niemals Müll, denn er hat nur eine Silbe!

Complete thread:

 RSS Feed of thread