aravinddhiva

Hi Peter,
Can you share mail id

Inside the script file, only three update statement is present.

UPDATE wp_postmeta SET meta_value=’sampleTest1′ WHERE post_id = 1;
UPDATE wp_postmeta SET meta_value=’sampleTest2′ WHERE post_id = 2;
UPDATE wp_postmeta SET meta_value=’sampleTest3′ WHERE post_id = 3;

• This reply was modified 4 years, 11 months ago by aravinddhiva.

Hi Peter,
I tried to run the script directly from the Data Explorer main page. It comes like

ERROR: Import test.sql failed [check import file]

Insert query alone working for me.

• This reply was modified 4 years, 11 months ago by aravinddhiva.
• This reply was modified 4 years, 11 months ago by aravinddhiva.

I’m using this query inside sql file

UPDATE wp_postmeta SET meta_value=’sampleTest1′ WHERE post_id = 1;
UPDATE wp_postmeta SET meta_value=’sampleTest2′ WHERE post_id = 2;
UPDATE wp_postmeta SET meta_value=’sampleTest3′ WHERE post_id = 3;

but it not working for me.
result : INFO: Imported 0 rows (2 failed).