Jump to content
TNG Community

Census Plus International mod for PHP 8


Ken Roy

Recommended Posts

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

Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
Share on other sites

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
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.  

Link to comment
Share on other sites

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 by Ken Roy
fix grammar
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...