Thread Rating:
  • 17 Vote(s) - 3.65 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 - by Inferno - 01-22-2008, 11:49 PM
RE: How to change hosts successfully - by EviLito - 01-22-2008, 11:52 PM
RE: How to change hosts successfully - by Inferno - 01-22-2008, 11:53 PM
RE: How to change hosts successfully - by Inferno - 01-24-2008, 03:42 AM
RE: How to change hosts successfully - by hemi - 01-24-2008, 11:50 PM
RE: How to change hosts successfully - by Inferno - 01-25-2008, 12:35 AM
RE: How to change hosts successfully - by Ramy - 02-01-2008, 09:29 PM
RE: How to change hosts successfully - by Ramy - 02-02-2008, 04:31 AM
RE: How to change hosts successfully - by Ramy - 02-03-2008, 05:18 AM
RE: How to change hosts successfully - by Ramy - 02-04-2008, 03:46 AM
RE: How to change hosts successfully - by Ramy - 02-08-2008, 04:21 AM
RE: How to change hosts successfully - by zzuzu - 02-09-2008, 06:39 AM
RE: How to change hosts successfully - by Spyda - 02-10-2008, 05:52 PM
RE: How to change hosts successfully - by Spyda - 02-10-2008, 06:23 PM
RE: How to change hosts successfully - by Inferno - 02-13-2008, 01:58 AM
RE: How to change hosts successfully - by Legacy - 06-06-2008, 06:38 PM
RE: How to change hosts successfully - by judel - 06-06-2008, 09:16 PM
RE: How to change hosts successfully - by Legacy - 06-06-2008, 10:17 PM
RE: How to change hosts successfully - by SteelD - 08-05-2008, 03:35 PM
RE: How to change hosts successfully - by peepo - 08-19-2008, 01:13 PM
RE: How to change hosts successfully - by Zayebis - 01-28-2009, 07:41 PM
RE: How to change hosts successfully - by Matt. - 05-22-2009, 05:06 PM
RE: How to change hosts successfully - by cobarde - 09-03-2009, 11:48 AM
RE: How to change hosts successfully - by Skiilz - 10-08-2009, 12:32 AM
RE: How to change hosts successfully - by mugen - 11-09-2009, 08:15 PM
RE: How to change hosts successfully - by Gothic - 01-07-2010, 10:58 PM
RE: How to change hosts successfully - by Lo. - 01-14-2010, 01:34 AM
RE: How to change hosts successfully - by elootos - 01-14-2010, 05:17 PM
RE: How to change hosts successfully - by ReDDs - 01-14-2010, 05:43 PM
RE: How to change hosts successfully - by Pegasis - 03-04-2010, 07:11 PM
RE: How to change hosts successfully - by gnuhong - 04-01-2010, 06:39 PM
RE: How to change hosts successfully - by 5416339 - 04-08-2010, 08:54 AM
RE: How to change hosts successfully - by D1G1T - 05-07-2010, 03:51 AM
RE: How to change hosts successfully - by blake - 09-30-2010, 09:46 PM
RE: How to change hosts successfully - by Taim - 12-15-2010, 12:47 PM
RE: How to change hosts successfully - by -AW- - 12-16-2010, 02:22 AM
RE: How to change hosts successfully - by Philly - 02-18-2011, 04:59 AM
RE: How to change hosts successfully - by iDude - 03-08-2011, 11:05 AM
RE: How to change hosts successfully - by Prime - 03-25-2011, 01:35 AM
RE: How to change hosts successfully - by iDude - 03-25-2011, 07:05 AM
RE: How to change hosts successfully - by Prime - 03-25-2011, 09:48 PM
RE: How to change hosts successfully - by spitman - 03-26-2011, 10:21 PM
RE: How to change hosts successfully - by iDude - 03-27-2011, 06:58 AM
RE: How to change hosts successfully - by Prime - 03-28-2011, 11:04 PM
RE: How to change hosts successfully - by Prime - 03-29-2011, 02:04 AM
RE: How to change hosts successfully - by Akari - 04-19-2011, 08:10 PM
RE: How to change hosts successfully - by Alan S. - 04-19-2011, 08:46 PM
RE: How to change hosts successfully - by Akari - 04-20-2011, 05:17 AM
RE: How to change hosts successfully - by Reku - 07-23-2011, 11:16 PM
RE: How to change hosts successfully - by Reku - 07-25-2011, 04:24 PM
RE: How to change hosts successfully - by Rukbat - 09-25-2011, 11:47 PM
RE: How to change hosts successfully - by mcmar - 03-02-2012, 06:28 AM
RE: How to change hosts successfully - by immu - 03-03-2012, 01:23 PM
RE: How to change hosts successfully - by RedCP - 05-09-2012, 11:02 PM
RE: How to change hosts successfully - by .m. - 10-07-2013, 03:39 PM
RE: How to change hosts successfully - by prsreek - 10-19-2013, 12:02 PM
RE: How to change hosts successfully - by tdbnz - 11-26-2013, 10:28 PM
RE: How to change hosts successfully - by ashleyn - 01-25-2014, 12:45 AM
RE: How to change hosts successfully - by error - 04-08-2014, 10:47 PM
RE: How to change hosts successfully - by Nolan - 08-12-2014, 12:29 AM
RE: How to change hosts successfully - by aaronnz - 08-12-2014, 12:31 AM
RE: How to change hosts successfully - by adsol93 - 05-02-2015, 02:19 AM
RE: How to change hosts successfully - by cees - 07-13-2015, 07:34 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)