little problem with the zWatermark Addon v0.50β / but solved!

[Clemens]

hope someone will be interested of my little experience ...

when i did install the zWatermark Addon first it didn't want work. Everythink did look good: the plugin was installed, the watermark image was uploaded and the plugin says that it's ready to watermark new images!

but when i did try to upload a new image, there came an "echo" from the script resp. the database: "Updating table pixelpost failed! Error: Unknown column 'zw_id' in 'field list'"

first i did not understand. but when i did read this message once again, i found out that there was already written the reason respectively the solution of the problem!

The reason was, that the circumstance that there is in my database no more a table called pixelpost! my very own pixelpost-tables did get an extra prefix (xyz_ pixelpost) and in this case the installing resp. the altering of just this one meant table couldn't be done the right way! the script did have has looked for a table named "pixelpost", but that wasn't there!

I do wonder a little why the script didn't gave an error-message after installing itself. cause it wasn't able to work really!

At last i did solve the problem by adding the 5 necessary columns into the table xyz_pixelpost by hand! And so the Addon does work well right now!

in this case i do think, there is a little lack in the concept of the plugin, resp. the admin_zwatermark.php.

But - it is a "beta", i know. ;-)

Hope i've should have given a little help and will say thanks at all for this pretty work!

[Dennis+]

Hi.. yeah, this is why we all use the variable $pixelpost_dbprefix in our addons, which is pulled from the database.

The addon obviously assumes you use the standard prefix "pixelpost_" for your tables and that is hardcoded in the addon.

Changes are very simple and then everybody will be happy.

[Clemens]

thanks Dennis for this clear statement!
Im sorry that i didn't decide before about this comprehensible precondition.
But there are often some different and possibly unexpecting occurrences in life.
i did install two Pixelpost-Blogs indeed and when i own only one single database, i have had to add an special prefix for one of them. And this i wouldn't change subsequently, sorry. ;-) nevertheless i think, a plugin-script may be necessary written to manage these not so special kind of eventualitys easyly.

[Dennis+]

Well the prefix is actually stored in the configfile and accessible for all addons just for this purpose. Chances are the author of the addon was unaware of this setting, otherwise he/she would have used it. Even I made that mistake a couple of times because I copied some SQL from my testingblog. If you move on to quickly it is likely that these little things just slip by.

IMHO there is no need for a plugin-script to handle this as this can be perfectly handled by using the stated variable.