Avatar

An option to disable the 'Contact' link / Backup-Restore (Features)

by shian ⌂, Sunday, August 30, 2020, 13:54 (23 days ago)

One feature that I personally would use is to disable the 'Contact' link at the bottom of the forum screen.

In my case I prefer to get email directly from the sender; The other reason is that the 'Contact' link is a "great" feature for spam mail, and this is annoying.

I guess that the option to disable the 'Contact' link should be in the 'Advanced options' of the forum. (In my case the email is displayed on the screen).


Another thing:

One of the best admin features of my little forum is the 'Backup'. I would love to use it instead of using the cpanel of the server. Yet, every time that I've tried to 'Restore' a database it failed with the message (or something similar):

Error!

MySQL error: Incorrect datetime value: '' for column `rapideup_mylittleforum-2.4.21`.`mlf2_temp_infos`.`time` at row 1

If the 'Backup' feature is not reliable, then it shouldn't be there, yet I guess that a lot of users would love to use this great feature. We all know that Backup is critical and we all need it. I would love to see it works, really.


Thank you for this great software.

--
Everyone knows the truth about himself, except the fool who considers himself wise.

Avatar

Error in the backup-restore-function

by Auge ⌂ @, Friday, September 04, 2020, 15:43 (18 days ago) @ shian

Hello

One of the best admin features of my little forum is the 'Backup'. I would love to use it instead of using the cpanel of the server. Yet, every time that I've tried to 'Restore' a database it failed with the message (or something similar):

Error!

MySQL error: Incorrect datetime value: '' for column `rapideup_mylittleforum-2.4.21`.`mlf2_temp_infos`.`time` at row 1

Did you encounter further errors?

If the 'Backup' feature is not reliable, then it shouldn't be there, yet I guess that a lot of users would love to use this great feature. We all know that Backup is critical and we all need it. I would love to see it works, really.

With version 2.5 the backup function will get removed. It's because we get error reports every when and then – often months after the introduction of new datafields or tables – for this function like the one above. Not every admin run backups. Not every admin who run backups reimports the data. Because of that we have a fair chance to forget something in the backup function without taking notice of it (we as developers and forum operators) for a long time.

We came to the conclusion that it's much better to remove this function and to point the audience to tools like phpMyAdmin, the MySQL-Workbench or equivalents.

To be fair, it's necessary to remove known errors as long as we maintain the 2.4-branch. So, if you found and find further error messages like the one above, please tell us about it.

Tschö, Auge

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

Avatar

Error in the backup-restore-function

by shian ⌂, Friday, September 04, 2020, 18:14 (18 days ago) @ Auge

Error!

MySQL error: Incorrect datetime value: '' for column `rapideup_mylittleforum-2.4.21`.`mlf2_temp_infos`.`time` at row 1


Did you encounter further errors?

As far as I remember this was the only error, in PHP version 5.x as well as in PHP version 7.x - the same error after a clean install of the forum and the database.

With version 2.5 the backup function will get removed. ...

We came to the conclusion that it's much better to remove this function and to point the audience to tools like phpMyAdmin, the MySQL-Workbench or equivalents.

I see. I'll use other tools then. :crying:

To be fair, it's necessary to remove known errors as long as we maintain the 2.4-branch. So, if you found and find further error messages like the one above, please tell us about it.

I did not find more errors yet. Actually, this specific error never allowed me to restore my backups even once...

BTW, since I backup everything every 30 minutes (emotional disorder :cool: )... the Backup feature was the punch line in my decision to go for 'my little forum', which was the best choice. Honestly.

I'll live without this feature - 'my little forum' is still much better then other bloated forums.

I wonder if 'my little forum' could create a database file in the home directory... I don't know much about servers and PHP though.

Thank you.

--
Everyone knows the truth about himself, except the fool who considers himself wise.

Avatar

I think I found the reason for the backup error

by Auge ⌂ @, Monday, September 07, 2020, 12:15 (15 days ago) @ shian

Hello

One of the best admin features of my little forum is the 'Backup'. I would love to use it instead of using the cpanel of the server. Yet, every time that I've tried to 'Restore' a database it failed with the message (or something similar):

Error!

MySQL error: Incorrect datetime value: '' for column `rapideup_mylittleforum-2.4.21`.`mlf2_temp_infos`.`time` at row 1

Please open the backup file and search for the INSERT-statements of the temp-info-table (should be named mlf2_temp_infos or similar). Are there entries with 'NULL' (with empty single quotes) as third value of a row?

INSERT INTO mlf2_temp_infos VALUES ('foo', 'bar', '');

If so, please change it to …

INSERT INTO mlf2_temp_infos VALUES ('foo', 'bar', NULL);

… (value NULL without single quotes) and try again to restore the backup.

The installation SQL-script in itself defines the column time to be NULL or an datetime value. That does obviously does not allow the column to be an empty string '' on your server even this seems to be no problem on some other servers.

Tschö, Auge

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

Avatar

I think I found the reason for the backup error

by shian ⌂, Tuesday, September 08, 2020, 08:25 (14 days ago) @ Auge

Thank you.

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');
 


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 */;
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 */;
 
--
-- Dumping data for table `mlf2_temp_infos`
--
 
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;
 


It looks OK. So I tried to restore again using my little forum 'Restore', and I got a new error! :-D :

Error!

    MySQL error: Column count doesn't match value count at row 1


it's getting interesting... BTW - The 'Restore' simply erased all entries in my Forum! :-|

Thank you, shian.

--
Everyone knows the truth about himself, except the fool who considers himself wise.

Avatar

I think I found the reason for the backup error

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

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

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 satement 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!

Avatar

I think I found the reason for the backup error

by shian ⌂, Tuesday, September 08, 2020, 14:02 (14 days ago) @ Auge

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?

No. That's all there is, one entry.

It looks OK. So I tried to restore again using my little forum 'Restore', and I got a new error! :-D :

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 satement 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

Thank you. I backup everything, always. Yet I did the tests in a productive copy... anyone who knows me cannot be too surprised... :-)

--
Everyone knows the truth about himself, except the fool who considers himself wise.

RSS Feed of thread
powered by my little forum