freeform-dev
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Freeform-dev] traceback, trying to make a second reply


From: Jim Crayne
Subject: [Freeform-dev] traceback, trying to make a second reply
Date: Mon, 16 Sep 2002 00:08:42 -0700 (PDT)

i got this traceback when i try to make a second
comment on an article that already had one.


__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
--> --> --> >
 
 
OperationalError
Python 2.2.1: /usr/local/bin/python
Mon Sep 16 03:04:53 2002

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/reply.py
  297          exit()
  298       else: submit(uid,articleid,rate,title,body)
  299    else: submit(0,articleid,0,title,body)
  300    exit()
  301 print 'Content-type: text/html\n\n<HTML><HEAD><TITLE>Freeform Reply CGI</TITLE></HEAD><BODY>End?</BODY></HTML>'
submit = <function submit>, articleid = '2', title = 'Yes the comment did it', body = '... seem to need body to post comment'

 /var/www/reply.py in submit(uid=0, aid='2', rated='0', title='Yes the comment did it', body='... seem to need body to post comment')
   55    else :
   56       while next>0 :
   57          c1.execute('select reply_id, replied_time, next_reply from replies where reply_id='+str(next))
   58          q1=c1.fetchall()
   59          next=q1[0][2]
global c1 = <MySQLdb.cursors.Cursor instance>, c1.execute = <bound method Cursor.execute of <MySQLdb.cursors.Cursor instance at 0x818fc14>>, str undefined, next = 2L

 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in execute(self=<MySQLdb.cursors.Cursor instance>, query='select reply_id, replied_time, next_reply from replies where reply_id=2', 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 0x818fc14>>, query = 'select reply_id, replied_time, next_reply from replies where reply_id=2'

 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in _query(self=<MySQLdb.cursors.Cursor instance>, q='select reply_id, replied_time, next_reply from replies where reply_id=2')
  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 0x818fc14>>, q = 'select reply_id, replied_time, next_reply from replies where reply_id=2'

 /usr/lib/python2.2/site-packages/MySQLdb/cursors.py in __do_query(self=<MySQLdb.cursors.Cursor instance>, q='select reply_id, replied_time, next_reply from replies where reply_id=2')
  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 'localhost' at 818b028>, db.query = <built-in method query of connection object>, q = 'select reply_id, replied_time, next_reply from replies where reply_id=2'

OperationalError: (1054, "Unknown column 'replied_time' in 'field list'")
      __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 0x818f7c4>>
      __init__ = <bound method OperationalError.__init__ of <_mys...ceptions.OperationalError instance at 0x818f7c4>>
      __module__ = '_mysql_exceptions'
      __str__ = <bound method OperationalError.__str__ of <_mysq...ceptions.OperationalError instance at 0x818f7c4>>
      args = (1054, "Unknown column 'replied_time' in 'field list'")


reply via email to

[Prev in Thread] Current Thread [Next in Thread]