Comments not visible after upgrade

Member

Hansch 18-03-2009, 00:59

After an upgrade to the latest version 1.2.3 (from I think 1.1) all comments are still there in the admin section but they are not shown with the images. Is there a way to repair this?

Member

sbillard 18-03-2009, 03:13

What theme are you using? Is the allow comments option set?

Member

Hansch 19-03-2009, 18:24

I have tried different themes, but this makes no difference.

Current theme is default.

Image: http://tweakers.net/ext/i.dsp?FotoAlbumID=150743&format=full&ext=.jpg

Strangely enough, there are no checkboxes next to some of the comments options.

Under the pictures, there are no comments (in the admin section, under this picture there is, but not in the public part of the site):

http://tweakers.net/ext/i.dsp?FotoAlbumID=150751&format=full&ext=.jpg

Administrator

acrylian 19-03-2009, 19:23

The image links are not accessible (forbidden). Do you have any spam filters enabled? If you use Akisment that is apparently broken as is Mollom. Please read: http://www.zenphoto.org/support/topic.php?id=5083#post-29706

Member

Hansch 19-03-2009, 20:13

I never used any antispam measures whatsoever.

Member

sbillard 19-03-2009, 21:04

Probably then the allow comments option is not selected. But if you have no checkbox next to it you have a more serious problem. Please review your CGI logs to see what errors are being generated.

Member

Hansch 19-03-2009, 21:12

hmmmm... cgi? I do not know where to find those logs but when I searched files with that name (I have shell access, Debian Lenny) I saw php 4 and cgi (my former php version) but not php5. So I did: apt-get install php5-cgi, which installed a package. I will keep you informed.

After this, I tried to add a comment. Result:

Fatal error: Call to undefined function fetchComments() in /var/www/wordpress/zenphoto/zp-core/functions.php on line 971

I find this thread when searching that error:
http://www.zenphoto.org/support/topic.php?id=4859

I disabled notifications and new posted comments are now visible but not the old ones. The call to undefined function error is not showing any more.

Seems like I have to rename a table in the db to get the old comments back?

It says:

Same problem with the last nightly (Version de Zenphoto 1.2.3 [3445] (Version officielle))

I update directly in the database the 'type': images -> _images
images (old comments)
_images (recent comment)

But I guess only old messages will be shown.

Member

sbillard 19-03-2009, 21:40

That error had to do with e-mailing comments, so disabling notification would fix it. (It has been corrected in the nightly builds.) Also the problem with old comments not showing up is fixed, so your best bet is to install the nightly build.

Member

Hansch 20-03-2009, 09:20

Downloaded the latest nightly. Done running upgrade.php (several tables updated).

Still no sign of "old" comments.

How can they show up in the admin section but not with the images? The new comments are there with the images. Surely both scripts get their data from the same table in the database?

Enabling comment notifications still produces
Fatal error: Call to undefined function fetchComments() in /var/www/wordpress/zenphoto/zp-core/functions.php on line 971

Interestingly, new comments have the originating IP address in the Admin section shown.

Something else: rss-comments.php shows all comments (old and new).

Member

sbillard 20-03-2009, 17:13

#10

If you are still geting this error you have not sucessfully installed the nightly build. Remove all the files in the zp-core.php folder and re-upload from the nightly build archive.

Member

Hansch 20-03-2009, 22:16

#11

When I unzip, files are overwritten. There are no files used by the nightly build which are not overwritten. But Ok, I will try it.

What I did:

Rename zp-core
Unzip the nightly build
Copy back zp-config.php
Ran upgrade.php

Now, I get several errors and most of the images are not displayed (though comments are!):

Notice: Undefined index: album_folder in /var/www/wordpress/zenphoto/zp-core/functions-basic.php on line 642

Warning: Cannot modify header information - headers already sent by (output started at /var/www/wordpress/zenphoto/zp-core/functions-basic.php:642) in /var/www/wordpress/zenphoto/index.php on line 25

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/wordpress/zenphoto/zp-core/functions-basic.php:642) in /var/www/wordpress/zenphoto/zp-core/admin-functions.php on line 9

Warning: Cannot modify header information - headers already sent by (output started at /var/www/wordpress/zenphoto/zp-core/functions-basic.php:642) in /var/www/wordpress/zenphoto/index.php on line 113

Member

Hansch 21-03-2009, 08:32

#12

So I'm back at the release.

Rename zp-core
Unzip the offical build
Copy back zp-config.php
Ran upgrade.php

Everything works normally, except old comments.

Member

sbillard 21-03-2009, 17:17

#13

Strange error above (the first one.) Can you tell me exactly where in the process it occurred? It is an indication that one of the basic arrays of Zenphoto is not setup. It should have been setup in zp-config.php.

Did the setup program run on the new install?

Anyway, your work-around would be to change the type field of the old comments to match the same field in the new comments. (But, of course, that should not be required!)

Member

Hansch 22-03-2009, 10:27

#14

The setup ran.

Well, I tried it again:

Rename zp-core
Unzip the nightly build (of 19/3)
Copy back zp-config.php
Set all permissions (chown -R www-data zenphoto)
Ran setup.php

I get:

Zenphoto has detected that you're upgrading to a new version.

Systems Check:

PHP version 5.2.6-1+lenny2
PHP Safe Mode
PHP magic_quotes_gpc
Grapics support PHP GD library
PHP gettext() support
PHP mbstring package
PHP MySQL support
zp-config.php file
Strict Permissions [is not in effect]
Warning!
When this option is not in effect, file and folder permissions are relaxed. This could constitute a security risk so it is recommended that you enable Strict Permissions. However, on some servers Zenphoto does not function correctly with strict file/folder permissions. If you enable this option and Zenphoto has permission errors, run setup again and disable the option.

Click here to use strict file/folder permissions.

NOTE: This option applies only to new files and folders created by Zenphoto. You may have to change permissions on existing ones to resolve problems.

MySQL setup in zp-config.php
connect to MySQL
MySQL version 5.0.51a
connect to the database wordpress
SQL mode
MySQL access rights
MySQL show tables found: zenphotoadministrators, zenphotoadmintoalbum, zenphotoalbums, zenphotocaptcha, zenphotocomments, zenphotoimages, zenphotoobj_to_tag, zenphotooptions, zenphototags
Zenphoto core files
.htaccess file (RewriteEngine is ON)
.htaccess RewriteBase is /zenphoto
Notice: Undefined index: album_folder in /var/www/wordpress/zenphoto/zp-core/setup.php on line 990

albums folder (zenphoto)
cache folder
locale folders
Database tables to update: zenphotooptions, zenphotoalbums, zenphotoimages, zenphotocomments, zenphotoadministrators, zenphotoadmintoalbum, zenphototags, zenphotoobj_to_tag, zenphotocaptcha.

Running setup

After that, I get an error:

Notice: Undefined index: album_folder in /var/www/wordpress/zenphoto/zp-core/functions-basic.php on line 642

I tried to run upgrade.php

About to update tables...

Notice: Undefined index: album_folder in /var/www/wordpress/zenphoto/zp-core/functions-basic.php on line 642

Done with table update

When viewing the gallery I get the aforementioned errors:

Notice: Undefined index: album_folder in /var/www/wordpress/zenphoto/zp-core/functions-basic.php on line 642

Warning: Cannot modify header information - headers already sent by (output started at /var/www/wordpress/zenphoto/zp-core/functions-basic.php:642) in /var/www/wordpress/zenphoto/index.php on line 25

Warning: Cannot modify header information - headers already sent by (output started at /var/www/wordpress/zenphoto/zp-core/functions-basic.php:642) in /var/www/wordpress/zenphoto/index.php on line 114

To me, the basic functions of the album are more important than the comments but I still would like to have them back..... ;(

I have reset everything to the release.

By the way: unfortunately, I know nothing about php, but I do not understand why it is so difficult to display comments with the images.

As my simple uneducated logic says, the php script fetches data (comments) from the database. It does so on the rss page and the admin page, and on the album page as well. Would it be difficult to have the script on the album page get the same info from the db as the admin page?

Member

sbillard 22-03-2009, 17:51

#15

I suspect that your zp-config.php file is not based on the current release. Can you post the content of your file? Of course, obscure the User code/password information.

You are correct in that it is pretty simple to fetch the comments. The devil is in the details. Comments can be made on a number of different items, so the fetch code has to take this into account. You would not want album comments show on an image, would you.

The problem with the old comments is a bug in what the code is looking for. As I mention above, the work-a-round will get you back the old comments.

Member

sbillard 22-03-2009, 18:07

#16

I noticed another anomoly in the setup listing above. It is saying that your album folder is named 'zenphoto' which is also your install base folder. That is not a likely situation.

Member

Hansch 22-03-2009, 20:13

#17

Didn't know that I could not use the zp-config.php from the old installation (thought it would be updated). Followed an upgrade guide which mentioned I could use the old zp-config.php.

And... well, if I change anything in the folder names some things won't be working (e.g. links to the images from my main, Wordpress site).

Started with the nightly zp-config.php (renamed the zp-config.php.source but I had to copy it back because the setup did not like the fact that I had renamed it).

Now it works perfectly. Thanks for all the help!

Member

sbillard 22-03-2009, 20:44

#18

Well, the old zp-copnfig.php should have worked. Guess we have a migration bug to deal with. Anyway, glad it is working for you now. Just out of curiosity, do you know what version zenphoto you were using when the zp-config.php file was created?

Member

Hansch 23-03-2009, 09:20

#19

Judging from the dates of files, I'd say I installed Zenphoto in may 2006 and upgraded in june 2006 to the then-current version.

How can I find out the version of Zenphoto? Is it only in the db or also in some file?

Administrator

acrylian 23-03-2009, 10:11

#20

The version number of your current install is printed on the admin overview and in the footer. According to our changelog archive in May 2006 it was probably 1.0.3 beta. http://www.zenphoto.org/2006/05/version-103-beta/