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=,
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=,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