coppermine-gallery.com/forum

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

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

Quote from: GauGau on May 09, 2004, 06:41:58 PM
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!

• 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'

thank you!

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

Quote from: GauGau on May 09, 2004, 11:42:03 PM

• 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'"

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

GauGau