ZenphotoCMS Forum
Comments not visible after upgrade - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Comments not visible after upgrade (/thread-4869.html)

Pages: 1 2


Comments not visible after upgrade - Hansch - 2009-03-18

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?




Comments not visible after upgrade - sbillard - 2009-03-18

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




Comments not visible after upgrade - Hansch - 2009-03-19

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




Comments not visible after upgrade - acrylian - 2009-03-19

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




Comments not visible after upgrade - Hansch - 2009-03-19

I never used any antispam measures whatsoever.




Comments not visible after upgrade - sbillard - 2009-03-19

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.




Comments not visible after upgrade - Hansch - 2009-03-19

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.




Comments not visible after upgrade - sbillard - 2009-03-19

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.




Comments not visible after upgrade - Hansch - 2009-03-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).




Comments not visible after upgrade - sbillard - 2009-03-20

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.




Comments not visible after upgrade - Hansch - 2009-03-20

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

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




Comments not visible after upgrade - Hansch - 2009-03-21

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.




Comments not visible after upgrade - sbillard - 2009-03-21

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




Comments not visible after upgrade - Hansch - 2009-03-22

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/zp-core/functions.php on line 1769

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

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?




Comments not visible after upgrade - sbillard - 2009-03-22

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.




Comments not visible after upgrade - sbillard - 2009-03-22

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.




Comments not visible after upgrade - Hansch - 2009-03-22

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!




Comments not visible after upgrade - sbillard - 2009-03-22

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?




Comments not visible after upgrade - Hansch - 2009-03-23

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?




Comments not visible after upgrade - acrylian - 2009-03-23

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/