[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2021-08-26 Thread pa...@cancamusa.net
It's also important to use fake_migrate_all=True, besides fake_migrate=True and migrate=True. On Thursday, July 29, 2021 at 1:15:11 PM UTC+2 pa...@cancamusa.net wrote: > My problem came from importing a sql database backup. I had to checkout > the version which was used to make that backup, the

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2021-07-29 Thread pa...@cancamusa.net
My problem came from importing a sql database backup. I had to checkout the version which was used to make that backup, then update the code and trust the web2py migrations, which worked, then make a new backup for the test data. Regards -- Resources: - http://web2py.com - http://web2py.com/bo

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2021-07-26 Thread pa...@cancamusa.net
Hello: I'm getting this problem and, like the author, deleting the database folder and fake_migrating did not help. The link to the "the solution provided in this link" above is broken: could anyone please copy and paste it, or link to newer documentation, since that comment from 2014 may not

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-06-05 Thread Mark Li
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.

Re: [web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-03-12 Thread Johann Spies
I do not use mysql but postgresql. I would try the following: * using the database backend export the table to a csv-file * drop the table in the database backend. * remove the table's entry in applications/yourapp/databases (be careful to delete the correct file). Maybe move it to another tempo

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-03-11 Thread sujin870814
In sql.log and database/**.MXPDEVICE.table file has that column info. but when I search in MySQL, MXPDEVICE table doesn't have that column.. What should I do??? Should I drop the table?? T T. 2014년 3월 10일 월요일 오후 3시 58분 29초 UTC+9, sujin...@gmail

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-03-10 Thread Anthony
Looks like the new fields didn't get added to the database. Do you have migrations turned off? On Monday, March 10, 2014 7:56:11 PM UTC-4, sujin...@gmail.com wrote: > > I had made MXPDEVICE table, and I added MXPPCPLATFORM table yesterday. > Then definition of MXPDEVICE changed as below (Red part

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-03-10 Thread sujin870814
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','s

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-03-10 Thread Anthony
Generally helps to show the code and full traceback. On Monday, March 10, 2014 2:58:29 AM UTC-4, sujin...@gmail.com wrote: > > 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 me