HELP NAO

[MasterRetro]

On a forum I'm constructing, whenever I try to make spoiler tags, it gives me this.

General Error
SQL ERROR [ mysql4 ]

Unknown column 'ff_bbcode' in 'field list' [1054]

SQL

INSERT INTO retroplace_bbcodes (bbcode_tag, bbcode_match, bbcode_tpl, display_on_posting, bbcode_helpline, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace, ff_bbcode, bbcode_id) VALUES ('spoiler', '{TEXT}', '<div style=\"margin:20px; margin-top:5px\"><div class=\"quotetitle\">Spoiler: <input type=\"button\" value=\"Show\" style=\"width:45px;font-size:10px;margin:0px;padding:0px;\" onclick=\"if (this.parentNode.parentNode.getElementsByTagName(\ 'div\')[1].getElementsByTagName(\'div\')[0].style.display != \'\') { this.parentNode.parentNode.getElementsByTagName(\' div\')[1].getElementsByTagName(\'div\')[0].style.display = \'\'; this.innerText = \'\'; this.value = \'Hide\'; } else { this.parentNode.parentNode.getElementsByTagName(\' div\')[1].getElementsByTagName(\'div\')[0].style.display = \'none\'; this.innerText = \'\'; this.value = \'Show\'; }\" /></div><div class=\"quotecontent\"><div style=\"display: none;\">{TEXT}</div></div></div>', 1, 'Show and Hide a large post', '!\\[spoiler\\](.*?)\\[/spoiler\\]!ies', '\'[spoiler:$uid]\'.str_replace(array(\"\\r\\n\", \'\\\"\', \'\\\'\', \'(\', \')\'), array(\"\\n\", \'\"\', \'&#39;\', \'&#40;\', \'&#41;\'), trim(\'${1}\')).\'[/spoiler:$uid]\'', '!\\[spoiler:$uid\\](.*?)\\[/spoiler:$uid\\]!s', '<div style=\"margin:20px; margin-top:5px\"><div class=\"quotetitle\">Spoiler: <input type=\"button\" value=\"Show\" style=\"width:45px;font-size:10px;margin:0px;padding:0px;\" onclick=\"if (this.parentNode.parentNode.getElementsByTagName(\ 'div\')[1].getElementsByTagName(\'div\')[0].style.display != \'\') { this.parentNode.parentNode.getElementsByTagName(\' div\')[1].getElementsByTagName(\'div\')[0].style.display = \'\'; this.innerText = \'\'; this.value = \'Hide\'; } else { this.parentNode.parentNode.getElementsByTagName(\' div\')[1].getElementsByTagName(\'div\')[0].style.display = \'none\'; this.innerText = \'\'; this.value = \'Show\'; }\" /></div><div class=\"quotecontent\"><div style=\"display: none;\">${1}</div></div></div>', 1, 13)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 197
CALL: dbal->sql_error()

FILE: includes/acp/acp_bbcodes.php
LINE: 228
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 592
CALL: acp_bbcodes->main()

FILE: adm/index.php
LINE: 81
CALL: p_master->load_active()

[SandSpur]

{text}

=
{text}


Works just fine for me

[SalamiNipples]

He's trying to make tags.

[MasterRetro]

Still doesn't work.

[SandSpur]

Oh, sorry, didn't read the whole thing....


Lol, you need to have HTML backup.

Getting it now, hold on

Edit:
HTML =

<dl class="codebox"><dt>{TEXT1}: Open</dt><dd style="display: none;">{TEXT2}</dd></dl>

Note that the code above is for a customizable title spoiler, so your BBCode would have to be some variation of this:

[Spoiler={TEXT1}]{TEXT2}

[MasterRetro]

Um, what?

[SandSpur]

Look at my post above

[MasterRetro]

Still doesn't work.

[SandSpur]

What kind of forum are you using?
Prophpbb, forum-motion, what?
if prophpbb, on the ACP go posting > bbcodes. Then make a new code and put the tags in the first box, then the HTML in the second

[MasterRetro]

Its on Freeforums.org. I got fed up with Forum Motion a while back.