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)")
