Deleting comments

☆ A M B ☆
455 Posts

AHHP Reply #1, 19 years, 7 months ago

Hi,
how can i delete all comments in page immediately? or delete a big number of them immediately?
i received many advertisment commnets and want to delete them.
another qouestion: does using Captcha stop the advertisment comments?

Regards
AHHP

God loves me. 【ツ】

MODX.ir (Persian Support)

Boplo.ir/modx/ (Persian)

43 Posts

YankeeDeuce Reply #2, 19 years, 7 months ago

Captcha should stop it. I actually just noticed I had a ton of spam today (Haven’t been able to work on the site too much in a while sad

)

If you have phpMyAdmin for your mysql DB you can delete the comments from there, jot_content is the table they are stored in.

101 Posts

gcruz Reply #3, 19 years, 7 months ago

I got an error that I couldn’t drop the columns, so I dropped the table instead and got this error when trying to load my site.

« MODx Parse Error »

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table 'lamp.modx_jot_content' doesn't exist »
      SQL: SELECT count(id) FROM `lamp`.`modx_jot_content` WHERE uparent = 14 AND tagid = "" and published = 1 
      [Copy SQL to ClipBoard]
 
Parser timing
  MySQL:	0.0659 s	(18 Requests)
  PHP:	0.2361 s	 
  Total:	0.3021 s

☆ A M B ☆
24,524 Posts

sottwell Reply #4, 19 years, 7 months ago

Well, yeah... Jot does require that table with all its columns. Instead of "drop table" you should have used "truncate table". That empties it and sets the auto-increment back to 1.

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

101 Posts

gcruz Reply #5, 19 years, 7 months ago

Thank goodness for backups!

I thought it would be like MaxiGallery where it would recreate the table if not found.