#1064 – error SQL syntax – line 1 – phpMyadmin

  • Hi,
    It’s 3 sleeps before Christmas and this greenhorn is FREAKIN’!
    I REALLY needs some help.

    My story in a nutshell.
    a.) Backed up an existing WordPress site to my computer with MAMP (the WPsite was designed by someone else over a year ago).
    b.) Upgraded to WP 3.7.1 from WP 3.5, and changed the Revolution Slider.
    c.) Then uploaded files from localhost to live server by ftp, then placed WordPress folder in ‘public’ folder.
    d.) Logged into C panel and created a database – I kept the databases’ name the same as the original. I, then, deleted the old database*.
    e.) Next, I went into phpMyadmin to import the WordPress database. Clicked on the database I created earlier, ‘Imported’ the gzipped database and pressed the ‘Go’ button a the bottom of the page.
    f.) At the bottom of a garbled pink error message, I got the following message:

    MySQL said:
    #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 ‘?’ at line 1

    *Because step ‘e’ didn’t work, now there’s no database connection to the WP site. As a newbie, I didn’t anticipate this error. By the way, I do have original version of the SQL. I tried importing that and got a longer error message.

    Thanks everyone.

Viewing 2 replies - 1 through 2 (of 2 total)
  • popper

    (@julialasarte)

    What’s the longer error with the sql database?

    Thread Starter 80grit

    (@80grit)

    Hey popper!
    BTW, the first error message is still there too. But, here is the longer error – a bug in the SQL parser.

    Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNpzDQryD7JScDZUcDZS8HH1s1IwUDBUMDEw4AoOAYrLc3H5VgYH+lgpmOoZ6pmZ6ibn5HCFBgcp
+AfrKDi6u/qF6CiEuQIV+iYmKwQ7ujkGeQJVGuiZGptzBfg6WikY65noGRrqGXIFeASAVOr4B4PM
MtIzU/DJzCut4PJx9HO3UkjN4wLbIt/NwQAGzG/+Rk+/7bbJgEstvcT6/T/Rm6/uTvuz8sShqQqn
dW8vnR2bd3fbqpT3/7Z9v+CpVliaX2LteYiVKYdhjdDe7elfL6+ptNd/fmbO5rD9Z9aYfhZ/trbe
y/5M1Gd9tcTcAmuIeiNhcyYVDe9Xk27t83CBCAnOlAQCQUnJi683Xk36WlL8Sr+5Y+7/28LfCvbG
/F12PTkcalWzRZLf/Rf8GxImpq6e/Pjx69evQa6s2XSn4M8S+U6euEe/1z82sU5MVMspsX76kKku
6SJUpxDneYEzrhtE1N8snGF02ippWuKtnvQzEnMlnL890gwDGSLOuWXlbdvEvPtvb5vtq/z4lftb
7tIf5vst60sa78ra1/77ILj7eJ5tNUgpCNeWfqz58/bl5PD+Y+fn9/5/vnj6+fxat69GGdV/gmU4
11RcN/DjYb7355n58f+Pt/clSoED4LBXPEhv/aeCPw9eX56+nF9Pbq+M88UfBydvdj+v9672Z2qw
4W/54/Pftn74dPHnanXx59EKIZXSPc/9582Jm3NQQQ7kr/pvby4y/+lUkOrargjiW9f+ejFn7eab
E+6tPFl5whhkwUNNn4P8k1We/TO93/NYZUb/+nD+9/11B6Ii1n5v+/8iTe+HiojO2UlfTaLVm84+
akkN+Xb466n5Pccuz3zuH/awSs7lcYltJFuklnQ90BkvjyqXFVb9P7k4durNufcNvjXXSD0+8u9A
jSHXNJDte5L5+ub439z8vKE53H+eTKJtRr1ln8W1XY9OlhycbL3sae2pTzcVpghukgO5q6qGqzjo
l5nAwv+nQdx9jx5K7eN7nDGv83rk4elLTxU+6n7CLuZyU/byny2cKSsSfA9VNLnW13xZzqV1rPG/
lEDIwXPLK4/KiO+KapwTtLTmQuVaJq75/54Ff3txMzz9vNzd6l2W1gDvkY3h
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 0 1 400
STR: 

MySQL: 5.1.65-cll
USR OS, AGENT, VER: Mac SAFARI 5.0.537
PMA: 3.4.11.1
PHP VER,OS: 5.2.6 Linux
LANG: en
SQL: ???[??F?0
>????????? ?-??]n??d?????I"I?l???g??y?/???V??5???J??Z?/&"27$(K???HD"?????b?ts?/??????p?\???cW"I?8bN???

    ?e???????>|??p??? ^????4;aa<??~b?W” ??E?’?2?:b?a?g??C??)V> ???=an???6?y?? ?m??7?9t???}????n={>>}u?|????W?????磗?o}F?2h{?S ?x?0N ???7???a&?J_>?p?????.?C?????G?.?}?eS1?????????’?[ Ty??O??^?? <????? ??!<;}?蜭????y?3>?)L??$??5??$???W??~?ZX?????f.?$,??4[‘????eT????????OV?zD?t=YY*?????#vqz??]???0??|????|1
    ?<?c??O?瀃WO?a=h9?8???t??;??}??? ??>z|
    sR?6???>?????h???Y×??q???D???? d?`M?x?E|??
    *??T?Χy??Z??R?|?y?
    ???S???Wg??{?9;
    —-END RAW—-`

    Thanks for your insight.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘#1064 – error SQL syntax – line 1 – phpMyadmin’ is closed to new replies.