I get the following error on people pages after upgrade:
Query: SELECT .testID, .personID as tpersonID, .gedcom as tgedcom, test_type, test_number, test_date FROM , WHERE .personID = "I1" AND .gedcom = "1" AND .testID = .testID ORDER BY test_date, test_number * 1 ASC
And on the admin page I get:
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 count(*) as num FROM
It looks like the upgrade finished(I ran it again to verify):
TNG 11 Database Structure Update
ALTER TABLE tng_cemeteries MODIFY latitude VARCHAR(22) NOT NULL ... doneALTER TABLE tng_cemeteries MODIFY longitude VARCHAR(22) NOT NULL ... doneCREATE TABLE (ID int(11) NOT NULL AUTO_INCREMENT, testID int(11) NOT NULL, personID varchar(22) NOT NULL, gedcom varchar(20) NOT NULL, PRIMARY KEY (ID)) ENGINE = MYISAM ... failed or done previouslyCREATE TABLE (testID int(11) NOT NULL AUTO_INCREMENT, test_type varchar(40) NOT NULL, test_number varchar(50) NOT NULL, notes text NOT NULL, vendor varchar(100) NOT NULL, test_date date NOT NULL, personID varchar(22) NOT NULL, gedcom varchar(20) NOT NULL, urls text NOT NULL, haplogroup varchar(40) NOT NULL, significant_snp varchar(80) NOT NULL, terminal_snp varchar(80) NOT NULL, markers varchar(40) NOT NULL, PRIMARY KEY (testID), INDEX test_date (test_date)) ENGINE = MYISAM ... failed or done previouslyALTER TABLE tng_languages ADD norels VARCHAR(1) NOT NULL after charset ... failed or done previouslyALTER TABLE tng_media MODIFY latitude VARCHAR(22) NULL ... doneALTER TABLE tng_media MODIFY longitude VARCHAR(22) NULL ... doneALTER TABLE tng_mediatypes ADD localpath VARCHAR(250) NOT NULL after ordernum ... failed or done previouslyALTER TABLE tng_places MODIFY latitude VARCHAR(22) NULL ... doneALTER TABLE tng_places MODIFY longitude VARCHAR(22) NULL ... doneALTER TABLE tng_users ADD languageID SMALLINT(6) NOT NULL after website ... failed or done previouslyThe Next Generation database has now been updated to v11 specs.