Same problem as Cesar.
After updating framework earlier capturing by
import MySQLdb
try:
[...]
except MySQLdb.IntegrityError
[...]
stopped working. How do I now catch this exception?
Traceback (most recent call last):
File "/home/[user]/web2py/applications/[app]/models/
Associations.py", line 44, in insert
DB.executesql("INSERT INTO `associations` (`assoc_name`) VALUES
(%s)", (value, ))
File "/home/[user]/web2py/gluon/dal.py", line 3497, in executesql
self._adapter.execute(query, placeholders)
File "/home/[user]/web2py/gluon/dal.py", line 1067, in execute
return self.log_execute(*a, **b)
File "/home/[user]/web2py/gluon/dal.py", line 1064, in log_execute
return self.cursor.execute(*a,**b)
File "/home/[user]/web2py/gluon/contrib/pymysql/cursors.py", line
102, in execute
self.errorhandler(self, exc, value)
File "/home/[user]/web2py/gluon/contrib/pymysql/cursors.py", line
97, in execute
result = self._query(query)
File "/home/[user]/web2py/gluon/contrib/pymysql/cursors.py", line
179, in _query
conn.query(q)
File "/home/[user]/web2py/gluon/contrib/pymysql/connections.py",
line 586, in query
self._affected_rows = self._read_query_result()
File "/home/[user]/web2py/gluon/contrib/pymysql/connections.py",
line 673, in _read_query_result
result.read()
File "/home/[user]/web2py/gluon/contrib/pymysql/connections.py",
line 830, in read
self.first_packet = self.connection.read_packet()
File "/home/[user]/web2py/gluon/contrib/pymysql/connections.py",
line 668, in read_packet
packet.check_error()
File "/home/[user]/web2py/gluon/contrib/pymysql/connections.py",
line 328, in check_error
raise_mysql_exception(self.__data)
File "/home/[user]/web2py/gluon/contrib/pymysql/err.py", line 132,
in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/home/[user]/web2py/gluon/contrib/pymysql/err.py", line 125,
in _check_mysql_exception
raise errorclass, (errno,errorvalue)
IntegrityError: (1062, u"Duplicate entry 'test' for key 'name'")
On 20 Lis 2010, 17:18, CesarBustios <[email protected]> wrote:
> Mmmm i don't have the application right now but i'll let you know as
> soon as possible. I asume that its because of the IS_NOT_IN_DB()
> requirement, i let the application rise the error on purpose so i can
> catch it but i dont know how to do that
>
> mdipierro ha escrito:
>
>
>
> > Can you show us the traceback?
>
> > On Nov 19, 5:52 pm, CesarBustios <[email protected]> wrote:
> > > Hi! Please, how can i catchIntegrityErrorim trying with "from pyodbc
> > > importIntegrityError" but is not working.
>
> > > Thanks!
