Thread Rating:
  • 16 Vote(s) - 3.56 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to change hosts successfully
#82
Hello today I just thought to try out this tutorial. However I seem to be getting an error whenever I import the database. I'm importing the database on a new URL and on a new host.

I get the following error;

Code:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 379
STR: </
SQL:
    <style type="text/css">
        #mybb_error_content { border: 1px solid #B60101; background: #fff; }
        #mybb_error_content h2 { font-size: 12px; padding: 4px; background: #B60101; color: #fff; margin: 0; }
        #mybb_error_error { padding: 6px; }
        #mybb_error_footer { font-size: 11px; border-top: 1px solid #ccc; padding-top: 10px; }
        #mybb_error_content dt { font-weight: bold; }
    </style>
    <div id="mybb_error_content">
        <h2>MyBB SQL Error</h2>
        <div id="mybb_error_error">
        <p>MyBB has experienced an internal SQL error and cannot continue.</p><dl>
<dt>SQL Error:</dt>
<dd>2006 - MySQL server has gone away</dd>
<dt>Query:</dt>
<dd>OPTIMIZE TABLE mybb_privatemessages</dd>
</dl>

            <p id="mybb_error_footer">Please contact the <a href="http://mybb.com">MyBB Group</a> for support.</p>
        </div>
    </div>


SQL query:

<style type="text/css"> #mybb_error_content { border: 1px solid #B60101; background: #fff; } #mybb_error_content h2 { font-size: 12px; padding: 4px; background: #B60101; color: #fff; margin: 0; } #mybb_error_error { padding: 6px; } #mybb_error_footer { font-size: 11px; border-top: 1px solid #ccc; padding-top: 10px; } #mybb_error_content dt { font-weight: bold; } </style> <div id="mybb_error_content"> <h2>MyBB SQL Error</h2> <div id="mybb_error_error"> <p>MyBB has experienced an internal SQL error and cannot continue.</p><dl> <dt>SQL Error:</dt> <dd>2006 - MySQL server has gone away</dd> <dt>Query:</dt> <dd>OPTIMIZE TABLE mybb_privatemessages</dd> </dl> <p id="mybb_error_footer">Please contact the <a href="http://mybb.com">MyBB Group</a> for support.</p> </div> </div>

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 '&lt;style type=&quot;text/css&quot;&gt;
        #mybb_error_content { border: 1px solid #B60101; backg' at line 1

Since I'm only doing this as an experiment to learn. It's not a real emergency. I've also tried it over and over with new backups to ensure that none of them were corrupted. Any help would be highly appreciated.
[Image: sig.php]
Reply


Messages In This Thread
How to change hosts successfully - Inferno - 01-22-2008, 11:49 PM
RE: How to change hosts successfully - Lo. - 01-14-2010, 01:34 AM
RE: How to change hosts successfully - iDude - 03-08-2011, 11:05 AM
RE: How to change hosts successfully - .m. - 10-07-2013, 03:39 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)