Home› General support

no images in folder cache

mikinoo Member
in General support
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

Comments

  • mikinoo Member
    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...
  • ZeBoxx Member
    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 :)

    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])

    `

  • sbillard Member
    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.
  • mikinoo Member
    but i dont understand why is it working on localhost, i have the same files there...
  • sbillard Member
    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: <host>/<zenphoto folder>/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.
  • mikinoo Member
    thanks guys! for now i installed the latest stable release and its working. but will try the debug setup.
  • sbillard Member
    If you ever install directly from the SVN you must 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.
  • Skee Member
    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:
    # 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.
  • sbillard Member
    Thanks, We will correct that SQL.
Sign In or Register to comment.