from:"Marin"

Well, nothing unusual with my table definitions. Everything by the specs.
I just removed all .table files and started with new sqlite file, and that
problem is gone.
(i still have copies)

Seems that files were stuck in some state.

However, main.message error still confuses me, because sql query that's
created by DAL is valid.
And this happens even after migrations are fixed.

So it's probably SQLite that's broken/corrupted and I'm not sure if those
issues are somehow related.

Marin




On Sun, May 4, 2014 at 8:58 PM, Niphlod niph...@gmail.com wrote:

 how are your table defined ? the fact that 'main.message' gets into the
 error seems a little weird for a table named message_receiver. Also, that
 success repeated into sql.log means that something really strange is
 going on with your migrations.


 On Sunday, May 4, 2014 3:22:19 PM UTC+2, Marin Pranjić wrote:

 To confirm...
 https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1262

 This gets executed on every request.

 However I still don't understand why sqlite fails on insert.

 It fails on testing server but it works on my local instance.

 Marin


  On Sun, May 4, 2014 at 3:13 PM, Marin Pranjić marin@gmail.comwrote:

  Hi.

 I have application hosted on EC2. It is a testing server. It's like
 production environment except it uses SQLite.

 I have a table called message_receiver. When I fetch records (for ex. in
 appadmin) it works, but when I try to insert something (appadmin or in-app)
 i get the following error:

 OperationalError: no such table: main.message



 I got the actual SQL query from the error ticket:



 INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES 
 (NULL,93,1);



 That seems correct.

 However, I noticed that my sql.log is bigger than sqlite database file. It 
 has lots of success! messages inside.
 And it seems that migration for some tables is triggered on every request 
 but nothing changes in .table files.



 There are 6 tables that are affected by migration but I don't see a pattern.

 Can someone suggest how to trace/debug this?

  --
 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 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-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-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] strange problem with DAL

I copied broken database locally so I can test it.
I also added print
herehttps://github.com/web2py/web2py/blob/master/gluon/dal.py#L1353to
get actual queries.

Queries are fine. Actually if I just c/p those queries into SQLite Database
Browser, it works (on the same database file).

So it's not web2py, it's not sqlite, but it doesn't work.

-__-



On Mon, May 5, 2014 at 9:05 AM, Marin Pranjić marin.pran...@gmail.comwrote:

 Well, nothing unusual with my table definitions. Everything by the specs.
 I just removed all .table files and started with new sqlite file, and that
 problem is gone.
 (i still have copies)

 Seems that files were stuck in some state.

 However, main.message error still confuses me, because sql query that's
 created by DAL is valid.
 And this happens even after migrations are fixed.

 So it's probably SQLite that's broken/corrupted and I'm not sure if those
 issues are somehow related.

 Marin




 On Sun, May 4, 2014 at 8:58 PM, Niphlod niph...@gmail.com wrote:

 how are your table defined ? the fact that 'main.message' gets into the
 error seems a little weird for a table named message_receiver. Also, that
 success repeated into sql.log means that something really strange is
 going on with your migrations.


 On Sunday, May 4, 2014 3:22:19 PM UTC+2, Marin Pranjić wrote:

 To confirm...
 https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1262

 This gets executed on every request.

 However I still don't understand why sqlite fails on insert.

 It fails on testing server but it works on my local instance.

 Marin


  On Sun, May 4, 2014 at 3:13 PM, Marin Pranjić marin@gmail.comwrote:

  Hi.

 I have application hosted on EC2. It is a testing server. It's like
 production environment except it uses SQLite.

 I have a table called message_receiver. When I fetch records (for ex.
 in appadmin) it works, but when I try to insert something (appadmin or
 in-app) i get the following error:

 OperationalError: no such table: main.message




 I got the actual SQL query from the error ticket:




 INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES 
 (NULL,93,1);




 That seems correct.

 However, I noticed that my sql.log is bigger than sqlite database file. It 
 has lots of success! messages inside.
 And it seems that migration for some tables is triggered on every request 
 but nothing changes in .table files.




 There are 6 tables that are affected by migration but I don't see a 
 pattern.

 Can someone suggest how to trace/debug this?

  --
 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 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-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-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] Querying Tables from Private Folder

The command written in previous message is meant to be run along with
web2py server, not instead.

If that's what you mean by isolation. Not sure if I understand the question.


Marin



On Sun, May 4, 2014 at 5:35 PM, jaw...@gmail.com wrote:

 Thanks Marin

 Is there any way to tun the script in isolation so that it can detect
 the tables?

 My current setup is that I have the web2py.py server already running and
 then running each Private script in isolation (general web scraping).


 On Sunday, 4 May 2014 09:58:38 UTC+2, Marin Pranjić wrote:

 Tables are in there but if you don't call db.define_table(...) DAL will
 not know about them.

 How are you running the script in private?


 You can do something like this:
 python web2py.py -S appname -M -R applications/appname/private/
 scriptname.py

 This will run your models before running the script, so scriptname.py
 will have access to DAL and everything.
 Of course, this expects table definitions in application's model files.

 Marin


 On Sat, May 3, 2014 at 2:03 PM, jaw...@gmail.com wrote:

  I'm trying to query my tables from the private folder:

 from gluon.tools import DAL

 db = DAL(sqlite://../databases/storage.sqlite)
 print db.tables

 However none of my tables can be seen.

 The idea is to have a better manner of extracting data rather than the
 old-school:

 with sqlite3.connect('../databases/storage.sqlite') as conn:
 c = conn.cursor()
 etc

 What am I missing?

 --
 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 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-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-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] strange problem with DAL

default DAL configuration that is shipped with welcome app.
I also searched for solution but didn't find anything.

sqlite path is fine. There are at least 10 queries in the same transaction
before this one breaks.
i have no idea what's wrong...


On Mon, May 5, 2014 at 11:40 PM, Derek sp1d...@gmail.com wrote:

 What I've read says that you need to specify the full path to the sqlite
 data file or you will get this error. What's your db.py look like?


 On Monday, May 5, 2014 12:31:35 AM UTC-7, Marin Pranjić wrote:

 I copied broken database locally so I can test it.
 I also added print 
 herehttps://github.com/web2py/web2py/blob/master/gluon/dal.py#L1353to get 
 actual queries.

 Queries are fine. Actually if I just c/p those queries into SQLite
 Database Browser, it works (on the same database file).

 So it's not web2py, it's not sqlite, but it doesn't work.

 -__-



 On Mon, May 5, 2014 at 9:05 AM, Marin Pranjić marin@gmail.comwrote:

 Well, nothing unusual with my table definitions. Everything by the specs.
  I just removed all .table files and started with new sqlite file, and
 that problem is gone.
 (i still have copies)

 Seems that files were stuck in some state.

 However, main.message error still confuses me, because sql query that's
 created by DAL is valid.
 And this happens even after migrations are fixed.

 So it's probably SQLite that's broken/corrupted and I'm not sure if
 those issues are somehow related.

 Marin




 On Sun, May 4, 2014 at 8:58 PM, Niphlod nip...@gmail.com wrote:

 how are your table defined ? the fact that 'main.message' gets into the
 error seems a little weird for a table named message_receiver. Also, that
 success repeated into sql.log means that something really strange is
 going on with your migrations.


 On Sunday, May 4, 2014 3:22:19 PM UTC+2, Marin Pranjić wrote:

 To confirm...
 https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1262

 This gets executed on every request.

 However I still don't understand why sqlite fails on insert.

 It fails on testing server but it works on my local instance.

 Marin


  On Sun, May 4, 2014 at 3:13 PM, Marin Pranjić marin@gmail.comwrote:

  Hi.

 I have application hosted on EC2. It is a testing server. It's like
 production environment except it uses SQLite.

 I have a table called message_receiver. When I fetch records (for ex.
 in appadmin) it works, but when I try to insert something (appadmin or
 in-app) i get the following error:

 OperationalError: no such table: main.message






 I got the actual SQL query from the error ticket:






 INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES 
 (NULL,93,1);






 That seems correct.

 However, I noticed that my sql.log is bigger than sqlite database file. 
 It has lots of success! messages inside.
 And it seems that migration for some tables is triggered on every 
 request but nothing changes in .table files.






 There are 6 tables that are affected by migration but I don't see a 
 pattern.

 Can someone suggest how to trace/debug this?

  --
 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 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-users group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to web2py+un...@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-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-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] strange problem with DAL

File can't just dissapear in the middle of transaction :)
And my table is not called main.message anyway.
And it's not blank, I have data stored in there that I can read.
I can't write into one specific table. Other tables work.

Marin

On Tue, May 6, 2014 at 12:21 AM, Derek sp1d...@gmail.com wrote:

well, it will be fine until it can't find the file, creates it again blank.

http://stackoverflow.com/questions/14262771/why-am-i-suddenly-getting-operationalerror-no-such-table

On Monday, May 5, 2014 3:12:31 PM UTC-7, Marin Pranjić wrote:

default DAL configuration that is shipped with welcome app.
I also searched for solution but didn't find anything.

sqlite path is fine. There are at least 10 queries in the same
transaction before this one breaks.
i have no idea what's wrong...

On Mon, May 5, 2014 at 11:40 PM, Derek sp1...@gmail.com wrote:

What I've read says that you need to specify the full path to the sqlite
data file or you will get this error. What's your db.py look like?

On Monday, May 5, 2014 12:31:35 AM UTC-7, Marin Pranjić wrote:

I copied broken database locally so I can test it.
I also added print
herehttps://github.com/web2py/web2py/blob/master/gluon/dal.py#L1353to
get actual queries.

Queries are fine. Actually if I just c/p those queries into SQLite
Database Browser, it works (on the same database file).

So it's not web2py, it's not sqlite, but it doesn't work.

-__-

On Mon, May 5, 2014 at 9:05 AM, Marin Pranjić marin@gmail.comwrote:

Well, nothing unusual with my table definitions. Everything by the
specs.
I just removed all .table files and started with new sqlite file, and
that problem is gone.
(i still have copies)

Seems that files were stuck in some state.

However, main.message error still confuses me, because sql query
that's created by DAL is valid.
And this happens even after migrations are fixed.

So it's probably SQLite that's broken/corrupted and I'm not sure if
those issues are somehow related.

Marin

On Sun, May 4, 2014 at 8:58 PM, Niphlod nip...@gmail.com wrote:

how are your table defined ? the fact that 'main.message' gets into
the error seems a little weird for a table named message_receiver.
Also,
that success repeated into sql.log means that something really strange
is
going on with your migrations.

On Sunday, May 4, 2014 3:22:19 PM UTC+2, Marin Pranjić wrote:

To confirm...
https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1262

This gets executed on every request.

However I still don't understand why sqlite fails on insert.

It fails on testing server but it works on my local instance.

Marin

On Sun, May 4, 2014 at 3:13 PM, Marin Pranjić
marin@gmail.comwrote:

Hi.

I have application hosted on EC2. It is a testing server. It's like
production environment except it uses SQLite.

I have a table called message_receiver. When I fetch records (for
ex. in appadmin) it works, but when I try to insert something
(appadmin or
in-app) i get the following error:

OperationalError: no such table: main.message

I got the actual SQL query from the error ticket:

INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES
(NULL,93,1);

That seems correct.

However, I noticed that my sql.log is bigger than sqlite database
file. It has lots of success! messages inside.
And it seems that migration for some tables is triggered on every
request but nothing changes in .table files.

There are 6 tables that are affected by migration but I don't see a
pattern.

Can someone suggest how to trace/debug this?

--
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 options, visit https://groups.google.com/d/optout.

Re: [web2py] if statement always true in view

You have a typo in there. funciton  should be function.

That's why it always returns None.


Marin


On Sat, May 3, 2014 at 5:15 PM, john smith lukaszbur...@gmail.com wrote:

 Hello!
 I have a problem with 'reddit-clone' app from this tutorial. I'm stuck at
 moment in 2:28:00. My problem is with if statement that is supposed to
 change the button responsible for changing the view.
 For me the condition is always false, even though when printed, the
 request.function shows 'list_posts_by_votes' which is the condition.
 Here is the code:
 {{if request.funciton=='list_posts_by_votes':}}
 {{=A('sort by datetime', _class='btn', _href=URL('list_posts_by_datetime',args
 =category.name))}}
 h3this part never works for me/h3
 {{else:}}
 {{=A('sort by votes', _class='btn', _href=URL('list_posts_by_votes', args=
 category.name))}}
 h3{{=request.function}}/h3
 {{pass}}


 You can find the whole code 
 here:linkhttps://bitbucket.org/badn3wz/reddit_clone/src/8adf342f8683fb7d1f15c073bfee1a13e5d24e21/views/default/list_posts_by_votes.html?at=default

  --
 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-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] Querying Tables from Private Folder

Tables are in there but if you don't call db.define_table(...) DAL will not
know about them.

How are you running the script in private?


You can do something like this:
python web2py.py -S appname -M -R applications/appname/private/scriptname.py

This will run your models before running the script, so scriptname.py will
have access to DAL and everything.
Of course, this expects table definitions in application's model files.

Marin


On Sat, May 3, 2014 at 2:03 PM, jaw...@gmail.com wrote:

 I'm trying to query my tables from the private folder:

 from gluon.tools import DAL

 db = DAL(sqlite://../databases/storage.sqlite)
 print db.tables

 However none of my tables can be seen.

 The idea is to have a better manner of extracting data rather than the
 old-school:

 with sqlite3.connect('../databases/storage.sqlite') as conn:
 c = conn.cursor()
 etc

 What am I missing?

 --
 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-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] Virtual Field not working anymore?

In general, Virtual field will try to calculate it's value. It can fail
(for example, you didn't select all the fields that are needed to do the
calculation, or your calculation is buggy). If it fails, it won't be there.

Which database are you using?

I suspect that .count() returns None and thus it fails on +. But it is
backend-specific, I am not sure.

Marin


On Sun, May 4, 2014 at 6:02 AM, Leonardo Pires Felix 
leona...@piresfelix.com wrote:


 I've created a virtualfield on my table as this:
 db.define_table(alunos,
   SQLField(nome, string, length=255, label=Nome, notnull=True,
 requires=IS_UPPER())
   SQLField(data_nascimento, date, label=Data de
 nascimento,represent=campoDataNascimento, notnull=True),
   SQLField.Virtual('mediaFreq',lambda linha:
 db(db.entrada_cartao_alunos.id_aluno == 
 linha.aluno.id).count()+db(db.faltas_alunos.id_aluno
 == linha.aluno.id).count())
   )
   singular=Aluno,
   plural=Alunos,
   format=%(nome)s)

 And on the smartgrid the virtual field doesn't show.

 I've tried from command line, but:
 Traceback (most recent call last):
   File console, line 1, in module
   File /home/leonardo/domains/homo.com/arquivos/web2py/gluon/dal.py,
 line 7343, in __getitem__
 raise ae
 AttributeError: 'Row' object has no attribute 'mediaFreq'

 But on dir(db.alunos) the virtualfield is there, on db.alunos.fields isn't.
 So, the virtualfield isn't working anymore?

 --
 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-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] Howto deploy web2py on a shared host?

Hi,


It's really hard to tell. You should ask them. How do they setup python
websites?
You have to upload web2py but the issue is how to configure web server.

You only need to configure to your virtual host file but I'm not sure if
they allow that.
Just email them and ask :)

If they support python 2.6 or 2.7 and have mod_wsgi you are able to run
web2py.

Marin


On Sat, May 3, 2014 at 1:28 AM, jansende janusendi...@gmail.com wrote:

 Hi guys,
 I am searching for a web-framework for my website, and are currently
 trying several option.
 I would be interested in using web2py, but I do not have any idea how to
 install it.

 The manual is for servers with ssh access. However I do not have this
 option with my provider.
 The host has apache, python, mod_wsgi, ... already installed. So all what
 should be missing is some configuration and the data.

 What do I have to upload? And what are the important configurations
 missing?

 Greetings
 jansende

 --
 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-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] strange problem with DAL

Hi.

I have application hosted on EC2. It is a testing server. It's like 
production environment except it uses SQLite.

I have a table called message_receiver. When I fetch records (for ex. in 
appadmin) it works, but when I try to insert something (appadmin or in-app) 
i get the following error:

OperationalError: no such table: main.message

I got the actual SQL query from the error ticket:

INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES (NULL,93,1);

That seems correct.

However, I noticed that my sql.log is bigger than sqlite database file. It has 
lots of success! messages inside.
And it seems that migration for some tables is triggered on every request but 
nothing changes in .table files.
There are 6 tables that are affected by migration but I don't see a pattern.

Can someone suggest how to trace/debug this?

-- 
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] strange problem with DAL

To confirm...
https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1262

This gets executed on every request.

However I still don't understand why sqlite fails on insert.

It fails on testing server but it works on my local instance.

Marin


On Sun, May 4, 2014 at 3:13 PM, Marin Pranjić marin.pran...@gmail.comwrote:

 Hi.

 I have application hosted on EC2. It is a testing server. It's like
 production environment except it uses SQLite.

 I have a table called message_receiver. When I fetch records (for ex. in
 appadmin) it works, but when I try to insert something (appadmin or in-app)
 i get the following error:

 OperationalError: no such table: main.message

 I got the actual SQL query from the error ticket:

 INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES (NULL,93,1);

 That seems correct.

 However, I noticed that my sql.log is bigger than sqlite database file. It 
 has lots of success! messages inside.
 And it seems that migration for some tables is triggered on every request but 
 nothing changes in .table files.

 There are 6 tables that are affected by migration but I don't see a pattern.

 Can someone suggest how to trace/debug this?

  --
 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-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] parallel shell cause portal block

2014-04-24 Thread Marin Pranjić

It might be that database is blocking because you never end a transaction.
Do you have db.commit() in your task?

Marin


On Thu, Apr 24, 2014 at 8:58 PM, Manuele Pesenti
manuele.pese...@gmail.comwrote:

 Hi!
 I want to notify a strange behaviour. If I run any kind of parallel
 command, such as calling web2py.py with -K option to run my scheduled
 task or with -S app -M to test manually some function in my
 environment it cause a portal block. The portal will reply again only
 from the moment I kill the parallel process. Any idea??

 Thank you very mutch
 Cheers

 Manuele

 --
 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-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] Admin is disabled because insecure channel error Hosting web2py app on Amazon EC2 Linux server

2014-04-21 Thread Marin Pranjić

http is insecure. you need to use https to access admin app.

Marin (mobile)
On Apr 21, 2014 5:02 AM, Pawan Gupta pawangupt...@gmail.com wrote:

 Hi Everyone

 We are having serious problem with our website 911india.com. We have
 hosted it on Amazon EC2 server and there is a ticket that is issued which
 redirects us to the admin interface that shows Admin is disabled because
 insecure channel

 I tried searching on the website but nothing seems to make sense probably
 because we are somewhat beginners.

 Can someone please help us with what could be done to resolve this.


 Cheers

 Pawan

 --
 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-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] Login ajax component

2014-04-21 Thread Marin Pranjić

This sounds like a bug.

Marin (mobile)
On Apr 18, 2014 9:10 PM, Louis Amon moo...@msn.com wrote:

 I'm trying to build an Ajax-based login form using web2py's LOAD() helper.

 I made a controller named 'users.py', in which I defined a 'signin()'
 function :

 def signin():
 form=auth.login()
 if form.process(formname=None).accepted: #hideerrors=True
 response.flash = 'form accepted'
 print form.vars
 elif form.errors:
 print form.errors
 return dict(login_form=form)


  The corresponding view ('users/signin.load') is as follows:

 h2 class=form-login-sign-up_titleS'identifier/h2
 p class=form-login-sign-up_subtitleJ'ai déjà un compte/p
 {{ =login_form.custom.begin }}
 {{ =login_form.custom.widget.email }}
 {{ =login_form.custom.widget.password }}
 {{ =login_form.custom.end }}


 Now if I go to the url : [...]/users/signin.load, my form displays
 correctly but validation doesn't occur upon submitting the form. It's as
 though the displayed form isn't linked to the one defined in the controller.


 After some research, I found that if I change my view to

 {{=login_form}}


 Then validation occurs correctly. My form isn't customized correctly
 though (obviously).

 Further research indicates that, using the first view, the rendered html
 code actually contains two signatures for the FORM (just before the /form
 tag):

 div style=display:none;
 input name=_next type=hidden value=/
 input name=_formkey type=hidden
 value=c33c0072-ac25-461f-8e37-0ba48cc53dc2
 /div


 And:

 div style=display:none;
 input name=_next type=hidden value=/
 input name=_formkey type=hidden
 value=553bae82-7864-4620-93ee-d54eeea366bf
 input name=_formname type=hidden value=login
 /div



 My guess is that, having two different signatures, web2py gets confused
 about how to manage this form.
 I tried several things like putting formname=None in the process()
 function, but the only way I got my ajax component to work so far is by not
 customizing my form.

 Any workaround ?

 --
 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-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] autodelete(?) on computed field

2014-04-15 Thread Marin Pranjić

Ok, I'll just code it by myself. I was hoping there is better solution.

Marin


On Mon, Apr 14, 2014 at 11:49 AM, Marin Pranjić marin.pran...@gmail.comwrote:

 db.define_table(...,
   Field('image', 'upload', autodelete=True),
   Field('thumbnail', 'upload', autodelete=True, compute=create_thumbnail),
  ...)

 This is not working because on _before_update/_before_delete callbacks
 thumbnail is not one of the upload_fields.
 I am talking about delete_uploaded_files defined inside gluon/dal.py.

 Is there an easier way or I have to manually do the code?

 Marin

 --
 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-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] autodelete(?) on computed field

2014-04-14 Thread Marin Pranjić

db.define_table(...,
  Field('image', 'upload', autodelete=True),
  Field('thumbnail', 'upload', autodelete=True, compute=create_thumbnail),
 ...)

This is not working because on _before_update/_before_delete callbacks 
thumbnail is not one of the upload_fields.
I am talking about delete_uploaded_files defined inside gluon/dal.py.

Is there an easier way or I have to manually do the code?

Marin

-- 
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: Password feild type seems to save in plain text for me.

2014-03-26 Thread Marin Pranjić

This is how auth_user.password is defined internally:

https://github.com/web2py/web2py/blob/master/gluon/tools.py#L1753

is_crypted = CRYPT(key=settings.hmac_key, min_length=settings.
password_min_length)
Field(passfield, 'password', length=512,readable=False, label=self.messages.
label_password,
requires=[is_crypted]),




so, yeah, you need to add CRYPT validator by yourself.

Marin


On Wed, Mar 26, 2014 at 1:14 PM, Encompass solutions encomp...@gmail.comwrote:

 How do I do this?
 And is this how it is don't in db.auth_user?  Cause it's rather confusing
 that it doesn't do this automatically.
 BR,
 Jason Brower


 On Sunday, March 23, 2014 2:24:24 PM UTC+2, Anthony wrote:

 By default, I think password fields only get an IS_LENGTH validator, so
 you'll have to set the CRYPT validator explicitly.

 Anthony

 On Tuesday, March 18, 2014 1:04:54 PM UTC-4, Encompass solutions wrote:

 I am trying to create a model with an encrypted key so it's harder for
 someone to maliciously screw over my customers.
 I have the following snippet.
 Field('public_gram', 'boolean', default=False),
 Field('tag_name', 'list:string'),
 Field('deletion_key', 'password')
 )
 You can see there the deletion_key is a feild type password which I
 understand is hashed out so you can't get the original code.  However, when
 I try to print it I get this...
 test
 CRYPT()(gram_details.deletion_key)
 (gluon.validators.LazyCrypt object at 0x7f56b8305c10, None)
 CRYPT()(gram_details.deletion_key) == gram_details.deletion_key
 False
 Where test is print gram_details.deletion_key
 If this is the case then my password is not very cryptic.
 Am I doing something wrong?
 BR,
 Jason Brower

  --
 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-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] please help testing windows and mac binary

2014-03-20 Thread Marin Pranjić

windows 8.1


C:\Users\Marin\Desktop\web2pyweb2py.exe
Traceback (most recent call last):
  File string, line 6, in module
  File __main__.py, line 128, in module
  File __main__web2py__.py, line 18, in module
  File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 15, in
modu
le
  File /home/mdipierro/make_web2py/web2py/gluon/globals.py, line 21, in
modul
e
  File /home/mdipierro/make_web2py/web2py/gluon/html.py, line 27, in
module
  File HTMLParser.py, line 47, in module
  File re.py, line 190, in compile
  File re.py, line 242, in _compile
sre_constants.error: nothing to repeat


On Thu, Mar 20, 2014 at 5:16 PM, Massimo Di Pierro 
massimo.dipie...@gmail.com wrote:

 problems have been reported with the windows and mac binaries for 2.9.x.

 Can you please help?

 Download the nightly builds:
 http://web2py.com/examples/static/nightly/web2py_win.zip
 http://web2py.com/examples/static/nightly/web2py_osx.zip

 and let us know if they work/do-not-work for you. Which OS version?

 Massimo

 --
 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-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] Password feild type seems to save in plain text for me.

2014-03-18 Thread Marin Pranjić

How did you insert test into database?

If you use db.tablename.insert(..., deletion_key='test') it will store it
plain text because you are bypassing validators.


You should:

1. use .validate_and_insert(...) instead
or
2. use .insert(deletion_key=db.tablename.deletion_key.validate('test'))

If you use SQLFORM(db.tablename...) it will automatically validate (=hash
the password)


Marin


On Tue, Mar 18, 2014 at 6:04 PM, Encompass solutions encomp...@gmail.comwrote:

 I am trying to create a model with an encrypted key so it's harder for
 someone to maliciously screw over my customers.
 I have the following snippet.
 Field('public_gram', 'boolean', default=False),
 Field('tag_name', 'list:string'),
 Field('deletion_key', 'password')
 )
 You can see there the deletion_key is a feild type password which I
 understand is hashed out so you can't get the original code.  However, when
 I try to print it I get this...
 test
 CRYPT()(gram_details.deletion_key)
 (gluon.validators.LazyCrypt object at 0x7f56b8305c10, None)
 CRYPT()(gram_details.deletion_key) == gram_details.deletion_key
 False
 Where test is print gram_details.deletion_key
 If this is the case then my password is not very cryptic.
 Am I doing something wrong?
 BR,
 Jason Brower

  --
 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-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] How to use multiple SQLALL objects in groupby

2014-03-04 Thread Marin Pranjić

I guess I never did it before, which is weird because it looks like usual 
requirement.

I have a DB query where I need to get a join of two tables and aggregate 
from third table.
That means I need to set two tables in groupby.

To describe what *doesn't *work but you'll get the idea what I want:

count = db.table3.id.count()
left = db.table3.on(something)
rows = db(some_query).select(count, db.table1.ALL, db.table2.ALL, left=left, 
*groupby=[db.table1.ALL, 
db.table2.ALL]*)

So the groupby thing is not working and I don't see an easy way to do it. I 
could extract fields from SQLALL object but that's not a way to go. It 
should be easier :)

Marin

-- 
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/groups/opt_out.

Re: [web2py] Re: session security issue?

2014-03-03 Thread Marin Pranjić

Isn't this why session.renew() was added?


On Mon, Mar 3, 2014 at 2:29 PM, Massimo Di Pierro 
massimo.dipie...@gmail.com wrote:

 I will check and release a patch soon. Please do not discuss possible
 security issues on this mailing list. Report them to the developers
 directly.


 On Monday, 3 March 2014 02:06:05 UTC-6, Kiran Subbaraman wrote:

 I see this in 2.9.2 too (Just tested with the latest release)

 On Monday, March 3, 2014 1:25:14 PM UTC+5:30, Kiran Subbaraman wrote:

 Hello,
 I noticed this issue recently related to user session data.
 In my application I store some user specific session data, so that I do
 not have to hit the database everytime (now, am also looking at using
 the cache for that, instead of session).
 If userA is logged into the application, and then userA auth session
 expires, a login screen is presented. In case login is performed with
 userB's credentials, the session data from userA is still available, and
 is displayed on userB's screen.

 I have created a minimal app to demonstrate the issue that I see. Also
 take a look at the screenshots. Notice the session.userdata variable's
 value.
 Tested this on web2py 2.8.2, on Windows 8.

 This is my controller code:
 @auth.requires_login()
 def index():
 ...

  if session['userdata'] is None:
  session.userdata = auth.user.first_name

 I am suspecting this is an issue / bug. Can anyone confirm?
 This issue does not arise, if the user explicitly logs out of a session,
 or the browser window is closed (I have set my browser to clear all
 cookies data when it is closed)

 --

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

  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Re: email on logging in is case sensitive. Is this a good idea?

2014-02-24 Thread Marin Pranjić

It is sensitive by default, and by design:
http://email.about.com/od/emailbehindthescenes/f/email_case_sens.htm

:(


but not by implementation, i don't think anyone is using case sensitive
emails.
I'd like to see the above line in welcome app, as I have it in all my apps.

Marin


On Mon, Feb 24, 2014 at 12:40 PM, peter peterchutchin...@gmail.com wrote:

 Okay I see that this is already attended to by the following setting

 auth.settings.email_case_sensitive = False


 So I guess my comment would be - Wouldn't it be better if the default
 setting is False rather than True.

 Peter

 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] how login_onaccept works ?

2014-02-20 Thread Marin Pranjić

you are calling the function and assigning the return value

use = lambda: check_production(1)
or just = check_production, without (1)

Marin (mobile)
On Feb 21, 2014 12:56 AM, brushek luk...@chrustek.net wrote:

 Hello web2py users and devs,

 I have simple question: does auth.settings.login_onaccept should fire only
 once after login, or it is normal that it is running in every click after
 login ?

 I have folowing code in default.py:

 def check_production(towar=1):
 if not session.auth:
 return
 user_id = str(session.auth.user.id)
 import datetime

 db.produkcja.update_or_insert((db.produkcja.id_field == 2)  (db.
 produkcja.id_user == user_id),end_time = datetime.datetime.now(),id_towaru
 = towar)

 auth.settings.login_onaccept = check_production(1)

 As I can see, the end_time field is updated in database every time I click
 on site (after login). It is correct behavior ? I would to fire this
 function only once, after user login.


 Regards
 brushek

  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Virtual Fields not working on print.

2014-02-19 Thread Marin Pranjić

most likely get_country is failing for some reason

Marin


On Wed, Feb 19, 2014 at 9:40 AM, Jason Brower encomp...@gmail.com wrote:

 I have this in the model...
 import uuid
 import os
 import pygeoip
 gi = pygeoip.GeoIP(os.path.join(request.folder, 'private', 'GeoIP.dat'))
 def get_country(row):
 return gi.country_code_by_addr(row.from_where)
 # -*- coding: utf-8 -*-
 db.define_table('melodigram_play',
 Field('melodigram_id', 'reference melodigram'),
 Field('when_opened', 'datetime', default = request.now),
 Field('from_where', 'string', default = request.client),
 Field.Virtual('from_country', lambda row: get_country(row))
 )
 db.melodigram_play.melodigram_id.requires = IS_NOT_EMPTY()
 db.melodigram_play.when_opened.requires = IS_NOT_EMPTY()

 I can insert data... but when I try to retrieve it, it tells me the row
 doesn't exist:
 h2From: {{=gram_details.from_where}} :
 {{=gram_details.from_country}}/h2
 
 gram_details.from_where has always worked.
 gram_details.from_country doesn't work.


 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Absolute URL issue in PythonAnywhere when using scheduled script

2014-02-15 Thread Marin Pranjić

As explained here:

http://www.web2py.com/books/default/chapter/29/04/the-core#Absolute-urls


You should use:

URL(..., scheme='http', host='www.mysite.com')


Marin


On Sat, Feb 15, 2014 at 4:49 PM, Ykä Marjanen yka.marja...@gmail.comwrote:

 I got the scheduled background script working in PA. The script is started
 in web2py environment with -S app and -M -R parameters. The script
 generates emails, which include links (e.g. registration link with UUID).

 I use scheme=True and host=True to generate absolute URL. This works when
 I generate the emails directly from a website request. But when the
 scheduled script generates it in the background, the URL has local host
 (127.0.0.1) and not the real domain.

 I assume that because I generate the link in a background script, web2py
 instance lives in the local host and doesn't see the outside world (like
 when a website request happens).

 Should I just generate the domain manually, or do I have any better way to
 replace the localhost with the real domain?

 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

[web2py] Single form for many to many relationship

2014-02-14 Thread Oleg Marin

Hi!

I'm looking for solution for nice single SQLFORM for many to many 
relationship. For example I have such model:

db.define_table('person', Field('name'), Field('position'), Field('office', 
'integer'))
db.define_table('thing', Field('name'), Field('color'))
db.define_table('person_thing', Field('person_id', 'reference person'), 
Field('thing_id', 'reference thing'))

And I want to creeate SQLFORM.grid for table person, with insert/update 
form containing list of checkboxes for things, and ability to add new thing 
from that form, like this:

Name:  [Alex]
Poszition: [CEO]
Office:  [13]
Things:
   Thing1   [v]
   Thing2   [  ]
   Thing3   [v]
   (Add new thing button)

Is it possible?

-- 
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/groups/opt_out.

Re: [web2py] Re: [CLOSED] XMLHttpRequest cannot load https://www..... disallowed for cross-origin request ...

2014-02-14 Thread Marin Pranjić

https://groups.google.com/forum/#!topic/web2py/0vqUFdr0cjg


On Tue, Feb 11, 2014 at 7:52 AM, Umed zarrh...@gmail.com wrote:

 why didnt you specify what was a solution


 On Wednesday, December 18, 2013 4:05:43 PM UTC+5, weheh wrote:

 Looks like I got it working. The Apache config file wasn't complete, so
 once I found that issue, the CORS started to function properly. Thanks
 again for your responses.


 On Monday, December 16, 2013 11:16:05 PM UTC+8, Marin Pranjić wrote:

 Well, as I said, try your own jquery.ajax call.

 If it works, then CORS is enabled but component load is failing.
 If it doesn't work, then you didn't enable CORS correctly.

 You should also try $.ajax({crossDomain: true, ...});
 JQuery should add it automatically but maybe it's not detecting it
 properly.


 On Mon, Dec 16, 2013 at 4:12 PM, weheh richard...@verizon.net wrote:

 @Marin: Thanks for your suggestion. I believe that that is precisely
 what is causing this issue. The original call is an HTTP call. It's
 followed by an HTTPS that results in the error message. But still no idea
 how to get the https call to go through.


 On Monday, December 16, 2013 10:45:45 PM UTC+8, Marin Pranjić wrote:

 @weheh can you try a custom jQuery.ajax cross domain call for
 testing/debugging? (just load something from HTTP to HTTPS)

 On Mon, Dec 16, 2013 at 2:38 PM, weheh richard...@verizon.net wrote:

 Hi Anthony, I added CORS stuff to my Apache httpd.conf as per this
 http://enable-cors.org/server_apache.html but I'm still getting the
 same error message. Any ideas about how to push through this?


 On Sunday, December 15, 2013 1:13:55 AM UTC+8, Anthony wrote:

 Is it in fact a cross-origin request, and have you set up CORS on
 the server?

 On Saturday, December 14, 2013 10:39:25 AM UTC-5, weheh wrote:

 I've got a dialog that I pop open and on it is a button that makes
 a web2py_component call. The button code looks like this, after it's 
 gone
 through the XML() helper and jquery UI.

 button class=... onclick=if (confirm('Read?')) {
 web2py_component(quot;https://www.mysite.com/mycontroller/m
 yfunc.load?pc=YGYzlEh6amp;_signature=607e035a239d88bd3ab865
 2814ceff2a9cab92b5quothttps://www.mysite.com/mycontroller/myfunc.load?pc=YGYzlEh6_signature=607e035a239d88bd3ab8652814ceff2a9cab92b5quot;,
 quot;target-divquot;); } role=button aria-disabled=false ...
 /button

 The button works fine when I launch it from my development machine:
 http://127.0.0.1:8000/myapp/...  But, when I migrate the code to
 the server and execute there, I get an error.

 Firebug reports the following:

 XMLHttpRequest cannot load https://www.mysite.com/mycontr
 oller/myfunc.load?pc=YGYzlEh6_signature=https://www.yakitome.com/store/execute.load?pc=HcfnI_pVpid=7qty=1_signature=6c18eb4d880e19d463d85df3f9b02c97b5c8430e
 607e035a239d88bd3ab8652814ceff2a9cab92b5. The request was
 redirected to 'https://www.mysite.com/user/login.load?_next=/
 mycontroller/myfunc.load%https://www.yakitome.com/user/login.load?_next=/store/execute.load%3Fpc%3DHcfnI_pV%26pid%3D7%26qty%3D1
 pc=YGYzlEh6https://www.yakitome.com/store/execute.load?pc=HcfnI_pVpid=7qty=1_signature=6c18eb4d880e19d463d85df3f9b02c97b5c8430e',
 which is disallowed for cross-origin requests that require preflight.


 Anybody have any idea how to deal with this?


  --
 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 options, visit https://groups.google.com/groups/opt_out.


  --
 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 options, visit https://groups.google.com/groups/opt_out.


  --
 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/groups/opt_out.


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

Re: [web2py] Re: Javascript runs locally but not when deployed

2014-02-14 Thread Marin Pranjić

Do you use http or https? What if you try another one?

Marin


On Fri, Feb 14, 2014 at 4:31 PM, Leonel Câmara leonelcam...@gmail.comwrote:

 There are no errors at all on the browser javascript console?

 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Third-party image grabs being redirected...

2014-02-13 Thread Marin Pranjić

Maybe redirection based on request.env.http_referer ?
Not sure if I understood (not a twitter user) but if you give a link to an
actual tweet it may help :)

Marin

On Thu, Feb 13, 2014 at 2:27 PM, Jason Brower encomp...@gmail.com wrote:

 Is there a way to redirect those that try to download an image directly
 to a new location?
 The reason is this...
 If I for example share this:
 https://melodigram.com/gram/20a40890-949c-11e3-97c0-1231390a0101
 on twitter.  I need to give it an image as well to show the product.
 But the image is clickable and goes to just the image and not the cool
 looking view I am working on that has sound added.
 Is there a way to catch the situation when the image is pulled alone and
 then redirect them to the correct location based on that image or url?
 BR,
 Jason Brower

 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Re: Latest thinking -- Bootstrap vs. Foundation?

2014-02-11 Thread Marin Pranjić

At the moment I like Foundation more then any other.
Semantic UI also looks great (and promising).
Bootstrap is still awesome, of course.

Marin


On Tue, Feb 11, 2014 at 3:39 PM, Michele Comitini 
michele.comit...@gmail.com wrote:

 I agree with the article.
 Nothing prevents using Foundation or any other framework on web2py,
 consider bootstrap as a commodity to get your ideas started fast.
 Bootstrap is ubiquitous among developers, because requires less effort,
 IMHO it is the right choice for a welcome app at the moment.
 To get an idea of Foundation in action see Mozilla's sites: they look very
 slick.  Foundation gives top of the notch UX
 designers the power and freedom they need at the expense of readiness to
 use, giving great results in the long run.



 2014-02-11 15:13 GMT+01:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 https://medium.com/frontend-and-beyond/8b3812c7007c


 On Monday, 10 February 2014 23:44:46 UTC-6, weheh wrote:

 I'm trying to catch up with the times and migrate to Bootstrap. The
 latest web2py doc says Bootstrap. But a colleague said to me,
 Foundation. Checking the web2py group shows some users on Foundation.

 Would a few experienced users mind chiming in about which they prefer
 with web2py, Bootstrap or Foundation? Any gotchas either way? Both look
 like they'll do the job. Thanks.

  --
 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/groups/opt_out.


  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

[web2py] Re: binary(1024) field truncates to 255

2014-02-08 Thread Oleg Marin

I'm sorry for long silence, I was busy. I solved my problem. At first, I 
didn't specified TDS version in connection string. Then I found that 
connection string at least for mssql not fully URI-compliant, multiple 
parameters after question sign separating by ;  instead of . I think 
it needs to be added to documentation.

-- 
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/groups/opt_out.

Re: [web2py] Why does redirect() always append '#'?

2014-02-03 Thread Marin Pranjić

We can only guess without seeing the code.

My guess is:

1. redirect doesn't append #, something else does it client side
2. # doesn't break script execution, something else does (probably same
issue that appends #)

Can you check your console for javascript error logs?

Marin


On Mon, Feb 3, 2014 at 3:59 PM, horridohobbyist
horrido.hobb...@gmail.comwrote:

 I have the following added to the end of a view:

 script
 $(function(){

 $(#includedContent).load(/MyApp/static/desc/P+id+_desc.html);
 });
 /script
 div id='includedContent'/div

 This works fine. However, if this page is arrived from a redirect(), the
 URL has a fragment identifier '#' appended. For some reason, this causes
 the script *not* to execute and so I don't get the included content.

 Two questions:

1. Why is the fragment identifier blocking the script?
2. Why is it necessary for redirect() to always append a fragment
identifier? If the fragment identifier is sometimes needed, why can't it be
optional?


 Thanks.

 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

[web2py] Re: binary(1024) field truncates to 255

2014-01-30 Thread Oleg Marin


Web2py example from web-based shell
In [2] : len(seus_db.executesql(exec armSpins ?, ?;, (88,bytearray(b
\x89\xa0H\'\x87\x13GF\xb5\xd6z\xe97\x15i\t)))[0].EVT_CONTENT)
*255*

Pyodbc example from interactive python shell
 cur.execute(exec armSpins ?, ?;, 88, bytearray(b
\x89\xa0H\'\x87\x13GF\xb5\xd6z\xe97\x15i\t) )
pyodbc.Cursor object at 0xb6c57e90
 len(cur.fetchone().EVT_CONTENT)
1024




четверг, 30 января 2014 г., 0:06:10 UTC+4 пользователь Niphlod написал:

 post the code please.
 executesql('abc') just does 

 cursor.execute('abc')
 cursor.fetchall()



 On Wednesday, January 29, 2014 12:55:51 PM UTC+1, Oleg Marin wrote:

 Hi!

 I'm using MSSQL2008 in readonly without tables definition, and when I run 
 stored procedure with executesql, it returns field of type binary(1024) 
 truncated to size of 255. Running same procedure directly with pyodbc works 
 well.  Is it a bug, or something I have missed?



-- 
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/groups/opt_out.

[web2py] binary(1024) field truncates to 255

2014-01-29 Thread Oleg Marin

Hi!

I'm using MSSQL2008 in readonly without tables definition, and when I run 
stored procedure with executesql, it returns field of type binary(1024) 
truncated to size of 255. Running same procedure directly with pyodbc works 
well.  Is it a bug, or something I have missed?

-- 
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/groups/opt_out.

[web2py] MSSQL binary(1024) field truncated to length of 255

2014-01-29 Thread Oleg Marin

Hi!

I'm using MSSQL 2008, and when I run stored procedure with executesql, 
among other it returns field of type binary(1024) truncated to length of  
255.
Pyodbc directly works well. Is it a bug? Or maybe I have missed something?

-- 
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/groups/opt_out.

[web2py] web2py.js disables submit buttons when submitting form with ajax

2014-01-28 Thread Oleg Marin

Hi!

I'm trying to submit form with $.post(), by attaching function handling 
event submit. And when it send ajax request to server some handler from 
web2py.js disables submit button, and changes it's value to Working 
Alright, it is good behavior. But it doesn't re-enable it after ajax 
comletes. What I do wrong, or what need I do to enable form submission 
again?

-- 
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/groups/opt_out.

Re: [web2py] Re: Form input prolem

2014-01-23 Thread Marin Pranjić

INPUT(_name='password', _type='password')

because INPUT(_password='password') is a nonsense.


On Wed, Jan 22, 2014 at 8:14 PM, Lucas Schreiber 
lucas.schreiber.pri...@gmail.com wrote:

 Hi, i thought the form worked good, but unfortunally i was wrong.
 name = form.vars.name contains the data from 'Name', INPUT(_name='name'),
 but
 passwords = form.vars.password is always none

 here again the code, with the improvements:

 def login():
 form = FORM(
 'Name', INPUT(_name='name'),
 'password', INPUT(_password='password'),
 INPUT(_type='submit'))
 if form.process().accepted:
 name = form.vars.
 name
 passwdb = dba(dba.user.name== name).select(dba.user.password).
 first()
 passwords = form.vars.password
 dba.user.insert(name = 'justtest', password= form.vars.name, email
 = form.vars.password, country= form.vars.name)
 if passwdb == passwords:
redirect(URL('index'))
 else:
redirect(URL('register'))

 return dict(form=form)


 Am Sonntag, 19. Januar 2014 19:28:23 UTC+1 schrieb Lucas Schreiber:

 Hi guys,


 i have this function:

 def login():
 form = FORM(
 'Name', INPUT(_name='name'),
 'password', INPUT(_password='password'),
 INPUT(_type='submit'))
 if form.process().accepted:
 name = form.vars.name
 records = SQLTABLE(dba(dba.user.name== name).select(dba.user.
 password),headers='fieldname:capitalize')
 passworddb = records[1]
 password = form.vars.password
 dba.person.insert(name = 'test', email=password)
 if passworddb == password:
redirect(URL('register'))
 else:
redirect(URL('index'))

 return dict(form=form)


 As you can see, you enter name and password into a form, and from a db it
 choose a password correspondending to the username. that part works fine.
 but the problem is on the part:

 password = form.vars.password

 i think this doesnt work, since the line below


 dba.person.insert(name = 'test', email=password)

 inserts into another db test, none

 Do anyone has an idea how to fix this problem? Or can anyone tell me what
 i did wrong?

 Thanks for the help,
 Darren

  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] auth.is_logged_in and @auth.requires_signature() under investigation

2013-12-21 Thread Marin Pranjić

Hello,

I tried to trace down the problem.

If you sign an url on different scheme (http - https) everything works
when opened manually in browser.
But when opening it async, for example using $.ajax, current.session is
empty.
This causes URL.Verify to return False because there is no session.auth
record stored.

CORS requests assign new session ID every time. Why? Because cookies are
not sent.
The jQuery 'fix' is described here:
http://stackoverflow.com/questions/8863571/cors-request-why-are-the-cookies-not-sent

Solution includes adding xhrFields: {withCredentials: true}.

Should this be treated as a bug in JS-part of components load?


Marin


On Sat, Dec 21, 2013 at 3:44 PM, weheh richard_gor...@verizon.net wrote:

 I am dead in the water trying to make an https ajax call from an http
 session. CORS is enabled on server but the web2py_component https URL with
 user_signature=True now triggers an erroneous non-logged-in response to
 auth.is_logged_in() when, in fact, the user is logged in.

 First, thanks to Marin Pranjić's help, I am able to articulate the above
 statement. A little while ago I couldn't have done so.

 The trouble with auth.is_logged_in() is mirrored by an error raised by
 @auth.requires_signature(). In response to an experiment designed by Marin,
 I documented the following:

 If I put the @auth.requires_signature() decorator back into the
 controller and reexecute, I get the Firebug error message:
 XMLHttpRequest cannot load https://www.blah 
 blahhttps://www.yakitome.com/store/checkout.load?pid=1_signature=e5308784ae38c2f5f1a67552b4143bf7b9adeca1.
 The request was redirected to 
 'https://www.mydomain.com/user/login.load?_next=/blah
 blahhttps://www.yakitome.com/user/login.load?_next=/store/checkout.load%3Fpid%3D1',
 which is disallowed for cross-origin requests that require preflight.


 Marin replied,

 As I expected, auth.requires_signature looks broken. Give me some time, I
 am very busy, but I'll try to give you solution.
 Maybe URL.verify instead of decorator.


 Now, I have that auth.is_logged_in() in a critical spot and
 @auth.requires_signature() decorators on many functions that are now
 negatively impacted by this issue. So my sense of urgency is higher than my
 normal constant sense of urgency. I've been stuck on this for many days so
 I think I'm ready to ask for as much help as possible. Please.

 Thank you Marin and the web2py community for all the excellent support.
 Any suggestions about how to proceed, including from Marin, are appreciated.

 --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] auth.is_logged_in and @auth.requires_signature() under investigation

2013-12-21 Thread Marin Pranjić

@weheh, the quick fix would be using custom ajax function instead of using
web2py_component.
It's meant to be used with server-side LOAD helper. Since you can't create
CORS component using LOAD, I'm not sure if web2py_component should work
with CORS either.

So, instead of calling web2py_component, you should write your own
javascript function that, using $.ajax, sends CORS requests and handles it.

Marin


On Sat, Dec 21, 2013 at 4:19 PM, Marin Pranjić marin.pran...@gmail.comwrote:

 Hello,

 I tried to trace down the problem.

 If you sign an url on different scheme (http - https) everything works
 when opened manually in browser.
 But when opening it async, for example using $.ajax, current.session is
 empty.
 This causes URL.Verify to return False because there is no session.auth
 record stored.

 CORS requests assign new session ID every time. Why? Because cookies are
 not sent.
 The jQuery 'fix' is described here:
 http://stackoverflow.com/questions/8863571/cors-request-why-are-the-cookies-not-sent

 Solution includes adding xhrFields: {withCredentials: true}.

 Should this be treated as a bug in JS-part of components load?


 Marin


 On Sat, Dec 21, 2013 at 3:44 PM, weheh richard_gor...@verizon.net wrote:

 I am dead in the water trying to make an https ajax call from an http
 session. CORS is enabled on server but the web2py_component https URL with
 user_signature=True now triggers an erroneous non-logged-in response to
 auth.is_logged_in() when, in fact, the user is logged in.

 First, thanks to Marin Pranjić's help, I am able to articulate the above
 statement. A little while ago I couldn't have done so.

 The trouble with auth.is_logged_in() is mirrored by an error raised by
 @auth.requires_signature(). In response to an experiment designed by Marin,
 I documented the following:

 If I put the @auth.requires_signature() decorator back into the
 controller and reexecute, I get the Firebug error message:
 XMLHttpRequest cannot load https://www.blah 
 blahhttps://www.yakitome.com/store/checkout.load?pid=1_signature=e5308784ae38c2f5f1a67552b4143bf7b9adeca1.
 The request was redirected to 
 'https://www.mydomain.com/user/login.load?_next=/blah
 blahhttps://www.yakitome.com/user/login.load?_next=/store/checkout.load%3Fpid%3D1',
 which is disallowed for cross-origin requests that require preflight.


 Marin replied,

 As I expected, auth.requires_signature looks broken. Give me some time,
 I am very busy, but I'll try to give you solution.
 Maybe URL.verify instead of decorator.


 Now, I have that auth.is_logged_in() in a critical spot and
 @auth.requires_signature() decorators on many functions that are now
 negatively impacted by this issue. So my sense of urgency is higher than my
 normal constant sense of urgency. I've been stuck on this for many days so
 I think I'm ready to ask for as much help as possible. Please.

 Thank you Marin and the web2py community for all the excellent support.
 Any suggestions about how to proceed, including from Marin, are appreciated.

 --
 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/groups/opt_out.




-- 
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/groups/opt_out.

Re: [web2py] Re: XMLHttpRequest cannot load https://www..... disallowed for cross-origin request ...

2013-12-16 Thread Marin Pranjić

@weheh can you try a custom jQuery.ajax cross domain call for
testing/debugging? (just load something from HTTP to HTTPS)

On Mon, Dec 16, 2013 at 2:38 PM, weheh richard_gor...@verizon.net wrote:

 Hi Anthony, I added CORS stuff to my Apache httpd.conf as per this
 http://enable-cors.org/server_apache.html but I'm still getting the same
 error message. Any ideas about how to push through this?


 On Sunday, December 15, 2013 1:13:55 AM UTC+8, Anthony wrote:

 Is it in fact a cross-origin request, and have you set up CORS on the
 server?

 On Saturday, December 14, 2013 10:39:25 AM UTC-5, weheh wrote:

 I've got a dialog that I pop open and on it is a button that makes a
 web2py_component call. The button code looks like this, after it's gone
 through the XML() helper and jquery UI.

 button class=... onclick=if (confirm('Read?')) {
 web2py_component(quot;https://www.mysite.com/mycontroller/
 myfunc.load?pc=YGYzlEh6amp;_signature=607e035a239d88bd3ab8652814ceff
 2a9cab92b5quothttps://www.mysite.com/mycontroller/myfunc.load?pc=YGYzlEh6_signature=607e035a239d88bd3ab8652814ceff2a9cab92b5quot;,
 quot;target-divquot;); } role=button aria-disabled=false ...
 /button

 The button works fine when I launch it from my development machine:
 http://127.0.0.1:8000/myapp/...  But, when I migrate the code to the
 server and execute there, I get an error.

 Firebug reports the following:

 XMLHttpRequest cannot load https://www.mysite.com/
 mycontroller/myfunc.load?pc=YGYzlEh6_signature=https://www.yakitome.com/store/execute.load?pc=HcfnI_pVpid=7qty=1_signature=6c18eb4d880e19d463d85df3f9b02c97b5c8430e
 607e035a239d88bd3ab8652814ceff2a9cab92b5. The request was redirected to
 'https://www.mysite.com/user/login.load?_next=/mycontroller/myfunc.load%https://www.yakitome.com/user/login.load?_next=/store/execute.load%3Fpc%3DHcfnI_pV%26pid%3D7%26qty%3D1
 pc=YGYzlEh6https://www.yakitome.com/store/execute.load?pc=HcfnI_pVpid=7qty=1_signature=6c18eb4d880e19d463d85df3f9b02c97b5c8430e',
 which is disallowed for cross-origin requests that require preflight.


 Anybody have any idea how to deal with this?


  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Re: XMLHttpRequest cannot load https://www..... disallowed for cross-origin request ...

2013-12-16 Thread Marin Pranjić

Well, as I said, try your own jquery.ajax call.

If it works, then CORS is enabled but component load is failing.
If it doesn't work, then you didn't enable CORS correctly.

You should also try $.ajax({crossDomain: true, ...});
JQuery should add it automatically but maybe it's not detecting it properly.


On Mon, Dec 16, 2013 at 4:12 PM, weheh richard_gor...@verizon.net wrote:

 @Marin: Thanks for your suggestion. I believe that that is precisely what
 is causing this issue. The original call is an HTTP call. It's followed by
 an HTTPS that results in the error message. But still no idea how to get
 the https call to go through.


 On Monday, December 16, 2013 10:45:45 PM UTC+8, Marin Pranjić wrote:

 @weheh can you try a custom jQuery.ajax cross domain call for
 testing/debugging? (just load something from HTTP to HTTPS)

 On Mon, Dec 16, 2013 at 2:38 PM, weheh richard...@verizon.net wrote:

 Hi Anthony, I added CORS stuff to my Apache httpd.conf as per this
 http://enable-cors.org/server_apache.html but I'm still getting the
 same error message. Any ideas about how to push through this?


 On Sunday, December 15, 2013 1:13:55 AM UTC+8, Anthony wrote:

 Is it in fact a cross-origin request, and have you set up CORS on the
 server?

 On Saturday, December 14, 2013 10:39:25 AM UTC-5, weheh wrote:

 I've got a dialog that I pop open and on it is a button that makes a
 web2py_component call. The button code looks like this, after it's gone
 through the XML() helper and jquery UI.

 button class=... onclick=if (confirm('Read?')) {
 web2py_component(quot;https://www.mysite.com/mycontroller/m
 yfunc.load?pc=YGYzlEh6amp;_signature=607e035a239d88bd3ab8652814ceff
 2a9cab92b5quothttps://www.mysite.com/mycontroller/myfunc.load?pc=YGYzlEh6_signature=607e035a239d88bd3ab8652814ceff2a9cab92b5quot;,
 quot;target-divquot;); } role=button aria-disabled=false ...
 /button

 The button works fine when I launch it from my development machine:
 http://127.0.0.1:8000/myapp/...  But, when I migrate the code to the
 server and execute there, I get an error.

 Firebug reports the following:

 XMLHttpRequest cannot load https://www.mysite.com/mycontr
 oller/myfunc.load?pc=YGYzlEh6_signature=https://www.yakitome.com/store/execute.load?pc=HcfnI_pVpid=7qty=1_signature=6c18eb4d880e19d463d85df3f9b02c97b5c8430e
 607e035a239d88bd3ab8652814ceff2a9cab92b5. The request was redirected
 to 'https://www.mysite.com/user/login.load?_next=/mycontroller/
 myfunc.load%https://www.yakitome.com/user/login.load?_next=/store/execute.load%3Fpc%3DHcfnI_pV%26pid%3D7%26qty%3D1
 pc=YGYzlEh6https://www.yakitome.com/store/execute.load?pc=HcfnI_pVpid=7qty=1_signature=6c18eb4d880e19d463d85df3f9b02c97b5c8430e',
 which is disallowed for cross-origin requests that require preflight.


 Anybody have any idea how to deal with this?


  --
 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 options, visit https://groups.google.com/groups/opt_out.


  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

Re: [web2py] Re: Error with session when user tries to login

2013-12-14 Thread Marin Pranjić

I deleted all session files and asked the customer to delete cookies. He
even upgraded his browser but was still getting the error.



On Sat, Dec 14, 2013 at 12:33 AM, Massimo Di Pierro 
massimo.dipie...@gmail.com wrote:

 have you deleted all sessions or are you using sessions created with a
 previous version?


 On Friday, 13 December 2013 13:40:18 UTC-6, Marin Pranjić wrote:

 This happens when customer tries to login. I have no idea why it happens
 and it works when I try it on localhost.


 web2py™ Version 2.8.2-stable+timestamp.2013.11.28.07.51.37 PythonPython
 2.7.3: /usr/bin/python (prefix: /usr)

 Traceback

 1.
 2.
 3.
 4.
 5.
 6.
 7.
 8.

 9.
 10.
 11.
 12.
 13.

 Traceback (most recent call last):

   File /home/www-data/web2py/gluon/main.py, line 479, in wsgibase

 session._try_store_in_cookie_or_file(request, response)

   File /home/www-data/web2py/gluon/globals.py, line 1089, in 
 _try_store_in_cookie_or_file

 return self._try_store_in_file(request, response)

   File /home/www-data/web2py/gluon/globals.py, line 1096, in 
 _try_store_in_file

 or self._unchanged(response)):

   File /home/www-data/web2py/gluon/globals.py, line 1041, in _unchanged

 session_pickled = cPickle.dumps(self)

   File /usr/lib/python2.7/copy_reg.py, line 84, in _reduce_ex

 dict = getstate()
 TypeError: 'NoneType' object is not callable


 Any ideas? It's urgent so any suggestion is welcome.

 Marin

  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

[web2py] Error with session when user tries to login

This happens when customer tries to login. I have no idea why it happens 
and it works when I try it on localhost.


web2py™Version 2.8.2-stable+timestamp.2013.11.28.07.51.37PythonPython 2.7.3: 
/usr/bin/python (prefix: /usr)

Traceback

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

Traceback (most recent call last):
  File /home/www-data/web2py/gluon/main.py, line 479, in wsgibase
session._try_store_in_cookie_or_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 1089, in 
_try_store_in_cookie_or_file
return self._try_store_in_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 1096, in 
_try_store_in_file
or self._unchanged(response)):
  File /home/www-data/web2py/gluon/globals.py, line 1041, in _unchanged
session_pickled = cPickle.dumps(self)
  File /usr/lib/python2.7/copy_reg.py, line 84, in _reduce_ex
dict = getstate()
TypeError: 'NoneType' object is not callable


Any ideas? It's urgent so any suggestion is welcome.

Marin

-- 
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/groups/opt_out.

Re: [web2py] Re: Error with session when user tries to login

Ok, let's continue discussion there.

Marin



On Fri, Dec 13, 2013 at 9:16 PM, Leonel Câmara leonelcam...@gmail.comwrote:

 Yes, Lucas and I are having the same problem.
 https://groups.google.com/forum/#!topic/web2py/CSuT_CknD20

 Restarting the webserver temporarily solves the problem for me. Saving
 sessions in db also seems to make the problem take longer to appear.

 For me, it's happening with apache in windows, I've never seen it happen
 with the included rocket server.

 Either way, it's definitely a bug introduced between 2.7 and 2.8, I just
 didn't have the time to look into it properly yet, hopefully one of the
 devs will have time to do it soon.

 What seems to be happening here is that somewhere along the way, an object
 that is not copyable is being saved in the session.

 A potential way to find the bug that I didn't have time to try yet, is to
 define Session __setitem__ and try to cPickle.dumps everything that is put
 there as that should crash instantly and find what's going wrong.


 Sexta-feira, 13 de Dezembro de 2013 19:40:18 UTC, Marin Pranjić escreveu:

 This happens when customer tries to login. I have no idea why it happens
 and it works when I try it on localhost.


 web2py™Version 2.8.2-stable+timestamp.2013.11.28.07.51.37 PythonPython
 2.7.3: /usr/bin/python (prefix: /usr)

 Traceback

 1.
 2.
 3.
 4.
 5.
 6.
 7.
 8.


 9.
 10.
 11.
 12.
 13.

 Traceback (most recent call last):


   File /home/www-data/web2py/gluon/main.py, line 479, in wsgibase


 session._try_store_in_cookie_or_file(request, response)


   File /home/www-data/web2py/gluon/globals.py, line 1089, in 
 _try_store_in_cookie_or_file


 return self._try_store_in_file(request, response)


   File /home/www-data/web2py/gluon/globals.py, line 1096, in 
 _try_store_in_file


 or self._unchanged(response)):


   File /home/www-data/web2py/gluon/globals.py, line 1041, in _unchanged


 session_pickled = cPickle.dumps(self)


   File /usr/lib/python2.7/copy_reg.py, line 84, in _reduce_ex


 dict = getstate()
 TypeError: 'NoneType' object is not callable


 Any ideas? It's urgent so any suggestion is welcome.

 Marin

  --
 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/groups/opt_out.


-- 
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/groups/opt_out.

[web2py] Re: login crash under 2.8.2

I just found this:

https://groups.google.com/forum/#!searchin/web2py/weird$20auth$20error/web2py/jkqyPM5_zaE/Ve5gy7greuoJ
This is version 2.4.5 so it is NOT something introduced in recent version.

I am also privileged to feel the pain that this issue causes in production.

Marin

-- 
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/groups/opt_out.

[web2py] Scheduler - observation