SQl Error loading Message

Problems with the Windows version of XAMPP, questions, comments, and anything related.

SQl Error loading Message

Postby Bernard46 » 22. August 2015 11:17

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
Bernard46
 
Posts: 3
Joined: 22. August 2015 11:01
Operating System: Windows 7

Re: SQl Error loading Message

Postby Altrea » 22. August 2015 11:53

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQl Error loading Message

Postby Bernard46 » 22. August 2015 13:51

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?
Bernard46
 
Posts: 3
Joined: 22. August 2015 11:01
Operating System: Windows 7

Re: SQl Error loading Message

Postby Nobbie » 22. August 2015 17:17

Bernard46 wrote: Any chance you can help me?


NO. Definately NOT.

This is crap, nothing else. Its corrupted HTML.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: SQl Error loading Message

Postby Altrea » 22. August 2015 18:50

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQl Error loading Message

Postby Bernard46 » 22. August 2015 19:54

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
Bernard46
 
Posts: 3
Joined: 22. August 2015 11:01
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: jeanneotts and 148 guests