[MarkFL]

Originally Posted by Dragonsys

nope, but it did get me in the right area. I replaced all the varchar with 1 2 3 etc, and now it inserts. So I just have to try one at a time to find the faulty one.

Thank you

Actually, the query should be:

$db->query_write("
	INSERT INTO " . TABLE_PREFIX . "bbcode 
		(bbcodetag, bbcodereplacement, bbcodeexample, bbcodeexplanation, twoparams, title, buttonimage, options) 
	VALUES 
		('fa', '<i class=\"fa %1\$s\"></i>', '[fa]fa-male[/fa]', 'Use Font Awesome icons. For a list of available icons see here: https://fortawesome.github.io/Font-Awesome/icons/', 0, 'Font Awesome', '', 31)
");
build_bbcode_cache();

The double-quotes also need to be escaped.