DEV Community

loading...

HOPL bugs

Bruce Axtens
Programmed Canon Canola calculators in 1977. Assorted platforms and languages ever since. Assisting with HOPL.info. I am NOT looking for work -- I've got more than enough to do.
・5 min read

HOPL site bugs, those who reported them and what the status is on fixing them. Obviously, if you see any yourself (formatting, functionality or historical detail) please send them to hopl.acquisitions@gmail.com

Date Reporter Location Description Status
5/02/2020 Graydon Hoare http://hopl.info/findlanguages.prx?id=de&which=byCountry CMPVARLIT: Subscript out of range 9 ProtiumLPNDB at CountryLabel creating comparison structure TRIAGED
5/02/2020 Graydon Hoare http://hopl.info/findlanguages.prx?id=de&which=byCountry Error text: Subscript out of range 9 ProtiumLPNDB at CountryLabel creating comparison structure FIXED
5/02/2020 bruce http://hopl.info/findlanguages.prx?NodeID=2231240&which=byMyCat DEFRST\\\: [Microsoft][ODBC SQL Server Driver][SQL Server]'First' is not
a recognized built-in function name. -2147217900 0 Microsoft OLE DB
Provider for ODBC Drivers at
SQL is SELECT First(tblCategories.NodeID) AS PrevNodeID,
tblCategories.NodeText AS PrevNodeText, tblCategories.ParentID FROM
tblCategories GROUP BY tblCategories.NodeText, tblCategories.ParentID
HAVING (((First(tblCategories.NodeID))<2231240) AND
((tblCategories.ParentID)=2231200)) ORDER BY First(tblCategories.NodeID)
DESC;
FIXED
6/02/2020 bruceax http://hopl.info/showperson.prx?peopleid=20&which=ByPerson Ralph Griswold has passed away TRIAGED
7/02/2020 andriy.makukha http://hopl.info/showperson.prx?PeopleID=593 SAYFLD: Field name [surShort] not in current recordsetsaying value.. FIXED
7/02/2020 andriy.makukha http://hopl.info/showlanguage.prx?exp=242&language=TMG TST\\\FLD: Field name [tblSource.IntYear] not in current recordsetpost memory recall FIXED
24/02/2020 bruce http://hopl.info/decadereportgr.prx DEFRST: [Microsoft][ODBC SQL Server Driver][SQL Server]The data types varchar and varchar are incompatible in the '&' operator. -2147217900 0 Microsoft OLE DB Provider for ODBC Drivers at
SQL is SELECT Left(Str([firstyear]),4) & '0s' AS Decade, Count(tblLanguage.FirstYear) AS CountOfFirstYear FROM tblLanguage WHERE (((tblLanguage.FirstYear)<>0)) GROUP BY Left(Str([firstyear]),4) & '0s';
FIXED
24/02/2020 bruce http://hopl.info/findlanguages.prx?NodeID=1311310&which=byMyCat Missing data TRIAGED
24/02/2020 bruce http://hopl.info/findlanguages.prx?NodeID=&which=byMyCat Doesn't handle bad data well: DEFRST\\\: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'And'. -2147217900 0 Microsoft OLE DB Provider for ODBC Drivers at
SQL is SELECT tblCategories.NodeText, tblCategories_1.NodeText AS ParentNodeText, tblCategories_1.NodeID AS ParentNodeID, tblCategories_2.NodeID AS GrandParentNodeID, tblCategories_2.NodeText AS GrandparentNodeText, tblCategories_3.NodeID AS GreatGrandparentNodeID, tblCategories_3.NodeText AS GreatGrandparentNodeText FROM ((tblCategories LEFT JOIN tblCategories AS tblCategories_1 ON tblCategories.ParentID = tblCategories_1.NodeID) LEFT JOIN tblCategories AS tblCategories_2 ON tblCategories_1.ParentID = tblCategories_2.NodeID) LEFT JOIN tblCategories AS tblCategories_3 ON tblCategories_2.ParentID = tblCategories_3.NodeID WHERE (((tblCategories.NodeID)= And (tblCategories.NodeID)<>0));
TRIAGED
26/02/2020 bruce http://hopl.info/famtree.prx?exp=7800 DescriptionSAYFLD: Object variable or With block variable not set 91 ProtiumLPNDB at lngFKChild saying value… ACKNOWLEDGED
26/02/2020 bruce http://hopl.info/countriesreportgr.prx FONT color of MAROON not very readable ACKNOWLEDGED
26/02/2020 bruce http://hopl.info/findlanguages2.prx?id=S&which=ByCountry http://hopl.info/alphareport.prx - selection here gives no results there ACKNOWLEDGED

Discussion (0)