Comments mod

September 8, 2019

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.

September 8, 2019

What Template are you using?

What other Mods are installed?

What version of PHP is running?

Brett

September 8, 2019

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

September 8, 2019

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

September 8, 2019

I'll give that a try now and let you know, thanks.

September 8, 2019

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.

September 8, 2019

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.

February 12, 2020

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:

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	Config File Name	Version	Status
1. Comments	comments_v12.0.1.2.cfg	12.0.1.2	Installed [Options] Requires database updates
2. Count Ancestors Descendants	count_ancestors_descendants_mod_v10.1.1.3e.cfg	10.1.1.3e	Installed [Options]
3. FGWTabs	fgw_tabs_v11.0.0.9.cfg	11.0.0.9	Installed [Options]
4. Forum for TNG	forum_for_tng_mod_v11.0.1.5.cfg	11.0.1.5	Installed [Options]
5. Simple SEO	simple_seo_v12.0.3.6a.cfg	12.0.3.6a	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.

February 12, 2020

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

February 12, 2020

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

February 12, 2020

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.

February 13, 2020

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

February 13, 2020

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

February 15, 2020

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.

May 18, 2020

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.

September 22, 2020

I just now installed v13.0.0.2a and the menu item is there:

I didn't have to, but have you tried to clear the cache?

/Erik

September 23, 2020

I test in PHP 7.4.2 but now I (uninstalled the mod) downgraded to PHP 7.3.9 and re-installed the mod. It's okay.

The "Database update" message is always there. It's just a reminder, as MM can't detect your tables (as far as I know).

The button under "First Time Install" named "Create Comments database tables" creates TWO tables: tng_comments and tng_commentsvisits.

8 hours ago, manofmull said:

and created the tng_comments table we

Do you have both tables? The SimplyHosting message says only one...

If you have only the tng_comments table: Delete it ("Drop table") and then click the Create Comments database tables to create both tables.

HTH

Erik

September 24, 2020

I have installed TNG 13 on a Simply Hosting package.

I have made a number of attempts to install / reinstall which appears to have had success;

Reports:

Attempting to create database table(s)...   Database table(s) created succesfully.
Attempting to add keys to database table(s)...   All keys added succesfully.
Attempting to add autoincrements to database tables...   All autoincrements added succesfully.

However, there are no changes to the Menu and I cannot access or use the mod in any way.

I am using Template 10.

I have raised a ticket with Simply Hosting and will repost any helpful suggestions that I might receive.

September 24, 2020

Albin at Simply Hosting is also being quite helpful.

He whitelisted the mod

He found this error, which means nothing to me; but I will add, in case it means anything


[Wed Sep 23 23:44:03.123876 2020] [:error] [pid 28328:tid 47543197161216] [client 130.255.19.43:3644] [client 130.255.19.43] ModSecurity: Warning. detected XSS using libinjection. [file "/etc/apache2/conf.d/modsec_vendor_configs/OWASP3/rules/REQUEST-941-APPLICATION-ATTACK-XSS.conf"] [line "37"] [id "941100"] [rev "2"] [msg "XSS Attack Detected via libinjection"] [data "Matched Data: <div><b>Sep 24th 2020</b></div><div><br></div><div>

He suggested that I disabled mod-security - but that hasn't worked either.

Will keep posting if anything happens

September 24, 2020

Wait! What? "XSS Attack Detected via libinjection" 😳

So you two have the same host and the same problem. No DDmenu item.

8 downloads from the TNG Wiki so far. 2 reports = 6 not reported. Are there any downloads out there that works?

I don't use the Comments "live", only on my localhost and it works fine. Yesterday I compared the genlib.php code that's making the DDmenu item between my working code and manofmull's not working. They were exactly the same. So I copied-and-pasted his code into mine and the menu is still okay.

I do suspect that there is a mod that makes this happen. Maybe doing some Custom Menu thingie?

Do you use any other mod except Comments that modifies the DD menus?

/Erik

September 24, 2020

"XSS Attack Detected via libinjection" I think that comes from the other TNG - Star Trek

My browser always gets a bit confused 🚀

Simply Hosting are working on the issue and will report back

September 24, 2020

Matt at Simply Hosting has resolved my problem.

They have been very helpful.

Part of the problem was my installation of the upgrade and he very kindly did a fresh install of the whole TNG13 package.

He also put PHP version 7.3 into my setup - because that is the one they're using for new TNG installations

He then did a fresh install of the Comments mod which worked first time - so no problems there.

As my profile says - Newbie. Thanks to all who give great support with this programme.

September 24, 2020

Mike... And now you see the "Comments" menu item at the bottom of the "Find" menu?

/Erik

September 24, 2020

Erik,

A couple of things have happened - I did a test comment and received an email notification of the same.

In Template 10, which I am using, the "Comments" link hasn't appeared at the place where I think it should.
see attached.

Mike

September 24, 2020

Erik and MM,

Thanks for the help.

The system is all working - emails and reading comments.

Mike

Comments mod

Recommended Posts

bushtroll

Link to comment

Share on other sites

Brett

Link to comment

Share on other sites

bushtroll

Link to comment

Share on other sites

Brett

Link to comment

Share on other sites

bushtroll

Link to comment

Share on other sites

bushtroll

Link to comment

Share on other sites

Ken Roy

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

omalleyashe

Link to comment

Share on other sites

bushtroll

Link to comment

Share on other sites

XerxX

Link to comment

Share on other sites

XerxX

Link to comment

Share on other sites

BeresfordMike

Reports:

Link to comment

Share on other sites

BeresfordMike

Link to comment

Share on other sites

XerxX

Link to comment

Share on other sites

BeresfordMike

Link to comment

Share on other sites

BeresfordMike

Link to comment

Share on other sites

XerxX

Link to comment

Share on other sites

BeresfordMike

Link to comment

Share on other sites

BeresfordMike

Link to comment

Share on other sites

Join the conversation

TNG