Ken Roy Posted October 18, 2021 Report Share Posted October 18, 2021 I have posted Census_Plus_International_V13.0.0.12-rc1 zip which Brent Hemphill and I updated to eliminate PHP 8 warnings. Some major code re-write was necessary which is why I posted it as RC-1 although Brent and I have been running it on both TNG 13.0.4 and TNG 13.1 beta. The zip file includes 3 different mods: Census Plus International Census Plus International Lang Media Census Plus International Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 10, 2021 Report Share Posted November 10, 2021 I am new to TNG and trying to install the Census Plus mod. I've already had an issue installing it on my live site and am now trying to fix it on wamp64 before retrying on the live site. I keep getting the same errors on both. When I click to create the CPI tables: Determining collation sequence of the database Collation sequence of the database is utf8mb4_0900_ai_ci Database engine is being set to InnoDb Attempting to create the Census Plus Base table as An error has occurred in the TNG software. What to do: If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step. If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step. If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message. Query: CREATE TABLE IF NOT EXISTS ( cpbaseID INT(11) NOT NULL AUTO_INCREMENT, microfilm VARCHAR(20), roll VARCHAR(20), volume VARCHAR(12), page VARCHAR(12), enumDist VARCHAR(20), todaysDate VARCHAR(20), enumDate VARCHAR(18), transcriptID VARCHAR(60), natarch VARCHAR(36), incplace VARCHAR(18), ward VARCHAR(8), location text, series text, censusYear VARCHAR(4), format VARCHAR(16), folder VARCHAR(12), imagenbr VARCHAR(12), publication VARCHAR(12), volumePage VARCHAR(12), researcher VARCHAR(18), imageurl VARCHAR(255), comment text, sourceWebsite VARCHAR(512), siteName VARCHAR(127), town VARCHAR(36), county VARCHAR(36), state VARCHAR(36), country VARCHAR(36), censusurl VARCHAR(155), regDist VARCHAR(20), subDist VARCHAR(20), PRIMARY KEY (cpbaseID) ) ENGINE = InnoDb COLLATE utf8mb4_0900_ai_ci You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( cpbaseID INT(11) NOT NULL AUTO_INCREMENT, microfilm VARCHAR(20), r' at line 1 When I click to create the CPI indexes: ALTER TABLE `cp_data` ADD INDEX `BaseID` ( `cpbaseID` ) ... An error has occurred in the TNG software. What to do: If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step. If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step. If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message. Query: ALTER TABLE `cp_data` ADD INDEX `BaseID` ( `cpbaseID` ) Table 'tng13.cp_data' doesn't exist Any assistance is greatly appreciated. Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 10, 2021 Report Share Posted November 10, 2021 line 32: %target:@extensions/cp_settings.inc% file missing (optional) will ignore line 106: %target:css/genstyle.css% verified line 107: %location:% #1 not installed line 231: %target:@templates/template1/css/templatestyle.css% verified line 234: %location:% #1 not installed line 254: %target:@templates/template4/css/templatestyle.css% verified line 257: %location:% #1 not installed line 275: %target:@templates/template5/css/templatestyle.css% verified line 278: %location:% #1 not installed line 320: %target:@templates/template9/css/templatestyle.css% verified line 323: %location:% #1 not installed line 353: %target:@templates/template10/css/templatestyle.css% verified line 356: %location:% #1 not installed line 379: %target:@templates/template11/css/templatestyle.css% verified line 382: %location:% #1 not installed line 411: %target:@templates/template13/css/templatestyle.css% verified line 414: %location:% #1 not installed line 441: %target:@templates/template14/css/templatestyle.css% verified line 443: %location:% #1 not installed line 470: %target:personlib.php% verified line 473: %location:% #1 not installed line 492: %location:% #2 not installed line 512: %location:% #3 not installed line 520: %location:% #4 not installed line 529: %location:% #5 not installed line 536: %target:admin_merge.php% verified line 537: %location:% #1 not installed line 555: %target:admin.php% verified line 556: %location:% #1 not installed line 566: %target:admin_leftmenu.php% verified line 567: %location:% #1 not installed line 577: %target:admin_secondmenu.php% verified line 578: %location:% #1 not installed line 587: %target:admin_secondary.php% verified line 588: %location:% #1 not installed line 703: %target:languages/English/cust_text.php% verified line 704: %location:% #1 not installed line 731: %target:languages/English-UTF8/cust_text.php% verified line 732: %location:% #1 not installed line 759: %target:customconfig.php% verified line 760: %location:% #1 not installed line 774: %target:admin_genconfig.php% verified line 777: %location:% #1 not installed line 788: %location:% #2 not installed line 799: %location:% #3 not installed line 811: %target:admin_utilities.php% verified line 812: %location:% #1 not installed line 826: %target:admin_backup.php% verified line 827: %location:% #1 not installed line 837: %target:admin_optimize.php% verified line 838: %location:% #1 not installed line 848: %target:admin_restore.php% verified line 849: %location:% #1 not installed line 859: %target:deletelib.php% verified line 862: %location:% #1 not installed line 877: %location:% #2 not installed line 885: %target:admin_deleteevent.php% verified line 888: %location:% #1 not installed line 904: %target:ajx_delete.php% verified line 907: %location:% #1 not installed line 915: %target:treelib.php% verified line 917: %location:% #1 not installed line 932: %newfile: ~extensions/cp_settings.inc not created line 996: %copyfile: admin_censusplus.php copied Source: mods/censusplus_v130012_rc1/admin_censusplus.php line 997: %copyfile: admin_cpcreate.php copied Source: mods/censusplus_v130012_rc1/admin_cpcreate.php line 998: %copyfile: admin_cpdelete.php copied Source: mods/censusplus_v130012_rc1/admin_cpdelete.php line 999: %copyfile: admin_cpdeleteselected.php copied Source: mods/censusplus_v130012_rc1/admin_cpdeleteselected.php line 1000: %copyfile: admin_cpedit.php copied Source: mods/censusplus_v130012_rc1/admin_cpedit.php line 1001: %copyfile: admin_cpimage.php copied Source: mods/censusplus_v130012_rc1/admin_cpimage.php line 1002: %copyfile: admin_cplinkIDs.php copied Source: mods/censusplus_v130012_rc1/admin_cplinkIDs.php line 1003: %copyfile: admin_cprestore.php copied Source: mods/censusplus_v130012_rc1/admin_cprestore.php line 1004: %copyfile: admin_cpscrape.php copied Source: mods/censusplus_v130012_rc1/admin_cpscrape.php line 1005: %copyfile: admin_cpupdate.php copied Source: mods/censusplus_v130012_rc1/admin_cpupdate.php line 1006: %copyfile: admin_cpxfamsearch.php copied Source: mods/censusplus_v130012_rc1/admin_cpxfamsearch.php line 1007: %copyfile: admin_cpxtngsearch.php copied Source: mods/censusplus_v130012_rc1/admin_cpxtngsearch.php line 1008: %copyfile: copycentables.php copied Source: mods/censusplus_v130012_rc1/copycentables.php line 1009: %copyfile: cpaddimage.php copied Source: mods/censusplus_v130012_rc1/cpaddimage.php line 1010: %copyfile: cpcheck_tables.php copied Source: mods/censusplus_v130012_rc1/cpcheck_tables.php line 1011: %copyfile: cpcreate.php copied Source: mods/censusplus_v130012_rc1/cpcreate.php line 1012: %copyfile: cpcreateindices.php copied Source: mods/censusplus_v130012_rc1/cpcreateindices.php line 1013: %copyfile: cpdelete.php copied Source: mods/censusplus_v130012_rc1/cpdelete.php line 1014: %copyfile: cpdisplay.php copied Source: mods/censusplus_v130012_rc1/cpdisplay.php line 1015: %copyfile: cpdroptables.php copied Source: mods/censusplus_v130012_rc1/cpdroptables.php line 1016: %copyfile: cpfindID.php copied Source: mods/censusplus_v130012_rc1/cpfindID.php line 1017: %copyfile: cpfind2linkID.php copied Source: mods/censusplus_v130012_rc1/cpfind2linkID.php line 1018: %copyfile: cphouseholdupdate.php copied Source: mods/censusplus_v130012_rc1/cphouseholdupdate.php line 1019: %copyfile: cpinclude.php copied Source: mods/censusplus_v130012_rc1/cpinclude.php line 1020: %copyfile: cplinkID.php copied Source: mods/censusplus_v130012_rc1/cplinkID.php line 1021: %copyfile: cploaddata.php copied Source: mods/censusplus_v130012_rc1/cploaddata.php line 1022: %copyfile: cpmakedir.php copied Source: mods/censusplus_v130012_rc1/cpmakedir.php line 1023: %copyfile: cpmakelabel.php copied Source: mods/censusplus_v130012_rc1/cpmakelabel.php line 1024: %copyfile: cpmakesummary.php copied Source: mods/censusplus_v130012_rc1/cpmakesummary.php line 1025: %copyfile: cpmaketables.php copied Source: mods/censusplus_v130012_rc1/cpmaketables.php line 1026: %copyfile: cpmakeveteran.php copied Source: mods/censusplus_v130012_rc1/cpmakeveteran.php line 1027: %copyfile: cpproccreate.php copied Source: mods/censusplus_v130012_rc1/cpproccreate.php line 1028: %copyfile: cpprochousehold.php copied Source: mods/censusplus_v130012_rc1/cpprochousehold.php line 1029: %copyfile: cpproclabel.php copied Source: mods/censusplus_v130012_rc1/cpproclabel.php line 1030: %copyfile: cpprocupdate.php copied Source: mods/censusplus_v130012_rc1/cpprocupdate.php line 1031: %copyfile: cpscrapeALL.php copied Source: mods/censusplus_v130012_rc1/cpscrapeALL.php line 1032: %copyfile: cpsearch.php copied Source: mods/censusplus_v130012_rc1/cpsearch.php line 1033: %copyfile: cpUSsummary.php copied Source: mods/censusplus_v130012_rc1/cpUSsummary.php line 1034: %copyfile: cpUSvet.php copied Source: mods/censusplus_v130012_rc1/cpUSvet.php line 1035: %copyfile: cpsummary.php copied Source: mods/censusplus_v130012_rc1/cpsummary.php line 1036: %copyfile: cpupdate.php copied Source: mods/censusplus_v130012_rc1/cpupdate.php line 1037: %copyfile: cpupdate_eventIDs.php copied Source: mods/censusplus_v130012_rc1/cpupdate_eventIDs.php line 1038: %copyfile: cpupdate_label.php copied Source: mods/censusplus_v130012_rc1/cpupdate_label.php line 1039: %copyfile: cpupdate_transid.php copied Source: mods/censusplus_v130012_rc1/cpupdate_transid.php line 1040: %copyfile: cpxfamsearch.php copied Source: mods/censusplus_v130012_rc1/cpxfamsearch.php line 1041: %copyfile: cpxsearch.php copied Source: mods/censusplus_v130012_rc1/cpxsearch.php line 1042: %copyfile: cpxsearchlib.php copied Source: mods/censusplus_v130012_rc1/cpxsearchlib.php line 1043: %copyfile: cpxtngsearch.php copied Source: mods/censusplus_v130012_rc1/cpxtngsearch.php line 1044: %copyfile: dropcensustables.php source missing Source: mods/censusplus_v130012_rc1/dropcensustables.php line 1045: %copyfile: micro_cpinclude.php source missing Source: mods/censusplus_v130012_rc1/micro_cpinclude.php line 1046: %copyfile: simple_html_dom.php source missing Source: mods/censusplus_v130012_rc1/simple_html_dom.php line 1047: %copyfile: upgrade_cp_tables.php copied Source: mods/censusplus_v130012_rc1/upgrade_cp_tables.php line 1048: %copyfile: upgrade_cp_summary.php copied Source: mods/censusplus_v130012_rc1/upgrade_cp_summary.php line 1049: %copyfile: upgrade_cp_veteran.php copied Source: mods/censusplus_v130012_rc1/upgrade_cp_veteran.php line 1050: %copyfile2: js/cenplus.js copied Source: mods/censusplus_v130012_rc1/cenplus.js line 1051: %copyfile2: languages/English/cp_text.php copied Source: mods/censusplus_v130012_rc1/cp_text.php line 1052: %copyfile2: languages/English-UTF8/cp_text.php copied Source: mods/censusplus_v130012_rc1/cp_text.php line 1053: %copyfile2: img/cpi_icon.gif copied Source: mods/censusplus_v130012_rc1/cpi_icon.gif line 1054: %copyfile2: img/cpicon.jpg copied Source: mods/censusplus_v130012_rc1/cpicon.jpg line 1055: %copyfile2: img/cpsprite.jpg copied Source: mods/censusplus_v130012_rc1/cpsprite.jpg code modifications specified: 34; modified: 0 file copies specified: 60; copied: 57 new files specified: 1; created: 0 new folders specified: 0; created: 0 errors: 3 Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted November 10, 2021 Author Report Share Posted November 10, 2021 Sarah, Based on latest reply, it looks like the mod is not installed. So you cannot created the tables. I do not understand how you can have part of the mod show files copied, unless you did not upload the censusplus_v130012_rc1 folder as a subfolder to your TNG mods folder. Also depending on your host, your table names cannot be tng13. You have to use underscores for the table prefix. At least that is what my hosting support team told me. You must resolve the missing source issue before trying to get any further. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted November 11, 2021 Author Report Share Posted November 11, 2021 Sarah, Where do you stand with installing the Census Plus International mod? I ask because I will be out of town the next 2 weeks and may not always have internet access. Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 11, 2021 Report Share Posted November 11, 2021 I fixed most of it. Now I'm down to just one error: line 470: %target:personlib.php% verified line 473: %location:% #1 not installed line 492: %location:% #2 not installed line 512: %location:% #3 not installed line 520: %location:% #4 Bad target line 529: %location:% #5 not installed Sarah Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 11, 2021 Report Share Posted November 11, 2021 The tng13 table names were on the wampserver (offline host). I wanted to make sure I could fix it there before I attempted on the live site. As of last night, I have it 100% installed on the wampserver. The error is on the live site. I got the media cofig and the lang config to the OK to install status. Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 11, 2021 Report Share Posted November 11, 2021 Completely fixed and installed. I ended up mirroring the offline files. Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 11, 2021 Report Share Posted November 11, 2021 Now that I have it completely installed, it won't display on the person's individual pages. Again, any help is appreaciated. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted November 11, 2021 Author Report Share Posted November 11, 2021 (edited) Sarah, You indicate you are new to TNG, so I am not sure what you are expecting the mod to do for you. Did you create (Add) any census transcripts? See Census Plus International - Add article and the others in the Related Links section at the bottom of the TNG Wiki page for the Census Plus International mod Note that the Import from Ancestry is no longer supported since they changed the way they generate their DOM source page. Edited November 11, 2021 by Ken Roy fix grammar Quote Link to comment Share on other sites More sharing options...
Sarah6 Posted November 12, 2021 Report Share Posted November 12, 2021 Fixed it. It was one of the settings in the options for custom events that was not displaying it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.