Page 1 of 1

SQl Error loading Message

PostPosted: 22. August 2015 11:17
by Bernard46
I've just started using XAMPP on Windows 7.1 Pro so please understand if I have posted this in the wrong place. I have been trying to download a copy of an existing website which I no longer want just so that if the worst comes to the worst I can reinstate it. This website works as far as I am aware.
However I have downloaded the SQL database from GoDaddy and I did the import into XAMPP using the phpMyAdmin - much to my surprise it came up with the following error message. Unfortunately I haven't a clue as to how to work out exactly what the error is or how to correct it. Could anyone help please/

<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="tbl_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60souther9_wp3%60+LIKE+%27wp_postmeta%27&amp;show_query=1&amp;db=&amp;table=wp_postmeta&amp;token=23c996ac1ce92b545be94ef5673fefd1"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p>
<p>
<span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdo

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 '<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Error</h1>
<p><strong>SQL quer' at line 1


regards, Bernard

Re: SQl Error loading Message

PostPosted: 22. August 2015 11:53
by Altrea
Code: Select all
<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="tbl_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60souther9_wp3%60+LIKE+%27wp_postmeta%27&amp;show_query=1&amp;db=&amp;table=wp_postmeta&amp;token=23c996ac1ce92b545be94ef5673fefd1"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p>
<p>
<span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdo

This is not a valid SQL Statement so you cannot put this in the SQL text field and try to import it.

Re: SQl Error loading Message

PostPosted: 22. August 2015 13:51
by Bernard46
Sure, I got the message that there was an error in it but it does come from a working system and was exported from it by phpMyAdmin. All that is to some extent irrelevant since the problem exists. However what I was really looking for was some help in identifying what could be wrong and how I could correct the error. Any chance you can help me?

Re: SQl Error loading Message

PostPosted: 22. August 2015 17:17
by Nobbie
Bernard46 wrote: Any chance you can help me?


NO. Definately NOT.

This is crap, nothing else. Its corrupted HTML.

Re: SQl Error loading Message

PostPosted: 22. August 2015 18:50
by Altrea
Bernard46 wrote:However what I was really looking for was some help in identifying what could be wrong and how I could correct the error.

If all your information you gave us are correct than there is only one possible issue: the export went terrible wrong.

Re: SQl Error loading Message

PostPosted: 22. August 2015 19:54
by Bernard46
Thanks Altrea, that was helpful - I'll drop the tables created by the import and give the export and import another try, paying more attention to the process in case there is something I should be doing that I missed. Much appreciated.
Bernard