MyBB

Has this issue just started, Henryk?

I've just tried a backup, and looked at previous backups, and everything seems OK to me...

Hm, if I look at the backup dates, it seems to occur after the update from 1.4.9 to 1.4.10.
In the backups before the fields have no quotes at all.
I vaguely remember that there is something like autoquotes in PHP, which depends on the PHP configuration of the server.
Perhaps it has to do with that.

Normal (') quotes work perfectly fine in MySQL.

I dont know with what version of MySQL you work, but I dont know any where you can enclose field names in normal single quotes.
Either you put it in backquotes or in no quotes at all, otherwise you get a syntax error like this (on MySQL 5.0.70 and 5.0.84):

INSERT INTO mybb_adminlog( 'uid', 'ipaddress', 'dateline', 'module', 'action', 'data' )
VALUES (
'1', '77.137.37.82', '1241261952', 'tools/backupdb', 'backup', 'a:1:{i:0;s:8:\"download\";}'
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''uid','ipaddress','dateline','module','action','data') VALUES ('1','77.137.37.82' at line 1

Oh nevermind, I thought you were talking about the values not the actual column names.

Looks like this is a regression from issue #307

Applied in changeset r4595.

This has been applied to the MyBB 1.4.10 download and MyBB 1.4.10 changed file package. We apologize for the inconvenience.