I've had this happen several times, and the solution provided in this link have worked for me.
http://comments.gmane.org/gmane.comp.python.web2py/42344 On Sunday, March 9, 2014 11:58:29 PM UTC-7, sujin...@gmail.com wrote: > > I had made MXPDEVICE table, and I added MXPPCPLATFORM table yesterday. > Then definition of MXPDEVICE changed as below (Red color part). > > ------------------------------------------------------------------------------------------------------------------------- > db.define_table('MXPDEVICE', > Field('NAME','string', notnull=True, label='Device'), > Field('MODEL_NO','string', required=True), > Field('PLATFORM_ID', db.MXPPLATFORM, ondelete='NO ACTION', > required=True, label='Platform'), > Field('PLATFORM_VERSION',required=True), > Field('PC_PLATFORM_ID', db.MXPPCPLATFORM, ondelete='NO ACTION', > required=True, label='PC Platform'), > Field('PC_PLATFORM_VERSION',required=True), > Field('DEVICE_INFO', 'text', required=True), > Field('DEFAULT_TESTER_ID', db.MXPTESTER, required=True, ondelete='NO > ACTION', label = 'Tester'), > Field('DEFAULT_TEST_DEVICE_YN', 'boolean', default=True), > Field('USE_YN', 'boolean', default=True, writable=False, readable = > False ), > Field('CREATED_ON', 'datetime', default=request.now, writable=False > ), > Field('UPDATED_ON', 'datetime', update=request.now, writable=False > )) > > ------------------------------------------------------------------------------------------------------------------------- > > and then I got Error...... > ======================================================================= > Database db select > Traceback > Traceback (most recent call last): > File > "/home/mxptest/web2py/applications/mxpTest/controllers/appadmin.py", line > 270, in select > *fields, limitby=(start, stop)) > File "/home/mxptest/web2py/gluon/dal.py", line 10335, in select > return adapter.select(self.query,fields,attributes) > File "/home/mxptest/web2py/gluon/dal.py", line 1831, in select > return self._select_aux(sql,fields,attributes) > File "/home/mxptest/web2py/gluon/dal.py", line 1796, in _select_aux > self.execute(sql) > File "/home/mxptest/web2py/gluon/dal.py", line 1916, in execute > return self.log_execute(*a, **b) > File "/home/mxptest/web2py/gluon/dal.py", line 1910, in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 166, in > execute > self.errorhandler(self, exc, value) > File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 35, in > defaulterrorhandler > raise errorclass, errorvalue > OperationalError: (1054, "Unknown column 'MXPDEVICE.PC_PLATFORM_ID' in > 'field list'") > ======================================================================= > I thought it's because of migration. > but even though I changed the option, It wasn't solved..... > > Thank you for your answer!! > > > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > > Hi. > I tried adding new columns, but I got that error 1054, "Unknown column in > 'field list'............. > As web2py document > (set fake_migrate=True and after the metadata has been rebuilt, set > fake_migrate=False and migrate the table again).--- I'm using MySQL), I > did it but the problem was not solved. > I searched and tried many things... change migration option, delete .table > file etc... But It didn't work. > > Is anybody who knows solution? Help meeeeeeeeeeee > > Thank you so much!!! :) > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
