Wyszukiwarka pld-lists po raz n-ty ...

[Tomasz "Witek" Wittner]

 ... i n-ta kompromitacja ... . Pisałem już kiedyś na feedback - jak widać bez 
efektu.
 

 --> -->

search result score
 

the pld linux distribution
listserver archives
OperationalError Python 2.2.1: /usr/bin/python2.2
Thu Mar 13 17:33:11 2003
---------------------------
BTW: u mnie jest 23:48 CET
---------------------------
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 = 'pld17', form = FieldStorage(None, 
None, [FieldStorage('query', ...argument"'), FieldStorage('listno', None, 
'17')]), ].value = [FieldStorage('query', None, '"iptables: Invalid 
argument"'), FieldStorage('listno', None, '17')]

 /www/lists.pld/index/s.cgi in askforit(table='pld17', query='"iptables: 
Invalid argument"', mss='17')
   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 0x822cb44>>, query = 
'"iptables: Invalid argument"', table = 'pld17'

 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in 
execute(self=<MySQLdb.cursors.Cursor instance>, query='SELECT 
author,subject,mss,MATCH (author,subject,...t,body) AGAINST (""iptables: 
Invalid argument"") ', 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 0x822cb44>>, 
query = 'SELECT author,subject,mss,MATCH (author,subject,...t,body) AGAINST 
(""iptables: Invalid argument"") '

 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in 
_query(self=<MySQLdb.cursors.Cursor instance>, q='SELECT 
author,subject,mss,MATCH (author,subject,...t,body) AGAINST (""iptables: 
Invalid argument"") ')
  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 0x822cb44>>, q = 'SELECT 
author,subject,mss,MATCH (author,subject,...t,body) AGAINST (""iptables: 
Invalid argument"") '

 /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,...t,body) AGAINST (""iptables: 
Invalid argument"") ')
  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 823e7a0>, db.query = 
<built-in method query of connection object>, q = 'SELECT 
author,subject,mss,MATCH (author,subject,...t,body) AGAINST (""iptables: 
Invalid argument"") '

OperationalError: (2000, 'You have an error in your SQL syntax near 
\'iptables: Invalid argument"") AS score FROM pld17 WHERE MATCH 
(author,subject,bo\' at line 1')
      __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 0x82406ec>>
      __init__ = <bound method OperationalError.__init__ of 
<_mys...ceptions.OperationalError instance at 0x82406ec>>
      __module__ = '_mysql_exceptions'
      __str__ = <bound method OperationalError.__str__ of 
<_mysq...ceptions.OperationalError instance at 0x82406ec>>
      args = (2000, "You have an error in your SQL syntax near 'iptab...M 
pld17 WHERE MATCH (author,subject,bo' at line 1") 

PKP. 
-- 
Tomasz "Witek" Wittner