Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import reports false SQL error with MariaDB #12025

Closed
foundationphp opened this Issue Feb 24, 2016 · 7 comments

Comments

Projects
None yet
7 participants
@foundationphp
Copy link

foundationphp commented Feb 24, 2016

Steps to reproduce

  1. Running phpMyAdmin 4.5.5 with MariaDB 10.1.10.
  2. Export a database to a dumpfile.
  3. Try to import the same dumpfile to an empty database.

Expected behaviour

It should be correctly imported.

Actual behaviour

#1064 - You have an error in your SQL syntax. The location of the error is after an INSERT query, just before a CREATE TABLE query. The syntax is correct. Maria DB imports the same dumpfile from the command line without complaint.

Dumpfiles created originally on MySQL are correctly imported. It's only dumpfiles generated from MariaDB that have this problem.

Server configuration

Operating system:
Windows 10
Web server:
Apache 2.4.18
Database:
upandrunning
PHP version:
7.0.3
phpMyAdmin version:
4.5.5

Client configuration

Browser:
Chrome 48
Operating system:
Windows 10
up_and_running_backup.sql.txt

@brad-jones

This comment has been minimized.

Copy link

brad-jones commented Feb 25, 2016

I am also having this issue, I am running on Fedora 23.
Also running PHP 7.0.3. FYI: Same error also happen when running 5.6.18

Static analysis:
2 errors were found during analysis.

  • Ending quote ' was expected. (near "" at position 78553)
  • 4 values were expected, but found 3. (near "(" at position 11278)

MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4:"data";s:' at line 1

This is the dump that caused the errors above.
dumpdYaXNc.zip

@princeermes

This comment has been minimized.

Copy link

princeermes commented Feb 25, 2016

Hello!
This is my bug:
MySQL a répondu: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '�?�' at line 2
Thanks to help me

@nijel nijel self-assigned this Mar 2, 2016

@nijel nijel added this to the 4.6.0 milestone Mar 2, 2016

@nijel

This comment has been minimized.

Copy link
Member

nijel commented Mar 2, 2016

This is same as #12054 which I've fixed today.

@nijel nijel closed this Mar 2, 2016

@rbester

This comment has been minimized.

Copy link

rbester commented Jan 9, 2017

Same problem here with this version of phpMyAdmin that came with wamp. The solution - don't use phpMyAdmin for the import of the WP dump file. Instead use the good old command line:
$ mysql -u your_db_user -p < [path-to-sql]\wp-dumpfile.sql

@nijel

This comment has been minimized.

Copy link
Member

nijel commented Jan 17, 2017

@rbester Which phpMyAdmin version did you use? Does the fix for #12054 work for you?

@rbester

This comment has been minimized.

Copy link

rbester commented Jan 17, 2017

It was phpMyAdmin 4.5.5 but I did not try that fix. Instead, I went around it by importing the WordPress SQL file using MySQL from the shell and that solved the issue for me.

@Agimovel

This comment has been minimized.

Copy link

Agimovel commented May 2, 2018

Hi, my phpMyAdmin version is 4.5.5 and is not working. In the middle of my sql dump (from PHPMyAdmin) there's this line:

para \ 'F \ ' (there's no spaces, if I post here without spaces code dissapear).

When importing, it breaks on 'F' with "expecting ' "

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.