Table doesn't exist - in mySQL migrate

[Dmitri Ermolaev]

Error in string:

   format='%(name)s',

db.define_table('systems',

   Field('name', length=25, readable=False, comment='name of tokenized system'),

   Field('from_block', 'integer', comment='block was tested'),

   #migrate=False,

   format='%(name)s',

   )

<class 'gluon.contrib.pymysql.err.ProgrammingError'> (1146, u"Table 'ipay4_free.systems' doesn't exist")

Version

web2py™	Version 2.14.6-stable+timestamp.2016.05.10.00.21.47

Traceback

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23.

Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 227, in restricted exec ccode in environment File "C:/web2py/applications/ipay4_in_free/models/db1.py", line 57, in <module> format='%(name)s', File "C:\web2py\gluon\packages\dal\pydal\base.py", line 834, in define_table table = self.lazy_define_table(tablename,*fields,**args) File "C:\web2py\gluon\packages\dal\pydal\base.py", line 873, in lazy_define_table polymodel=polymodel) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 510, in create_table fake_migrate=fake_migrate File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 623, in migrate_table self.execute(sub_query) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1388, in execute return self.log_execute(*a, **b) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1382, in log_execute ret = self.get_cursor().execute(command, *a[1:], **b) File "C:\web2py\gluon\contrib\pymysql\cursors.py", line 117, in execute self.errorhandler(self, exc, value) File "C:\web2py\gluon\contrib\pymysql\connections.py", line 202, in defaulterrorhandler raise errorclass, errorvalue ProgrammingError: (1146, u"Table 'ipay4_free.systems' doesn't exist")

[Dmitri Ermolaev]

!!! in appconfig I use not boolean - it need in DB!

now all work ))

if myconf.take('db.migrate'):

    migrate = True ## ONLY BOOLEAN!

else:

    migrate = False ## ONLY BOOLEAN!

if myconf.take('db.fake_migrate'):

    fake_migrate = True ## ONLY BOOLEAN!

else:

    fake_migrate = False ## ONLY BOOLEAN!

        db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all'],

                #migrate = Not (Not (myconf.take('db.migrate'))),

                migrate = migrate,

                fake_migrate = fake_migrate,

                )

четверг, 1 марта 2018 г., 14:52:50 UTC+3 пользователь Dmitri Ermolaev написал:

[Massimo Di Pierro]

if you use myconf.get('db.migrate') it will convert "true" and "false" to True and False.

[olorunshola matins]

Traceback (most recent call last):
  File "C:\Users\MATINS\Videos\web2py_src\web2py\applications\PCBS\controllers/appadmin.py", line 249, in select
    nrows = db(query, ignore_common_filters=True).count()
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\packages\dal\pydal\objects.py", line 2265, in count
    return db._adapter.count(self.query, distinct)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py", line 791, in count
    self.execute(self._count(query, distinct))
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line 67, in wrap
    return f(*args, **kwargs)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py", line 413, in execute
    rv = self.cursor.execute(command, *args[1:], **kwargs)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\cursors.py", line 166, in execute
    result = self._query(query)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\cursors.py", line 322, in _query
    conn.query(q)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\connections.py", line 835, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\connections.py", line 1019, in _read_query_result
    result.read()
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\connections.py", line 1302, in read
    first_packet = self.connection._read_packet()
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\connections.py", line 981, in _read_packet
    packet.check_error()
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\connections.py", line 393, in check_error
    err.raise_mysql_exception(self._data)
  File "C:\Users\MATINS\Videos\web2py_src\web2py\gluon\contrib\pymysql\err.py", line 107, in raise_mysql_exception
    raise errorclass(errno, errval)
ProgrammingError: (1146, u"Table 'david_home.auth_group' doesn't exist")