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

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


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):


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!

Complete thread:

 RSS Feed of thread