[web2py] Re: Sending simplified email from web2py
I just tested your code and it works fine! The raw=True does the job as expected so I can stop using smtplib directly. Thank you! On Saturday, January 21, 2012 7:31:57 PM UTC+1, Alan Etkin wrote: > > I requested a change in Mail to support unencoded and no multipart > messages. > http://code.google.com/p/web2py/issues/detail?id=630 > > >
[web2py] PowerPack
Dear All , How can i just use the Comments and blog system from web2py PowerPack ??
[web2py] db select with left but concatenated orderby fields?
Hi, I have a special case where one table (t1) has 0:1 relationships with two other semi-identical tabes (t1.linkt2 to t2 table, t1.linkt3 to t3 table), and I need to generate a list of all t1 rows with some fields from t2 & t3. I'm using the "left" select var which works ok. db().select( t1.id, t2.name, t3.name, left=[ t2.on( t1.linkt2==t2.id ), t3.on( t1.linkt3==t3.id ) ], orderby=t2.name|t3.name ) But my problem is that I need to order the rows (in the query, not in the actual rows result) by the common field "name" in tables t2 & t3, but as if they were concatenated. Currently I get all rows first ordered by t2.name and then all rows ordered by t3.name afterwards (i.e. two orderby groups), which is not what I need. I need to somehow "concatenate" t2.name and t3.name and order by that concatenation. My real situation is more complex but I tried to simplify as much as I could, I hope I explained clearly. Is this possible?, how?. Thanks!, Carlos
[web2py] BrowserID the login method aside of OpenId and co.
One interesting project from mozilla. https://github.com/mozilla/browserid/wiki/How-to-Use-BrowserID-on-Your-Site http://lloyd.io/how-browserid-works
[web2py] web2py.com is down
http://www.downforeveryoneorjustme.com/web2py.com: It's not just you! http://web2py.com looks down from here.
Re: [web2py] web2py.com is down
On Sun, Jan 22, 2012 at 3:15 PM, Anthony wrote: > http://www.downforeveryoneorjustme.com/web2py.com: > > It's not just you! http://web2py.com looks down from here. > Wow... terrible, does anybody knows why? is it hosted in a VPS? Javier
Re: [web2py] web2py.com is down
On Sun, Jan 22, 2012 at 6:15 PM, Anthony wrote: > http://www.downforeveryoneorjustme.com/web2py.com: > > It's not just you! http://web2py.com looks down from here. > Yesterday the site was down for me, it is occurring every day since the last week. -- Bruno Rocha [http://rochacbruno.com.br]
Re: [web2py] web2py.com is down
same in here On Sun, Jan 22, 2012 at 3:23 PM, Bruno Rocha wrote: > > > On Sun, Jan 22, 2012 at 6:15 PM, Anthony wrote: > >> http://www.downforeveryoneorjustme.com/web2py.com: >> >> It's not just you! http://web2py.com looks down from here. >> > > > Yesterday the site was down for me, it is occurring every day since the > last week. > -- > > Bruno Rocha > [http://rochacbruno.com.br] > >
[web2py] Re: web2py.com is down
I second On 22 Sty, 21:34, steve van christie wrote: > same in here > > > > > > > > On Sun, Jan 22, 2012 at 3:23 PM, Bruno Rocha wrote: > > > On Sun, Jan 22, 2012 at 6:15 PM, Anthony wrote: > > >>http://www.downforeveryoneorjustme.com/web2py.com: > > >> It's not just you!http://web2py.comlooks down from here. > > > Yesterday the site was down for me, it is occurring every day since the > > last week. > > -- > > > Bruno Rocha > > [http://rochacbruno.com.br]
Re: [web2py] Re: web2py.com is down
why web2py.com Down. Ovidio Marinho Falcao Neto Web Developer ovidio...@gmail.com ovidiomari...@itjp.net.br ITJP - itjp.net.br 83 8826 9088 - Oi 83 9334 0266 - Claro Brasil Apóio 2012/1/22 Marek Mollin > I second > > On 22 Sty, 21:34, steve van christie > wrote: > > same in here > > > > > > > > > > > > > > > > On Sun, Jan 22, 2012 at 3:23 PM, Bruno Rocha > wrote: > > > > > On Sun, Jan 22, 2012 at 6:15 PM, Anthony wrote: > > > > >>http://www.downforeveryoneorjustme.com/web2py.com: > > > > >> It's not just you!http://web2py.comlooks down from here. > > > > > Yesterday the site was down for me, it is occurring every day since the > > > last week. > > > -- > > > > > Bruno Rocha > > > [http://rochacbruno.com.br] >
Re: [web2py] Re: web2py.com is down
It's been down for me since yesterday. I start receiving time-outs after this hop: 10 ip65-46-63-46.z63-46-65.customer.algx.net (65.46.63.46) 104.814 ms 104.535 ms 104.382 ms On Sun, Jan 22, 2012 at 3:38 PM, Marek Mollin wrote: > I second > > On 22 Sty, 21:34, steve van christie > wrote: >> same in here >> >> >> >> >> >> >> >> On Sun, Jan 22, 2012 at 3:23 PM, Bruno Rocha wrote: >> >> > On Sun, Jan 22, 2012 at 6:15 PM, Anthony wrote: >> >> >>http://www.downforeveryoneorjustme.com/web2py.com: >> >> >> It's not just you!http://web2py.comlooks down from here. >> >> > Yesterday the site was down for me, it is occurring every day since the >> > last week. >> > -- >> >> > Bruno Rocha >> > [http://rochacbruno.com.br]
[web2py] Re: web2py.com is down
I do not know what is going on. It is not a software issue. It happened twice that that the VPS was shut down and I had to turn it on again. Let week there was a problem that the vps.net DNS servers were down for about a day. Massimo On Jan 22, 2:50 pm, Justin Heath wrote: > It's been down for me since yesterday. > > I start receiving time-outs after this hop: > > 10 ip65-46-63-46.z63-46-65.customer.algx.net (65.46.63.46) 104.814 > ms 104.535 ms 104.382 ms > > > > > > > > On Sun, Jan 22, 2012 at 3:38 PM, Marek Mollin wrote: > > I second > > > On 22 Sty, 21:34, steve van christie > > wrote: > >> same in here > > >> On Sun, Jan 22, 2012 at 3:23 PM, Bruno Rocha wrote: > > >> > On Sun, Jan 22, 2012 at 6:15 PM, Anthony wrote: > > >> >>http://www.downforeveryoneorjustme.com/web2py.com: > > >> >> It's not just you!http://web2py.comlooksdown from here. > > >> > Yesterday the site was down for me, it is occurring every day since the > >> > last week. > >> > -- > > >> > Bruno Rocha > >> > [http://rochacbruno.com.br]
[web2py] Re: db select with left but concatenated orderby fields?
try replace orderby=t2.name|t3.name with orderby=t2.name+t3.name On Jan 22, 12:31 pm, Carlos wrote: > Hi, > > I have a special case where one table (t1) has 0:1 relationships with two > other semi-identical tabes (t1.linkt2 to t2 table, t1.linkt3 to t3 table), > and I need to generate a list of all t1 rows with some fields from t2 & t3. > > I'm using the "left" select var which works ok. > > db().select( > t1.id, t2.name, t3.name, > left=[ t2.on( t1.linkt2==t2.id ), t3.on( t1.linkt3==t3.id ) ], > orderby=t2.name|t3.name > ) > > But my problem is that I need to order the rows (in the query, not in the > actual rows result) by the common field "name" in tables t2 & t3, but as if > they were concatenated. > > Currently I get all rows first ordered by t2.name and then all rows ordered > by t3.name afterwards (i.e. two orderby groups), which is not what I need. > > I need to somehow "concatenate" t2.name and t3.name and order by that > concatenation. > > My real situation is more complex but I tried to simplify as much as I > could, I hope I explained clearly. > > Is this possible?, how?. > > Thanks!, > > Carlos
[web2py] Re: db select with left but concatenated orderby fields?
Hi Massimo, I just tried "+" instead of "|" for orderby, but I get the following error: ProgrammingError: operator does not exist: character varying + character varying HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. I'm using postgresql. Any advice?, thanks! Carlos
[web2py] Re: db select with left but concatenated orderby fields?
Looks like postgresql uses || instead of | for string concatenation. I just pushed a change in trunk that should make this work orderby=t2.name+t3.name Please give it a try and let me know. On Jan 22, 3:12 pm, Carlos wrote: > Hi Massimo, > > I just tried "+" instead of "|" for orderby, but I get the following error: > > ProgrammingError: operator does not exist: character varying + character > varying > HINT: No operator matches the given name and argument type(s). You > might need to add explicit type casts. > > I'm using postgresql. > > Any advice?, thanks! > > Carlos
[web2py] dig command or something like that
Hello, I need to scan a list of domain names to find out the IP-address and DNS-server of that domain. I thought I'd run the dig command and parse the result. Is this possible or is there a better way for this? Kenneth
[web2py] Re: db select with left but concatenated orderby fields?
It now accepts that operator (without errors), but it's not ordering the rows correctly. Any ideas?, thanks.
[web2py] accepts > KeyError: '_id', latest trunk with postgresql
Hi, I'm getting the following error with latest trunk and postgresql, especially after changeset # fab104bec898 (web2py-py3k: proof of concept). File "C:\web2py\gluon\sqlhtml.py", line 1082, in accepts hideerror=hideerror, File "C:\web2py\gluon\html.py", line 1807, in accepts status = self._traverse(status,hideerror) File "C:\web2py\gluon\html.py", line 749, in _traverse newstatus = c._traverse(status,hideerror) and newstatus File "C:\web2py\gluon\html.py", line 749, in _traverse newstatus = c._traverse(status,hideerror) and newstatus File "C:\web2py\gluon\html.py", line 749, in _traverse newstatus = c._traverse(status,hideerror) and newstatus File "C:\web2py\gluon\html.py", line 749, in _traverse newstatus = c._traverse(status,hideerror) and newstatus File "C:\web2py\gluon\html.py", line 756, in _traverse newstatus = self._validate() File "C:\web2py\gluon\html.py", line 1572, in _validate (value, errors) = validator(value) File "C:\web2py\gluon\validators.py", line 549, in __call__ elif str(rows[0]._id) != str(self.record_id): File "C:\web2py\gluon\dal.py", line 5003, in __getattr__ return self[key] File "C:\web2py\gluon\dal.py", line 4994, in __getitem__ return dict.__getitem__(self, key) KeyError: '_id' This error does not occur when reverting to changeset # dafe70b55ae5 (oops, some tests were not committed, now they are). Is this a bug?. Thanks. Carlos
[web2py] Re: web2py.com is down
I use vps.net and have recently been disappointed with their reliability. So much so that I have decided that it is time for a change. I have been doing some tests with linode.com for a few weeks and have been pleased, so I am moving sites to them. Regards, David
Re: [web2py] Re: web2py.com is down
I am using Linode for more than one year and Linode is amazing! http://www.linode.com/?r=3f383df8639c367bfc73419d6c1ebfbd8dc11cf7 -- Bruno Rocha [http://rochacbruno.com.br]
Re: [web2py] Re: web2py.com is down
I have been using linode.com for over a year now and they are very reliable. Not a single reboot or shutdown. And their customer service is also good. On Jan 23, 2012 5:30 AM, "villas" wrote: > I use vps.net and have recently been disappointed with their reliability. > So much so that I have decided that it is time for a change. > > I have been doing some tests with linode.com for a few weeks and have > been pleased, so I am moving sites to them. > > Regards, > David >
Re: [web2py] Re: web2py.com is down
We have been using linode for 3 months now good service the only problem we had was with the large bbos attack that was hitting there cali data center. We ended up getting attacked also. Other then that have had a good experience with them. On Jan 22, 2012 4:35 PM, "qasimak...@gmail.com" wrote: > I have been using linode.com for over a year now and they are very > reliable. Not a single reboot or shutdown. And their customer service is > also good. > On Jan 23, 2012 5:30 AM, "villas" wrote: > >> I use vps.net and have recently been disappointed with their >> reliability. So much so that I have decided that it is time for a change. >> >> I have been doing some tests with linode.com for a few weeks and have >> been pleased, so I am moving sites to them. >> >> Regards, >> David >> >
Re: [web2py] SQLFORM errors with custom id fields
I reported the same thing in this thread:
http://groups.google.com/group/web2py/browse_thread/thread/280f6b746e2b7201
-Jim
On 1/21/2012 4:00 PM, Alan Etkin wrote:
I recently updated my web2py source code from the mercurial repository
I think that something has changed in SQLFORM that is incompatible
with custom id field names declared with:
Field("other_id", ...)
On form processing, record updates stop the app with this error:
Traceback (most recent call last):
File "/home/alan/gestionlibre/gestionlibre_gui-hg/controllers/
appadmin.py", line 178, in update
if session.form.accepts(evt.args, formname=None, keepvalues=False,
dbio=False):
File "/home/alan/web2py-hg/gluon/sqlhtml.py", line 1050, in accepts
(formname_id, record_id) = (self.record[id_fieldname],
File "/home/alan/web2py-hg/gluon/dal.py", line 4987, in __getitem__
return dict.__getitem__(self, key)
I managed to solve the problem for updates by changing sqlhtml.py in
this way:
(Line 1039)
# retrieve the actual id name (for legacy databases)
try:
id_fieldname = self.table.id.name
except (IndexError, AttributeError):
# could not retrieve the table id value
id_fieldname = "id"
# former notation was self.record.id Check for
compatibility
(formname_id, record_id) = (self.record[id_fieldname],
request_vars.get('id',
None))
The problem seems to be related to SQLFORM trying to get the default
id key from table records, and may reproduce in other instances, since
I see that the record.id property is being called in other sections of
the module.
I'd continue with the fix to provide a complete modification of the
module if the solution provided has no backward compatibility or other
problems.
Thanks
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4757 - Release Date: 01/21/12
--
Jim Steil
VP of Information Technology
Quality Liquid Feeds, Inc.
608.935.2345 office
608.341.9896 cell
Re: [web2py] Re: web2py.com is down
hi, I just want to recommend webfaction and uwsgi again, even for hosting web2py.com :) uwsgi is of version 1.0.21, and from version 1, uwsgi is optimized for low resources systems as WAS webfaction WAS, now webfaction increased RAM from 80Mb to 256 Mb (app RAM), also offers 100Gb space, 600Gb traffic - and the price is half of the Linode one and I think they handle some security for you (e.g ddos attacks) regards
Re: [web2py] Re: web2py.com is down
These ddos were 15GB per second webfaction doesn't handle that. On Jan 22, 2012 6:45 PM, "Vasile Ermicioi" wrote: > hi, > I just want to recommend webfaction and uwsgi again, even for hosting > web2py.com :) > > uwsgi is of version 1.0.21, and from version 1, uwsgi is optimized for low > resources systems as WAS webfaction > WAS, now webfaction increased RAM from 80Mb to 256 Mb (app RAM), > also offers 100Gb space, 600Gb traffic - and the price is half of the > Linode one > and I think they handle some security for you (e.g ddos attacks) > > > regards > > >
[web2py] Re: Auth.registration_requires_invitation
Can you do it without storing a new field in the database? Like could the key be a hash of the email address?
[web2py] Re: web2py.com is down
How do they handle backup. That is the one think that sold me to VPS.net. They do daily, weakly and monthly backup of the entire server. that takes some of my worries away. On Jan 22, 8:45 pm, Vasile Ermicioi wrote: > hi, > I just want to recommend webfaction and uwsgi again, even for hosting > web2py.com :) > > uwsgi is of version 1.0.21, and from version 1, uwsgi is optimized for low > resources systems as WAS webfaction > WAS, now webfaction increased RAM from 80Mb to 256 Mb (app RAM), > also offers 100Gb space, 600Gb traffic - and the price is half of the > Linode one > and I think they handle some security for you (e.g ddos attacks) > > regards
Re: [web2py] Re: web2py.com is down
Linode does the same but cost a little more. On Jan 22, 2012 7:48 PM, "Massimo Di Pierro" wrote: > How do they handle backup. That is the one think that sold me to > VPS.net. They do daily, weakly and monthly backup of the entire > server. that takes some of my worries away. > > On Jan 22, 8:45 pm, Vasile Ermicioi wrote: > > hi, > > I just want to recommend webfaction and uwsgi again, even for hosting > > web2py.com :) > > > > uwsgi is of version 1.0.21, and from version 1, uwsgi is optimized for > low > > resources systems as WAS webfaction > > WAS, now webfaction increased RAM from 80Mb to 256 Mb (app RAM), > > also offers 100Gb space, 600Gb traffic - and the price is half of the > > Linode one > > and I think they handle some security for you (e.g ddos attacks) > > > > regards
Re: [web2py] Re: web2py.com is down
Linode has a fantastic backup system. you can look it up on http://www.linode.com/faq.cfm. Also they provide node balancer if you have to much of traffic for just 20$'s. -Qasim On Jan 23, 2012 8:48 AM, "Massimo Di Pierro" wrote: > How do they handle backup. That is the one think that sold me to > VPS.net. They do daily, weakly and monthly backup of the entire > server. that takes some of my worries away. > > On Jan 22, 8:45 pm, Vasile Ermicioi wrote: > > hi, > > I just want to recommend webfaction and uwsgi again, even for hosting > > web2py.com :) > > > > uwsgi is of version 1.0.21, and from version 1, uwsgi is optimized for > low > > resources systems as WAS webfaction > > WAS, now webfaction increased RAM from 80Mb to 256 Mb (app RAM), > > also offers 100Gb space, 600Gb traffic - and the price is half of the > > Linode one > > and I think they handle some security for you (e.g ddos attacks) > > > > regards
