[Tutor] Operational Error. --HELP

[bijoy franco]

Hi,

When used in psql interface directly, all Database operation queries
works perfectly fine.
Pls find the full code and error below

code:

import pgdb

__metaclass__=type

class addbook:

        conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1')
        curs=conn.cursor()

        def addBook(self):
                name=raw_input("Enter Book Name: ")
                subject=raw_input("Enter Book Subject: ")
                language=raw_input("Enter Book Language: ")
                category=raw_input("Enter Book Category: ")
                author=raw_input("Enter Book Author: ")
                publication=raw_input("Enter Book Publication: ")
                cost=raw_input("Enter Book Cost: ")
                purchasedyear=raw_input("Enter Book Purchased Year: ")

                infunction_curs=self.curs
                infunction_curs.execute('SELECT book_name FROM
table_book WHERE book_name=%s' %name)


        conn.commit()
        conn.close()

def main():
        addbookinstance=addbook()
        addbookinstance.addBook()

if __name__=='__main__':main()

error code:

Traceback (most recent call last):
  File "/home/bijoy/python/secondbooks/secondbooks_main.py", line 44,
in <module>
    if __name__=='__main__':main()
  File "/home/bijoy/python/secondbooks/secondbooks_main.py", line 42, in main
    addbookinstance.addBook()
  File "/home/bijoy/python/secondbooks/secondbooks_main.py", line 24, in addBook
    infunction_curs.execute('SELECT book_name FROM table_book WHERE
book_name=%s' %name)
  File "/usr/lib/python2.5/site-packages/pgdb.py", line 174, in execute
    self.executemany(operation, (params,))
  File "/usr/lib/python2.5/site-packages/pgdb.py", line 197, in executemany
    raise OperationalError, "internal error in '%s': %s" % (sql,err)
pg.OperationalError: internal error in 'SELECT book_name FROM
table_book WHERE book_name=fgfd': error return without exception set



thanks

Bijoy


On Wed, Apr 1, 2009 at 12:20 AM, bob gailer <bgailer at gmail.com> wrote:
>
> bijoy franco wrote:
> >
> > Hi,
> >
> > Python throws OperationalError while trying to do any database operations. I am using pgdb module.
> >
> > Code:
> >
> > import pgdb
> >
> > __metaclass__=type
> >
> > class addbook:
> >
> >         conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1')
> >         curs=conn.cursor()
> >
> >         def addBook(self):
> >
> >                 infunction_curs=self.curs
> >                 infunction_curs.execute('SELECT * FROM table_book')
> >
> >
> > error code:
> >
> > File "/usr/lib/python2.5/site-packages/pgdb.py", line 197, in executemany
> > raise OperationalError, "internal error in '%s': %s" % (sql,err)
> > pg.OperationalError: internal error in 'SELECT * FROM table_book': error return without exception set
> >
> > i am not able to do any database operations apart from opening Conection and assaigning cursor object.
> >
> > how do i solve this. pls help
>
> 1 - please post in plain text - I reformatted it so I could read it.
> 2 - please post the rest of the code and the rest of the traceback so we can see where addbook is instantiated and where addBook is called. It is impossible for me to diagnose this without that information.
> 3 - have you verified in some other way that SELECT * FROM table_book is acceptable to postgresql?
> 4 - please reply to the list
>
> >
> > Thanks in advance
> >
> > Bijoy
> >
>
> Welcome in retrospect.