View Full Version : Does anyone know how to reset the watermark table in the database?
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?
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'
October 31st, 2004, 08:38 AM
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?
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
November 1st, 2004, 02:24 AM
hmm... I only have these options under Database
Purge Old Photos
Whats the filename for this database viewer?
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.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.