i just put up my gallery with custom made theme and no images are shown on index/album/image pages, also nothing is in cache folder. on localhost everything is fine. i chmoded the folders to 777 and still nothing happens. im planning to release the theme to public and this is the last thing in the way... if it helps ask for the theme source or login for debugging. please help. thanks.

br ja@michalrusina.sk

oops, i forgot, the gallery is @ michalrusina.sk/galeria/ and the images have the right size but no image is there... i tested it also with the default theme and it is still not working...

when I go to 'view image' one of the images directly in my browser, I get the following error output that I'm guessing you'll want to check out

Quote:Zenphoto Error
MySQL Query ( SELECT id, watermark FROM zp_albums WHERE folder LIKE "flmch-v-chorvatsku" ) failed. Error: Unknown column 'watermark' in 'field list'

`

Backtrace:

in query (functions-db.php [119])

 in query_full_array (functions-basic.php [935])

   in getalbuminherited (functions-image.php [135])

     in cacheimage (_functions-image.php [12])

       in cacheimage_protected (i.php [192])

`

Sounds like you are using the nightly build or the SVN. Be sure you have uploaded ALL the files from the build and also run the setup program.

but i dont understand why is it working on localhost, i have the same files there...

The error you are getting is caused by not having the watermark field in the albums table of the database. That is a new field introduced in the development stream for album specific watermarks. The table entry gets created by setup when it is run.

If you think you have run setup and it did not create the field then run setup as follows: //zp-core/setup.php?debug. This will create a log of all the SQL queries setup does. The log can be viewed if you enable the filter-login filter. Then there will be a logs tab on the back-end. Go to it and view the setup log. Just about the last SQL log should be the entry that is supposed to create that field. If there is an error, it will be reported there.

thanks guys! for now i installed the latest stable release and its working. but will try the debug setup.

If you ever install directly from the SVN you [b]must[/b] run setup.php manually just in case some database changes have been made. Installing from the nightly, etc. will figure out if setup is needed, but the SVN does not do that.

Btw, I installed 1.2.6 stable and had a similar issue. Upon following the steps outlined here,
MySQL Query ( ALTER TABLE``zp_albums ADD COLUMN watermark varchar(256) ) Failed. Error: Too big column length for column 'watermark' (max = 255). Use BLOB instead

I'm running on 1&1 shared Linux hosting with the following setup:

Quote:# Zenphoto version 1.2.6 [4335] (Official Build)

Current gallery theme: default

PHP version: 5.2.10

Graphics support: PHP GD library bundled (2.0.34 compatible)

PHP memory limit: 96M (Note: Your server might allocate less!)

MySQL version: 4.0.27

I added the watermark column manually with a length of 255, everything works ok now.

Thanks, We will correct that SQL.