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=,
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=,Members Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login Now