Problems with the Windows version of XAMPP, questions, comments, and anything related.
by 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&show_query=1&db=&table=wp_postmeta&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
by 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&show_query=1&db=&table=wp_postmeta&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
-
Altrea
- AF Moderator
-
- Posts: 11941
- Joined: 17. August 2009 13:05
- XAMPP version: several
- Operating System: Windows 11 Pro x64
by 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
by 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: 13181
- Joined: 09. March 2008 13:04
by 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
-
Altrea
- AF Moderator
-
- Posts: 11941
- Joined: 17. August 2009 13:05
- XAMPP version: several
- Operating System: Windows 11 Pro x64
by 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: Nobbie and 172 guests