OK, I have spent the past 3-hours reading the posts here trying to figure my problem out with no luck...
I had a watermark on my photoserver for a while but had to turn it off for bit because of a special project. Now, I am trying to trun back on the watermark and go back through the photos that were uploaded while the watermark was turned off and I can't.
My server used GD2 and I have a watermark.png file. I have set the path to the PNG and when I upload new pics they get watermarked just fine.
When I use the database utility [Scan Database >> Check Here to Watermark unwatermarked files] nothing changes.
I went into the database as suggested in another thread and looked at the field with my photos. The cell for "watermarked is NULL for all of my photos
I looked at the database structure and the default is supposed to be "no"
1. Can someone confirm if the 'no' becomes '' if the system thinks the image is watermarked?
2. Can someone confirm that if I change all the values to "no" that the watermark script is likely to work?
3. Anybody good with MySql that can give me a quick script to update all the photos? I am using the same watermark image so it will rewatermark over the existing image...
I have a problem with images being used off my site all over the place and I want to at least get some return trafic for the bandwith I am paying to supply! Edit for Cliff Notes to Solution:
The problem I had was caused by the server NOT having write permssion for the image file! The server would get a "No Permissions" message but the $watermarked variable was NEVER getting defined elsewhere so the value of the variable was NULL. When the database updated, the "no" became "null". With the value being NULL, the script would never try to watermark the images again (it wanted to see "no") and I would see the "done" message even though the images were not changed!
More detail is in this thread!