• Hello
    Sorry if i post here but i’m trying to move from godaddy managed wp to dreamhost shared hosting and i get syntax errors at different points.
    Can someone look and tell me where is the error?
    At the moment i have errors in wp_bp_messages_messages

    CREATE TABLE wp_09vwg62cy4_bp_messages_messages (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    thread_id bigint(20) NOT NULL,
    sender_id bigint(20) NOT NULL,
    subject varchar(200) NOT NULL,
    message longtext NOT NULL,
    date_sent datetime NOT NULL,
    PRIMARY KEY (id),
    KEY sender_id (sender_id),
    KEY thread_id (thread_id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1912 ;

    This is the error it say i have chk using MySQL workbench but not see any error at that line.

    Error
    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 ‘INSERT INTO wp_09vwg62cy4_bp_messages_messages VALUES(37, 11, 1, ‘Re: user pay’ at line 2
    Here is the line of it.

    INSERT INTO wp_09vwg62cy4_bp_messages_messages VALUES(37, 11, 1, ‘Re: user payd’, ‘he have to check the paypal email for activation. sorry i was busy studying. ‘, ‘2012-10-30 01:17:36’);

    I can’t post more data because is from private messages.
    Any input are welcome to help,unfortunately both hosts don’t care much to help.

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mysql import syntax errors’ is closed to new replies.