PDA

View Full Version : Does anyone know how to reset the watermark table in the database?


teodorbjerrang
October 31st, 2004, 07:23 AM
I guess there is a table in the database saying if a picture has been applied a watermark or not. I need to reset this one to “NO” on all images. Does anyone have a step by step guide on how to do this?

Chuck S
October 31st, 2004, 07:48 AM
There is no watermark table.

Resetting the watermark field would cause images to be rewatermarked again causing a double image on images where it is already applied

Here is a query you can run in phpmyadmin just put your table prefix on there

UPDATE photos SET watermarked='no'

teodorbjerrang
October 31st, 2004, 08:38 AM
ok :-)

I'm not so familiar with PHP .. Where do I find "phpmyadmin"?

About double watermarking.
I have taken a backup of the data directory without the watermarks. I want to copy that back and do a new watermark on all the photos.
I guess that will work ok?

Chuck S
October 31st, 2004, 08:51 AM
well in your control panel for your site do you have a database administrator/viewer this is where you would enter that query

teodorbjerrang
November 1st, 2004, 02:24 AM
hmm... I only have these options under Database

Scan Database
Purge Old Photos

Whats the filename for this database viewer?

Chuck S
November 1st, 2004, 07:01 AM
database administrator/viewer = phpmyadmin

THIS HAS NOTHING TO DO WITH PHOTOPOST !! I asked in your CONTROL PANEL of your site do you have a mysql administration section as you did not know what phpmyadmin was.