Jump to content
TNG Community
bushtroll

Comments mod

Recommended Posts

bushtroll

Can anyone help, when I install the Comments mod to my site (tng v12.1) all of my person pages dissapear, that is when I try to view any persons page allI see is their name and the rest of the page is just blank.

Share this post


Link to post
Share on other sites
Brett

What Template are you using?

What other Mods are installed?

What version of PHP is running?

Brett

Share this post


Link to post
Share on other sites
bushtroll

I am using Template 15 and PHP 7.3, I have about 20 other mods running but not the Cemeteries Edit mod.

Share this post


Link to post
Share on other sites
Brett

Are you able to change your PHP version to an earlier version and see the result?

Share this post


Link to post
Share on other sites
bushtroll

It appears it is PHP 7.2.7 and my ISP will not let me change to any other version, so it looks like I will have to live without comments, thanks anyway.

Share this post


Link to post
Share on other sites
Ken Roy

Do you have access to the PHP error log?  A Blank Page normally indicates a syntax error or in this case it could be a PHP fatal error.  Without knowing what the error is, it will be difficult for someone to fix the Comments mod.

Share this post


Link to post
Share on other sites
omalleyashe

Trying to resolve the same issue as stated by OP.

Here is the error I receive after trying to update the tables:

___________________________________________________________________________________

Reports:

Attempting to alter tables...   An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.

Query: ALTER TABLE tng_comments ADD commentsApproved tinyint(4) NOT NULL AFTER commentsID;

Duplicate column name 'commentsApproved'

________________________________________________________________________________________

Installs okay, but when trying to update tables as required I get the above error and everything on personal pages has disappeared after the header of profile pic and name / age, i.e nothing shows including and below this menu bar:

image.png 

TNG v.12.2 template 15 as well, tried other templates and same. 

Was PHP 5.6, tried 5.5 and same

Mods here:

Mod Name  tng_sort_desc.gif Config File Name  tng_sort_asc.gif Version
Wiki
Status Files
1. Comments
comments_v12.0.1.2.cfg
12.0.1.2
wiki16.png
Installed [Options]   Requires database updates
tng_more.gif
2. Count Ancestors Descendants
count_ancestors_descendants_mod_v10.1.1.3e.cfg
10.1.1.3e
wiki16.png
Installed [Options]
tng_more.gif
3. FGWTabs
fgw_tabs_v11.0.0.9.cfg
11.0.0.9
wiki16.png
Installed [Options]
tng_more.gif
4. Forum for TNG
forum_for_tng_mod_v11.0.1.5.cfg
11.0.1.5
wiki16.png
Installed [Options]
tng_more.gif
5. Simple SEO
simple_seo_v12.0.3.6a.cfg
12.0.3.6a
wiki16.png
Installed [Options]
  • code modifications specified: 24; modified: 24
  • file copies specified: 13; copied: 13
  • new files specified: 0; created: 0
  • new folders specified: 0; created: 0
  • errors: 0

Much thanks for any ideas, not a coder but can follow instructions well. :) 

Share this post


Link to post
Share on other sites
manofmull

I remember this occurred with someone else in the past two years or so.

From memory it was resolved by the ISP of that person (SimplyHosting?)

Worth asking I guess.

 

M

Share this post


Link to post
Share on other sites
omalleyashe

Interesting. Simplyhosting is also my host. Thanks for that lead.

Share this post


Link to post
Share on other sites
omalleyashe

Here is more from the status of the mod install

line 69: %copyfile: comments_add.php  not copied
Source: mods/comments2/comments_add.php
line 70: %copyfile: comments_pagelist.php  not copied
Source: mods/comments2/comments_pagelist.php
line 71: %copyfile: ajx_commentsmod.php  not copied
Source: mods/comments2/ajx_commentsmod.php
line 72: %copyfile2: img/commentsIcon3.png  not copied
Source: mods/comments2/commentsImg/commentsIcon3.png
line 73: %copyfile2: img/commentsIcon_big.jpg  not copied
Source: mods/comments2/commentsImg/commentsIcon_big.jpg
line 74: %copyfile2: img/cmmt101.jpg  not copied
Source: mods/comments2/commentsImg/cmmt101.jpg
line 75: %copyfile2: img/cmmt102.jpg  not copied
Source: mods/comments2/commentsImg/cmmt102.jpg
line 76: %copyfile2: img/cmmt103.jpg  not copied
Source: mods/comments2/commentsImg/cmmt103.jpg
line 77: %copyfile2: img/cmmt104.jpg  not copied
Source: mods/comments2/commentsImg/cmmt104.jpg
line 78: %copyfile2: img/cmmt105.jpg  not copied
Source: mods/comments2/commentsImg/cmmt105.jpg
line 79: %copyfile2: img/cmmt106.jpg  not copied
Source: mods/comments2/commentsImg/cmmt106.jpg
line 80: %copyfile2: img/cmmt107.jpg  not copied
Source: mods/comments2/commentsImg/cmmt107.jpg
line 81: %copyfile2: img/cmmt108.jpg  not copied
Source: mods/comments2/commentsImg/cmmt108.jpg
line 87: %target:genlib.php% verified
line 89: %location:% #1 not installed
line 128: %location:% #2 not installed
line 288: %target:customconfig.php% verified
line 291: %parameter:$commentsPublic:false% 
line 300: %parameter:commentsPublicAdd:false% 
line 310: %parameter:commentsGuestcaptcha:true% 
line 319: %parameter:commentsApproveguests:true% 
line 328: %parameter:commentsApproveusers:false% 
line 337: %parameter:$commentsAlwayson:false% 
line 345: %location:% #1 not installed
line 374: %target:admin_genconfig.php% verified
line 376: %location:% #1 not installed
line 394: %target:admin_utilities.php% verified
line 395: %location:% #1 not installed
line 412: %target:admin_backup.php% verified
line 413: %location:% #1 not installed
line 430: %target:admin_optimize.php% verified
line 431: %location:% #1 not installed
line 448: %target:admin_restore.php% verified
line 449: %location:% #1 not installed
line 468: %target:@ajx_commentsmod.php% file missing (optional) will ignore
line 492: %target:getperson.php% verified
line 495: %parameter:$commentsPersonOn:true% 
line 503: %location:% #1 not installed
line 535: %target:familygroup.php% verified
line 538: %parameter:$commentsFamilyOn:true% 
line 546: %location:% #1 not installed
line 572: %location:% #2 not installed
line 590: %target:placesearch.php% verified
line 593: %parameter:$commentsPlaceOn:true% 
line 601: %location:% #1 not installed
line 616: %location:% #2 not installed
line 645: %target:showmedia.php% verified
line 648: %parameter:$commentsMediaOn:true% 
line 656: %location:% #1 not installed
line 687: %target:languages/English/cust_text.php% verified
line 689: %location:% #1 not installed
line 754: %target:languages/English-UTF8/cust_text.php% verified
line 756: %location:% #1 not installed
line 821: %target:@languages/Dutch/cust_text.php% verified
line 824: %location:% #1 not installed
line 889: %target:@languages/Dutch-UTF8/cust_text.php% verified
line 892: %location:% #1 not installed
line 957: %target:@languages/French/cust_text.php% verified
line 960: %location:% #1 not installed
line 1026: %target:@languages/French-UTF8/cust_text.php% verified
line 1029: %location:% #1 not installed
line 1096: %target:@languages/German/cust_text.php% verified
line 1099: %location:% #1 not installed
line 1164: %target:@languages/German-UTF8/cust_text.php% verified
line 1167: %location:% #1 not installed
line 1232: %target:@languages/Swedish/cust_text.php% verified
line 1235: %location:% #1 not installed
line 1300: %target:@languages/Swedish-UTF8/cust_text.php% verified
line 1303: %location:% #1 not installed

And the PHPAdmin tool ScreenHunter 225.png

Share this post


Link to post
Share on other sites
manofmull

As for what Simply Hosting support did to the DB...

Alan,

We found some mod-security rules that were being triggered by the mod, which we have whitelisted. I also updated the database table collation to match your other tables (changed to utf8_general_ci), and reinstalled the mod

Regards,
Matt
SimplyHosting.net

Share this post


Link to post
Share on other sites
omalleyashe

Awesome!

Some type of security blocking the changes would seem to make sense based upon the status log. The install works fine. Just the table writes not working.

Thanks much for the extra effort! I will contact simplyhosting.

 

Share this post


Link to post
Share on other sites
omalleyashe

Simplyhosting support is trying hard to fix it. They tried the previous changes and same issue. The "requires database updates" language on the mod is apparently not an issue as it does not need to be done and only causes an additional errors as discussed at the bottom of a post here.

The issue now is focused on the disappearance of the body of the personal pages and the lack of any actual comments mod functionality, even though the mod installation appears to have no issues.

It should be noted that, after Simplyhosting white listed the rules the installation report showed all issues with installation resolved now as shown below, but the issues persists:

line 69: %copyfile: comments_add.php copied
Source: mods/comments2/comments_add.php
line 70: %copyfile: comments_pagelist.php copied
Source: mods/comments2/comments_pagelist.php
line 71: %copyfile: ajx_commentsmod.php copied
Source: mods/comments2/ajx_commentsmod.php
line 72: %copyfile2: img/commentsIcon3.png copied
Source: mods/comments2/commentsImg/commentsIcon3.png
line 73: %copyfile2: img/commentsIcon_big.jpg copied
Source: mods/comments2/commentsImg/commentsIcon_big.jpg
line 74: %copyfile2: img/cmmt101.jpg copied
Source: mods/comments2/commentsImg/cmmt101.jpg
line 75: %copyfile2: img/cmmt102.jpg copied
Source: mods/comments2/commentsImg/cmmt102.jpg
line 76: %copyfile2: img/cmmt103.jpg copied
Source: mods/comments2/commentsImg/cmmt103.jpg
line 77: %copyfile2: img/cmmt104.jpg copied
Source: mods/comments2/commentsImg/cmmt104.jpg
line 78: %copyfile2: img/cmmt105.jpg copied
Source: mods/comments2/commentsImg/cmmt105.jpg
line 79: %copyfile2: img/cmmt106.jpg copied
Source: mods/comments2/commentsImg/cmmt106.jpg
line 80: %copyfile2: img/cmmt107.jpg copied
Source: mods/comments2/commentsImg/cmmt107.jpg
line 81: %copyfile2: img/cmmt108.jpg copied
Source: mods/comments2/commentsImg/cmmt108.jpg
line 87: %target:genlib.php% verified
line 89: %location:% #1 Installed
line 128: %location:% #2 Installed
line 288: %target:customconfig.php% verified
line 291: %parameter:$commentsPublic:false%
line 300: %parameter:commentsPublicAdd:false%
line 310: %parameter:commentsGuestcaptcha:true%
line 319: %parameter:commentsApproveguests:true%
line 328: %parameter:commentsApproveusers:false%
line 337: %parameter:$commentsAlwayson:false%
line 345: %location:% #1 Installed
line 374: %target:admin_genconfig.php% verified
line 376: %location:% #1 Installed
line 394: %target:admin_utilities.php% verified
line 395: %location:% #1 Installed
line 412: %target:admin_backup.php% verified
line 413: %location:% #1 Installed
line 430: %target:admin_optimize.php% verified
line 431: %location:% #1 Installed
line 448: %target:admin_restore.php% verified
line 449: %location:% #1 Installed
line 468: %target:@ajx_commentsmod.php% verified
line 472: %parameter:$commentsAdminmailGuest:true%
line 481: %parameter:$commentsAdminmail:true%
line 492: %target:getperson.php% verified
line 495: %parameter:$commentsPersonOn:true%
line 503: %location:% #1 Installed
line 535: %target:familygroup.php% verified
line 538: %parameter:$commentsFamilyOn:true%
line 546: %location:% #1 Installed
line 572: %location:% #2 Installed
line 590: %target:placesearch.php% verified
line 593: %parameter:$commentsPlaceOn:true%
line 601: %location:% #1 Installed
line 616: %location:% #2 Installed
line 645: %target:showmedia.php% verified
line 648: %parameter:$commentsMediaOn:true%
line 656: %location:% #1 Installed
line 687: %target:languages/English/cust_text.php% verified
line 689: %location:% #1 Installed
line 754: %target:languages/English-UTF8/cust_text.php% verified
line 756: %location:% #1 Installed
line 821: %target:@languages/Dutch/cust_text.php% verified
line 824: %location:% #1 Installed
line 889: %target:@languages/Dutch-UTF8/cust_text.php% verified
line 892: %location:% #1 Installed
line 957: %target:@languages/French/cust_text.php% verified
line 960: %location:% #1 Installed
line 1026: %target:@languages/French-UTF8/cust_text.php% verified
line 1029: %location:% #1 Installed
line 1096: %target:@languages/German/cust_text.php% verified
line 1099: %location:% #1 Installed
line 1164: %target:@languages/German-UTF8/cust_text.php% verified
line 1167: %location:% #1 Installed
line 1232: %target:@languages/Swedish/cust_text.php% verified
line 1235: %location:% #1 Installed
line 1300: %target:@languages/Swedish-UTF8/cust_text.php% verified
line 1303: %location:% #1 Installed
code modifications specified: 24; modified: 24
file copies specified: 13; copied: 13
new files specified: 0; created: 0
new folders specified: 0; created: 0
errors: 0

Share this post


Link to post
Share on other sites
omalleyashe

Resolved! (by Matt at simplyhosting) honourable mention goes to manofmull

Small issue now remaining for error when a media file name includes an apostrophe.  This was also mentioned in Matt's response to me below; an issue previously documented here

___________________________________________

Thank you for uploading the zip file. Since we saw an issue with the comments_add.php file, I wanted to try replacing some of the comment mod php files, notably those located in /public_html/:

ajx_commentsmod.php
comments_pagelist.php
comments_add.php

I'm now able to view the comment field on the individual getperson page, as well some showmedia pages.

However, you are still getting an error on some of the show media pages.

Given the error message on those pages, I would recommend that you contact Darrin (darrin@lythgoes.net) to get his input.

Regards,
Matt
SimplyHosting.net

Share this post


Link to post
Share on other sites
omalleyashe

As a follow up to the fix and how it is now behaving for me:

  • The Comments menu item never showed up in the Find menu or anywhere else for that matter. I resolved this issue by adding it through the customconfig.php file. It works great now!
  • The apostrophe issue is being resolved by using the character ` below the ~ on the keyboard.
  • Quotation marks " are also causing issues, at least with Histories when in the File Name or Body Text or Title or Description. I just removed any quote characters for now from all those areas.
  • Using the Body Text for the History content causes the Comments box to appear above the Body Text and below the Description. This results in the Comments box appearing between the entire History description, which I think looks and functions poorly. So I moved the content for each History down to the Title and Description areas instead. If you have a file you need to attach as the history itself for large histories, then adding the file name doesn't affect the Title; unless it has those offending apostrophes or quotation marks. It doesn't look as nice for text formatting as it did using the File Name and Body Text, but is shows a lot nicer than having the Comments area in the middle of the History content. Since I have just begun adding Histories, this wasn't a large burden for me. However, for someone with significant numbers of Histories that workaround would be a large endeavour. Its worth it for me since adding comments functionality is a huge enhancement.
  • image.png

Share this post


Link to post
Share on other sites
bushtroll

Sorry all, problem solved it was a cacheing problem.  After clearing all of the cache and history it was Ok.

Again sorry, but thanks for all of the responses.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×