Mark Kosinski Posted July 16, 2019 Report Share Posted July 16, 2019 After successfully updating CP International and the CP International Language Mods and updating the CPI Label Table and the CPI Veteran Table I get the following error on any page containing census data: Quote 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: SELECT cp_data.cpbaseID AS th, surname, givenname, relation, household, cplineno, lineno, censusYear, street, sex, race, age, birthdate, birthplace, fatherBthplace, motherBthplace, household,immigration, occupation, veteran, status, street, location, personID, nbrSlaves, nbrSlaveHouses, comments, cpdataID, yearsMarried, chborn, chliving, nationality, religion, tribal FROM cp_data LEFT JOIN cp_link ON cp_data.cpdataID = cp_link.cpdataID WHERE cp_data.censusYear = "1920" AND household LIKE "406" AND (cp_data.transcriptID LIKE "dbid=6061&iid=4384791_00%") AND cp_data.location = "Erie, Erie, Pennsylvania, USA" ORDER BY cp_data.transcriptID ASC, lineno+0 ASC Column 'censusYear' in field list is ambiguous I checked the database and in the cp_data table the column censusYear does in fact exist and is populated with data as well as in the cp_link table. The current PHP version I am using is 7.2.20 on SiteGround. I rolled back to V12.0.0.9 of the Mod and everything is back to normal without the error. Quote Link to comment Share on other sites More sharing options...
lastejas Posted July 16, 2019 Report Share Posted July 16, 2019 just a thought did you clear your browser cache after doing the update. Quote Link to comment Share on other sites More sharing options...
Mark Kosinski Posted July 16, 2019 Author Report Share Posted July 16, 2019 Yes cleared browser cache, tried Edge, Internet Explorer, Safari, Chrome and Opera all with the same result. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted July 16, 2019 Report Share Posted July 16, 2019 6 hours ago, Mark Kosinski said: Query: SELECT cp_data.cpbaseID AS th, surname, givenname, relation, household, cplineno, lineno, censusYear, street, sex, race, age, birthdate, birthplace, fatherBthplace, motherBthplace, household,immigration, occupation, veteran, status, street, location, personID, nbrSlaves, nbrSlaveHouses, comments, cpdataID, yearsMarried, chborn, chliving, nationality, religion, tribal FROM cp_data LEFT JOIN cp_link ON cp_data.cpdataID = cp_link.cpdataID WHERE cp_data.censusYear = "1920" AND household LIKE "406" AND (cp_data.transcriptID LIKE "dbid=6061&iid=4384791_00%") AND cp_data.location = "Erie, Erie, Pennsylvania, USA" ORDER BY cp_data.transcriptID ASC, lineno+0 ASC Column 'censusYear' in field list is ambiguous Until, I get a fix out, you can eliminate the problem by going to Edit Options in the Mod Manager and change the option for Return all members of household even though PersonIDs are not assigned. Defaults to (n). from the default of n to y which will eliminate the LEFT JOIN from being added to the query and thus the censusYear is ambiguous error. Quote Link to comment Share on other sites More sharing options...
Mark Kosinski Posted July 16, 2019 Author Report Share Posted July 16, 2019 Thanks Ken! Works as you said. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted July 16, 2019 Report Share Posted July 16, 2019 I will try to get new version that fixes the issue later this week, but now also need to get to the bottom of the issue being reported by Rick hooley as a conflict with the Sosa mod Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted July 19, 2019 Report Share Posted July 19, 2019 Mark I sent you a new Census Plus International mod version to beta test when the Return All is set to the default of n Quote Link to comment Share on other sites More sharing options...
lastejas Posted July 19, 2019 Report Share Posted July 19, 2019 Hi Ken Just got in for lunch so while I have 5 mins will load the update and give it a run. Quote Link to comment Share on other sites More sharing options...
lastejas Posted July 19, 2019 Report Share Posted July 19, 2019 Ken, Initial indications show that this has cured the problem with SOSA, but will give it a longer test run this evening. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted July 20, 2019 Report Share Posted July 20, 2019 Census Plus International v12.0.0.10a has been posted to resolve the problem 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.