Reset Everything with only one click!

[nova-bossa]

how can i reset/delete AT ONCE (!!!) ALL ratings and ALL comments and ALL most viewed?

[Joachim Müller]

out-of-the-box, with built-in coppermine tools: not at all.
I recommend using a tool like phpMyAdmin and running an apropriate query there (backup your stuff first in case anything goes wrong).

GauGau

[nova-bossa]

I recommend using a tool like phpMyAdmin and running an apropriate query there (backup your stuff first in case anything goes wrong).

GauGau

thanks.
but could you please give me the examples above?
i'm still learning to use mysql...

thanks for your pacience!

[Joachim Müller]

• to delete all comments in the comments table:
  Code Select Expand
  TRUNCATE `cpg11d_comments`
  
• to delete all ratings (votes) from the votes table:
  Code Select Expand
  TRUNCATE `cpg11d_votes`
  
• to get rid of the votes count from all pics:
  Code Select Expand
  UPDATE `cpg11d_pictures` SET `pic_rating` = '0', `votes` = '0';
  
• to set the views counter to zero for all pics:
  Code Select Expand
  UPDATE `cpg11d_pictures` SET `hits` = '0'

[nova-bossa]

thank you!

the first three worked fine.
but for the last one:

• to set the views counter to zero for all pics:
  Code Select Expand
  UPDATE `cpg11d_pictures` SET `hit` = '0'

i got this error message:

"#1054 - Unknown column 'hit' in 'field list'"

[Joachim Müller]

sorry, must be "hits", not "hit" . I corrected my above posting as well, so others will not run into the same issue.

GauGau