manual set of counter

[empfl]

hello,

i had to upload a file oncemore after i have deleted it.

now my question, how can i set the counte rmanually to f. example to 199

[Joachim Müller]

Why did you delete it in the first place?
Anyway: there's no method built into the coppermine user interface to set the counter to a specific value. You'll need to manipulate the database directly, using a tool like phpMyAdmin. I'm pretty sure that this has been discussed in detail already, so please use the search.

[empfl]

Thx GauGau,

i've used the search, i searched von manual counter set.
i've nothing, really, even perhaps i gave up to soon ;-)
sorry

[Joachim Müller]

Something like

Code Select Expand

UPDATE `CPG_pictures` SET `hits` = '199' WHERE `pid` =1234 LIMIT 1 ;should do the trick, where "1234" in the example is the ID of the pic and "CPG" is the table prefix you chose during install. Not recommended for total newbies.