HOPL bugs
Tags: hopl
Published: 2020-02-26 08:54:30

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
<table width="1162" cellspacing="0" cellpadding="0" border="2">
<tbody>
<tr>
<td><font size="-2"><b>Date</b></font></td>
<td width="104"><font size="-2"><b>Reporter</b></font></td>
<td width="390"><font size="-2"><b>Location</b></font></td>
<td width="489"><font size="-2"><b>Description</b></font></td>
<td width="103"><font size="-2"><b>Status</b></font></td>
</tr>
<tr>
<td><font size="-2">5/02/2020</font></td>
<td><font size="-2">Graydon Hoare</font></td>
<td><font size="-2"><a
href="http://hopl.info/findlanguages.prx?id=de&amp;which=byCountry"
target="_parent">http://hopl.info/findlanguages.prx?id=de&amp;which=byCountry</a></font></td>
<td><font size="-2">CMPVARLIT: Subscript out of range 9
ProtiumLPNDB at CountryLabel creating comparison structure</font></td>
<td><font size="-2">TRIAGED</font></td>
</tr>
<tr>
<td><font size="-2">5/02/2020</font></td>
<td><font size="-2">Graydon Hoare</font></td>
<td><font size="-2"><a
href="http://hopl.info/findlanguages.prx?id=de&amp;which=byCountry"
target="_parent">http://hopl.info/findlanguages.prx?id=de&amp;which=byCountry</a></font></td>
<td><font size="-2">Error text: Subscript out of range 9
ProtiumLPNDB at CountryLabel creating comparison structure</font></td>
<td><font size="-2">FIXED</font></td>
</tr>
<tr>
<td><font size="-2">5/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/findlanguages.prx?NodeID=2231240&amp;which=byMyCat"
target="_parent">http://hopl.info/findlanguages.prx?NodeID=2231240&amp;which=byM<span>yCat</span></a></font></td>
<td><font size="-2">DEFRST\\\: [Microsoft][ODBC SQL Server
Driver][SQL Server]'First' is not <br>
a recognized built-in function name. -2147217900 0
Microsoft
OLE DB <br>
Provider for ODBC Drivers at<br>
SQL is SELECT First(tblCategories.NodeID) AS PrevNodeID, <br>
tblCategories.NodeText AS PrevNodeText,
tblCategories.ParentID FROM <br>
tblCategories GROUP BY tblCategories.NodeText,
tblCategories.ParentID <br>
HAVING (((First(tblCategories.NodeID))&lt;2231240) AND <br>
((tblCategories.ParentID)=2231200)) ORDER BY
First(tblCategories.NodeID) <br>
DESC;</font></td>
<td><font size="-2">FIXED</font></td>
</tr>
<tr>
<td><font size="-2">6/02/2020</font></td>
<td><font size="-2">bruceax</font></td>
<td><font size="-2"><a
href="http://hopl.info/showperson.prx?peopleid=20&amp;which=ByPerson"
target="_parent">http://hopl.info/showperson.prx?peopleid=20&amp;which=ByPerson</a></font></td>
<td><font size="-2">Ralph Griswold has passed away</font></td>
<td><font size="-2">TRIAGED</font></td>
</tr>
<tr>
<td><font size="-2">7/02/2020</font></td>
<td><font size="-2">andriy.makukha</font></td>
<td><font size="-2"><a
href="http://hopl.info/showperson.prx?PeopleID=593"
target="_parent">http://hopl.info/showperson.prx?PeopleID=593</a></font></td>
<td><font size="-2">SAYFLD: Field name [surShort] not in
current
recordsetsaying value..</font></td>
<td><font size="-2">FIXED</font></td>
</tr>
<tr>
<td><font size="-2">7/02/2020</font></td>
<td><font size="-2">andriy.makukha</font></td>
<td><font size="-2"><a
href="http://hopl.info/showlanguage.prx?exp=242&amp;language=TMG"
target="_parent">http://hopl.info/showlanguage.prx?exp=242&amp;language=TMG</a></font></td>
<td><font size="-2">TST\\\FLD: Field name [tblSource.IntYear]
not
in current recordsetpost memory recall</font></td>
<td><font size="-2">FIXED</font></td>
</tr>
<tr>
<td><font size="-2">24/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/decadereportgr.prx"
target="_parent">http://hopl.info/decadereportgr.prx </a></font></td>
<td><font size="-2">DEFRST: [Microsoft][ODBC SQL Server
Driver][SQL
Server]The data types varchar and varchar are incompatible
in the '&amp;' operator. -2147217900 0 Microsoft OLE DB
Provider for ODBC Drivers at <br>
SQL is SELECT Left(Str([firstyear]),4) &amp; '0s' AS
Decade,
Count(tblLanguage.FirstYear) AS CountOfFirstYear FROM
tblLanguage WHERE (((tblLanguage.FirstYear)&lt;&gt;0))
GROUP
BY Left(Str([firstyear]),4) &amp; '0s';</font></td>
<td><font size="-2">FIXED</font></td>
</tr>
<tr>
<td><font size="-2">24/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/findlanguages.prx?NodeID=1311310&amp;which=byMyCat"
target="_parent">http://hopl.info/findlanguages.prx?NodeID=1311310&amp;which=byMyCat</a></font></td>
<td><font size="-2">Missing data</font></td>
<td><font size="-2">TRIAGED</font></td>
</tr>
<tr>
<td><font size="-2">24/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/findlanguages.prx?NodeID=&amp;which=byMyCat"
target="_parent">http://hopl.info/findlanguages.prx?NodeID=&amp;which=byMyCat</a></font></td>
<td><font size="-2">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
<br>
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)&lt;&gt;0));</font></td>
<td><font size="-2">TRIAGED</font></td>
</tr>
<tr>
<td><font size="-2">26/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/famtree.prx?exp=7800"
target="_parent">http://hopl.info/famtree.prx?exp=7800</a></font></td>
<td><font size="-2">DescriptionSAYFLD: Object variable or With
block variable not set 91 ProtiumLPNDB at lngFKChild
saying
value…</font></td>
<td><font size="-2">ACKNOWLEDGED</font></td>
</tr>
<tr>
<td><font size="-2">26/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/countriesreportgr.prx"
target="_parent">http://hopl.info/countriesreportgr.prx</a></font></td>
<td><font size="-2">FONT color of MAROON not very readable</font></td>
<td><font size="-2">ACKNOWLEDGED</font></td>
</tr>
<tr>
<td><font size="-2">26/02/2020</font></td>
<td><font size="-2">bruce</font></td>
<td><font size="-2"><a
href="http://hopl.info/findlanguages2.prx?id=S&amp;which=ByCountry"
target="_parent">http://hopl.info/findlanguages2.prx?id=S&amp;which=ByCountry</a></font></td>
<td><font size="-2"><a
href="http://hopl.info/alphareport.prx%20-%20selection%20here%20gives%20no%20results%20there"
target="_parent">http://hopl.info/alphareport.prx -
selection here gives no results there</a></font></td>
<td><font size="-2">ACKNOWLEDGED</font></td>
</tr>
</tbody>
</table>