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 |
Top comments (0)