[web2py] Re: insecure string pickle

[Mirek Zvolský]

I just confirm that this works.
1. (Backup and) delele database/*.table files
2. Into db=DAL(..) command add db=DAL(..., fake_migrate_all=True), then run 
once: app/appadmin/ or some other page
3. Remove fake_migrate_all=..



Dne pátek 8. září 2017 12:24:05 UTC+2 Leonel Câmara napsal(a):
>
> Your problem is caused by the table files. Do a fake migrate.
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Mirek Zvolský]

2.15.3-2017.08.07

I had same here, with SQLite too.

I confirm it can be solved so:
1) rename databases/ to databases_corrupted/
2) create empty folder databases/
3) navigate to appadmin or main page -> database is now empty
4) copy databases_corrupted/sqlite.db back to databases/sqlite.db

or so:
1) remove databases/*.table metadata
2) in models in db=DAL() temporary add db=DAL(..., fake_migrate_all=True)
3) navigate to appadmin or main page -> database is now empty
4) remove fake_migrate_all=True from source code

However in my case this is a localhost copy (localhost backup) of 
production database.
There is no problem in production, but when I copy sqlite.db from 
production to localhost, I will receive "insecure string pickle" again.

Can it be some cross-versions problem of some library, between production 
and localhost?





Dne pátek 4. srpna 2017 18:15:29 UTC+2 Leonel Câmara napsal(a):
>
> This is weird I would just move all table files to a backup migration and 
> do a fake migration to recreate them and see if it solves the problem.
>

-- 
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.

[web2py] Re: insecure string pickle

[Leonel Câmara]

Your problem is caused by the table files. Do a fake migrate.

-- 
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.

Re: [web2py] Re: insecure string pickle

[Wabbajack]

Hi Dave,

I have tried cleaning it in web2py web interface and 
also i have checked using os gui that all files ,folders or subfolders are 
erased...

For now session,errors and cache folders are all clean as suggested... but 
still error exist.. :(

Thanks,
Jak


On Thursday, September 7, 2017 at 1:17:41 AM UTC+8, Dave S wrote:
>
>
>
> On Wednesday, September 6, 2017 at 12:23:50 AM UTC-7, Wabbajack wrote:
>>
>> Hi Kiran,
>>
>> Yes the folders cache, sessions, and error have no file inside...
>> Is there any other way to clear this folders? 
>> I just manually delete all files in each folder..
>> and also i have tried restarting the web2py itself 
>>
>> Still the error exist 
>>
>> Thanks,
>> Jak
>>
>
> You probably noticed that the sessions directory has subfolders, and you 
> made sure these are empty, as well.
> (I would do a rm -r myapp/sessions ... or use a gui to do the same, such 
> as the Files application on Linux,
> or my favorite ... Beyond Compare.)
>
> /dps
>
>
>> On Wednesday, September 6, 2017 at 3:11:36 PM UTC+8, Kiran Subbaraman 
>> wrote:
>>>
>>> You should clear out the following files - sessions / errors / cache 
>>> content - from your 2.9.11 based application
>>>
>>> 
>>> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/
>>>
>>> On 06-Sep-17 10:26 AM, Wabbajack wrote:
>>>
>>> Hi I also go this Error...
>>>
>>> I am running Win7 computer
>>> I used web2py 2.9.11 when i created an app before
>>> with database and etc.
>>>
>>> Now i have new applications running 2.14.6 with no problem also...
>>>
>>> But when i copied the old application created on my previous 
>>> web2py<2.9.11>
>>> into web2py<2.14.6> to pack it all up in one running web2py
>>>
>>> then i got this error specific to applications created on 2.9.11
>>>
>>> I thought it is back compatible with the newer releases...
>>>
>>> Thanks,
>>> Jak
>>>
>>>
>>>
>>> On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry Ermolaev 
>>> wrote: 

 Error ticket for "admin" Ticket ID 

 127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015
  insecure string pickle Версия 
 web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03 
 Python Python 2.7.6: C:\Python27\python.exe (prefix: C:\Python27) 
 Traceback 

 1.
 2.
 3.
 4.
 5.
 6.
 7.
 8.
 9.
 10.
 11.
 12.
 13.
 14.
 15.

 Traceback (most recent call last):
   File "C:\web2py-m\gluon\restricted.py", line 224, in restricted
 exec ccode in environment
   File 
 "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
 line 1945, in 
   File "C:\web2py-m\gluon\globals.py", line 393, in 
 self._caller = lambda f: f()
   File 
 "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
 line 1554, in errors
   File "C:\Python27\lib\pickle.py", line 1378, in load
 return Unpickler(file).load()
   File "C:\Python27\lib\pickle.py", line 858, in load
 dispatch[key](self)
   File "C:\Python27\lib\pickle.py", line 966, in load_string
 raise ValueError, "insecure string pickle"ValueError: insecure string 
 pickle

 Error snapshot [image: help] 
 
  

 (insecure string pickle)

 inspect attributes
 Frames 

- 

*File C:\web2py-m\gluon\restricted.py in restricted at line 224* код
 аргументы переменные
- 

*File 
C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
 in  at line 1945* код
 аргументы переменные
- 

*File C:\web2py-m\gluon\globals.py in  at line 393* код 
аргументы переменные
- 

*File 
C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
 in errors at line 1554* код 
аргументы переменные
- 

*File C:\Python27\lib\pickle.py in load at line 1378* код аргументы 
переменные
- 

*File C:\Python27\lib\pickle.py in load at line 858* код аргументы 
переменные
- 

*File C:\Python27\lib\pickle.py in load_string at line 966* код 
аргументы переменные
Function argument list 

(self=)
Code listing 

961.
962.
963.
964.
965.
966.

967.
968.
969.
970.

def load_string(self):
rep = self.readline()[:-1]
for q in "\"'": # double or single quote
if rep.startswith(q):
if len(rep) < 2 

Re: [web2py] Re: insecure string pickle

[Dave S]

On Wednesday, September 6, 2017 at 12:23:50 AM UTC-7, Wabbajack wrote:
>
> Hi Kiran,
>
> Yes the folders cache, sessions, and error have no file inside...
> Is there any other way to clear this folders? 
> I just manually delete all files in each folder..
> and also i have tried restarting the web2py itself 
>
> Still the error exist 
>
> Thanks,
> Jak
>

You probably noticed that the sessions directory has subfolders, and you 
made sure these are empty, as well.
(I would do a rm -r myapp/sessions ... or use a gui to do the same, such as 
the Files application on Linux,
or my favorite ... Beyond Compare.)

/dps


> On Wednesday, September 6, 2017 at 3:11:36 PM UTC+8, Kiran Subbaraman 
> wrote:
>>
>> You should clear out the following files - sessions / errors / cache 
>> content - from your 2.9.11 based application
>>
>> 
>> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/
>>
>> On 06-Sep-17 10:26 AM, Wabbajack wrote:
>>
>> Hi I also go this Error...
>>
>> I am running Win7 computer
>> I used web2py 2.9.11 when i created an app before
>> with database and etc.
>>
>> Now i have new applications running 2.14.6 with no problem also...
>>
>> But when i copied the old application created on my previous 
>> web2py<2.9.11>
>> into web2py<2.14.6> to pack it all up in one running web2py
>>
>> then i got this error specific to applications created on 2.9.11
>>
>> I thought it is back compatible with the newer releases...
>>
>> Thanks,
>> Jak
>>
>>
>>
>> On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry Ermolaev wrote: 
>>>
>>> Error ticket for "admin" Ticket ID 
>>>
>>> 127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015
>>>  insecure string pickle Версия 
>>> web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03 
>>> Python Python 2.7.6: C:\Python27\python.exe (prefix: C:\Python27) 
>>> Traceback 
>>>
>>> 1.
>>> 2.
>>> 3.
>>> 4.
>>> 5.
>>> 6.
>>> 7.
>>> 8.
>>> 9.
>>> 10.
>>> 11.
>>> 12.
>>> 13.
>>> 14.
>>> 15.
>>>
>>> Traceback (most recent call last):
>>>   File "C:\web2py-m\gluon\restricted.py", line 224, in restricted
>>> exec ccode in environment
>>>   File 
>>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>>> line 1945, in 
>>>   File "C:\web2py-m\gluon\globals.py", line 393, in 
>>> self._caller = lambda f: f()
>>>   File 
>>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>>> line 1554, in errors
>>>   File "C:\Python27\lib\pickle.py", line 1378, in load
>>> return Unpickler(file).load()
>>>   File "C:\Python27\lib\pickle.py", line 858, in load
>>> dispatch[key](self)
>>>   File "C:\Python27\lib\pickle.py", line 966, in load_string
>>> raise ValueError, "insecure string pickle"ValueError: insecure string 
>>> pickle
>>>
>>> Error snapshot [image: help] 
>>> 
>>>  
>>>
>>> (insecure string pickle)
>>>
>>> inspect attributes
>>> Frames 
>>>
>>>- 
>>>
>>>*File C:\web2py-m\gluon\restricted.py in restricted at line 224* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File 
>>>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
>>> in  at line 1945* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File C:\web2py-m\gluon\globals.py in  at line 393* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File 
>>>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
>>> in errors at line 1554* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File C:\Python27\lib\pickle.py in load at line 1378* код аргументы 
>>>переменные
>>>- 
>>>
>>>*File C:\Python27\lib\pickle.py in load at line 858* код аргументы 
>>>переменные
>>>- 
>>>
>>>*File C:\Python27\lib\pickle.py in load_string at line 966* код 
>>>аргументы переменные
>>>Function argument list 
>>>
>>>(self=)
>>>Code listing 
>>>
>>>961.
>>>962.
>>>963.
>>>964.
>>>965.
>>>966.
>>>
>>>967.
>>>968.
>>>969.
>>>970.
>>>
>>>def load_string(self):
>>>rep = self.readline()[:-1]
>>>for q in "\"'": # double or single quote
>>>if rep.startswith(q):
>>>if len(rep) < 2 or not rep.endswith(q):
>>>raise ValueError, "insecure string pickle"
>>>
>>>rep = rep[len(q):-len(q)]
>>>break
>>>else:
>>>raise ValueError, "insecure string pickle"
>>>
>>>Variables 
>>>builtinValueError  
>>>
>>> Context 
>>>
>>> locals request session response
>>> In file: 
>>> C:\web2py-m\applications\admin\compiled\controllers.default.errors.pyc 
>>>
>>> 1.
>>>
>>>  at 072EADA0, file 
>>> 

Re: [web2py] Re: insecure string pickle

[Kiran Subbaraman]

Hello Jak,
Not sure what could be causing the issue, then. Will get back to you if 
I have any useful suggestions.



Kiran Subbaraman
http://subbaraman.wordpress.com/about/

On 06-Sep-17 1:26 PM, Wabbajack wrote:

Hi Kiran,

Yes exactly i have copied a 2.9.11 app into a 2.14.6 web2py 
environment and try to run it...
Also right now i tried removing *.pyc files... anyways i dont have 
much .pyc file... for now i have only deleted __init__.pyc only from 
web2py files


Also i have Clean on the admin interface...
Sstill having the issue...

Thanks,
Jak



On Wednesday, September 6, 2017 at 3:37:09 PM UTC+8, Kiran Subbaraman 
wrote:


Didn't notice it earlier, but the error seems to have been raised
from a 2.9.12 web2py system. So, just to confirm, you have copied
your 2.9.11 app, into a 2.14.6 web2py environment. And trying to
run it from in there.
Also, looks like you had pre-compiled the 2.9.11 app. It is a good
idea to remove all the *.pyc files from in there. And then copy it
into your 2.14.6 environment.

If you were to use the admin interface, then there is a "Clean up
App" ( I don't remember the specific name) option there, which you
could use, before you start running the app.


Kiran Subbaraman
http://subbaraman.wordpress.com/about/


On 06-Sep-17 12:53 PM, Wabbajack wrote:

Hi Kiran,

Yes the folders cache, sessions, and error have no file inside...
Is there any other way to clear this folders?
I just manually delete all files in each folder..
and also i have tried restarting the web2py itself

Still the error exist

Thanks,
Jak

On Wednesday, September 6, 2017 at 3:11:36 PM UTC+8, Kiran
Subbaraman wrote:

You should clear out the following files - sessions / errors
/ cache content - from your 2.9.11 based application


Kiran Subbaraman
http://subbaraman.wordpress.com/about/


On 06-Sep-17 10:26 AM, Wabbajack wrote:

Hi I also go this Error...

I am running Win7 computer
I used web2py 2.9.11 when i created an app before
with database and etc.

Now i have new applications running 2.14.6 with no problem
also...

But when i copied the old application created on my previous
web2py<2.9.11>
into web2py<2.14.6> to pack it all up in one running web2py

then i got this error specific to applications created on 2.9.11

I thought it is back compatible with the newer releases...

Thanks,
Jak



On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry
Ermolaev wrote:


Error ticket for "admin"


  Ticket ID

127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015


 insecure string
pickle


  Версия

web2py™ Version
2.9.12-stable+timestamp.2015.01.17.06.11.03
Python  Python 2.7.6: C:\Python27\python.exe (prefix:
C:\Python27)


  Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.



Traceback(most recent call last): 
File"C:\web2py-m\gluon\restricted.py", line224, in restricted
 exec ccodein environment
   
File"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line1945, in  
File"C:\web2py-m\gluon\globals.py", line393, in  self._caller= lambda f: f() 
File"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line1554, in errors
   File"C:\Python27\lib\pickle.py", line1378, in load
 return Unpickler(file).load() File"C:\Python27\lib\pickle.py", 
line858, in load
 dispatch[key](self) File"C:\Python27\lib\pickle.py", line966, 
in load_string
 raise ValueError, "insecure string pickle" ValueError: 
insecure string pickle


  Error snapshot help
  


|(insecure string pickle)|

inspect attributes


Frames

 *

*File C:\web2py-m\gluon\restricted.py in restricted
at line 224* код аргументы переменные

 *

*File

Re: [web2py] Re: insecure string pickle

[Wabbajack]

Hi Kiran,

Yes exactly i have copied a 2.9.11 app into a 2.14.6 web2py environment and 
try to run it...
Also right now i tried removing *.pyc files... anyways i dont have much 
.pyc file... for now i have only deleted __init__.pyc  only from web2py 
files

Also i have Clean on the admin interface...
Sstill having the issue...

Thanks,
Jak



On Wednesday, September 6, 2017 at 3:37:09 PM UTC+8, Kiran Subbaraman wrote:
>
> Didn't notice it earlier, but the error seems to have been raised from a 
> 2.9.12 web2py system. So, just to confirm, you have copied your 2.9.11 app, 
> into a 2.14.6 web2py environment. And trying to run it from in there.
> Also, looks like you had pre-compiled the 2.9.11 app. It is a good idea to 
> remove all the *.pyc files from in there. And then copy it into your 2.14.6 
> environment.
>
> If you were to use the admin interface, then there is a "Clean up App" ( I 
> don't remember the specific name) option there, which you could use, before 
> you start running the app. 
>
> 
> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/
>
> On 06-Sep-17 12:53 PM, Wabbajack wrote:
>
> Hi Kiran,
>
> Yes the folders cache, sessions, and error have no file inside...
> Is there any other way to clear this folders? 
> I just manually delete all files in each folder..
> and also i have tried restarting the web2py itself 
>
> Still the error exist 
>
> Thanks,
> Jak
>
> On Wednesday, September 6, 2017 at 3:11:36 PM UTC+8, Kiran Subbaraman 
> wrote: 
>>
>> You should clear out the following files - sessions / errors / cache 
>> content - from your 2.9.11 based application
>>
>> 
>> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/
>>
>> On 06-Sep-17 10:26 AM, Wabbajack wrote:
>>
>> Hi I also go this Error...
>>
>> I am running Win7 computer
>> I used web2py 2.9.11 when i created an app before
>> with database and etc.
>>
>> Now i have new applications running 2.14.6 with no problem also...
>>
>> But when i copied the old application created on my previous 
>> web2py<2.9.11>
>> into web2py<2.14.6> to pack it all up in one running web2py
>>
>> then i got this error specific to applications created on 2.9.11
>>
>> I thought it is back compatible with the newer releases...
>>
>> Thanks,
>> Jak
>>
>>
>>
>> On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry Ermolaev wrote: 
>>>
>>> Error ticket for "admin" Ticket ID 
>>>
>>> 127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015
>>>  insecure string pickle Версия 
>>> web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03 
>>> Python Python 2.7.6: C:\Python27\python.exe (prefix: C:\Python27) 
>>> Traceback 
>>>
>>> 1.
>>> 2.
>>> 3.
>>> 4.
>>> 5.
>>> 6.
>>> 7.
>>> 8.
>>> 9.
>>> 10.
>>> 11.
>>> 12.
>>> 13.
>>> 14.
>>> 15.
>>>
>>> Traceback (most recent call last):
>>>   File "C:\web2py-m\gluon\restricted.py", line 224, in restricted
>>> exec ccode in environment
>>>   File 
>>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>>> line 1945, in 
>>>   File "C:\web2py-m\gluon\globals.py", line 393, in 
>>> self._caller = lambda f: f()
>>>   File 
>>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>>> line 1554, in errors
>>>   File "C:\Python27\lib\pickle.py", line 1378, in load
>>> return Unpickler(file).load()
>>>   File "C:\Python27\lib\pickle.py", line 858, in load
>>> dispatch[key](self)
>>>   File "C:\Python27\lib\pickle.py", line 966, in load_string
>>> raise ValueError, "insecure string pickle"ValueError: insecure string 
>>> pickle
>>>
>>> Error snapshot [image: help] 
>>> 
>>>  
>>>
>>> (insecure string pickle)
>>>
>>> inspect attributes
>>> Frames 
>>>
>>>- 
>>>
>>>*File C:\web2py-m\gluon\restricted.py in restricted at line 224* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File 
>>>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
>>> in  at line 1945* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File C:\web2py-m\gluon\globals.py in  at line 393* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File 
>>>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
>>> in errors at line 1554* код 
>>>аргументы переменные
>>>- 
>>>
>>>*File C:\Python27\lib\pickle.py in load at line 1378* код аргументы 
>>>переменные
>>>- 
>>>
>>>*File C:\Python27\lib\pickle.py in load at line 858* код аргументы 
>>>переменные
>>>- 
>>>
>>>*File C:\Python27\lib\pickle.py in load_string at line 966* код 
>>>аргументы переменные
>>>Function argument list 
>>>
>>>(self=)
>>>Code listing 
>>>
>>>961.
>>>962.
>>>963.

Re: [web2py] Re: insecure string pickle

[Kiran Subbaraman]

Didn't notice it earlier, but the error seems to have been raised from a 
2.9.12 web2py system. So, just to confirm, you have copied your 2.9.11 
app, into a 2.14.6 web2py environment. And trying to run it from in there.
Also, looks like you had pre-compiled the 2.9.11 app. It is a good idea 
to remove all the *.pyc files from in there. And then copy it into your 
2.14.6 environment.


If you were to use the admin interface, then there is a "Clean up App" ( 
I don't remember the specific name) option there, which you could use, 
before you start running the app.



Kiran Subbaraman
http://subbaraman.wordpress.com/about/

On 06-Sep-17 12:53 PM, Wabbajack wrote:

Hi Kiran,

Yes the folders cache, sessions, and error have no file inside...
Is there any other way to clear this folders?
I just manually delete all files in each folder..
and also i have tried restarting the web2py itself

Still the error exist

Thanks,
Jak

On Wednesday, September 6, 2017 at 3:11:36 PM UTC+8, Kiran Subbaraman 
wrote:


You should clear out the following files - sessions / errors /
cache content - from your 2.9.11 based application


Kiran Subbaraman
http://subbaraman.wordpress.com/about/


On 06-Sep-17 10:26 AM, Wabbajack wrote:

Hi I also go this Error...

I am running Win7 computer
I used web2py 2.9.11 when i created an app before
with database and etc.

Now i have new applications running 2.14.6 with no problem also...

But when i copied the old application created on my previous
web2py<2.9.11>
into web2py<2.14.6> to pack it all up in one running web2py

then i got this error specific to applications created on 2.9.11

I thought it is back compatible with the newer releases...

Thanks,
Jak



On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry
Ermolaev wrote:


Error ticket for "admin"


  Ticket ID

127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015


 insecure string pickle


  Версия

web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03
Python  Python 2.7.6: C:\Python27\python.exe (prefix:
C:\Python27)


  Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.



Traceback(most recent call last): 
File"C:\web2py-m\gluon\restricted.py", line224, in restricted
 exec ccodein environment
   
File"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line1945, in  
File"C:\web2py-m\gluon\globals.py", line393, in  self._caller= lambda f: f() 
File"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line1554, in errors
   File"C:\Python27\lib\pickle.py", line1378, in load
 return Unpickler(file).load() File"C:\Python27\lib\pickle.py", 
line858, in load
 dispatch[key](self) File"C:\Python27\lib\pickle.py", line966, in 
load_string
 raise ValueError, "insecure string pickle" ValueError: insecure 
string pickle


  Error snapshot help
  


|(insecure string pickle)|

inspect attributes


Frames

 *

*File C:\web2py-m\gluon\restricted.py in restricted at
line 224* код аргументы переменные

 *

*File

C:\web2py-m\applications\admin\compiled\controllers.default.errors.py
 in  at
line 1945* код аргументы переменные

 *

*File C:\web2py-m\gluon\globals.py in  at line
393* код аргументы переменные

 *

*File

C:\web2py-m\applications\admin\compiled\controllers.default.errors.py
 in errors at line
1554* код аргументы переменные

 *

*File C:\Python27\lib\pickle.py in load at line 1378* код
аргументы переменные

 *

*File C:\Python27\lib\pickle.py in load at line 858* код
аргументы переменные

 *

*File C:\Python27\lib\pickle.py in load_string at line
966* код аргументы переменные


  Function argument list

(self=)


  Code listing

961.
962.
963.
964.
965.
966.

967.
968.
969.
970.

 

Re: [web2py] Re: insecure string pickle

[Wabbajack]

Hi Kiran,

Yes the folders cache, sessions, and error have no file inside...
Is there any other way to clear this folders? 
I just manually delete all files in each folder..
and also i have tried restarting the web2py itself 

Still the error exist 

Thanks,
Jak

On Wednesday, September 6, 2017 at 3:11:36 PM UTC+8, Kiran Subbaraman wrote:
>
> You should clear out the following files - sessions / errors / cache 
> content - from your 2.9.11 based application
>
> 
> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/
>
> On 06-Sep-17 10:26 AM, Wabbajack wrote:
>
> Hi I also go this Error...
>
> I am running Win7 computer
> I used web2py 2.9.11 when i created an app before
> with database and etc.
>
> Now i have new applications running 2.14.6 with no problem also...
>
> But when i copied the old application created on my previous web2py<2.9.11>
> into web2py<2.14.6> to pack it all up in one running web2py
>
> then i got this error specific to applications created on 2.9.11
>
> I thought it is back compatible with the newer releases...
>
> Thanks,
> Jak
>
>
>
> On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry Ermolaev wrote: 
>>
>> Error ticket for "admin" Ticket ID 
>>
>> 127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015
>>  insecure string pickle Версия 
>> web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03 
>> Python Python 2.7.6: C:\Python27\python.exe (prefix: C:\Python27) 
>> Traceback 
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>> 12.
>> 13.
>> 14.
>> 15.
>>
>> Traceback (most recent call last):
>>   File "C:\web2py-m\gluon\restricted.py", line 224, in restricted
>> exec ccode in environment
>>   File 
>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>> line 1945, in 
>>   File "C:\web2py-m\gluon\globals.py", line 393, in 
>> self._caller = lambda f: f()
>>   File 
>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>> line 1554, in errors
>>   File "C:\Python27\lib\pickle.py", line 1378, in load
>> return Unpickler(file).load()
>>   File "C:\Python27\lib\pickle.py", line 858, in load
>> dispatch[key](self)
>>   File "C:\Python27\lib\pickle.py", line 966, in load_string
>> raise ValueError, "insecure string pickle"ValueError: insecure string 
>> pickle
>>
>> Error snapshot [image: help] 
>> 
>>  
>>
>> (insecure string pickle)
>>
>> inspect attributes
>> Frames 
>>
>>- 
>>
>>*File C:\web2py-m\gluon\restricted.py in restricted at line 224* код 
>>аргументы переменные
>>- 
>>
>>*File 
>>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
>> in  at line 1945* код 
>>аргументы переменные
>>- 
>>
>>*File C:\web2py-m\gluon\globals.py in  at line 393* код 
>>аргументы переменные
>>- 
>>
>>*File 
>>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
>> in errors at line 1554* код 
>>аргументы переменные
>>- 
>>
>>*File C:\Python27\lib\pickle.py in load at line 1378* код аргументы 
>>переменные
>>- 
>>
>>*File C:\Python27\lib\pickle.py in load at line 858* код аргументы 
>>переменные
>>- 
>>
>>*File C:\Python27\lib\pickle.py in load_string at line 966* код 
>>аргументы переменные
>>Function argument list 
>>
>>(self=)
>>Code listing 
>>
>>961.
>>962.
>>963.
>>964.
>>965.
>>966.
>>
>>967.
>>968.
>>969.
>>970.
>>
>>def load_string(self):
>>rep = self.readline()[:-1]
>>for q in "\"'": # double or single quote
>>if rep.startswith(q):
>>if len(rep) < 2 or not rep.endswith(q):
>>raise ValueError, "insecure string pickle"
>>
>>rep = rep[len(q):-len(q)]
>>break
>>else:
>>raise ValueError, "insecure string pickle"
>>
>>Variables 
>>builtinValueError  
>>
>> Context 
>>
>> locals request session response
>> In file: 
>> C:\web2py-m\applications\admin\compiled\controllers.default.errors.pyc 
>>
>> 1.
>>
>>  at 072EADA0, file 
>> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", 
>> line 3>
>>
>> -- 
> 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+un...@googlegroups.com .
> For more 

Re: [web2py] Re: insecure string pickle

[Kiran Subbaraman]

You should clear out the following files - sessions / errors / cache 
content - from your 2.9.11 based application



Kiran Subbaraman
http://subbaraman.wordpress.com/about/

On 06-Sep-17 10:26 AM, Wabbajack wrote:

Hi I also go this Error...

I am running Win7 computer
I used web2py 2.9.11 when i created an app before
with database and etc.

Now i have new applications running 2.14.6 with no problem also...

But when i copied the old application created on my previous 
web2py<2.9.11>

into web2py<2.14.6> to pack it all up in one running web2py

then i got this error specific to applications created on 2.9.11

I thought it is back compatible with the newer releases...

Thanks,
Jak



On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry Ermolaev wrote:


Error ticket for "admin"


  Ticket ID

127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015


 insecure string pickle


  Версия

web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03
Python  Python 2.7.6: C:\Python27\python.exe (prefix: C:\Python27)


  Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.



Traceback(most recent call last): File"C:\web2py-m\gluon\restricted.py", 
line224, in restricted
 exec ccodein environment
   
File"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line1945, in  
File"C:\web2py-m\gluon\globals.py", line393, in  self._caller= lambda f: f() 
File"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line1554, in errors
   File"C:\Python27\lib\pickle.py", line1378, in load
 return Unpickler(file).load() File"C:\Python27\lib\pickle.py", 
line858, in load
 dispatch[key](self) File"C:\Python27\lib\pickle.py", line966, in 
load_string
 raise ValueError, "insecure string pickle" ValueError: insecure string 
pickle


  Error snapshot help
  


|(insecure string pickle)|

inspect attributes


Frames

 *

*File C:\web2py-m\gluon\restricted.py in restricted at line
224* код аргументы переменные

 *

*File
C:\web2py-m\applications\admin\compiled\controllers.default.errors.py
 in  at line
1945* код аргументы переменные

 *

*File C:\web2py-m\gluon\globals.py in  at line 393*
код аргументы переменные

 *

*File
C:\web2py-m\applications\admin\compiled\controllers.default.errors.py
 in errors at line 1554*
код аргументы переменные

 *

*File C:\Python27\lib\pickle.py in load at line 1378* код
аргументы переменные

 *

*File C:\Python27\lib\pickle.py in load at line 858* код
аргументы переменные

 *

*File C:\Python27\lib\pickle.py in load_string at line 966*
код аргументы переменные


  Function argument list

(self=)


  Code listing

961.
962.
963.
964.
965.
966.

967.
968.
969.
970.



 def load_string(self): rep= self.readline()[:-1] for qin "\"'": # 
double or single quote if rep.startswith(q): if len(rep) < 2 or not rep.endswith(q):
raise ValueError, "insecure string pickle"
rep= rep[len(q):-len(q)] break else: raise ValueError, "insecure string 
pickle"


  Variables

builtinValueError   


Context

locals request session response


  In file:
  C:\web2py-m\applications\admin\compiled\controllers.default.errors.pyc

1.



 at072EADA0, 
file"C:/web2py-m/applications/admin\compiled\controllers.default.errors.py
", line3>

--
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.


--
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] Re: insecure string pickle

[Wabbajack]

Hi I also go this Error...

I am running Win7 computer
I used web2py 2.9.11 when i created an app before
with database and etc.

Now i have new applications running 2.14.6 with no problem also...

But when i copied the old application created on my previous web2py<2.9.11>
into web2py<2.14.6> to pack it all up in one running web2py

then i got this error specific to applications created on 2.9.11

I thought it is back compatible with the newer releases...

Thanks,
Jak



On Tuesday, February 3, 2015 at 12:43:41 PM UTC+8, Dmitry Ermolaev wrote:
>
> Error ticket for "admin"Ticket ID
>
> 127.0.0.1.2015-02-03.07-40-32.4dc31e25-5b8c-4c78-b525-2a58b4ff7015
>  insecure string pickleВерсия
> web2py™ Version 2.9.12-stable+timestamp.2015.01.17.06.11.03
> Python Python 2.7.6: C:\Python27\python.exe (prefix: C:\Python27)Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
> 13.
> 14.
> 15.
>
> Traceback (most recent call last):
>   File "C:\web2py-m\gluon\restricted.py", line 224, in restricted
> exec ccode in environment
>   File 
> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", line 
> 1945, in 
>   File "C:\web2py-m\gluon\globals.py", line 393, in 
> self._caller = lambda f: f()
>   File 
> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", line 
> 1554, in errors
>   File "C:\Python27\lib\pickle.py", line 1378, in load
> return Unpickler(file).load()
>   File "C:\Python27\lib\pickle.py", line 858, in load
> dispatch[key](self)
>   File "C:\Python27\lib\pickle.py", line 966, in load_string
> raise ValueError, "insecure string pickle"
> ValueError: insecure string pickle
>
> Error snapshot [image: help] 
> 
>
> (insecure string pickle)
>
> inspect attributes
> Frames
>
>- 
>
>*File C:\web2py-m\gluon\restricted.py in restricted at line 224* код 
>аргументы переменные
>- 
>
>*File 
>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
> in  at line 1945* код 
>аргументы переменные
>- 
>
>*File C:\web2py-m\gluon\globals.py in  at line 393* код 
>аргументы переменные
>- 
>
>*File 
>C:\web2py-m\applications\admin\compiled\controllers.default.errors.py 
> in errors at line 1554* код 
>аргументы переменные
>- 
>
>*File C:\Python27\lib\pickle.py in load at line 1378* код аргументы 
>переменные
>- 
>
>*File C:\Python27\lib\pickle.py in load at line 858* код аргументы 
>переменные
>- 
>
>*File C:\Python27\lib\pickle.py in load_string at line 966* код 
>аргументы переменные
>Function argument list
>
>(self=)
>Code listing
>
>961.
>962.
>963.
>964.
>965.
>966.
>
>967.
>968.
>969.
>970.
>
>def load_string(self):
>rep = self.readline()[:-1]
>for q in "\"'": # double or single quote
>if rep.startswith(q):
>if len(rep) < 2 or not rep.endswith(q):
>raise ValueError, "insecure string pickle"
>
>rep = rep[len(q):-len(q)]
>break
>else:
>raise ValueError, "insecure string pickle"
>
>Variables
>builtinValueError 
>
> Context
>
> locals request session response
> In file: 
> C:\web2py-m\applications\admin\compiled\controllers.default.errors.pyc
>
> 1.
>
>  at 072EADA0, file 
> "C:/web2py-m/applications/admin\compiled\controllers.default.errors.py", line 
> 3>
>
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Leonel Câmara]

Seth it seems like you did a fake_migrate after setting username=True in 
auth.define_tables. So the username column is not there and the .table file 
says it is.  
  
Set username=False. Do a fake_migrate. Turn fake_migrate=False. Set 
username=True. This will create the column.

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Seth J]

It is Sqlite3 and after following directions in this post to solve the 
"pickle issue" I get the following error with username table.  Am I missing 
something?

 no such column: auth_user.usernameVersion
web2py™ Version 2.15.3-stable+timestamp.2017.08.07.12.51.45
Python Python 2.7.10: C:\Python27\python.exe (prefix: C:\Python27)Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.

Traceback (most recent call last):
  File ".\gluon\restricted.py", line 219, in restricted
exec(ccode, environment)
  File "C:/inetpub/wwwroot/applications/PEDchangeLog/controllers/default.py" 
,
 line 90, in 
  File ".\gluon\globals.py", line 409, in 
self._caller = lambda f: f()
  File "C:/inetpub/wwwroot/applications/PEDchangeLog/controllers/default.py" 
,
 line 41, in user
return dict(form=auth())
  File ".\gluon\tools.py", line 1925, in __call__
return getattr(self, args[0])()
  File ".\gluon\tools.py", line 2704, in login
user = table_user(**{username: entered_username})
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\objects.py", line 566, in 
__call__
orderby_on_limitby=False).first()
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\objects.py", line 2211, in 
select
return adapter.select(self.query, fields, attributes)
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\sqlite.py", line 
82, in select
return super(SQLite, self).select(query, fields, attributes)
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line 
762, in select
return self._select_aux(sql, fields, attributes, colnames)
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line 
718, in _select_aux
rows = self._select_aux_execute(sql)
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line 
712, in _select_aux_execute
self.execute(sql)
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\__init__.py", line 
67, in wrap
return f(*args, **kwargs)
  File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line 
412, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
OperationalError: no such column: auth_user.username

Error snapshot [image: help] 


(no such column: auth_user.username)

On Monday, August 7, 2017 at 4:31:22 PM UTC-4, Dave S wrote:
>
>
>
> On Monday, August 7, 2017 at 1:08:47 PM UTC-7, Seth J wrote:
>>
>> So, the data in those tables is permanently gone?!
>>
>
> No, no ... "table files" describes the METADATA that PyDal uses to 
> interface with the Data Base Engine.  Unless you're using Sqlite3, the 
> actual data isn't even in the application directory, and (for production) 
> not even on the same machine.
>  
> /dps
>
>
>
>> On Friday, August 4, 2017 at 12:15:29 PM UTC-4, Leonel Câmara wrote:
>>>
>>> This is weird I would just move all table files to a backup migration 
>>> and do a fake migration to recreate them and see if it solves the problem.
>>>
>>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Dave S]

On Monday, August 7, 2017 at 1:08:47 PM UTC-7, Seth J wrote:
>
> So, the data in those tables is permanently gone?!
>

No, no ... "table files" describes the METADATA that PyDal uses to 
interface with the Data Base Engine.  Unless you're using Sqlite3, the 
actual data isn't even in the application directory, and (for production) 
not even on the same machine.
 
/dps



> On Friday, August 4, 2017 at 12:15:29 PM UTC-4, Leonel Câmara wrote:
>>
>> This is weird I would just move all table files to a backup migration and 
>> do a fake migration to recreate them and see if it solves the problem.
>>
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Seth J]

So, the data in those tables is permanently gone?!

On Friday, August 4, 2017 at 12:15:29 PM UTC-4, Leonel Câmara wrote:
>
> This is weird I would just move all table files to a backup migration and 
> do a fake migration to recreate them and see if it solves the problem.
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[José Leite]

It solved the problem ... thanks again Leonel

sexta-feira, 4 de Agosto de 2017 às 17:15:29 UTC+1, Leonel Câmara escreveu:
>
> This is weird I would just move all table files to a backup migration and 
> do a fake migration to recreate them and see if it solves the problem.
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Leonel Câmara]

This is weird I would just move all table files to a backup migration and 
do a fake migration to recreate them and see if it solves the problem.

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[José Leite]

The same error appears!
Doesn't solve it...

Error ticket for "HolidayExperience"Ticket ID

192.168.8.100.2017-08-04.16-58-01.7faba99b-7fcd-401e-9153-e8b071880ca4
 insecure string pickleVersão
web2py™ Version 2.15.2-stable+timestamp.2017.07.19.12.18.41
Python Python 2.7.11: C:\Python27\python.exe (prefix: C:\Python27)Traceback

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

Traceback (most recent call last):
  File "C:\web2py\gluon\restricted.py", line 219, in restricted
exec(ccode, environment)
  File "C:/web2py/applications/HolidayExperience/models/db.py" 
, line 60, 
in 
auth.define_tables(username=True, signature=False, migrate=True, 
fake_migrate=True)
  File "C:\web2py\gluon\tools.py", line 2215, in define_tables
super(Auth, self).define_tables(username, signature, migrate, 
fake_migrate)._table_signature_list
  File "C:\web2py\gluon\authapi.py", line 320, in define_tables
format='%(username)s'))
  File "C:\web2py\gluon\packages\dal\pydal\base.py", line 587, in define_table
table = self.lazy_define_table(tablename, *fields, **args)
  File "C:\web2py\gluon\packages\dal\pydal\base.py", line 621, in 
lazy_define_table
polymodel=polymodel)
  File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 795, in 
create_table
return self.migrator.create_table(*args, **kwargs)
  File "C:\web2py\gluon\packages\dal\pydal\migrator.py", line 295, in 
create_table
sql_fields_old = pickle.load(tfile)
  File "C:\Python27\lib\pickle.py", line 1384, in load
return Unpickler(file).load()
  File "C:\Python27\lib\pickle.py", line 864, in load
dispatch[key](self)
  File "C:\Python27\lib\pickle.py", line 972, in load_string
raise ValueError, "insecure string pickle"
ValueError: insecure string pickle


sexta-feira, 4 de Agosto de 2017 às 16:27:46 UTC+1, Leonel Câmara escreveu:
>
> Try just one more thing.
>
> Where you have auth.define_tables(username=True, signature=False)
>
> Put:
>
> auth.define_tables(username=True, signature=False, migrate=True, 
> fake_migrate=True)
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Leonel Câmara]

Try just one more thing.

Where you have auth.define_tables(username=True, signature=False)

Put:

auth.define_tables(username=True, signature=False, migrate=True, 
fake_migrate=True)

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Leonel Câmara]

Try just one more thing

where you declare auth

auth = Auth(db)

try:

auth = Auth(db, migrate=True, fake_migrate=True)

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[José Leite]

But you are right the .table files are corrupted since I can not access 
them from the Admin interface also.

Shall I delete them all? Or what shall I do?

This never happened with installation of previous web2py versions.

:-(

sexta-feira, 4 de Agosto de 2017 às 16:13:33 UTC+1, José Leite escreveu:
>
> Hello Leonel,
>
> I've already done a fake migration and nothing changed.
>
> db = DAL('postgres://postgres:%s@localhost:5432/HolidayExperience' % 
> DEV_DB_PWD, fake_migrate_all=True)
>
> sexta-feira, 4 de Agosto de 2017 às 01:42:41 UTC+1, Leonel Câmara escreveu:
>>
>> It seems your .table files are corrupted. Do a fake migration to rebuild 
>> them.
>>
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Leonel Câmara]

Are you using table files done on another machine or something like that?

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[José Leite]

Hello Leonel,

I've already done a fake migration and nothing changed.

db = DAL('postgres://postgres:%s@localhost:5432/HolidayExperience' % 
DEV_DB_PWD, fake_migrate_all=True)

sexta-feira, 4 de Agosto de 2017 às 01:42:41 UTC+1, Leonel Câmara escreveu:
>
> It seems your .table files are corrupted. Do a fake migration to rebuild 
> them.
>

-- 
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.

[web2py] Re: Insecure string Pickle with web2py 2.15.2

[Leonel Câmara]

It seems your .table files are corrupted. Do a fake migration to rebuild 
them.

-- 
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.

[web2py] Re: insecure string pickle

[Leonel Câmara]

Did you compile the admin app on the same computer this is running in now?

-- 
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.