TwistAndShout

Active Member
Mar 2, 2021
38
6
8
Paris
cPanel Access Level
Root Administrator
Hello,

I am trying to erase all products from a clone of my shop with this command :

DELETE FROM wp_posts WHERE post_type = 'product';

I identify my post table as this one :

8nSUmyx27_b2s_posts

So I send this command :

DELETE FROM 8nSUmyx27_b2s_posts WHERE post_type = 'product';

It fails, the system answers :

1064 - Syntax error close to 'WHERE post_type = 'product'' at line 1


I looked everywhere, I can't find what the error is. Any idea anyone ?

Thanks in advanced.
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
4,968
612
273
cPanel Access Level
Root Administrator
Hey there! I'm not sure there will be a good way to answer this for you as this isn't related to any cPanel tools on the machine. One would need to be familiar with the database and table structure to see why that error is happening. You might want to try running some "select" commands to see if you can query the data you are expecting to remove first, before trying the removal with "delete from"
 
  • Like
Reactions: TwistAndShout