Is this something that worked before? The error appear to be in the new pymysql driver. I do not know what it means but they have a very responsive mailing list (like ours) and perhaps you should also ask them.
Massimo On Dec 18, 12:36 pm, sushanth <sushant...@gmail.com> wrote: > I am using new dal.py file from trunk,but it throws below error > > Traceback (most recent call last): > File "/home/sushanth/web2py/gluon/restricted.py", line 188, in restricted > exec ccode in environment > File "/home/sushanth/web2py/applications/new/models/db.py" > <http://127.0.0.1:8000/admin/default/edit/new/models/db.py>, line 74, in > <module> > Field("status", "string", default='A')) > File "/home/sushanth/web2py/gluon/dal.py", line 3310, in define_table > self._adapter.create_table(t,migrate=migrate, > File "/home/sushanth/web2py/gluon/dal.py", line 525, in create_table > self.create_sequence_and_triggers(query,table) > File "/home/sushanth/web2py/gluon/dal.py", line 1048, in > create_sequence_and_triggers > self.execute(query) > File "/home/sushanth/web2py/gluon/dal.py", line 1055, in execute > return self.log_execute(*a, **b) > File "/home/sushanth/web2py/gluon/dal.py", line 1052, in log_execute > return self.cursor.execute(*a,**b) > File "/home/sushanth/web2py/gluon/contrib/pymysql/cursors.py", line 102, in > execute > self.errorhandler(self, exc, value) > File "/home/sushanth/web2py/gluon/contrib/pymysql/cursors.py", line 97, in > execute > result = self._query(query) > File "/home/sushanth/web2py/gluon/contrib/pymysql/cursors.py", line 179, in > _query > conn.query(q) > File "/home/sushanth/web2py/gluon/contrib/pymysql/connections.py", line > 578, in query > self._affected_rows = self._read_query_result() > File "/home/sushanth/web2py/gluon/contrib/pymysql/connections.py", line > 665, in _read_query_result > result.read() > File "/home/sushanth/web2py/gluon/contrib/pymysql/connections.py", line > 822, in read > self.first_packet = self.connection.read_packet() > File "/home/sushanth/web2py/gluon/contrib/pymysql/connections.py", line > 660, in read_packet > packet.check_error() > File "/home/sushanth/web2py/gluon/contrib/pymysql/connections.py", line > 323, in check_error > raise_mysql_exception(self.__data) > File "/home/sushanth/web2py/gluon/contrib/pymysql/err.py", line 132, in > raise_mysql_exception > _check_mysql_exception(errinfo) > File "/home/sushanth/web2py/gluon/contrib/pymysql/err.py", line 128, in > _check_mysql_exception > raise InternalError, (errno, errorvalue) > InternalError: (1005, u"Can't create table 'geomaster.geo_logistics' (errno: > 150)")
