MySQL error 1064 near "" at line 1?

  • Resolved michellebeth

    (@michellebeth)


    11 years, 5 months ago

    Hi, I just re-uploaded wp to the root of my server after problems running it from a sub-directory, and on trying to re-import the db it came back with this error:

    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—-
    eNo1zU0KwjAUBGChu3eKOUANSbUUsgslVOHlx6R24U6KC6F0J+jtTQVnOXzM2JRC0ugV+gZsvYZC
    A6Uoj6WuiNwnX1ijFUp0cj8vC11zQsg1zGD9WGOyBbr7DBduZ2ZTqKTojMZRSNFSPMXN1CFvKweh
    OvBzfb2JjR80Hiv9Dqja/fMFDOEg5Q==
    —-END CUT—-
    —-BEGIN RAW—-
    ERROR: C1 C2 LEN: 1 2 11
    STR:

    MySQL: 5.1.70-cll
    USR OS, AGENT, VER: Mac MOZILLA 5.0
    PMA: 4.0.5
    PHP VER,OS: 5.3.17 Linux
    LANG: en
    SQL:

    —-END RAW—-

    SQL query:

    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

    I know absolutely nothing about MySQL and not much about PHP in general really, so I have no idea where and what to change. I opened the SQL file in Textwrangler but couldn’t see what the error was referring to…

    Please help if possible!!

    https://www.pacificortho.com.au

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter michellebeth

    (@michellebeth)

    Sorted… I viewed the invisible characters on the dump and with the help of a very knowledgeable friend discovered there was an extra row at the bottom of the file, causing the error….. Thanks Gianmarco!!

    WordPress database error 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 for query SELECT count FROM wp_term_taxonomy WHERE term_id = made by require(‘C:\inetpub\vhosts\sristudentsolutions.com\httpdocs\wp-blog-header.php’), require_once(‘C:\inetpub\vhosts\sristudentsolutions.com\httpdocs\wp-includes\template-loader.php’), include(‘C:\inetpub\vhosts\sristudentsolutions.com\httpdocs\wp-content\themes\mesocolumn\front-page.php’), get_template_part, locate_template, load_template, require(‘C:\inetpub\vhosts\sristudentsolutions.com\httpdocs\wp-content\themes\mesocolumn\lib\templates\home-feat-cat.php’), dez_get_cat_post_count

    can someone tell me the reason for this type of error.
    i simply imported the database from my local server to host.
    please visit sristudentsolutions.com and scroll down.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL error 1064 near "" at line 1?’ is closed to new replies.

Tags