MySQL Error

MRAB python at mrabarnett.plus.com
Fri Jan 1 12:10:02 EST 2010


Victor Subervi wrote:
> Hi;
> I'm trying to avoid the mortal sin of blank excepts. I intentionally 
> threw this error:
> 
> Traceback (most recent call last):
>   File "/var/www/html/angrynates.com/cart/createAssociations2.py 
> <http://angrynates.com/cart/createAssociations2.py>", line 137, in ?
>     createAssociations2()
>   File "/var/www/html/angrynates.com/cart/createAssociations2.py 
> <http://angrynates.com/cart/createAssociations2.py>", line 108, in 
> createAssociations2
>     cursor.execute(sql)
>   File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 
> 163, in execute
>     self.errorhandler(self, exc, value)
>   File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 
> 35, in defaulterrorhandler
>     raise errorclass, errorvalue
> ProgrammingError: (1146, "Table 'test.productsAssociations' doesn't exist")
> 
> However, "ProgrammingError" is not an error. How do I discover the real 
> error, so I can write the appropriate except statement?
> 
What makes you think it isn't?

As the traceback says, "Table 'test.productsAssociations' doesn't
exist", and that's the cause.



More information about the Python-list mailing list