[web2py] Re: Mail.send failure

2015-06-14 Thread webpypy
trying another email account (hotmail , with only one dot)
and switching between port numbers 25 , 465

will switch between two errors :

error 10013
An attempt was made to access a socket in a way forbidden by its access 
permissions.

and 

error 10060
A connection attempt failed because the connected party did not properly 
respond after a period of time, or established connection failed because 
connected host has failed to respond.

where is the problem?

On Sunday, June 14, 2015 at 6:26:00 AM UTC+3, webpypy wrote:

 Hi :

 I got the error

 error 10013
 An attempt was made to access a socket in a way forbidden by its access 
 permissions.

 what is the cause?

 sender is in the format x.y...@gmail.com ( I mean there are two 
 dots). Is this a problem?

 Regards,

 Ashraf

  


-- 
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: avoid separate query within second nested loop

2015-06-14 Thread Niphlod
sorry what ?

On Friday, June 12, 2015 at 11:35:49 PM UTC+2, Alex Glaros wrote:

 are there file size limitations when moving to dict that are not an issue 
 if python loop?


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: blob type crop data

2015-06-14 Thread Niphlod
you're correct. web2py handles blob types and 'upload' Fields in its own 
way. You'd have to resort to either a full migration to another table or to 
access the data using raw sql statements.

On Saturday, June 13, 2015 at 5:20:06 AM UTC+2, Viktor Boiarchuk wrote:

 Hello everybody!
 Nice to meet so excellent community.

 My problem is next. I'm trying to use web2py with *external* sqlite 
 database formed by another program. One of the column of those database 
 consists of binary data of pdf docs. So I defined that field in model 
 *Field('pdf_binary','blob')*. I'm using SQLFORM.grid to modify my table 
 (not blob column). When I submit changes they are accepted but data in 
 'pdf_binary' become corrupted (it seems it has just begging of file data).

 Moreover when I try to extract binary data from blob field I also get just 
 part of data, but when I change field type to 'text' for e.g. ,
 *Field('pdf_binary','text')* I can extract normal data, but in this case 
 I get the query contains a null character error when i try to submit 
 changes in SQLFORM.
 I can't use upload field, because my binaries was made by another program 
 and it also raises errors when updating db.
 It seems that blob type is right choice for my aims, but it doesn't worked 
 I predicted.

 I will be thankful for all advices.
 Regard
 Viktor


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Scheduler Question

2015-06-14 Thread Niphlod
seems that the function that goes into timeout leaves zombie processes 
behind. What are you doing in that function ?

On Friday, June 12, 2015 at 11:56:09 PM UTC+2, Michael Gheith wrote:

 Hmmm.  Looking in the database, I have 21 TIMEOUTS which corresponds to 
 the 21 workers with all the same process ID of 10978... a red herring?


 $ pstree -p 10978

 python(10978)─┬─python(1719)

   ├─python(2063)

   ├─python(2977)

   ├─python(5383)

   ├─python(8176)

   ├─python(11013)

   ├─python(11069)

   ├─python(11521)

   ├─python(14466)

   ├─python(14490)

   ├─python(15190)

   ├─python(16210)

   ├─python(17019)

   ├─python(20546)

   ├─python(27816)

   ├─python(27882)

   ├─python(28702)

   ├─python(29459)

   ├─python(30343)

   ├─python(32193)

   └─{python}(10993)


 On Friday, June 12, 2015 at 3:49:12 PM UTC-5, Niphlod wrote:

 inspect the log to see why another worker gets started. Each worker 
 started can result AT MOST as two processes, the worker itself and the 
 process that actually executes the task.

 On Friday, June 12, 2015 at 10:36:35 PM UTC+2, Michael Gheith wrote:

 I have an application that uses the scheduler.  It runs really good, 
 however I noticed odd behavior which I don't think is normal.

 When I launch a worker thread (just one) with the following everything 
 works great: 
 python web2py.py -K myapp

 A few days later I will come back to the node that the application is 
 running on, and will run the following to see my web2py processes:
 pgrep -fl web2py

 and I will get something like the following:

 11013 python web2py.py -K myapp

 11069 python web2py.py -K myapp

 11521 python web2py.py -K myapp

 14466 python web2py.py -K myapp

 14490 python web2py.py -K myapp

 15190 python web2py.py -K myapp

 16210 python web2py.py -K myapp

 17019 python web2py.py -K myapp


 Why am I getting more than one of these processes?  I should just have 
 one, right?  Is this a bug, or normal behavior?  Please advise, 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/d/optout.


[web2py] Re: Select multiple rows

2015-06-14 Thread Limedrop
Try something like this:

rows = db(db.cikmis_soru.id.belongs(ids)).select()


On Monday, 15 June 2015 07:13:02 UTC+12, xmarx wrote:

 Hi.

 I want to select a list of id from database.

 ids=[12,145,69]

 how can i do this? Is there any quick way of it?

 for example:

 query=
 for i in ids:
 if not i==ids[-1]:
 query+=(db.cikmis_soru.id==+i+)
 else:
 query+=(db.cikmis_soru.id==+i+)

 rows=db(query).select()



 i get an error: SyntaxError: Set: no tables selected

 Thanks all.
  

-- 
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: avoid separate query within second nested loop

2015-06-14 Thread Alex Glaros
is there a size limitation to a dictionary? (want to know in general for 
future purposes)

is there consequential extra overhead if using the dictionary method? 

thanks

Alex

-- 
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] Select multiple rows

2015-06-14 Thread Selman Kocael
Hi.

I want to select a list of id from database.

ids=[12,145,69]

how can i do this? Is there any quick way of it?

for example:

query=
for i in ids:
if not i==ids[-1]:
query+=(db.cikmis_soru.id==+i+)
else:
query+=(db.cikmis_soru.id==+i+)

rows=db(query).select()



i get an error: SyntaxError: Set: no tables selected

Thanks all.

-- 
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: avoid separate query within second nested loop

2015-06-14 Thread Niphlod


On Sunday, June 14, 2015 at 11:56:34 PM UTC+2, Alex Glaros wrote:

 is there a size limitation to a dictionary? (want to know in general for 
 future purposes)


generally, your OS free memory.
 


 is there consequential extra overhead if using the dictionary method? 


of course, its an additonal loop
 

-- 
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] Invalid password reset

2015-06-14 Thread Annet


 Could it be expired?


I reported the same issue on 24. Mai

https://groups.google.com/forum/?fromgroups=#!topic/web2py/ytYoSQuOux4


Kind regards,

Anne 

-- 
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: Select multiple rows

2015-06-14 Thread Selman Kocael
Thanks.
14 Haz 2015 23:56 tarihinde Limedrop russ...@holtrd.com yazdı:

 Try something like this:

 rows = db(db.cikmis_soru.id.belongs(ids)).select()


 On Monday, 15 June 2015 07:13:02 UTC+12, xmarx wrote:

 Hi.

 I want to select a list of id from database.

 ids=[12,145,69]

 how can i do this? Is there any quick way of it?

 for example:

 query=
 for i in ids:
 if not i==ids[-1]:
 query+=(db.cikmis_soru.id==+i+)
 else:
 query+=(db.cikmis_soru.id==+i+)

 rows=db(query).select()



 i get an error: SyntaxError: Set: no tables selected

 Thanks all.

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