[web2py] Re: fake_migration issues

[Dave S]

On Sunday, January 31, 2021 at 3:58:21 PM UTC-8 Dave S wrote:

> On Saturday, January 30, 2021 at 3:32:13 PM UTC-8 valq...@gmail.com wrote:
>
>> try to compare db.py from  "fresh" welcome-app with your app. I have had 
>> a migration problem due to imports changes 
>>
>>
> Thanks!  This wasn't the issue, but you got me looking in the right place 
> ... I had missed migrate_enabled.
>
> There's some followup details for when I have time at the keyboard.
>
>
Briefly, I still get an exception but I think I understand why:   sql.log 
shows that the migration lower-cased all field names, which seems to be 
alright with sqlite, but doesn't seem to do that when I use the field in 
SQLTABLE.   This seems to be a broken backwards compatibility issue; I 
don't remember seeing this in the release notes.

/dps

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ff14c48e-a76c-46f2-845f-abf4227257b6n%40googlegroups.com.

Re: [web2py] Re: fake_migration issues

[António Ramos]

I have started another post with apparently the same problem.
as i have a production app i cant wait much longer so if anyone can help me
professionaly with this please contact me privately.
Regards

Em dom., 31 de jan. de 2021 às 23:58, Dave S 
escreveu:

> On Saturday, January 30, 2021 at 3:32:13 PM UTC-8 valq...@gmail.com wrote:
>
>> try to compare db.py from  "fresh" welcome-app with your app. I have had
>> a migration problem due to imports changes
>>
>>
> Thanks!  This wasn't the issue, but you got me looking in the right place
> ... I had missed migrate_enabled.
>
> There's some followup details for when I have time at the keyboard.
>
> Dave S
> /dps
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/f45054c1-5233-4106-a85b-25556b2e9255n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAEM0BxMxFd7W1t-qG4Hj2-jJ%3D8GKsKUq7FYOan6%3DEUYcMp%3DwTA%40mail.gmail.com.

[web2py] Re: fake_migration issues

[Dave S]

On Saturday, January 30, 2021 at 3:32:13 PM UTC-8 valq...@gmail.com wrote:

> try to compare db.py from  "fresh" welcome-app with your app. I have had a 
> migration problem due to imports changes 
>
>
Thanks!  This wasn't the issue, but you got me looking in the right place 
... I had missed migrate_enabled.

There's some followup details for when I have time at the keyboard.

Dave S
/dps
 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/f45054c1-5233-4106-a85b-25556b2e9255n%40googlegroups.com.

Re: [web2py] Re: fake_migration issues

[Nico Zanferrari]

You are right, I'd completely forgotten these issues...

I've closed them all, because the zip files in the official repository
http://www.web2py.com/init/default/download are fine.
Also, you can easily update the web2py program (and/or pydal) by manually
substituting the source files inside.

Cheers,
Nico

Il giorno dom 31 gen 2021 alle ore 00:17 valq...@gmail.com <
valq7...@gmail.com> ha scritto:

> I dont know, try to ask Nico, since issue is still open
>
> воскресенье, 31 января 2021 г. в 01:45:28 UTC+3, snide...@gmail.com:
>
>> On Saturday, January 30, 2021 at 2:33:37 PM UTC-8 valq...@gmail.com
>> wrote:
>>
>>> Do you use windows binaries? i.e web2py.exe?
>>> https://github.com/web2py/web2py/issues/2300
>>>
>>>
>> That issue is from April , and the exe I'm using is from November.  Are
>> the official ones still broken?
>>
>> /dps
>>
>> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/1ba5a3aa-3393-450d-8b30-a8f552f44452n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAAE8D_DEtG4SiDkxjhvfuUm5JS-A%2BpwUxpYnU8w3m4dQbPk_nw%40mail.gmail.com.

[web2py] Re: fake_migration issues

[valq...@gmail.com]

try to compare db.py from  "fresh" welcome-app with your app. I have had a 
migration problem due to imports changes 

воскресенье, 31 января 2021 г. в 02:22:33 UTC+3, valq...@gmail.com: 

> and this https://git-scm.com/download/win   (portable edition)
>
> воскресенье, 31 января 2021 г. в 02:20:50 UTC+3, valq...@gmail.com: 
>
>> I also used binaries for windows, but now I use this 
>> https://winpython.github.io
>>
>> воскресенье, 31 января 2021 г. в 02:17:52 UTC+3, valq...@gmail.com: 
>>
>>> I dont know, try to ask Nico, since issue is still open
>>>
>>> воскресенье, 31 января 2021 г. в 01:45:28 UTC+3, snide...@gmail.com: 
>>>
 On Saturday, January 30, 2021 at 2:33:37 PM UTC-8 valq...@gmail.com 
 wrote:

> Do you use windows binaries? i.e web2py.exe?
> https://github.com/web2py/web2py/issues/2300
>
>
 That issue is from April , and the exe I'm using is from November.  Are 
 the official ones still broken?

 /dps



-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/964c3042-5e80-44dd-b2dd-a53a004507a6n%40googlegroups.com.

[web2py] Re: fake_migration issues

[valq...@gmail.com]

and this https://git-scm.com/download/win   (portable edition)

воскресенье, 31 января 2021 г. в 02:20:50 UTC+3, valq...@gmail.com: 

> I also used binaries for windows, but now I use this 
> https://winpython.github.io
>
> воскресенье, 31 января 2021 г. в 02:17:52 UTC+3, valq...@gmail.com: 
>
>> I dont know, try to ask Nico, since issue is still open
>>
>> воскресенье, 31 января 2021 г. в 01:45:28 UTC+3, snide...@gmail.com: 
>>
>>> On Saturday, January 30, 2021 at 2:33:37 PM UTC-8 valq...@gmail.com 
>>> wrote:
>>>
 Do you use windows binaries? i.e web2py.exe?
 https://github.com/web2py/web2py/issues/2300


>>> That issue is from April , and the exe I'm using is from November.  Are 
>>> the official ones still broken?
>>>
>>> /dps
>>>
>>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/4c9a2ef3-9fce-4014-8190-6eb66bae6193n%40googlegroups.com.

[web2py] Re: fake_migration issues

[valq...@gmail.com]

I also used binaries for windows, but now I use 
this https://winpython.github.io

воскресенье, 31 января 2021 г. в 02:17:52 UTC+3, valq...@gmail.com: 

> I dont know, try to ask Nico, since issue is still open
>
> воскресенье, 31 января 2021 г. в 01:45:28 UTC+3, snide...@gmail.com: 
>
>> On Saturday, January 30, 2021 at 2:33:37 PM UTC-8 valq...@gmail.com 
>> wrote:
>>
>>> Do you use windows binaries? i.e web2py.exe?
>>> https://github.com/web2py/web2py/issues/2300
>>>
>>>
>> That issue is from April , and the exe I'm using is from November.  Are 
>> the official ones still broken?
>>
>> /dps
>>
>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/9f94da6a-6725-4423-b189-24e9b16e4144n%40googlegroups.com.

[web2py] Re: fake_migration issues

[valq...@gmail.com]

I dont know, try to ask Nico, since issue is still open

воскресенье, 31 января 2021 г. в 01:45:28 UTC+3, snide...@gmail.com: 

> On Saturday, January 30, 2021 at 2:33:37 PM UTC-8 valq...@gmail.com wrote:
>
>> Do you use windows binaries? i.e web2py.exe?
>> https://github.com/web2py/web2py/issues/2300
>>
>>
> That issue is from April , and the exe I'm using is from November.  Are 
> the official ones still broken?
>
> /dps
>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/1ba5a3aa-3393-450d-8b30-a8f552f44452n%40googlegroups.com.

[web2py] Re: fake_migration issues

[Dave S]

On Saturday, January 30, 2021 at 2:33:37 PM UTC-8 valq...@gmail.com wrote:

> Do you use windows binaries? i.e web2py.exe?
> https://github.com/web2py/web2py/issues/2300
>
>
That issue is from April , and the exe I'm using is from November.  Are the 
official ones still broken?

/dps

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/4a6c987e-0e41-4b09-b7ed-ce00445374een%40googlegroups.com.

[web2py] Re: fake_migration issues

[valq...@gmail.com]

Do you use windows binaries? i.e web2py.exe?
https://github.com/web2py/web2py/issues/2300

воскресенье, 31 января 2021 г. в 00:40:21 UTC+3, snide...@gmail.com: 

>
> On Saturday, January 30, 2021 at 11:39:58 AM UTC-8 valq...@gmail.com 
> wrote:
>
>>
>> Did you update pydal?
>
>
> PyDAL is "Version 18.0
> Released on December 27th 2019" 
>
> and installed from the Windows zip file distribution of web2py, Version 
> 2.21.1-stable+timestamp.2020.11.28.04.10.44.
>
> In addtion, I have other apps ported where there are no pydal issues (I 
> don't remember if I migration was needed).  On checking those, I don't see 
> table files there, either, so "no pydal issues" should be read as "no pydal 
> issues causing tickets".
> [One of them does have the "no module named path found" issue for imports 
> in a module]
>
> I find it strange that *anything *works with no table files, and one of 
> the working apps has several define_table() calls, and the 2.14.6 version 
> has about 15 table files when you include the scheduler.  (Haven't tried 
> the scheduler under 2.21.1)
>
> /dps
>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/7d17a87a-54f8-4aa5-ac69-55d0b69b9b1cn%40googlegroups.com.

[web2py] Re: fake_migration issues

[Dave S]

On Saturday, January 30, 2021 at 11:39:58 AM UTC-8 valq...@gmail.com wrote:

>
> Did you update pydal?


PyDAL is "Version 18.0
Released on December 27th 2019" 

and installed from the Windows zip file distribution of web2py, Version 
2.21.1-stable+timestamp.2020.11.28.04.10.44.

In addtion, I have other apps ported where there are no pydal issues (I 
don't remember if I migration was needed).  On checking those, I don't see 
table files there, either, so "no pydal issues" should be read as "no pydal 
issues causing tickets".
[One of them does have the "no module named path found" issue for imports 
in a module]

I find it strange that *anything *works with no table files, and one of the 
working apps has several define_table() calls, and the 2.14.6 version has 
about 15 table files when you include the scheduler.  (Haven't tried the 
scheduler under 2.21.1)

/dps

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/6e8c0e44-d62b-469c-b508-e6cbff70d3e7n%40googlegroups.com.

[web2py] Re: fake_migration issues

[valq...@gmail.com]

Did you update pydal?
суббота, 30 января 2021 г. в 10:11:04 UTC+3, snide...@gmail.com: 

> On Monday, January 25, 2021 at 6:36:23 PM UTC-8 Dave S wrote:
>
>> Porting another (personal) application from my old 2.14.6 environment to 
>> 2.21.1., and copied both the table files and storage.sqlite from the old 
>> application.  Index page works, but another page which displays a sorted 
>> list doesn't.
>
> [...]
>>
> Is this a 2.21.1 issue, or have I rejoined those who bungle migrations?
>>
>
> Clearly the latter, but the help from Jim and Clemens here:
> https://groups.google.com/g/web2py/c/MHNyKxeGEwY>
> looked apropros.
> But even with all 3 values true, I still don't seem to have table files, 
> and I still get the error if there is data found by my query, but no error 
> if rows is empty.
>
> /dps 
>  
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/66be3dbf-16c2-438c-9b95-7334a003d10dn%40googlegroups.com.

[web2py] Re: fake_migration issues

[Dave S]

On Monday, January 25, 2021 at 6:36:23 PM UTC-8 Dave S wrote:

> Porting another (personal) application from my old 2.14.6 environment to 
> 2.21.1., and copied both the table files and storage.sqlite from the old 
> application.  Index page works, but another page which displays a sorted 
> list doesn't.
> [...]
> Is this a 2.21.1 issue, or have I rejoined those who bungle migrations?
>

Clearly the latter, but the help from Jim and Clemens here:
https://groups.google.com/g/web2py/c/MHNyKxeGEwY>
looked apropros.
But even with all 3 values true, I still don't seem to have table files, 
and I still get the error if there is data found by my query, but no error 
if rows is empty.

/dps 
 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/f9deb06d-1516-4cbf-a08c-1c6622e6b177n%40googlegroups.com.

[web2py] Re: fake_migration issues

[Dave S]

On Monday, January 25, 2021 at 6:36:23 PM UTC-8 Dave S wrote:

> Porting another (personal) application from my old 2.14.6 environment to 
> 2.21.1., and copied both the table files and storage.sqlite from the old 
> application.  Index page works, but another page which displays a sorted 
> list doesn't.
>
> Traceback (most recent call last):
> File 
> "C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\gluon\restricted.py", 
> line 219, in restricted
> exec(ccode, environment)
> File 
> "C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\applications\QuarterMaster\views\default/sortedQ.html",
>  
> line 77, in 
> File 
> "C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\gluon\sqlhtml.py", 
> line 3544, in __init__
> "Column %s not found (SQLTABLE)" % colname)
> KeyError: 'Column QuarterMaster.IssueYr not found (SQLTABLE)' 
>  
>
> A cmd window running sqlite.exe verifies the schema of the table is 
> correct in the db (as expected), and entries made from the index page are 
> showing up.
>
> I delete the table files, set fake_migrate_all = True, and ... lather, 
> rinse .. index works, the table list doesn't, same exception.  And the 
> table files don't get created.
> Add migrate=True to the table definition ... lather, rinse. prior videre.
> Change "fake_migrate_all=True to migrate=False,fake_migrate=True ... 
> lather, rinse, p.v.
>
> Is this a 2.21.1 issue, or have I rejoined those who bungle migrations?
>
>
No suggestions?

/dps
 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/b9891cfb-fa86-4942-aaa5-8385be5e0f92n%40googlegroups.com.