Sql query - Remove tags massively????
delete all the labels on my forum, with an SQL query
Collapse
X
-
Comment
-
Backup your database first! Always make sure you have a current backup before running queries.
Run the follwing queries:
TRUNCATE TABLE tag
TRUNCATE TABLE tagthread
Make sure you add the prefix to the table name if you have one defined (i.e. 'vb_tag'). This will completely empty the two tables, thus discarding all your tags and all deleting all tags from threads.Last edited by cellarius; Tue 8 Sep '09, 8:33am.Comment
-
An error occurred while attempting to execute your query. The following information was returned.
Error number: 1064
Error Description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near''tag''at line 1Comment
-
Comment
-
this is my config.php $ config [ 'Database'] [ 'tableprefix'] ='';Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment