EzComments Upgrade error :: Zikula Community :: Support at your fingertips

Get Zikula 1.3.3!New core, modules & more

Quick Links

Donate Today!Support your Software

Documentationlearn, share & develop

Watch

GitHub Core

Show your support for Zikula! Sign up at Github account and watch the Core project!

GitHub Modules

Forum Activity

internetking created topic »password problem« 25. May
mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 25. May
mazdev responded to »Pages 2.5.0 and updating - Page not found« 25. May
ehdwma created topic »Hide "Register new account" and change template to 3 col« 25. May
mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 25. May
mdee created topic »How to implement returnpage ?« 25. May
nestormateo responded to »Fillters in Clip« 24. May

» Visit forum | » View latest posts

Zikula Blog

Anatomy of Open Source Projects on Mar 07
Continuous Review on Mar 01
Not Invented Here on Feb 24
How to Contribute Your Code at Github on Jan 13
10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
Submitting Bug Report Tickets That Get Results on Aug 17
Cozi Tricks #1: Syntax Highlighting on Aug 07

EzComments Upgrade error

Print topic

Go to page 1 - 2 [+1]:

JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 27, 2006 - 12:45 PM

I've been trying to upgrade the EZComments module from .02 to 1.3 RC2 on postnuke 0.7.6.2, after i regenerate the modules and hit Upgrade I receive the following error message:

Quote
Table update failed: Duplicate column name 'anonname'

I checked the nuke_ezcomments table and only see 1 anonname field in the structure.
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 27, 2006 - 08:13 PM

EZComments 0.2 didn't have an anonname field so not sure how that got there. Either you've got a previously attempted failed upgrade or possibly you've added some own fields for your own use.

Anyway restore the EZComments table back to is v0.2 state from your database backup and re-run the upgrade procedure.

-Mark

--
Visit My homepage and Zikula themes .
JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 28, 2006 - 08:51 AM

ThankYou Mark,

After reading your response, i remembered that i had a failed upgrade (see below error message) of EZComments last month and have been using .02 files with the 1.3 DB.

I was able to upgrade but my site doesn't work after i enable EZComments in pnFlashGames (version 1.5), the following error message appears below my center block (no left or right blocks):

Quote
Error! Called unknown function: EZComments_adminapi_countitems()
modname => pnFlashGames
objectid => contid-1
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 28, 2006 - 09:38 AM

Something is calling an incorrect API - countitems is a user API not an admin one. As to what I don't know - only you know what's installed on your site. It could be pnflashgames or any of the blocks you have active.

-Mark

--
Visit My homepage and Zikula themes .
JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 28, 2006 - 10:56 AM

Sorry, I'm not very good at understanding this, wondering if there is a way i can troubleshoot this error..

I found this post at pnflashgames.com but i'm not certain if it relates to my errors, wondering if it makes any sense.

http://www.pnflashga…p?DiscussionID=4166

Quote
Don't know if your users are like mine but here they post quite a lot of comments in the games (in fact pnFlashGames is the only website module where users post regulary comments )
So I missed pagination in EZ-Comments and I modified it to add a pnRender Pager (well more exactly a Smarty pager, EZ-Commenst is templated). You need to modify 3 files (pnuserapi.php pnuser.php and the default.htm template) But beware, you need a RECENT pnuserapi.php (I took mine from CVS) because the mod need the EZComments_userapi_count function and this function isn't in the released version.
To know details of the mod Go here
If it bother you to edit the file, I can provide complete EZ-Comments from CVS with Leason modifs and mine and as an added bonus the ability to change # of comments per page in the module administration

Jon

edited by: JonPurpleHaze, Jun 28, 2006 - 11:03 PM
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 28, 2006 - 11:11 AM

Sorry but I can't really help that much. It seems like pnFlashgames or some related code is talking directly to the EZComments module which is really has no need to do - all a module needs is one line in the code pnModCallHooks. As a quick work-around - until you work out the root cause - you could re-implement the API that's being called.

Open pnadminapi.php and add the following code at the end of the file (just before the closing PHP tag)

Code
function ezcomments_adminapi_countitems($args)
{
return pnModAPIFunc('EZComments', 'user', 'count', $args);
}

This code creates the missing API simply passing the information to the correct location. I'd raise this issue with Lee (pnFlashGames's author) since there's something not quite right here.

-Mark

--
Visit My homepage and Zikula themes .
JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 28, 2006 - 01:26 PM

Thanks again Mark,

I'll go ahead and post about the problem @ PnFlashGames.com, the only time i receive errors now is if i update the EzComment Files from .02 to 1.3.

I added your code on the EZComments pnadminapi.php file and was able to activate EZComments on pnFlashGames so i made it a step further! Now when i click on a game category i receive the error message listed below but the pnFlashGames home page and individual Game links work fine.

Quote
Error! Called unknown function: EZComments_userapi_count()
modname => pnFlashGames
objectid => 16

Jon
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 28, 2006 - 08:16 PM

Sorry typo on my part - take a look at the code I posted and it should be obvious... 'count' vs 'countitems' in the user API call.

-Mark

--
Visit My homepage and Zikula themes .
JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 29, 2006 - 03:43 PM

Thanks Again,
I added the following to the EZComments pnadminapi.php file and it fixed the Game category problems as described above!

Code
function ezcomments_adminapi_countitems($args)
{
return pnModAPIFunc('EZComments', 'user', 'countitems', $args);
}

Everything seems to work with pnFlashGames except all of the games have the same number of comments listed, ie:137 Comments.

I discoverd another problem with my EZComments upgrade, sitewide, the bbcode (version:1.20) and smilies (version:1.16) below the EZComments input box are gone.

If it helps, none of these errors appear when i use .02's files with 1.3 RC2's DB.

Jon

edited by: JonPurpleHaze, Jun 30, 2006 - 03:58 AM
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 29, 2006 - 08:18 PM

An EZComments upgade won't affect other non EZComments related section of the site.

The comment count logic has changed in this EZComments relase - again it sounds like pnflashgames is using some custom code to get the comment. Please refer this one to the pnflashgames site.

For bbcode etc. make sure your running the most recent releases of these and that the bbcode etc. hooks are enabled for the EZComments module. Earlier releases of EZComments incorrectly took the hooks settings from the top level module (e.g. pnFlashgames, News etc.) rather than EZComments itself.

Lastly you really should be doing all of this on a test site - don't touch your live site until your happy the test upgrade has been successful.

-Mark

--
Visit My homepage and Zikula themes .
JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 29, 2006 - 09:30 PM

Thanks again Mark,
It looks like pnflashgames.com is dead but i still don't understand why my smilies and bbcode disappears after upgrading EZComments...
I mentioned my versions of these hooks and have them configured properly, they disappear the second i replace 0.2 files with the new ones?
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 29, 2006 - 09:34 PM

Double check the configuration. As I indicated a hooks handling bug was fixed in the newer version meaning a configuration that worked under .2 might not be correct for 1.3. Check that the bbcode and smilie hooks are activated for the EZComments module.

Are you using your own custom templates? If so then there's been template changes between versions. Not all the standard templates sets show all interface elements either so check that which template set your using in the module configuration.

Apart from that i'm out of ideas without being able to see the problem first hand.

-Mark

--
Visit My homepage and Zikula themes .
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Jun 30, 2006 - 12:18 PM

Hello,
The problem is that pnFlashGames is trying to display the number of comments for each game.
The right way to do that would be to use a pnRender plugin (as Pagesetter is doing it) but unfortunately pnFlashGames is not templated wich is a very sad thing
Even worst the code pnFlashgames uses to call the EZComments API is very outdated and doesn't work anymore with the current EZComments release.
So the best thing to do is to fix pnFlashGames to use the correct call !
Edit modules/pnFlashGames/pnuser.php and change:

Code
if ($ezcomments && pnModAPILoad('EZComments', 'admin')) {
$numComments = pnModAPIFunc('EZComments',
'admin',
'countitems',
array('modname' => 'pnFlashGames',
'objectid' => $item['id']));

to:

Code
if ($ezcomments) {
$numComments = pnModAPIFunc('EZComments',
'user',
'countitems',
array('mod' => 'pnFlashGames',
'objectid' => $item['id'],
'status' => 0));

You will have to do the same change in 2 different places of the same file.
Doing that you don't need to modify the EZComments module.

--
Visit my live reef aquarium.

My Amazon wish list.
JonPurpleHaze

Rank: Registered User

Registered: Mar 03, 2003

Last visit: Oct 21, 2009

Posts: 16
Posted: Jun 30, 2006 - 04:02 PM

You guys are awesome, All of my problems are gone!
I switched templates from the AllOnOne template to the pnForum one and my bbcode and smilies reappeared.

Per jmvedrine's instructions, I uploaded the original EZComments pnadminapi.php file after making the changes to the modules/pnFlashGames/pnuser.php file.

Quote
You will have to do the same change in 2 different places of the same file.

In case anyone else runs into these problems, The second instance was replaced with:

Code
if ($ezcomments) {
$numComments = pnModAPIFunc('EZComments',
'user',
'countitems',
array('mod' => 'pnFlashGames',
'objectid' => 'contid-'.$contest['contid'],
'status' => 0));

I kept receiving some errors until i realized that i needed to do the same thing with a pnFlashGames Contest Block, i edited the contests.php file in modules/pnFlashGames/pnblocks.

The correct # of comments are now showing up properly, Thank You!
Jon

edited by: JonPurpleHaze, Jul 01, 2006 - 04:14 AM
markwest

Rank: Team Member

Registered: Mar 18, 2002

Last visit: Oct 21, 2009

Posts: 6606
Posted: Jun 30, 2006 - 08:45 PM

Cool - we got to the bottom of it in the end. Thanks to JM for taking a look at pnFlashgames.

With regard to the template sets and things like bbcode not being in all of theme - this is by design. If all of the template sets looked the same then there would be no point having the different designs... Don't forget you can also design your own look and feel to the commenting pages too - for example our comments pages here at postnuke.com.

-Mark

--
Visit My homepage and Zikula themes .