Frog CMS - Comment Plugin Admin Error

Comment Plugin Admin Error

15 posts, 6 voices

May 11, 2009 07:38 vh 18 posts	There seems to be an issue with my comment plugin, as every time I try to click the “comment” tab on the admin side I get this error: Fatal error: Call to a member function execute() on a non-object in /var/www/html/frog/plugins/comment/Comment.php on line 64 I’m using frog 0.9.5 RC2. Would upgrading to the stable version fix this problem?

May 12, 2009 08:43 vh 18 posts	I played with this a little more and it’s only the moderation feature that is giving the error. If I access the comment settings via the administration tab I can get to the documentation and settings just fine. I changed my settings to auto approve so I can receive comments on my blog, but I still can’t moderate (obviously!). Thought this might be helpful!

May 21, 2009 05:44 vh 18 posts	No one is having a similar problem or has any advice on this issue?

May 21, 2009 07:26 Valeska 20 posts	I’m afraid I can’t help, but I just wanted to start that I am having problems with the comment moderation feature too, when I try to upgrade from 0.9.4 to 0.9.5 stable. This is preventing me from upgrading at the moment.

Jun 11, 2009 06:32 vh 18 posts	After comparing the 0.9.5 RC2 comment plugin to the 0.9.5 stable comment plugin, I noticed there was a significant change in the two (at least in the Comment.php file). I replaced my RC2 comment plugin directory with the stable version’s, updated my layout to have the new comment field code and problem solved! Probably not the best fix since I didn’t do a full upgrade to the stable version, but I hope this helps anyone else who was having the same problem.

Jun 11, 2009 06:54 David 1493 posts	I don’t know if all these complaints are occasioned by the same issue, but do have a look here for a problem identified and solved. I wonder if this is what vh’s solution worked around…

Jun 11, 2009 08:14 vh 18 posts	I saw that one David, which helped because the .zip of the newest version of Frog I downloaded had the old comment plugin read me file with Plugins instead of Plugin in that code snippet. But I don’t think it’s the same issue because the old RC2 comment code snippet was slightly different. I also wasn’t having a problem getting the comment form to show up on actual front end pages either, it was all a back end issue where the moderation page threw an error instead of displaying at all. Then again I’m not an expert and there may be some tie somewhere :)

Jun 25, 2009 04:49 skye 18 posts	I have a similar issue. When I try to access the comments or moderation pages in the administration I get: Fatal error: Call to a member function fetchColumn() on a non-object in /path/frog/plugins/comment/views/index.php on line 51 Using 0.9.5 stable

Jun 26, 2009 05:56 Valeska 20 posts	Skye I am having the exact same issue (I detailed it here), but no one seems to know why or how to fix it. Are you upgrading or is this a fresh install?

Jun 26, 2009 07:51 skye 18 posts	Fresh install here. I tried reinstalling and it’s the same. If others don’t have this issue, then I’m guessing it has something to do with the server configuration. I’m running on apache 2.0.63, PHP 5.2.8 and mysql 4.1.22.

Jun 26, 2009 08:07 David 1493 posts	I’m running on apache 2.0.63, PHP 5.2.8 and mysql 4.1.22. This is another one that I am unable to replicate, but it is interesting to see this environment. Could others who have experienced this problem post here the version of mySQL being used? Thanks!

Jun 26, 2009 08:18 Valeska 20 posts	Thanks David, I am using MySQL – 5.0.51a (MySQL client version: 4.1.22) I did another fresh install and imported my db information and the problem fixed itself (but uncovered some more plugin related problems). But I still can’t get this to work for my main two installations.

Jun 30, 2009 00:46 Valeska 20 posts	Skye, I managed to fix this yesterday: I compared the config file from my fresh install and my old install, the only difference was the PDO setting – when I changed it to true my comments plugin worked. I hope this helps someone else it’s been driving me mad.

Jul 1, 2009 02:14 skye 18 posts	Well, my host doesn’t support pdo. I’ve been talking to my provider and he’ll install it later today so I can test it.

Jul 3, 2009 01:55 GagaPeter 13 posts	One possibility to fix it is to change `$stmt = $__FROG_CONN__->query($sql);` to `$stmt = $__FROG_CONN__->prepare($sql); $stmt->execute();` in file /frog/plugins/comment/views/index.php. This Bug seems to be caused that sometimes (or in every 0.9.5 installation) the query method returns an array with the query data and not an DoLiteStatement object.

Jul 14, 2009 13:42 Pac 1 posts	One possibility to fix it is to change $stmt = $__FROG_CONN__->query($sql); to $stmt = $__FROG_CONN__->prepare($sql); $stmt->execute(); in file /frog/plugins/comment/views/index.php. This Bug seems to be caused that sometimes (or in every 0.9.5 installation) the query method returns an array with the query data and not an DoLiteStatement object. Also, make the same change in /frog/plugins/comment/views/moderation.php. This fixed the problems I was having with the comments plugin.