--> -->
<class 'pg.ProgrammingError'> | Python 2.7.18: /usr/bin/python-cattle
Fri Apr 19 04:46:01 2024 |
A problem occurred in a Python script. Here is the sequence of
function calls leading up to the error, in the order they occurred.
| /var/www/cgi-bin/cattle/browse.py in <module>() |
9
|
10 print 'Content-Type: text/html'
|
11 print
|
12 bs = BrowseSheet()
|
=> 13 print bs.getPageHtml()
|
| bs = <mcls.cattle.web.browsesheet.BrowseSheet instance>, bs.getPageHtml = <bound method BrowseSheet.getPageHtml of <mcls.cattle.web.browsesheet.BrowseSheet instance>> |
| /usr/lib/python2.7/site-packages/mcls/cattle/web/browsesheet.py in getPageHtml(self=<mcls.cattle.web.browsesheet.BrowseSheet instance>) |
37 pageDict.load(files)
|
38
|
=> 39 d['NoForSale'] = self.__getNoForSale()
|
40 d['minPrice'] = self.__getMinPrice()
|
41 d['maxPrice'] = self.__getMaxPrice()
|
| d = {'AirlieMenuSection': '', 'GroupDesc': '', 'GroupMenuSection': '', 'GroupName': 'Browse Cattle', 'IvanMenuSection': ''}, self = <mcls.cattle.web.browsesheet.BrowseSheet instance>, self.__getNoForSale undefined |
| /usr/lib/python2.7/site-packages/mcls/cattle/web/browsesheet.py in __getNoForSale(self=<mcls.cattle.web.browsesheet.BrowseSheet instance>) |
56
|
57 def __getNoForSale(self):
|
=> 58 self.__LookupSaleCounts()
|
59 return `int(self.__salecounts['count'])`
|
60
|
| self = <mcls.cattle.web.browsesheet.BrowseSheet instance>, self.__LookupSaleCounts undefined |
| /usr/lib/python2.7/site-packages/mcls/cattle/web/browsesheet.py in __LookupSaleCounts(self=<mcls.cattle.web.browsesheet.BrowseSheet instance>) |
79 str = ( 'select count(*), min("Sale Price"), max("Sale Price")' +
|
80 'from cgroup_forsale_view' )
|
=> 81 salecounts = self.__db.query(str)
|
82 if salecounts:
|
83 self.__salecounts = salecounts.dictresult()[0]
|
| salecounts undefined, self = <mcls.cattle.web.browsesheet.BrowseSheet instance>, self.__db undefined, str = 'select count(*), min("Sale Price"), max("Sale Price")from cgroup_forsale_view' |
| /usr/lib/python2.7/site-packages/mcls/db/dbbase.py in query(self=<mcls.db.dbbase.DbBase instance>, queryStr='select count(*), min("Sale Price"), max("Sale Price")from cgroup_forsale_view') |
75 def query(self, queryStr):
|
76 """ Alias for stringQuery(). """
|
=> 77 return self.stringQuery(queryStr)
|
78
|
79 def sqlQuery(self, sqlObj, sqlMethod=None):
|
| self = <mcls.db.dbbase.DbBase instance>, self.stringQuery = <bound method DbBase.stringQuery of <mcls.db.dbbase.DbBase instance>>, queryStr = 'select count(*), min("Sale Price"), max("Sale Price")from cgroup_forsale_view' |
| /usr/lib/python2.7/site-packages/mcls/db/dbbase.py in stringQuery(self=<mcls.db.dbbase.DbBase instance>, s='select count(*), min("Sale Price"), max("Sale Price")from cgroup_forsale_view') |
118 listfields() -> tuple of col names
|
119 ntuples() -> int, no. of rows
|
120 """
|
121
|
=> 122 return _connections[self.__connAlias].query(s)
|
| global _connections = {'cattledbGuest': <pg.Connection object>}, self = <mcls.db.dbbase.DbBase instance>, self.__connAlias undefined, s = 'select count(*), min("Sale Price"), max("Sale Price")from cgroup_forsale_view' |
<class 'pg.ProgrammingError'>: ERROR: relation "cgroup_forsale_view" does not exist
LINE 1: ...ount(*), min("Sale Price"), max("Sale Price")from cgroup_for...
^
args =
('ERROR: relation "cgroup_forsale_view" does not ... ^\n',)
message =
'ERROR: relation "cgroup_forsale_view" does not ... ^\n'
sqlstate =
'42P01'