firstimagelink

kimisgold

I was looking at the documentation for printAlbumMenu and while it talks about the `$firstImagelink` variable, I don't see it anywhere in the plugin. It doesn't work when I set it to "true" either. Can anyone help me with this?

fretzl

Did you enable the plugin ?
Also have a look at zp-extensions -> print_album_menu.php.
That's where the function `printAlbumMenu()` comes from.
The file is very well commented.

kimisgold

I realized that the plugin was old, as my copy of print_album_menu.php didn't have it. Now I'm having database issues in trying to upgrade ...

`MySQL Query ( SELECT * FROM`zenp_administrators`WHERE`valid`= '1' ) failed. MySQL returned the error Unknown column 'valid' in 'where clause'`

I ran upgrade.php as well, but the same error comes up.

kimisgold

I dropped zenp_administrators and it worked.

sbillard

If anyone else has this problem, please run .../zp-core/setup.php?debug which will create a setup log of the SQL statements of the upgrade. Apparently the one which adds the `valid` field to the database is failing. We will need this log to understand why that happens.

9toes

I am having that error and here are the contents of the log file:

Zenphoto Setup v1.3[5479] Tue, 15 Jun 2010 15:54:55 -0500
Full environment
pass: PHP version 5.2.12
pass: PHP `Safe Mode`
pass: PHP `magic_quotes_gpc`
pass: Graphics support: `PHP GD library bundled (2.0.34 compatible)`
pass: PHP `gettext()` support
pass: PHP `mbstring` package
pass: PHP `MySQL support`
pass: zp-config.php file
pass: File/Folder Permissions [are strict (`0755`)] <p>If file and folder permissions are not set to strict or tighter there could be a security risk. However, on some servers Zenphoto does not function correctly with tight file/folder permissions. If Zenphoto has permission errors, run setup again and select a more relaxed permission.</p><p>You must be logged in to change permissions.</p>
pass: MySQL setup in zp-config.php
pass: MySQL version 5.0.89
pass: Connect to the database
pass: MySQL `SQL mode`
pass: MySQL `access rights`
pass: MySQL show tables found: `administrators`, `admintoalbum`, `albums`, `captcha`, `comments`, `images`, `obj_to_tag`, `options`, `tags`
warn: MySQL `$conf["UTF-8"]` [is not set true] You should consider porting your data to UTF-8 and changing the collation of the database fields to `utf8_unicode_ci` and setting this true. Zenphoto works best with pure UTF-8 encodings.
pass: Zenphoto core files
pass: .htaccess file (RewriteEngine is ON)
pass: .htaccess RewriteBase is `/zenphoto`
pass: robots.txt file [Not created] <p>Setup did not create a robots.txt file because one already exists.</p>
pass: albums folder
pass: cache folder
pass: locale folders
pass: uploaded folder
pass: zp-data folder
pass: HTML cache folder (cache_html)
pass: Third party plugins folder (plugins)

sbillard

This is the log of just the beginning of setup--no SQL statements have been executed. So has the error occurred at this point?

9toes

Yes it has. I also get the following warning at the setup summary screen before that:

You should consider porting your data to UTF-8 and changing the collation of the database fields to utf8_unicode_ci and setting this true. Zenphoto works best with pure UTF-8 encodings.

sbillard

What version of zenphoto were you upgrading from?

9toes

I believe it was 1.2.5, perhaps 1.2.5 RC2

sbillard

Thanks. I have found the problem. For any one else with this problem, you must either not skip so many releases or install with the nightly build. The 1.3.0 release became dependend on a change to the database introduced with the user=groups plugin that was introduced in the 1.2.6 release. We do not test upgrades from that far back, so missed the dependency.

9toes

If I understand correctly, installing the nightly should take care of it?

9toes

Please, disregard the question. I tried it and that seems to have fixed things. Thank you so much

cheboygan

Just a quick FYI, I just finished upgrading from version 1.2.4 [3716] -- and I ran into the same problem. Installed the nightly build 1.3 [5577] just now and it works fine. Looking forward to the next incremental release so that I be on an official build.

sbillard

If you would rather be running one of the "official" releases, just reinstall v1.3.0 now. The problem was "permanantly" fixed when you installed the nightly, so reverting will still work.