Announcement

Collapse
No announcement yet.

Stuck on Step 7

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Stuck on Step 7

    Please help me sort this out. Owning a server, trying to install vBulletin, and it gets stuck on step 7 with the following error message:

    Step 7) Importing Style Information





    Importing vbulletin-style.xml
    Importing Style, Please Wait


    [::::::::::::::::::::::::]



    MASTER STYLE

    Please Wait




    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Stuff, who you can also contact if the problem persists.

    We apologise for any inconvenience.


    Tags: None
  • #2
    The error report email contains:
    Database error in vBulletin :

    Invalid SQL:
    REPLACE INTO template
    (styleid, templatetype, title, template, template_un, dateline, username, version)
    VALUES
    (-1, 'template', 'navbar_link', '<if condition="$show[''''breadcrumb'''']">
    <span class="navbar">&gt; <a href="$nav_url">$nav_title</a></span>
    <else />
    $nav_title
    </if>
    ', '<if condition="$show[''breadcrumb'']">
    <span class="navbar">&gt; <a href="$nav_url">$nav_title</a></span>
    <else />
    $nav_title
    </if>
    ', 1070543944, 'Kier', '3.0.0 Gamma'),(-1, 'template', 'newattachment', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head>
    <title>$vbphrase[manage_attachments] - $vboptions[bbtitle]</title>
    $headinclude
    </head>
    <body style="margin:0px" onload="self.focus()">

    <script type="text/javascript">
    <!--
    function verify_upload(formobj)
    {
    var haveupload = false;
    for (var i=0; i < formobj.elements.length; i++)
    {
    var elm = formobj.elements[i];
    if (elm.type == ''''file'''')
    {
    if (elm.value != "")
    {
    haveupload = true;
    }
    }
    }

    if (haveupload)
    {
    toggle_display(''''uploading'''');
    return true;
    }
    else
    {
    alert("$vbphrase[select_a_file_to_attach]");
    return false;
    }
    }

    <if condition="$show[''''updateparent'''']">
    switch (vbDOMtype)
    {
    case "std":
    {
    var attachlist = window.opener.document.getElementById("attachlist");
    }
    break;

    case "ie4":
    {
    var attachlist = window.opener.document.all["attachlist"];
    }
    }

    attachlist.innerHTML = "$parentattach";
    </if>

    //-->
    </script>

    <form enctype="multipart/form-data" action="newattachment.php" name="newattachment" method="post">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="do" value="manageattach" />
    <input type="hidden" name="t" value="$threadid" />
    <input type="hidden" name="f" value="$forumid" />
    <input type="hidden" name="p" value="$postid" />
    <input type="hidden" name="poststarttime" value="$poststarttime" />
    <input type="hidden" name="editpost" value="$editpost" />
    <input type="hidden" name="posthash" value="$posthash" />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><a href="#" onclick="self.close()">$vbphrase[close_this_window]</a></span>
    $vbphrase[manage_attachments]
    </td>
    </tr>
    <if condition="$show[''''errors'''']">
    <tr>
    <td class="thead">$vbphrase[upload_errors]</td>
    </tr>
    $errorlist
    </if>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div align="$stylevar[left]">

    <fieldset class="fieldset">
    <legend>$vbphrase[upload_file]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <if condition="$show[''''attachoption'''']">
    <tr>
    <td colspan="2">" . construct_phrase("$vbphrase[use_x_to_find_file]", "$vbphrase[upload_word]") . "</td>
    </tr>
    <tr>
    <td colspan="2">$vbphrase[valid_file_extensions]: $attachtypes[extensions]</td>
    </tr>
    <tr valign="bottom">
    <td>
    $vbphrase[file_to_upload]:
    <input type="hidden" name="MAX_FILE_SIZE" value="$inimaxattach" /><br />
    $attachinput
    </td>
    <td align="$stylevar[right]"><input type="submit" class="button" name="upload" value="$vbphrase[upload]" style="width:70px" onclick="return verify_upload(this.form);" /></td>
    </tr>
    <else />
    <tr>
    <if condition="$show[''''forumclosed'''']">
    <td>$vbphrase[this_forum_is_not_accepting_new_attachments]</td>
    <else />
    <td>" . construct_phrase("$vbphrase[have_uploaded_maximum_x_files]", "$vboptions[attachlimit]") . "</td>
    </if>
    </tr>
    </if>
    </table>
    </fieldset>

    <if condition="$show[''''attachmentlimits'''']">
    <div class="fieldset">
    <div style="padding:$stylevar[formspacer]px">
    " . construct_phrase("$vbphrase[sum_of_attachments_owned_by_x]", "$attach_username") . ":
    $attachsum<br />
    <table style="border:2px groove" cellpadding="0" cellspacing="1" border="0" width="100%">
    <tr>
    <if condition="$show[''''currentsize'''']"><td width="$attachsize" bgcolor="red" style="border:1px outset" class="smallfont" title="" . construct_phrase("$vbphrase[current_attachment_total_x]", "$attachsum") . "">&nbsp;</td></if>
    <if condition="$show[''''totalsize'''']"><td width="$totalsize" bgcolor="green" style="border:1px outset" class="smallfont" title="" . construct_phrase("$vbphrase[maximum_attachment_storage_x]", "$attachlimit") . "">&nbsp;</td></if>
    </tr>
    </table>
    </div>
    </div>
    </if>

    <if condition="$show[''''attachmentlist'''']">
    <fieldset class="fieldset">
    <legend>$vbphrase[current_attachments]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <table class="fieldset" cellpadding="0" cellspacing="1" border="0" width="100%">
    $attachments
    </table>
    <div>$vbphrase[space_used]: $totallimit</div>
    </div>
    </fieldset>
    </if>

    </div>
    </div>

    <div align="center" id="uploading" style="display:none; margin-top:$stylevar[cellpadding]px">
    <strong>$vbphrase[uploading_file]</strong>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="button" class="button" value="$vbphrase[close_this_window]" onclick="window.close();" />
    </div>
    </td>
    </tr>
    </table>

    </form>
    </body>
    </html>', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head>
    <title>$vbphrase[manage_attachments] - $vboptions[bbtitle]</title>
    $headinclude
    </head>
    <body style="margin:0px" onload="self.focus()">

    <script type="text/javascript">
    <!--
    function verify_upload(formobj)
    {
    var haveupload = false;
    for (var i=0; i < formobj.elements.length; i++)
    {
    var elm = formobj.elements[i];
    if (elm.type == ''file'')
    {
    if (elm.value != "")
    {
    haveupload = true;
    }
    }
    }

    if (haveupload)
    {
    toggle_display(''uploading'');
    return true;
    }
    else
    {
    alert("$vbphrase[select_a_file_to_attach]");
    return false;
    }
    }

    <if condition="$show[''updateparent'']">
    switch (vbDOMtype)
    {
    case "std":
    {
    var attachlist = window.opener.document.getElementById("attachlist");
    }
    break;

    case "ie4":
    {
    var attachlist = window.opener.document.all["attachlist"];
    }
    }

    attachlist.innerHTML = "$parentattach";
    </if>

    //-->
    </script>

    <form enctype="multipart/form-data" action="newattachment.php" name="newattachment" method="post">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="do" value="manageattach" />
    <input type="hidden" name="t" value="$threadid" />
    <input type="hidden" name="f" value="$forumid" />
    <input type="hidden" name="p" value="$postid" />
    <input type="hidden" name="poststarttime" value="$poststarttime" />
    <input type="hidden" name="editpost" value="$editpost" />
    <input type="hidden" name="posthash" value="$posthash" />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><a href="#" onclick="self.close()">$vbphrase[close_this_window]</a></span>
    $vbphrase[manage_attachments]
    </td>
    </tr>
    <if condition="$show[''errors'']">
    <tr>
    <td class="thead">$vbphrase[upload_errors]</td>
    </tr>
    $errorlist
    </if>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div align="$stylevar[left]">

    <fieldset class="fieldset">
    <legend>$vbphrase[upload_file]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <if condition="$show[''attachoption'']">
    <tr>
    <td colspan="2"><phrase 1="$vbphrase[upload_word]">$vbphrase[use_x_to_find_file]</phrase></td>
    </tr>
    <tr>
    <td colspan="2">$vbphrase[valid_file_extensions]: $attachtypes[extensions]</td>
    </tr>
    <tr valign="bottom">
    <td>
    $vbphrase[file_to_upload]:
    <input type="hidden" name="MAX_FILE_SIZE" value="$inimaxattach" /><br />
    $attachinput
    </td>
    <td align="$stylevar[right]"><input type="submit" class="button" name="upload" value="$vbphrase[upload]" style="width:70px" onclick="return verify_upload(this.form);" /></td>
    </tr>
    <else />
    <tr>
    <if condition="$show[''forumclosed'']">
    <td>$vbphrase[this_forum_is_not_accepting_new_attachments]</td>
    <else />
    <td><phrase 1="$vboptions[attachlimit]">$vbphrase[have_uploaded_maximum_x_files]</phrase></td>
    </if>
    </tr>
    </if>
    </table>
    </fieldset>

    <if condition="$show[''attachmentlimits'']">
    <div class="fieldset">
    <div style="padding:$stylevar[formspacer]px">
    <phrase 1="$attach_username">$vbphrase[sum_of_attachments_owned_by_x]</phrase>:
    $attachsum<br />
    <table style="border:2px groove" cellpadding="0" cellspacing="1" border="0" width="100%">
    <tr>
    <if condition="$show[''currentsize'']"><td width="$attachsize" bgcolor="red" style="border:1px outset" class="smallfont" title="<phrase 1="$attachsum">$vbphrase[current_attachment_total_x]</phrase>">&nbsp;</td></if>
    <if condition="$show[''totalsize'']"><td width="$totalsize" bgcolor="green" style="border:1px outset" class="smallfont" title="<phrase 1="$attachlimit">$vbphrase[maximum_attachment_storage_x]</phrase>">&nbsp;</td></if>
    </tr>
    </table>
    </div>
    </div>
    </if>

    <if condition="$show[''attachmentlist'']">
    <fieldset class="fieldset">
    <legend>$vbphrase[current_attachments]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <table class="fieldset" cellpadding="0" cellspacing="1" border="0" width="100%">
    $attachments
    </table>
    <div>$vbphrase[space_used]: $totallimit</div>
    </div>
    </fieldset>
    </if>

    </div>
    </div>

    <div align="center" id="uploading" style="display:none; margin-top:$stylevar[cellpadding]px">
    <strong>$vbphrase[uploading_file]</strong>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="button" class="button" value="$vbphrase[close_this_window]" onclick="window.close();" />
    </div>
    </td>
    </tr>
    </table>

    </form>
    </body>
    </html>', 1108729967, 'Admin', '3.0.7'),(-1, 'template', 'newattachmentbit', '<tr>
    <td><img class="inlineimg" src="$stylevar[imgdir_attach]/$attach[extension].gif" alt="$attach[extension].gif" width="16" height="16" border="0" /> <a href="attachment.php?$session[sessionurl]attachmentid=$attach[attachmentid]&amp;stc=1" target="_blank">$attach[filename]</a> ($attach[filesize])</td>
    <td align="$stylevar[right]"><input type="submit" class="button" value="$vbphrase[remove]" name="delete$attach[attachmentid]" style="width:70px" /></td>
    </tr>', '<tr>
    <td><img class="inlineimg" src="$stylevar[imgdir_attach]/$attach[extension].gif" alt="$attach[extension].gif" width="16" height="16" border="0" /> <a href="attachment.php?$session[sessionurl]attachmentid=$attach[attachmentid]&amp;stc=1" target="_blank">$attach[filename]</a> ($attach[filesize])</td>
    <td align="$stylevar[right]"><input type="submit" class="button" value="$vbphrase[remove]" name="delete$attach[attachmentid]" style="width:70px" /></td>
    </tr>', 1071580628, 'Kier', '3.0.0 Release Candidate 1'),(-1, 'template', 'newattachment_errormessage', '<tr valign="top">
    <td class="alt1"><div class="smallfont">
    <strong>$filename</strong>:<br />
    $errormessage
    </div></td>
    </tr>
    ', '<tr valign="top">
    <td class="alt1"><div class="smallfont">
    <strong>$filename</strong>:<br />
    $errormessage
    </div></td>
    </tr>
    ', 1069935876, 'Kier', '3.0.0 Gamma'),(-1, 'template', 'newpoll', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head>
    <title>$vboptions[bbtitle] - $vbphrase[post_a_poll]</title>
    $headinclude
    </head>
    <body>
    $header
    $navbar

    <br />

    <form action="poll.php" method="post">

    $pollpreview

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><strong>$vbphrase[thread]</strong>: <a href="showthread.php?$session[sessionurl]t=$threadinfo[threadid]">$threadinfo[title]</a></span>
    $vbphrase[post_a_poll]
    </td>
    </tr>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    $usernamecode

    <div class="fieldset">
    <div><label for="pollquestion">$vbphrase[poll_question]</label>:</div>
    <input type="text" class="bginput" name="question" value="$question" id="pollquestion" size="50" maxlength="85" tabindex="1" />
    </div>

    <fieldset class="fieldset">
    <legend>$vbphrase[number_of_poll_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <label for="polloptnum"><if condition="$vboptions[''''maxpolloptions'''']">$vbphrase[maximum]: $vboptions[maxpolloptions] &nbsp; &nbsp; </if><input type="text" class="bginput" size="5" name="polloptions" value="$polloptions" id="polloptnum" tabindex="1" /></label>
    &nbsp; &nbsp;
    <input type="submit" class="button" name="updatenumber" accesskey="u" value="$vbphrase[update_options]" style="font-weight:normal" tabindex="1" />
    </div>
    </fieldset>

    <fieldset class="fieldset">
    <legend>$vbphrase[poll_options]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    $pollnewbits
    <tr>
    <td>$vbphrase[keep_poll_options_short]</td>
    </tr>
    </table>
    </fieldset>

    <fieldset class="fieldset">
    <legend>$vbphrase[poll_timeout]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <tr>
    <td>$vbphrase[automatically_close_poll_enter_days]</td>
    </tr>
    <tr>
    <td><label for="poll_timeout">$vbphrase[close_poll] <input type="text" class="bginput" name="timeout" value="$timeout" size="5" id="poll_timeout" tabindex="1" /> " . construct_phrase("$vbphrase[days_after_x]", "$polldate") . "</label></td>
    </tr>
    </table>
    </fieldset>

    <fieldset class="fieldset">
    <legend>$vbphrase[miscellaneous_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div><label for="cb_multiple"><input type="checkbox" name="multiple" value="1" id="cb_multiple" tabindex="1" $checked[multiple] />$vbphrase[allow_multiple_choice]</label></div>
    <div><label for="cb_public"><input type="checkbox" name="public" value="1" id="cb_public" tabindex="1" $checked[public] />$vbphrase[make_votes_public]</label></div>
    <div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div>
    $disablesmiliesoption
    </div>
    </fieldset>

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="t" value="$threadid" />
    <input type="hidden" name="do" value="postpoll" />
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_new_poll]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_poll]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </table>

    </form>

    <br />

    $forumrules

    $footer

    </body>
    </html>', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head>
    <title>$vboptions[bbtitle] - $vbphrase[post_a_poll]</title>
    $headinclude
    </head>
    <body>
    $header
    $navbar

    <br />

    <form action="poll.php" method="post">

    $pollpreview

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><strong>$vbphrase[thread]</strong>: <a href="showthread.php?$session[sessionurl]t=$threadinfo[threadid]">$threadinfo[title]</a></span>
    $vbphrase[post_a_poll]
    </td>
    </tr>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    $usernamecode

    <div class="fieldset">
    <div><label for="pollquestion">$vbphrase[poll_question]</label>:</div>
    <input type="text" class="bginput" name="question" value="$question" id="pollquestion" size="50" maxlength="85" tabindex="1" />
    </div>

    <fieldset class="fieldset">
    <legend>$vbphrase[number_of_poll_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <label for="polloptnum"><if condition="$vboptions[''maxpolloptions'']">$vbphrase[maximum]: $vboptions[maxpolloptions] &nbsp; &nbsp; </if><input type="text" class="bginput" size="5" name="polloptions" value="$polloptions" id="polloptnum" tabindex="1" /></label>
    &nbsp; &nbsp;
    <input type="submit" class="button" name="updatenumber" accesskey="u" value="$vbphrase[update_options]" style="font-weight:normal" tabindex="1" />
    </div>
    </fieldset>

    <fieldset class="fieldset">
    <legend>$vbphrase[poll_options]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    $pollnewbits
    <tr>
    <td>$vbphrase[keep_poll_options_short]</td>
    </tr>
    </table>
    </fieldset>

    <fieldset class="fieldset">
    <legend>$vbphrase[poll_timeout]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <tr>
    <td>$vbphrase[automatically_close_poll_enter_days]</td>
    </tr>
    <tr>
    <td><label for="poll_timeout">$vbphrase[close_poll] <input type="text" class="bginput" name="timeout" value="$timeout" size="5" id="poll_timeout" tabindex="1" /> <phrase 1="$polldate">$vbphrase[days_after_x]</phrase></label></td>
    </tr>
    </table>
    </fieldset>

    <fieldset class="fieldset">
    <legend>$vbphrase[miscellaneous_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div><label for="cb_multiple"><input type="checkbox" name="multiple" value="1" id="cb_multiple" tabindex="1" $checked[multiple] />$vbphrase[allow_multiple_choice]</label></div>
    <div><label for="cb_public"><input type="checkbox" name="public" value="1" id="cb_public" tabindex="1" $checked[public] />$vbphrase[make_votes_public]</label></div>
    <div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div>
    $disablesmiliesoption
    </div>
    </fieldset>

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="t" value="$threadid" />
    <input type="hidden" name="do" value="postpoll" />
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_new_poll]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_poll]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </table>

    </form>

    <br />

    $forumrules

    $footer

    </body>
    </html>', 1104625411, 'Admin', '3.0.4'),(-1, 'template', 'newpost_attachment', '<fieldset class="fieldset">
    <legend>$vbphrase[attach_files]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div style="margin-bottom:$stylevar[formspacer]px">
    <div>$vbphrase[valid_file_extensions]: $attachtypes[extensions]</div>
    </div>
    <div style="margin-bottom:$stylevar[formspacer]px" id="attachlist">
    <if condition="$show[''''attachmentlist'''']">
    $attachments
    </if>
    </div>
    <div>
    <script type="text/javascript">
    <!--
    document.write(''''<input type="button" class="button" tabindex="1" style="font-weight:normal" value="$vbphrase[manage_attachments]" title="$vbphrase[add_edit_files_attached]" onclick="manageattachments(''''newattachment.php?$session[sessionurl]$attachurl&amp;poststarttime=$poststarttime&amp;posthash=$posthash'''', 480, 480, ''''$postid'''')" />'''');
    //-->
    </script>
    <noscript>
    <a href="newattachment.php?$session[sessionurl]$attachurl&amp;poststarttime=$poststarttime&amp;posthash=$posthash" target="manageattach" title="$vbphrase[add_edit_files_attached]" tabindex="1"><strong>$vbphrase[manage_attachments]</strong></a>
    </noscript>
    </div>
    </div>
    </fieldset>
    ', '<fieldset class="fieldset">
    <legend>$vbphrase[attach_files]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div style="margin-bottom:$stylevar[formspacer]px">
    <div>$vbphrase[valid_file_extensions]: $attachtypes[extensions]</div>
    </div>
    <div style="margin-bottom:$stylevar[formspacer]px" id="attachlist">
    <if condition="$show[''attachmentlist'']">
    $attachments
    </if>
    </div>
    <div>
    <script type="text/javascript">
    <!--
    document.write(''<input type="button" class="button" tabindex="1" style="font-weight:normal" value="$vbphrase[manage_attachments]" title="$vbphrase[add_edit_files_attached]" onclick="manageattachments(\''newattachment.php?$session[sessionurl]$attachurl&amp;poststarttime=$poststarttime&amp;posthash=$posthash\'', 480, 480, \''$postid\'')" />'');
    //-->
    </script>
    <noscript>
    <a href="newattachment.php?$session[sessionurl]$attachurl&amp;poststarttime=$poststarttime&amp;posthash=$posthash" target="manageattach" title="$vbphrase[add_edit_files_attached]" tabindex="1"><strong>$vbphrase[manage_attachments]</strong></a>
    </noscript>
    </div>
    </div>
    </fieldset>
    ', 1073510546, 'Ed Sullivan', '3.0.0 Release Candidate 3'),(-1, 'template', 'newpost_attachmentbit', '<div style="margin:2px"><img class="inlineimg" src="$stylevar[imgdir_attach]/$attach[extension].gif" alt="$attach[filename]" border="0" /> <a href="attachment.php?$session[sessionurl]attachmentid=$attach[attachmentid]&amp;stc=1" target="_blank">$attach[filename]</a> ($attach[filesize])</div>', '<div style="margin:2px"><img class="inlineimg" src="$stylevar[imgdir_attach]/$attach[extension].gif" alt="$attach[filename]" border="0" /> <a href="attachment.php?$session[sessionurl]attachmentid=$attach[attachmentid]&amp;stc=1" target="_blank">$attach[filename]</a> ($attach[filesize])</div>', 1071580637, 'Kier', '3.0.0 Release Candidate 1'),(-1, 'template', 'newpost_disablesmiliesoption', '<div><label for="cb_disablesmilies"><input type="checkbox" name="disablesmilies" value="1" id="cb_disablesmilies" tabindex="1" $checked[disablesmilies] />$vbphrase[disable_smilies_in_text]</label></div>
    ', '<div><label for="cb_disablesmilies"><input type="checkbox" name="disablesmilies" value="1" id="cb_disablesmilies" tabindex="1" $checked[disablesmilies] />$vbphrase[disable_smilies_in_text]</label></div>
    ', 1070081482, 'Ed Sullivan', '3.0.0 Gamma'),(-1, 'template', 'newpost_errormessage', '<li>$errormessage</li>', '<li>$errormessage</li>', 1069263001, 'Kier', '3.0.0 Gamma'),(-1, 'template', 'newpost_preview', '<script type="text/javascript">
    <!--
    var preview_focus = true;
    //-->
    </script>

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <if condition="$show[''''errors'''']">
    $vbphrase[errors_occured_when_submitted]:
    <else />
    $vbphrase[preview]
    </if>
    </td>
    </tr>
    <tr>
    <td class="alt1">
    <if condition="$show[''''errors'''']">
    <ol>$errorlist</ol>
    <else />

    <if condition="$show[''''messageicon''''] OR $newpost[''''title'''']">
    <!-- icon and title -->
    <div class="smallfont">
    <if condition="$show[''''messageicon'''']"><img class="inlineimg" src="$newpost[iconpath]" alt="$newpost[icontitle]" border="0" /></if>
    <if condition="$newpost[''''title'''']"><strong>$newpost[title]</strong></if>
    </div>
    <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
    <!-- / icon and title -->
    </if>
    $previewmessage
    <if condition="$show[''''signature'''']">
    <div>__________________<br />
    $post[signature]</div>
    </if>
    </if>
    </td>
    </tr>
    <if condition="!$show[''''errors'''']">
    <tr>
    <td class="tfoot" align="center"><input type="submit" class="button" value="$vbphrase[submit_message]" accesskey="s" /></td>
    </tr>
    </if>
    </table>

    <br />', '<script type="text/javascript">
    <!--
    var preview_focus = true;
    //-->
    </script>

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <if condition="$show[''errors'']">
    $vbphrase[errors_occured_when_submitted]:
    <else />
    $vbphrase[preview]
    </if>
    </td>
    </tr>
    <tr>
    <td class="alt1">
    <if condition="$show[''errors'']">
    <ol>$errorlist</ol>
    <else />

    <if condition="$show[''messageicon''] OR $newpost[''title'']">
    <!-- icon and title -->
    <div class="smallfont">
    <if condition="$show[''messageicon'']"><img class="inlineimg" src="$newpost[iconpath]" alt="$newpost[icontitle]" border="0" /></if>
    <if condition="$newpost[''title'']"><strong>$newpost[title]</strong></if>
    </div>
    <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
    <!-- / icon and title -->
    </if>
    $previewmessage
    <if condition="$show[''signature'']">
    <div>__________________<br />
    $post[signature]</div>
    </if>
    </if>
    </td>
    </tr>
    <if condition="!$show[''errors'']">
    <tr>
    <td class="tfoot" align="center"><input type="submit" class="button" value="$vbphrase[submit_message]" accesskey="s" /></td>
    </tr>
    </if>
    </table>

    <br />', 1088450459, 'freddie', '3.0.2'),(-1, 'template', 'newpost_quote', '
    Originally posted by $originalposter
    {$pagetext}
    ', '
    Originally posted by $originalposter
    {$pagetext}
    ', 1069263046, 'Kier', '3.0.0 Gamma'),(-1, 'template', 'newpost_threadmanage', '<fieldset class="fieldset">
    <legend>$vbphrase[thread_management]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <if condition="$show[''''openclose'''']"><div>
    <label for="cb_openclose"><input type="checkbox" name="openclose" value="1" id="cb_openclose" tabindex="1" $checked[openclose] /><if condition="$show[''''closethread'''']">$vbphrase[close_this_thread]<else />$vbphrase[reopen_this_thread]</if> $vbphrase[after_you_submit_your_message].</label>
    </div></if>
    <if condition="$show[''''stickunstick'''']">
    <div><label for="cb_stickunstick"><input type="checkbox" name="stickunstick" value="1" id="cb_stickunstick" tabindex="1" $checked[stickunstick] /><if condition="$show[''''unstickthread'''']">$vbphrase[unstick_this_thread]<else />$vbphrase[stick_this_thread]</if> $vbphrase[after_you_submit_your_message].</label>
    </div></if>
    </div>
    </fieldset>', '<fieldset class="fieldset">
    <legend>$vbphrase[thread_management]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <if condition="$show[''openclose'']"><div>
    <label for="cb_openclose"><input type="checkbox" name="openclose" value="1" id="cb_openclose" tabindex="1" $checked[openclose] /><if condition="$show[''closethread'']">$vbphrase[close_this_thread]<else />$vbphrase[reopen_this_thread]</if> $vbphrase[after_you_submit_your_message].</label>
    </div></if>
    <if condition="$show[''stickunstick'']">
    <div><label for="cb_stickunstick"><input type="checkbox" name="stickunstick" value="1" id="cb_stickunstick" tabindex="1" $checked[stickunstick] /><if condition="$show[''unstickthread'']">$vbphrase[unstick_this_thread]<else />$vbphrase[stick_this_thread]</if> $vbphrase[after_you_submit_your_message].</label>
    </div></if>
    </div>
    </fieldset>', 1070081578, 'Ed Sullivan', '3.0.0 Gamma'),(-1, 'template', 'newpost_usernamecode', '<if condition="$show[''''member'''']">
    <!-- user is logged in -->
    <div class="smallfont" style="float:$stylevar[right]">
    " . construct_phrase("$vbphrase[logged_in_as_x]", "member.php?$session[sessionurl]u=$bbuserinfo[userid]", "$bbuserinfo[username]") . "
    </div>
    <else />
    <table cellpadding="0" cellspacing="0" border="0" style="margin-bottom:$stylevar[formspacer]px">
    <tr>
    <td class="smallfont">$vbphrase[your_username]:</td>
    <td class="smallfont" align="$stylevar[right]"><a href="#" onclick="fetch_object(''''navbar_username'''').select(); return false;">$vbphrase[click_here_to_log_in]</a></td>
    </tr>
    <tr>
    <td class="smallfont" colspan="2"><input type="text" class="bginput" name="username" value="$bbuserinfo[username]" size="50" style="margin-top:1px" /></td>
    </tr>
    </table>
    </if>', '<if condition="$show[''member'']">
    <!-- user is logged in -->
    <div class="smallfont" style="float:$stylevar[right]">
    <phrase 1="member.php?$session[sessionurl]u=$bbuserinfo[userid]" 2="$bbuserinfo[username]">$vbphrase[logged_in_as_x]</phrase>
    </div>
    <else />
    <table cellpadding="0" cellspacing="0" border="0" style="margin-bottom:$stylevar[formspacer]px">
    <tr>
    <td class="smallfont">$vbphrase[your_username]:</td>
    <td class="smallfont" align="$stylevar[right]"><a href="#" onclick="fetch_object(''navbar_username'').select(); return false;">$vbphrase[click_here_to_log_in]</a></td>
    </tr>
    <tr>
    <td class="smallfont" colspan="2"><input type="text" class="bginput" name="username" value="$bbuserinfo[username]" size="50" style="margin-top:1px" /></td>
    </tr>
    </table>
    </if>', 1070429997, 'Ed Sullivan', '3.0.0 Gamma'),(-1, 'template', 'newreply', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head><title>$vboptions[bbtitle] - $vbphrase[reply_to_topic]</title>
    $headinclude
    </head>
    <body$onload>
    $header
    $navbar

    <form action="newreply.php" name="vbform" method="post"<if condition="!is_browser(''''webtv'''')"> onsubmit="return validatePost(this, 0, $vboptions[postminchars], $vboptions[postmaxchars]);" onreset="vB_RESET(this);"</if>>

    $postpreview

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><strong>$vbphrase[thread]</strong>: <a href="showthread.php?$session[sessionurl]t=$threadinfo[threadid]">$threadinfo[title]</a></span>
    $vbphrase[reply_to_thread]
    </td>
    </tr>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    $usernamecode

    <!-- subject field -->
    <table cellpadding="0" cellspacing="0" border="0" class="fieldset">
    <tr>
    <td class="smallfont" colspan="3">$vbphrase[title]:</td>
    </tr>
    <tr>
    <td><input type="text" class="bginput" name="title" value="$title" size="50" maxlength="85" tabindex="1" title="$vbphrase[optional]" /></td>
    <td>&nbsp;&nbsp;</td>
    <td><img id="display_posticon" src="$selectedicon[src]" alt="$selectedicon[alt]" /></td>
    </tr>
    </table>
    <!-- / subject field -->

    <table cellpadding="0" cellspacing="0" border="0">
    <tr>
    <td>

    <!-- message area -->
    <div class="smallfont">$vbphrase[message]:</div>
    $messagearea
    <!-- / message area -->

    $posticons

    </td>
    </tr>
    </table>


    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="do" value="postreply" />
    <input type="hidden" name="t" value="$threadid" />
    <input type="hidden" name="p" value="$postid" />
    <input type="hidden" name="posthash" value="$posthash" />
    <input type="hidden" name="poststarttime" value="$poststarttime" />
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_reply]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </table>

    <br />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <thead>
    <tr>
    <td class="tcat">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse(''''newpost_options'''')"><img id="collapseimg_newpost_options" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_newpost_options].gif" alt="" border="0" /></a>
    $vbphrase[additional_options]
    </td>
    </tr>
    </thead>
    <tbody id="collapseobj_newpost_options" style="$vbcollapse[collapseobj_newpost_options]">
    <tr valign="top">
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    <fieldset class="fieldset">
    <legend>$vbphrase[miscellaneous_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <if condition="$bbuserinfo[''''signature''''] != ''''''''"><div><label for="cb_signature"><input type="checkbox" name="signature" value="1" id="cb_signature" tabindex="1" $checked[signature] />$vbphrase[show_your_signature]</label></div></if>
    <div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div>
    $disablesmiliesoption
    </div>
    </fieldset>

    $attachmentoption

    <if condition="$show[''''member'''']">
    <fieldset class="fieldset">
    <legend>$vbphrase[thread_subscription]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <tr>
    <td>$vbphrase[notification_type]:<br /><select name="emailupdate" tabindex="1">
    <option value="9999" $emailchecked[9999]>$vbphrase[do_not_subscribe]</option>
    <option value="0" $emailchecked[0]>$vbphrase[no_email_notification]</option>
    <option value="1" $emailchecked[1]>$vbphrase[instant_email_notification]</option>
    <option value="2" $emailchecked[2]>$vbphrase[daily_email_notification]</option>
    <option value="3" $emailchecked[3]>$vbphrase[weekly_email_notification]</option>
    </select></td>
    <if condition="$show[''''subscribefolders'''']"><td>$vbphrase[folder]:<br /><select name="folderid" tabindex="1">$folderbits</select></td></if>
    </tr>
    </table>
    </fieldset>
    </if>

    <if condition="$show[''''threadrating'''']">
    <fieldset class="fieldset">
    <legend>$vbphrase[rate_thread]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div>$vbphrase[can_add_a_score_for_thread]</div>
    <div>
    <select name="rating" tabindex="1">
    <option value="0"$rate[0]>$vbphrase[choose_a_rating]</option>
    <optgroup>
    <option value="5"$rate[5]>5 : $vbphrase[excellent]</option>
    <option value="4"$rate[4]>4 : $vbphrase[good]</option>
    <option value="3"$rate[3]>3 : $vbphrase[average]</option>
    <option value="2"$rate[2]>2 : $vbphrase[bad]</option>
    <option value="1"$rate[1]>1 : $vbphrase[terrible]</option>
    </optgroup>
    </select>
    </div>
    </div>
    </fieldset>
    </if>

    $threadmanagement

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_reply]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </tbody>
    </table>

    </form>

    <br />


    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse(''''threadreview'''')"><img id="collapseimg_threadreview" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_threadreview].gif" alt="" border="" /></a>
    $vbphrase[topic_review_newest_first]
    </td>
    </tr>
    </table>

    $spacer_close
    $spacer_open

    <div id="collapseobj_threadreview" style="$vbcollapse[collapseobj_threadreview]">

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

    $threadreviewbits

    <if condition="$show[''''reviewmore'''']">
    <tr>
    <td class="tfoot" align="center" colspan="2"><span class="smallfont">
    " . construct_phrase("$vbphrase[thread_has_more_than_x_review]", "$vboptions[maxposts]", "showthread.php?$session[sessionurl]t=$threadid") . "
    </span></td>
    </tr>
    </if>

    </table>

    </div>

    $spacer_close
    $spacer_open

    <br />

    $forumrules

    $footer

    </body>
    </html>', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head><title>$vboptions[bbtitle] - $vbphrase[reply_to_topic]</title>
    $headinclude
    </head>
    <body$onload>
    $header
    $navbar

    <form action="newreply.php" name="vbform" method="post"<if condition="!is_browser(''webtv'')"> onsubmit="return validatePost(this, 0, $vboptions[postminchars], $vboptions[postmaxchars]);" onreset="vB_RESET(this);"</if>>

    $postpreview

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><strong>$vbphrase[thread]</strong>: <a href="showthread.php?$session[sessionurl]t=$threadinfo[threadid]">$threadinfo[title]</a></span>
    $vbphrase[reply_to_thread]
    </td>
    </tr>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    $usernamecode

    <!-- subject field -->
    <table cellpadding="0" cellspacing="0" border="0" class="fieldset">
    <tr>
    <td class="smallfont" colspan="3">$vbphrase[title]:</td>
    </tr>
    <tr>
    <td><input type="text" class="bginput" name="title" value="$title" size="50" maxlength="85" tabindex="1" title="$vbphrase[optional]" /></td>
    <td>&nbsp;&nbsp;</td>
    <td><img id="display_posticon" src="$selectedicon[src]" alt="$selectedicon[alt]" /></td>
    </tr>
    </table>
    <!-- / subject field -->

    <table cellpadding="0" cellspacing="0" border="0">
    <tr>
    <td>

    <!-- message area -->
    <div class="smallfont">$vbphrase[message]:</div>
    $messagearea
    <!-- / message area -->

    $posticons

    </td>
    </tr>
    </table>


    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="do" value="postreply" />
    <input type="hidden" name="t" value="$threadid" />
    <input type="hidden" name="p" value="$postid" />
    <input type="hidden" name="posthash" value="$posthash" />
    <input type="hidden" name="poststarttime" value="$poststarttime" />
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_reply]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </table>

    <br />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <thead>
    <tr>
    <td class="tcat">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse(''newpost_options'')"><img id="collapseimg_newpost_options" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_newpost_options].gif" alt="" border="0" /></a>
    $vbphrase[additional_options]
    </td>
    </tr>
    </thead>
    <tbody id="collapseobj_newpost_options" style="$vbcollapse[collapseobj_newpost_options]">
    <tr valign="top">
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    <fieldset class="fieldset">
    <legend>$vbphrase[miscellaneous_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <if condition="$bbuserinfo[''signature''] != ''''"><div><label for="cb_signature"><input type="checkbox" name="signature" value="1" id="cb_signature" tabindex="1" $checked[signature] />$vbphrase[show_your_signature]</label></div></if>
    <div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div>
    $disablesmiliesoption
    </div>
    </fieldset>

    $attachmentoption

    <if condition="$show[''member'']">
    <fieldset class="fieldset">
    <legend>$vbphrase[thread_subscription]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <tr>
    <td>$vbphrase[notification_type]:<br /><select name="emailupdate" tabindex="1">
    <option value="9999" $emailchecked[9999]>$vbphrase[do_not_subscribe]</option>
    <option value="0" $emailchecked[0]>$vbphrase[no_email_notification]</option>
    <option value="1" $emailchecked[1]>$vbphrase[instant_email_notification]</option>
    <option value="2" $emailchecked[2]>$vbphrase[daily_email_notification]</option>
    <option value="3" $emailchecked[3]>$vbphrase[weekly_email_notification]</option>
    </select></td>
    <if condition="$show[''subscribefolders'']"><td>$vbphrase[folder]:<br /><select name="folderid" tabindex="1">$folderbits</select></td></if>
    </tr>
    </table>
    </fieldset>
    </if>

    <if condition="$show[''threadrating'']">
    <fieldset class="fieldset">
    <legend>$vbphrase[rate_thread]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div>$vbphrase[can_add_a_score_for_thread]</div>
    <div>
    <select name="rating" tabindex="1">
    <option value="0"$rate[0]>$vbphrase[choose_a_rating]</option>
    <optgroup>
    <option value="5"$rate[5]>5 : $vbphrase[excellent]</option>
    <option value="4"$rate[4]>4 : $vbphrase[good]</option>
    <option value="3"$rate[3]>3 : $vbphrase[average]</option>
    <option value="2"$rate[2]>2 : $vbphrase[bad]</option>
    <option value="1"$rate[1]>1 : $vbphrase[terrible]</option>
    </optgroup>
    </select>
    </div>
    </div>
    </fieldset>
    </if>

    $threadmanagement

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_reply]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </tbody>
    </table>

    </form>

    <br />


    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse(''threadreview'')"><img id="collapseimg_threadreview" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_threadreview].gif" alt="" border="" /></a>
    $vbphrase[topic_review_newest_first]
    </td>
    </tr>
    </table>

    $spacer_close
    $spacer_open

    <div id="collapseobj_threadreview" style="$vbcollapse[collapseobj_threadreview]">

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

    $threadreviewbits

    <if condition="$show[''reviewmore'']">
    <tr>
    <td class="tfoot" align="center" colspan="2"><span class="smallfont">
    <phrase 1="$vboptions[maxposts]" 2="showthread.php?$session[sessionurl]t=$threadid">$vbphrase[thread_has_more_than_x_review]</phrase>
    </span></td>
    </tr>
    </if>

    </table>

    </div>

    $spacer_close
    $spacer_open

    <br />

    $forumrules

    $footer

    </body>
    </html>', 1079977516, 'freddie', '3.0.1'),(-1, 'template', 'newreply_reviewbit', '<tr>
    <td class="thead" colspan="2">$postdate $posttime</td>
    </tr>
    <tr title="" . construct_phrase("$vbphrase[post_x]", "$post[postid]") . "" valign="top">
    <td class="alt1" width="125" align="center">$username</td>
    <td class="alt2">$reviewmessage</td>
    </tr>
    ', '<tr>
    <td class="thead" colspan="2">$postdate $posttime</td>
    </tr>
    <tr title="<phrase 1="$post[postid]">$vbphrase[post_x]</phrase>" valign="top">
    <td class="alt1" width="125" align="center">$username</td>
    <td class="alt2">$reviewmessage</td>
    </tr>
    ', 1070081883, 'Ed Sullivan', '3.0.0 Gamma'),(-1, 'template', 'newreply_reviewbit_ignore', '$vbphrase[this_user_on_your_ignore_list]', '$vbphrase[this_user_on_your_ignore_list]', 1070145199, 'Ed Sullivan', '3.0.0 Gamma'),(-1, 'template', 'newreply_reviewbit_ignore_global', '" . construct_phrase("$vbphrase[administrator_decided_x_quiet]", "$post[username]") . "', '<phrase 1="$post[username]">$vbphrase[administrator_decided_x_quiet]</phrase>', 1070145286, 'Ed Sullivan', '3.0.0 Gamma'),(-1, 'template', 'newthread', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head>
    <title>$vboptions[bbtitle] - $vbphrase[post_new_thread]</title>
    $headinclude
    </head>
    <body$onload>
    $header
    $navbar

    <form action="newthread.php" method="post" name="vbform"<if condition="!is_browser(''''webtv'''')"> onsubmit="return validatePost(this, this.subject.value, $vboptions[postminchars], $vboptions[postmaxchars]);" onreset="vB_RESET(this);"</if>>

    $postpreview

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><strong>$vbphrase[forum]</strong>: <a href="forumdisplay.php?$session[sessionurl]f=$foruminfo[forumid]">$foruminfo[title]</a></span>
    $vbphrase[post_new_thread]
    </td>
    </tr>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    $usernamecode

    <!-- subject field -->
    <table cellpadding="0" cellspacing="0" border="0" class="fieldset">
    <tr>
    <td class="smallfont" colspan="3">$vbphrase[title]:</td>
    </tr>
    <tr>
    <td><input type="text" class="bginput" name="subject" value="$subject" size="40" maxlength="85" tabindex="1" /></td>
    <td>&nbsp;&nbsp;</td>
    <td><img id="display_posticon" src="$selectedicon[src]" alt="$selectedicon[alt]" /></td> </tr>
    </table>
    <!-- / subject field -->

    <table cellpadding="0" cellspacing="0" border="0">
    <tr>
    <td>

    <!-- message area -->
    <div class="smallfont">$vbphrase[message]:</div>
    $messagearea
    <!-- / message area -->

    $posticons

    </td>
    </tr>
    </table>

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="f" value="$forumid" />
    <input type="hidden" name="do" value="postthread" />
    <input type="hidden" name="posthash" value="$posthash" />
    <input type="hidden" name="poststarttime" value="$poststarttime" />
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_new_thread]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </table>

    <br />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <thead>
    <tr>
    <td class="tcat">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse(''''newpost_options'''')"><img id="collapseimg_newpost_options" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_newpost_options].gif" alt="" border="0" /></a>
    $vbphrase[additional_options]
    </td>
    </tr>
    </thead>
    <tbody id="collapseobj_newpost_options" style="$vbcollapse[collapseobj_newpost_options]">
    <tr valign="top">
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    <fieldset class="fieldset">
    <legend>$vbphrase[miscellaneous_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <if condition="$bbuserinfo[''''signature''''] != ''''''''"><div><label for="cb_signature"><input type="checkbox" name="signature" value="1" id="cb_signature" tabindex="1" $checked[signature] />$vbphrase[show_your_signature]</label></div></if>
    <div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div>
    $disablesmiliesoption
    </div>
    </fieldset>

    $attachmentoption

    <if condition="$show[''''member'''']">
    <fieldset class="fieldset">
    <legend>$vbphrase[thread_subscription]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <tr>
    <td>$vbphrase[notification_type]:<br /><select name="emailupdate" tabindex="1">
    <option value="9999" $emailchecked[9999]>$vbphrase[do_not_subscribe]</option>
    <option value="0" $emailchecked[0]>$vbphrase[no_email_notification]</option>
    <option value="1" $emailchecked[1]>$vbphrase[instant_email_notification]</option>
    <option value="2" $emailchecked[2]>$vbphrase[daily_email_notification]</option>
    <option value="3" $emailchecked[3]>$vbphrase[weekly_email_notification]</option>
    </select></td>
    <if condition="$show[''''subscribefolders'''']"><td>$vbphrase[folder]:<br /><select name="folderid" tabindex="1">$folderbits</select></td></if>
    </tr>
    </table>
    </fieldset>
    </if>

    <if condition="$show[''''poll'''']">
    <fieldset class="fieldset">
    <legend>$vbphrase[post_a_poll]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div><label for="cb_postpoll"><input type="checkbox" name="postpoll" value="yes" id="cb_postpoll" tabindex="1" $checked[postpoll] />$vbphrase[yes_post_a_poll_thread]</label></div>
    <div><label for="polloptnum">$vbphrase[number_of_poll_options]: <input type="text" class="bginput" size="5" name="polloptions" value="$polloptions" id="polloptnum" tabindex="1" /></label> ($vbphrase[maximum]: $vboptions[maxpolloptions])</div>
    </div>
    </fieldset>
    </if>

    $threadmanagement

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_new_thread]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </tbody>
    </table>

    </form>

    <br />

    $forumrules

    $footer

    </body>
    </html>', '$stylevar[htmldoctype]
    <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
    <head>
    <title>$vboptions[bbtitle] - $vbphrase[post_new_thread]</title>
    $headinclude
    </head>
    <body$onload>
    $header
    $navbar

    <form action="newthread.php" method="post" name="vbform"<if condition="!is_browser(''webtv'')"> onsubmit="return validatePost(this, this.subject.value, $vboptions[postminchars], $vboptions[postmaxchars]);" onreset="vB_RESET(this);"</if>>

    $postpreview

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
    <td class="tcat">
    <span class="smallfont" style="float:$stylevar[right]"><strong>$vbphrase[forum]</strong>: <a href="forumdisplay.php?$session[sessionurl]f=$foruminfo[forumid]">$foruminfo[title]</a></span>
    $vbphrase[post_new_thread]
    </td>
    </tr>
    <tr>
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    $usernamecode

    <!-- subject field -->
    <table cellpadding="0" cellspacing="0" border="0" class="fieldset">
    <tr>
    <td class="smallfont" colspan="3">$vbphrase[title]:</td>
    </tr>
    <tr>
    <td><input type="text" class="bginput" name="subject" value="$subject" size="40" maxlength="85" tabindex="1" /></td>
    <td>&nbsp;&nbsp;</td>
    <td><img id="display_posticon" src="$selectedicon[src]" alt="$selectedicon[alt]" /></td> </tr>
    </table>
    <!-- / subject field -->

    <table cellpadding="0" cellspacing="0" border="0">
    <tr>
    <td>

    <!-- message area -->
    <div class="smallfont">$vbphrase[message]:</div>
    $messagearea
    <!-- / message area -->

    $posticons

    </td>
    </tr>
    </table>

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="hidden" name="s" value="$session[sessionhash]" />
    <input type="hidden" name="f" value="$forumid" />
    <input type="hidden" name="do" value="postthread" />
    <input type="hidden" name="posthash" value="$posthash" />
    <input type="hidden" name="poststarttime" value="$poststarttime" />
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_new_thread]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </table>

    <br />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <thead>
    <tr>
    <td class="tcat">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse(''newpost_options'')"><img id="collapseimg_newpost_options" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_newpost_options].gif" alt="" border="0" /></a>
    $vbphrase[additional_options]
    </td>
    </tr>
    </thead>
    <tbody id="collapseobj_newpost_options" style="$vbcollapse[collapseobj_newpost_options]">
    <tr valign="top">
    <td class="panelsurround" align="center">
    <div class="panel">
    <div style="width:$stylevar[formwidth]" align="$stylevar[left]">

    <fieldset class="fieldset">
    <legend>$vbphrase[miscellaneous_options]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <if condition="$bbuserinfo[''signature''] != ''''"><div><label for="cb_signature"><input type="checkbox" name="signature" value="1" id="cb_signature" tabindex="1" $checked[signature] />$vbphrase[show_your_signature]</label></div></if>
    <div><label for="cb_parseurl"><input type="checkbox" name="parseurl" value="1" id="cb_parseurl" tabindex="1" $checked[parseurl] />$vbphrase[automatically_parse_links_in_text]</label></div>
    $disablesmiliesoption
    </div>
    </fieldset>

    $attachmentoption

    <if condition="$show[''member'']">
    <fieldset class="fieldset">
    <legend>$vbphrase[thread_subscription]</legend>
    <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
    <tr>
    <td>$vbphrase[notification_type]:<br /><select name="emailupdate" tabindex="1">
    <option value="9999" $emailchecked[9999]>$vbphrase[do_not_subscribe]</option>
    <option value="0" $emailchecked[0]>$vbphrase[no_email_notification]</option>
    <option value="1" $emailchecked[1]>$vbphrase[instant_email_notification]</option>
    <option value="2" $emailchecked[2]>$vbphrase[daily_email_notification]</option>
    <option value="3" $emailchecked[3]>$vbphrase[weekly_email_notification]</option>
    </select></td>
    <if condition="$show[''subscribefolders'']"><td>$vbphrase[folder]:<br /><select name="folderid" tabindex="1">$folderbits</select></td></if>
    </tr>
    </table>
    </fieldset>
    </if>

    <if condition="$show[''poll'']">
    <fieldset class="fieldset">
    <legend>$vbphrase[post_a_poll]</legend>
    <div style="padding:$stylevar[formspacer]px">
    <div><label for="cb_postpoll"><input type="checkbox" name="postpoll" value="yes" id="cb_postpoll" tabindex="1" $checked[postpoll] />$vbphrase[yes_post_a_poll_thread]</label></div>
    <div><label for="polloptnum">$vbphrase[number_of_poll_options]: <input type="text" class="bginput" size="5" name="polloptions" value="$polloptions" id="polloptnum" tabindex="1" /></label> ($vbphrase[maximum]: $vboptions[maxpolloptions])</div>
    </div>
    </fieldset>
    </if>

    $threadmanagement

    </div>
    </div>

    <div style="margin-top:$stylevar[cellpadding]px">
    <input type="submit" class="button" name="sbutton" value="$vbphrase[submit_new_thread]" accesskey="s" tabindex="1" />
    <input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="p" tabindex="1" />
    </div>
    </td>
    </tr>
    </tbody>
    </table>

    </form>

    <br />

    $forumrules

    $footer

    </body>
    </html>', 1079977420, 'freddie', '3.0.1'),(-1, 'template', 'pagenav', '<div class="pagenav" align="$stylevar[right]">
    <table class="tborder" cellpadding="3" cellspacing="$stylevar[cellspacing]" border="0">
    <tr>
    <td class="vbmenu_control" style="font-weight:normal"><!--<img src="$stylevar[imgdir_misc]/multipage.gif" alt="" . construct_phrase("$vbphrase[showing_results_x_to_y_of_z_xx]", "$numbers[first]", "$numbers[last]", "$total", "$totalpages") . "" /> -->" . construct_phrase("$vbphrase[page_x_of_y]", "$pagenumber", "$totalpages") . "</td>
    <if condition="$show[''''first'''']"><td class="alt1"><a class="smallfont" href="$address&amp;page=1$address2" title="$vbphrase[first_page] - " . construct_phrase("$vbphrase[results_x_to_y_of_z]", "$firstnumbers[first]", "$firstnumbers[last]", "$total") . ""><strong>&laquo;</strong> $vbphrase[first]</a></td></if>
    <if condition="$show[''''prev'''']"><td class="alt1"><a class="smallfont" href="$address&amp;page=$prevpage$address2" title="$vbphrase[prev_page] - " . construct_phrase("$vbphrase[results_x_to_y_of_z]", "$prevnumbers[first]", "$prevnumbers[last]", "$total") . "">&lt;</a></td></if>
    $pagenav
    <if condition="$show[''''next'''']"><td class="alt1"><a class="smallfont" href="$address&amp;page=$nextpage$address2" title="$vbphrase[next_page] - " . construct_phrase("$vbphrase[results_x_to_y_of_z]", "$nextnumbers[first]", "$nextnumbers[last]", "$total") . "">&gt;</a></td></if>
    <if condition="$show[''''last'''']"><td class="alt1"><a class="smallfont" href="$address&amp;page=$totalpages$address2" title="$vbphrase[last_page] - " . construct_phrase("$vbphrase[results_x_to_y_of_z]", "$lastnumbers[first]", "$lastnumbers[last]", "$total") . "">$vbphrase[last] <strong>&raquo;</strong></a></td></if>
    </tr>
    </table>
    </div>
    ', '<div class="pagenav" align="$stylevar[right]">
    <table class="tborder" cellpadding="3" cellspacing="$stylevar[cellspacing]" border="0">
    <tr>
    <td class="vbmenu_control" style="font-weight:normal"><!--<img src="$stylevar[imgdir_misc]/multipage.gif" alt="<phrase 1="$numbers[first]" 2="$numbers[last]" 3="$total" 4="$totalpages">$vbphrase[showing_results_x_to_y_of_z_xx]</phrase>" /> --><phrase 1="$pagenumber" 2="$totalpages">$vbphrase[page_x_of_y]</phrase></td>
    <if condition="$show[''first'']"><td class="alt1"><a class="smallfont" href="$address&amp;page=1$address2" title="$vbphrase[first_page] - <phrase 1="$firstnumbers[first]" 2="$firstnumbers[last]" 3="$total">$vbphrase[results_x_to_y_of_z]</phrase>"><strong>&laquo;</strong> $vbphrase[first]</a></td></if>
    <if condition="$show[''prev'']"><td class="alt1"><a class="smallfont" href="$address&amp;page=$prevpage$address2" title="$vbphrase[prev_page] - <phrase 1="$prevnumbers[first]" 2="$prevnumbers[last]" 3="$total">$vbphrase[results_x_to_y_of_z]</phrase>">&lt;</a></td></if>
    $pagenav
    <if condition="$show[''next'']"><td class="alt1"><a class="smallfont" href="$address&amp;page=$nextpage$address2" title="$vbphrase[next_page] - <phrase 1="$nextnumbers[first]" 2="$nextnumbers[last]" 3="$total">$vbphrase[results_x_to_y_of_z]</phrase>">&gt;</a></td></if>
    <if condition="$show[''last'']"><td class="alt1"><a class="smallfont" href="$address&amp;page=$totalpages$address2" title="$vbphrase[last_page] - <phrase 1="$lastnumbers[first]" 2="$lastnumbers[last]" 3="$total">$vbphrase[results_x_to_y_of_z]</phrase>">$vbphrase[last] <strong>&raquo;</strong></a></td></if>
    </tr>
    </table>
    </div>
    ', 1071578441, 'Kier', '3.0.0 Release Candidate 1'),(-1, 'template', 'pagenav_curpage', ' <td class="alt2"><span class="smallfont" title="" . construct_phrase("$vbphrase[showing_results_x_to_y_of_z]", "$numbers[first]", "$numbers[last]", "$total") . ""><strong>$curpage</strong></span></td>
    ', ' <td class="alt2"><span class="smallfont" title="<phrase 1="$numbers[first]" 2="$numbers[last]" 3="$total">$vbphrase[showing_results_x_to_y_of_z]</phrase>"><strong>$curpage</strong></span></td>
    ', 1070082250, 'Ed Sullivan', '3.0.0 Gamma')

    mysql error: You have an error in your SQL syntax near 'newattachment.php?$session[sessionurl]$attachurl&amp;poststarttime=$poststarttim' at line 5

    mysql error number: 1064

    Date: Wednesday 11th of May 2005 07:31:19 PM
    Script: http://www.london.uk.com/forum/install/install.php?step=7
    Referer: http://www.london.uk.com/forum/install/install.php?step=6
    IP Address: xx.xx.xx.xx

    Comment

    • #3
      Running PP 4.3.0
      Apache 2
      MySQL 3.23.58

      Thanks in advance for your help.
      Alex

      Comment

      • #4
        Try uploading the files in your ./install directory again. Make sure they are uploaded in ASCII.
        Want to take your board beyond the standard vBulletin features?
        Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

        Comment

        • #5
          Originally posted by MarcoH64
          Try uploading the files in your ./install directory again. Make sure they are uploaded in ASCII.
          Thanks a lot for your support, Marco.
          I did as you suggested. Reuploaded the /install directory, made sure it's done in ASCII, ran the script again, followed the steps to empty the existing db data, and got stuck on the same step 7 again... Should I alter any server settings or pay attention to something particular?

          Thanks,
          Alex

          Comment

          • #6
            From what you posted it looks like you ./install/vbulletin-style.xml is corrupted when trying to import templates. If it is not a corrupted upload then i don't know anymore.

            Could you try to download a fresh vBulletin copy from member area, and upload again (maybe even a different FTP client).

            If that don't help, I suggest you wait for Jelsoft Support to reply or open a Support Ticket.
            Want to take your board beyond the standard vBulletin features?
            Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

            Comment

            • #7
              I have only downloaded a fresh copy of the archive an hour ago... This wasn't happening on the old server, and I switched to a new one a few days ago, then the forum started to give errors when trying to post new threads and do some other stuf. Then I tried a new install, and it doesn't go through. What can it be? Anyone knows? Please...

              Comment

              • #8
                Reupload all the original vB non-image files. Make sure you upload the non-image files in ASCII format and overwrite the ones on the server.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography

                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                • #9
                  Thanks, Steve.
                  I have taken care of that already, after reading a few posts on these forums, but with no luck.. Error is still there...

                  Comment

                  • #10
                    SQL syntax errors are almost always related to bad files or code. I do not know any other reason to get this error which is why I suggested reuploading the files again.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography

                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment

                    • #11
                      Steve if you look into that very long error message, you will find in the first few lines it is trying to load the 'navbar_link' template. This template is only 5 lines big. However the install script somehow reads past teh end of the 'navbar_link' template in the vbulletin-style.xml and try to insert much more. Because of this it is also trying to insert unescaped quotes, which in turn make the query give an SQL-error.

                      So the problem is not in the query, but in the reading from teh xml-file.

                      PS But i agree that uploading again should have solved this.
                      Want to take your board beyond the standard vBulletin features?
                      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                      Comment

                      • #12
                        Ok, I have installed a new FTP client (CuteFTP), made sure I am uploading the install directory in ASCII, then started a new install. Same thing, getting stuck on the step 7 again. Would you please take a look, I can give you FTP access to the files...

                        I appreciate all your time and support!
                        Thanks,
                        Alex

                        Comment

                        • #13
                          The solution was turning magic_quotes_gpc and magic_quotes_sybase to off insite php.ini file, and that solved all the problems. The install didn't lock on step 7 any more, it went through smoothly, and the existing forum started to work normally again.

                          Thanks to Marco, we have managed to get to the clue to why all this mess was happening, and now the forums are all set and running fine.

                          You're the man, Marco

                          Comment

                          Previous template Next
                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X