bushtroll 0 Report post Posted 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. Share this post Link to post Share on other sites
Brett 0 Report post Posted September 8, 2019 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 0 Report post Posted 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. Share this post Link to post Share on other sites
Brett 0 Report post Posted September 8, 2019 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 0 Report post Posted September 8, 2019 I'll give that a try now and let you know, thanks. Share this post Link to post Share on other sites
bushtroll 0 Report post Posted 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. Share this post Link to post Share on other sites
Ken Roy 0 Report post Posted 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. Share this post Link to post Share on other sites
omalleyashe 0 Report post Posted 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 Wiki Status Files 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. Share this post Link to post Share on other sites
manofmull 0 Report post Posted February 12, 2020 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 0 Report post Posted February 12, 2020 Interesting. Simplyhosting is also my host. Thanks for that lead. Share this post Link to post Share on other sites
omalleyashe 0 Report post Posted 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 Share this post Link to post Share on other sites
manofmull 0 Report post Posted February 12, 2020 Posted July 26, 2019 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, MattSimplyHosting.net Share this post Link to post Share on other sites
omalleyashe 0 Report post Posted 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. Share this post Link to post Share on other sites
omalleyashe 0 Report post Posted 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 copiedSource: mods/comments2/comments_add.phpline 70: %copyfile: comments_pagelist.php copiedSource: mods/comments2/comments_pagelist.phpline 71: %copyfile: ajx_commentsmod.php copiedSource: mods/comments2/ajx_commentsmod.phpline 72: %copyfile2: img/commentsIcon3.png copiedSource: mods/comments2/commentsImg/commentsIcon3.pngline 73: %copyfile2: img/commentsIcon_big.jpg copiedSource: mods/comments2/commentsImg/commentsIcon_big.jpgline 74: %copyfile2: img/cmmt101.jpg copiedSource: mods/comments2/commentsImg/cmmt101.jpgline 75: %copyfile2: img/cmmt102.jpg copiedSource: mods/comments2/commentsImg/cmmt102.jpgline 76: %copyfile2: img/cmmt103.jpg copiedSource: mods/comments2/commentsImg/cmmt103.jpgline 77: %copyfile2: img/cmmt104.jpg copiedSource: mods/comments2/commentsImg/cmmt104.jpgline 78: %copyfile2: img/cmmt105.jpg copiedSource: mods/comments2/commentsImg/cmmt105.jpgline 79: %copyfile2: img/cmmt106.jpg copiedSource: mods/comments2/commentsImg/cmmt106.jpgline 80: %copyfile2: img/cmmt107.jpg copiedSource: mods/comments2/commentsImg/cmmt107.jpgline 81: %copyfile2: img/cmmt108.jpg copiedSource: mods/comments2/commentsImg/cmmt108.jpgline 87: %target:genlib.php% verifiedline 89: %location:% #1 Installedline 128: %location:% #2 Installedline 288: %target:customconfig.php% verifiedline 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 Installedline 374: %target:admin_genconfig.php% verifiedline 376: %location:% #1 Installedline 394: %target:admin_utilities.php% verifiedline 395: %location:% #1 Installedline 412: %target:admin_backup.php% verifiedline 413: %location:% #1 Installedline 430: %target:admin_optimize.php% verifiedline 431: %location:% #1 Installedline 448: %target:admin_restore.php% verifiedline 449: %location:% #1 Installedline 468: %target:@ajx_commentsmod.php% verifiedline 472: %parameter:$commentsAdminmailGuest:true%line 481: %parameter:$commentsAdminmail:true%line 492: %target:getperson.php% verifiedline 495: %parameter:$commentsPersonOn:true%line 503: %location:% #1 Installedline 535: %target:familygroup.php% verifiedline 538: %parameter:$commentsFamilyOn:true%line 546: %location:% #1 Installedline 572: %location:% #2 Installedline 590: %target:placesearch.php% verifiedline 593: %parameter:$commentsPlaceOn:true%line 601: %location:% #1 Installedline 616: %location:% #2 Installedline 645: %target:showmedia.php% verifiedline 648: %parameter:$commentsMediaOn:true%line 656: %location:% #1 Installedline 687: %target:languages/English/cust_text.php% verifiedline 689: %location:% #1 Installedline 754: %target:languages/English-UTF8/cust_text.php% verifiedline 756: %location:% #1 Installedline 821: %target:@languages/Dutch/cust_text.php% verifiedline 824: %location:% #1 Installedline 889: %target:@languages/Dutch-UTF8/cust_text.php% verifiedline 892: %location:% #1 Installedline 957: %target:@languages/French/cust_text.php% verifiedline 960: %location:% #1 Installedline 1026: %target:@languages/French-UTF8/cust_text.php% verifiedline 1029: %location:% #1 Installedline 1096: %target:@languages/German/cust_text.php% verifiedline 1099: %location:% #1 Installedline 1164: %target:@languages/German-UTF8/cust_text.php% verifiedline 1167: %location:% #1 Installedline 1232: %target:@languages/Swedish/cust_text.php% verifiedline 1235: %location:% #1 Installedline 1300: %target:@languages/Swedish-UTF8/cust_text.php% verifiedline 1303: %location:% #1 Installedcode modifications specified: 24; modified: 24file copies specified: 13; copied: 13new files specified: 0; created: 0new folders specified: 0; created: 0errors: 0 Share this post Link to post Share on other sites
omalleyashe 0 Report post Posted 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 Share this post Link to post Share on other sites
omalleyashe 0 Report post Posted 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. Share this post Link to post Share on other sites
bushtroll 0 Report post Posted 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. Share this post Link to post Share on other sites
manofmull 0 Report post Posted September 22, 2020 Talk about irony. I have the same problem with TNG13 and the Comments mod. Installed [Options] Requires database updates I contacted SimplyHosting but they want me to submit a ticket. The fix is above (and below) but I don't understand it. On 2/15/2020 at 5:54 PM, omalleyashe said: 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! I've had a long weary day and I'm too tired and old to figure this out. Erik or anyone else, please help Share this post Link to post Share on other sites
XerxX 0 Report post Posted 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 Share this post Link to post Share on other sites
manofmull 0 Report post Posted September 22, 2020 Erik If only it were that simple! Something in my setup needs tweaking as this is not the only mod I'm having problems with. Share this post Link to post Share on other sites
manofmull 0 Report post Posted September 23, 2020 Erik Prior to my recent upgrade to TNG12, I was using the original beta version with TNG11 (was on Info drop-down). Before upgrading to TNG12 I uninstalled the mod, deleted the tables and waited for TNG13 which I've now installed. Here's the reply I got from SimplyHosting: Abin flagged me and asked if I could look at this with him. He whitelisted the necessary ModSecurity items, and then we ran through the mod installer. Side question: is this to be a new installation? The tng_comments table didn't exist in your database. If you were hoping to upgrade, then we may need to look into restoring that table. Anyway, after we ran the installer and created the tng_comments table we are able to post comments on the front end. However, we are still getting a message in the Mod Manager that the table needs to be updated. Can you check this on your end for us? Since the mod was just updated today I wonder if this might be a bug that you should discuss with Erik Hoppe (the mod developer). One side note: I updated some of your PHP settings, but I don't suspect that is pertinent to the issue. Nonetheless, if you contact Erik he might want to know some of this: PHP updated from v7.2 to v7.3 PHP memory_limit changed from 128 MB to 512 MB Share this post Link to post Share on other sites
XerxX 0 Report post Posted 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 Share this post Link to post Share on other sites
manofmull 0 Report post Posted September 23, 2020 Erik Messaged you Share this post Link to post Share on other sites
BeresfordMike 0 Report post Posted 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. Share this post Link to post Share on other sites
manofmull 0 Report post Posted September 24, 2020 Exactly the same problem I have as mentioned above. Erik (mod author) couldn't determine what the problem is. I'm using template 18. Hopefully Erik or Darrin (contacted him) will find a solution. Share this post Link to post Share on other sites