an
groups-icon

Import CSV server error

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

    I want to import a previously exported csv from an old business directory installation into the new installation, using the export/import plugin. Export works fine and data in the csv looks good. When I then try to import the csv in the new site it bombs out with the following error message below. What version of MariaDB is required for this to work? According to my server’s cpanel my MariaDB is on version ‘10.0.27-MariaDB’. On the Maria DB website I find 10.1.18 announced as the latest version. So which one does this export/import plugin require to work?

    WordPress database error: [The used command is not allowed with this MariaDB version]
    LOAD DATA LOCAL INFILE ‘/home/therapyp/public_html/dev2/wp-content/uploads/CSV-Friday’ INTO TABLE temp_14_10_2016_10_22_51 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,featured,fax_num,field_4eca15ae71456,add_package_point,mysuburb,mytown,province,other_town,address1,hits,sfw_comment_form_password,packageID,featured_image,fees,membership,registration,trackingID,pt_initial_start,landline_num,mobile_num,email_ad,notice_contact,notice_link,rest_date,rest_venue,rest_description,rest_facilitators,rest_fee,rest_contact,image,images,client_focus,add_point,field_4fba1f5ae3774,allorany,rule,rest_link,body,width,qualifications,layout,position,subtitle,thetel,country,field_4fba17a1c58a3,hide_on_screen,field_4eca15d2cc3fb,field_4eca15e6eabfc,field_4eca16952f179,field_4eca16aa1b8f3,field_4eca16d01dcbd,field_4eca1709b4c1e,field_4eca1722d08a8,field_4eca174024aab,field_4eca175809e45,treatment,notice_description,expires,email,address2,theweb,url,price,other_city,sfw_pwd,topcategory,html,visitorcounter,showgooglemap,listing_sticker,listing_status_msg,timeaccess,listing_expiry_date,username,userID,status,ref,clicks,listing_price_due,listing_price_paid,listing_price_paid_date,post_id)
    string(1508) “LOAD DATA LOCAL INFILE ‘/home/therapyp/public_html/dev2/wp-content/uploads/CSV-Friday’ INTO TABLE temp_14_10_2016_10_22_51 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,featured,fax_num,field_4eca15ae71456,add_package_point,mysuburb,mytown,province,other_town,address1,hits,sfw_comment_form_password,packageID,featured_image,fees,membership,registration,trackingID,pt_initial_start,landline_num,mobile_num,email_ad,notice_contact,notice_link,rest_date,rest_venue,rest_description,rest_facilitators,rest_fee,rest_contact,image,images,client_focus,add_point,field_4fba1f5ae3774,allorany,rule,rest_link,body,width,qualifications,layout,position,subtitle,thetel,country,field_4fba17a1c58a3,hide_on_screen,field_4eca15d2cc3fb,field_4eca15e6eabfc,field_4eca16952f179,field_4eca16aa1b8f3,field_4eca16d01dcbd,field_4eca1709b4c1e,field_4eca1722d08a8,field_4eca174024aab,field_4eca175809e45,treatment,notice_description,expires,email,address2,theweb,url,price,other_city,sfw_pwd,topcategory,html,visitorcounter,showgooglemap,listing_sticker,listing_status_msg,timeaccess,listing_expiry_date,username,userID,status,ref,clicks,listing_price_due,listing_price_paid,listing_price_paid_date,post_id)” NULL error=,

    October 14, 2016 at 10:33 am
  • 0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    November 24, 2016 at 12:51 am
  • 0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    November 24, 2016 at 5:57 am
  • Josh njenga
    -10 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    November 24, 2016 at 1:13 pm
  • Franck Aucuit
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    December 20, 2016 at 4:42 pm
  • Franck Aucuit
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    February 6, 2017 at 8:01 pm

429

Views

5

Replies