Czy nie można tego wrzucić na news i do googli ...

[Tomasz "Witek" Wittner]

... a nie robić jakieś badziewiaste wyszukiwarki


--> --> 


search result score

 

the pld linux distribution
 listserver archives



   


 
 
OperationalError
Python 2.2.1: /usr/bin/python2.2
Sat Jan 11 03:06:00 2003


A problem occurred in a Python script. Here is the sequence of function calls 
leading up to the error, in the order they occurred.



 /www/lists.pld/index/s.cgi 


   47 table = "pld"+form["listno"].value
 


   48 
 


   49 askforit(table, form["query"].value, form["listno"].value)
 


   50 
 


   51 #debug on:
 


askforit = <function askforit>, table = 'pld18', form = FieldStorage(None, 
None, [FieldStorage('query', None, 'ssh'), FieldStorage('listno', None, 
'18')]), ].value = [FieldStorage('query', None, 'ssh'), 
FieldStorage('listno', None, '18')]



 /www/lists.pld/index/s.cgi in askforit(table='pld18', query='ssh', mss='18')


   24         kursor = db.cursor()
 


   25         # SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
 


   26         kursor.execute('SELECT author,subject,mss,MATCH (author,subject,body) AGAINST ("%s") AS score FROM %s WHERE MATCH (author,subject,body) AGAINST ("%s") ' % (query, table, query))
 


   27         results = kursor.fetchall()
 


   28         kursor.close()
 


kursor = <MySQLdb.cursors.Cursor instance>, kursor.execute = <bound method 
Cursor.execute of <MySQLdb.cursors.Cursor instance at 0x822731c>>, query = 
'ssh', table = 'pld18'



 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in 
execute(self=<MySQLdb.cursors.Cursor instance>, query='SELECT 
author,subject,mss,MATCH (author,subject,...HERE MATCH (author,subject,body) 
AGAINST ("ssh") ', args=None)


   59         from types import ListType, TupleType
 


   60         if args is None:
 


   61             r = self._query(query)
 


   62         elif type(args) is ListType and type(args[0]) is TupleType:
 


   63             r = self.executemany(query, args) # deprecated
 


r undefined, self = <MySQLdb.cursors.Cursor instance>, self._query = <bound 
method Cursor._query of <MySQLdb.cursors.Cursor instance at 0x822731c>>, 
query = 'SELECT author,subject,mss,MATCH (author,subject,...HERE MATCH 
(author,subject,body) AGAINST ("ssh") '



 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in 
_query(self=<MySQLdb.cursors.Cursor instance>, q='SELECT 
author,subject,mss,MATCH (author,subject,...HERE MATCH (author,subject,body) 
AGAINST ("ssh") ')


  166 
 


  167     def _query(self, q):
 


  168         rowcount = self._BaseCursor__do_query(q)
 


  169         self._rows = self._result and self._fetch_row(0) or ()
 


  170         self._pos = 0
 


rowcount undefined, self = <MySQLdb.cursors.Cursor instance>, 
self._BaseCursor__do_query = <bound method Cursor.__do_query of 
<MySQLdb.cursors.Cursor instance at 0x822731c>>, q = 'SELECT 
author,subject,mss,MATCH (author,subject,...HERE MATCH (author,subject,body) 
AGAINST ("ssh") '



 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in 
__do_query(self=<MySQLdb.cursors.Cursor instance>, q='SELECT 
author,subject,mss,MATCH (author,subject,...HERE MATCH (author,subject,body) 
AGAINST ("ssh") ')


  110         from string import split, atoi
 


  111         db = self._get_db()
 


  112         db.query(q)
 


  113         self._result = self._get_result()
 


  114         self.rowcount = db.affected_rows()
 


db = <open connection to 'mysql.metalab.unc.edu' at 823e5e8>, db.query = 
<built-in method query of connection object>, q = 'SELECT 
author,subject,mss,MATCH (author,subject,...HERE MATCH (author,subject,body) 
AGAINST ("ssh") '


OperationalError: (2000, "Table 'linuxdoc.pld18' doesn't exist") 
      __doc__ = 'Exception raised for errors that are related to ...cation\n 
error occurred during processing, etc.' 
      __getitem__ = <bound method OperationalError.__getitem__ of 
<_...ceptions.OperationalError instance at 0x8202254>> 
      __init__ = <bound method OperationalError.__init__ of 
<_mys...ceptions.OperationalError instance at 0x8202254>> 
      __module__ = '_mysql_exceptions' 
      __str__ = <bound method OperationalError.__str__ of 
<_mysq...ceptions.OperationalError instance at 0x8202254>> 
      args = (2000, "Table 'linuxdoc.pld18' doesn't exist") 	
-- 
Pozdrawiam
Tomasz "Witek" Wittner
***************r-e-k-l-a-m-a**************

Chcesz oszczędzić na kosztach obsługi bankowej ?
mBIZNES - konto dla firm
http://epieniadze.onet.pl/mbiznes