an
groups-icon

CSV Import Plugin fail

Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    Michael Somerville
    0 points
    Beginner

    Responsive Directory Theme v8.0
    WP Version 4.1.1
    MySQL v5.5.41
    CSV Import Plugin v3.0

    1. Exported All Content from site (15 listings) using Plugin export function.
    2. Modified two rows (Post_Title column) only

    The error below is what I get on attempting to Import modified file.
    —————————————————————————————————-

    WordPress database error: [The used command is not allowed with this MySQL version]
    LOAD DATA LOCAL INFILE ‘/var/www/wordpress/wp-content/uploads/2015/02/US2_Export_Test.csv’ INTO TABLE temp_27_02_2015_23_27_37 CHARACTER SET UTF8 FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘\”‘ ESCAPED BY ‘\\’ IGNORE 1 LINES (ID,post_author,post_date,post_content,post_title,post_excerpt,post_type,category,access,claimme,doc_array,email,featured,feedbackrating,feedbackrating_total,feedbackrating_votes,frontpage,groupon_1,hidden,hits,hits_array,html,image_array,is_submission,last_visitor,listing_expiry_date,listing_price,listing_price_due,listing_price_paid,listing_price_paid_date,listing_status,listing_status_msg,listing_sticker,map-address1,map-address2,map-address3,map-city,map-country,map-lat,map-log,map-state,map-zip,map_location,menu,packageID,page-specific-menu-items_currentpage_items,pending_message,per-page-ath-content,phone,post_tags,ref,score,showgooglemap,starrating,starrating_total,starrating_votes,status,store,timeaccess,topcategory,url,userID,username,user_submit_image,user_submit_ip,user_submit_name,user_submit_url,visitorcounter,width,youtube,post_id)

    string(1232) “LOAD DATA LOCAL INFILE ‘/var/www/wordpress/wp-content/uploads/2015/02/US2_Export_Test.csv’ INTO TABLE temp_27_02_2015_23_27_37 CHARACTER SET UTF8 FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘\”‘ ESCAPED BY ‘\\’ IGNORE 1 LINES (ID,post_author,post_date,post_content,post_title,post_excerpt,post_type,category,access,claimme,doc_array,email,featured,feedbackrating,feedbackrating_total,feedbackrating_votes,frontpage,groupon_1,hidden,hits,hits_array,html,image_array,is_submission,last_visitor,listing_expiry_date,listing_price,listing_price_due,listing_price_paid,listing_price_paid_date,listing_status,listing_status_msg,listing_sticker,map-address1,map-address2,map-address3,map-city,map-country,map-lat,map-log,map-state,map-zip,map_location,menu,packageID,page-specific-menu-items_currentpage_items,pending_message,per-page-ath-content,phone,post_tags,ref,score,showgooglemap,starrating,starrating_total,starrating_votes,status,store,timeaccess,topcategory,url,userID,username,user_submit_image,user_submit_ip,user_submit_name,user_submit_url,visitorcounter,width,youtube,post_id)” NULL error=,

    February 28, 2015 at 1:38 am
  • Mark Fail
    11,848 points
    Platinum User
    Bronze User Silver User Gold User Platinum User Helpful Award Fast Responder Thank You Coffee Villian Award Video Testimonial
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    February 28, 2015 at 7:20 am
  • Michael Somerville
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    February 28, 2015 at 4:48 pm
  • 0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    April 11, 2016 at 2:21 pm
  • 0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    April 11, 2016 at 6:11 pm
  • oluwakemi odeleye
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    May 29, 2016 at 7:55 am

422

Views

5

Replies