I had made MXPDEVICE table, and I added MXPPCPLATFORM table yesterday.
Then definition of MXPDEVICE changed as below (Red 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 <https://165.243.187.146:8084/mxpTest/appadmin/index> 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!!
2014년 3월 10일 월요일 오후 3시 58분 29초 UTC+9, sujin...@gmail.com 님의 말:
>
> 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.
