[web2py] problem with 1.77.3 & 1.78.3 and legacy database

2010-05-17 Thread drayco
Hi, I updated my web2py, but I had a problem with web2py 1.78.3, I use legacy databases. When I try to go to my application I got this Error traceback Traceback (most recent call last): File "/media/RESPALDO/web2py/gluon/restricted.py", line 178, in restricted exec ccode in environment Fi

[web2py] Re: problem with 1.77.3 & 1.78.3 and legacy database

2010-05-18 Thread drayco
part, just a > > guess. > > > On May 17, 10:12 pm, mdipierro wrote: > > > > still the error he is getting makes no sense to me. > > > > On May 17, 8:54 pm, DenesL wrote: > > > > > On May 17, 6:31 pm, drayco wrote: > > > > > &g

[web2py] Re: How to set multiple primary key?

2010-05-19 Thread drayco
Thank's a lot Nico de Groot. It worked for me too even with mysql. On 18 mayo, 07:24, Nico de Groot wrote: > Hi Denes, > > I got the same syntax error (SyntaxError: invalid table "account" > attribute: sequence_name ) when using a legacy database (by specifying > the primarykey in 'define_table'

[web2py] Re: How to set multiple primary key?

2010-05-19 Thread drayco
Thank's a lot Nico de Groot. It worked for me too even with mysql. On 18 mayo, 07:24, Nico de Groot wrote: > Hi Denes, > > I got the same syntax error (SyntaxError: invalid table "account" > attribute: sequence_name ) when using a legacy database (by specifying > the primarykey in 'define_table'

[web2py] Re: How to set multiple primary key?

2010-05-19 Thread drayco
Thank's a lot Nico de Groot. It worked for me too even with mysql. On 18 mayo, 07:24, Nico de Groot wrote: > Hi Denes, > > I got the same syntax error (SyntaxError: invalid table "account" > attribute: sequence_name ) when using a legacy database (by specifying > the primarykey in 'define_table'

[web2py] Where can I download web2py 1.77.3?

2010-06-02 Thread drayco
Where can I download web2py 1.77.3? Because my application that's run in webfaction, with MySQL and web2py 1.78.3 needs to restart 4 times at day? And MySql rollback today, and I obtained a error that's say "server in process to shutdown" With web2py 1.77.3 and 1.66.5 I didn't need to do that ac

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-02 Thread drayco
ricted exec ccode in environment File "/home/drayco/webapps/seccion36/web2py/applications/init/ controllers/default.py", line 134, in File "gluon/globals.py", line 96, in self._caller = lambda f: f() File "gluon/tools.py", line 2036, in f return action(*a

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-02 Thread drayco
One of my user told me that He sent in 2 times new registers, and he didn't obtain answer. In previous versions of web2py, I never got this error. On Jun 2, 7:03 pm, drayco wrote: > Thank's a lot Dr. Massimo > > do you use apache? Yes > mod_wsgi? Yes > do you use th

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-02 Thread drayco
ccode in environment File "/home/drayco/webapps/seccion36/web2py/applications/init/models/ db.py", line 16, in db=SQLDB('mysql://drayco_sec36new:boci_1...@127.0.0.1/ drayco_sec36new',pool_size=10) File "gluon/sql.py", line 933, in __init__ self._execute('

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-02 Thread drayco
ccode in environment File "/home/drayco/webapps/seccion36/web2py/applications/init/models/ db.py", line 16, in db=SQLDB('mysql://xxx:x...@127.0.0.1/xxx',pool_size=10) File "gluon/sql.py", line 933, in __init__ self._execute('SET FOREIGN_KEY_CHECKS=1;&#

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-02 Thread drayco
(*) " crashing your mysql > database? It seems to me the problem is not the web2py version. > > On Jun 2, 7:03 pm, drayco wrote: > > > Thank's a lot Dr. Massimo > > > do you use apache? Yes > > mod_wsgi? Yes > > do you use the built-in web

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-03 Thread drayco
s/appname/web2py/wsgihandler.py I ran web2py manually one time, and them I ran apache, at this moment, everything is done with web2py version 1.78.3 even admin with https. On Jun 3, 1:48 am, drayco wrote: > Very probability, because i very new in web applications and python > > In the

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-04 Thread drayco
Today, when I try to download large csv archives, with admin, apache crashed Well, I added this to httpd.conf WSGIDaemonProcess web2py user=drayco group=drayco \ home=/home/drayco/webapps/seccion36/web2py \ processes=1 maximum-requests=1000 But even with that, apache crashed equal

[web2py] Cuestion about jzip and jpg image?

2010-02-25 Thread drayco
Hi, web2py users, I have a application with 6 web services with json in web2py. I answer topological information every minute. And my partners told me that the size of the answer is too large. They told me that we need to use jzip. The new requirements is that I need to give a jpg image too. But I

[web2py] Cuestion about jzip and jpg image?

2010-02-25 Thread drayco
Hi, web2py users, I have a application with 6 web services with json in web2py. I answer topological information every minute. And my partners told me that the size of the answer is too large. They told me that we need to use jzip. The new requirements is that I need to give a jpg image too. But I

[web2py] OperationalError 1054 Unknown column 'auth_user.reset_password_key' in 'field list'

2010-03-27 Thread drayco
Hi everyone. I have a application in a server production with web2py 1.72.3 and MySQL, and in this moment, I try to do some modifications in my localhost, but when I try to use with web2py 1.76.5 I got this error when I try to enter, Only in auth. I see that you did some changes in auth tables, we

[web2py] What is this mean?

2010-04-06 Thread drayco
I have web2py 1.76.5 with red hat 5.5 enterprise linux 5.5 at 64 bits. I updated web2py and when I try to go to admin i got this error. What is this mean? Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 173, in restricted exec ccode in e

[web2py] Re: What is this mean?

2010-04-07 Thread drayco
Apr 7, 12:32 am, mdipierro wrote: > can you open a regular python shell and run > > import os > print os.path.abspath(os.path.join('applications/admin/','hello')) > > ? looks like a python issue, it cannot determine os.getcwd() > > On Apr 7, 12:23 am, dr

[web2py] Re: What is this mean?

2010-04-07 Thread drayco
Apr 7, 12:32 am, mdipierro wrote: > can you open a regular python shell and run > > import os > print os.path.abspath(os.path.join('applications/admin/','hello')) > > ? looks like a python issue, it cannot determine os.getcwd() > > On Apr 7, 12:23 am, dr

[web2py] Typos in http://web2py.com/book/default/chapter/08#Authentication and Customizing Auth

2010-08-12 Thread drayco
In http://web2py.com/book/default/chapter/08#Authentication and Customizing Auth Example: # after # auth = Auth(globals(),db) db.define_table( auth.settings.table_user_name, Field('first_name', length=128, default=''), Field('last_name', length=128, default=''), Field('email', le

[web2py] Re: Typos in http://web2py.com/book/default/chapter/08#Authentication and Customizing Auth

2010-08-12 Thread drayco
ause you have an old version of web2py. > > On Aug 12, 12:19 pm, drayco wrote: > > > Inhttp://web2py.com/book/default/chapter/08#Authenticationand > > Customizing Auth > > > Example: > > > # after > > # auth = Auth(globals(),db) > > > db.defi

[web2py] Re: Typos in http://web2py.com/book/default/chapter/08#Authentication and Customizing Auth

2010-08-12 Thread drayco
ause you have an old version of web2py. > > On Aug 12, 12:19 pm, drayco wrote: > > > Inhttp://web2py.com/book/default/chapter/08#Authenticationand > > Customizing Auth > > > Example: > > > # after > > # auth = Auth(globals(),db) > > > db.defi

[web2py:30682] help with static files in webfaction

2009-09-10 Thread drayco
Good night, I ask for your support with this situation I have a subdomain on WebFaction. At this time, I can see and work with the admin, welcome and a mysql database in my application in WebFaction. However, when I request my subdomain, the initial application (init) loads blank pages. I think,

[web2py:30743] Can you help me with static files in webfaction?

2009-09-11 Thread drayco
Hi, Dr. Massimo: Can you help me please? This is my situation: I have a subdomain in webfaction with https. I can work with default applications of web2py. Even I can put data in a mysql database. All of that in with my subdomain in webfaction. However, when a I request

[web2py:30940] Re: Can you help me with static files in webfaction?

2009-09-13 Thread drayco
tool to check packed and unpacked files. On 11 sep, 12:24, drayco wrote: > Hi, Dr. Massimo: > >      Can you help me please? > >      This is my situation: >      I have a subdomain inwebfactionwith https. >      I can work with default applications of web2py. Even I can put

[web2py:31934] auth allow same user at the same time with different pc with different ip

2009-09-30 Thread drayco
I have many users with differents roles. Those users gave their passwords and username to others. I use auth and it allows to the people login in to the application with the same user at the same time with different pc with different ip. And I don't want that happen. Please, Can anybody help me?

[web2py:32362] Re: submenus and IE

2009-10-06 Thread drayco
In virtualbox with IE7 and IE8 with WinXP, it's works. With two machines with WinXP with IE7 and IE8, it's works. However, some of my user report me that it didn't not work. On 6 oct, 22:31, mdipierro wrote: > Has anybody tried submenus and IE. Do they work? I assumed they did > not I tried onc

[web2py:32514] Re: submenus and IE

2009-10-08 Thread drayco
With two machines with Windos Vista and IE6 It didn't work. On Oct 6, 10:31 pm, mdipierro wrote: > Has anybody tried submenus and IE. Do they work? I assumed they did > not I tried once and it did not work for me. > > Massimo --~--~-~--~~~---~--~~ You received thi

[web2py:32515] How to avoid this error with MySQL in WebFaction?

2009-10-08 Thread drayco
Hi, I don't want this error happen. Please, Can you teach me how to avoid this error with MySQL in WebFaction? Traceback (most recent call last): File "/home/user/webapps/app/web2py/gluon/restricted.py", line 178, in restricted exec ccode in environment File "/home/user/webapps/app/web2py

[web2py:34977] Re: Chapter 1 from 2nd edition web2py book in Spanish

2009-11-09 Thread drayco
I think, you need more help in this kind of work. Buenas tardes. Puedo ayudarlos revisando la traducción, por el momento. A partir del 15 de Diciembre podría contribuir con uno o dos capítulos. Sin embargo, no quisiera dejar pasar la oportunidad para comentar que existen frases que no refieren e

[web2py:34998] Re: 1.72.1 is OUT

2009-11-09 Thread drayco
I use MySQL and auth. When i try to login, Web2py 1.72.1 give me this error. But With Web2py 1.71.1 this dosen't happend. Traceback (most recent call last): File "/media/RESPALDO/web2py/gluon/restricted.py", line 184, in restricted exec ccode in environment File "/media/RESPALDO/web2py/ap

[web2py:36179] How can I avoid this error in pagination?

2009-11-29 Thread drayco
This is my function @auth.requires_membership('Capturista') def lee_notas(): if len(request.args): page=int(request.args[0]) else: page=0 items_per_page=25 limitby=(page*items_per_page,(page+1)*items_per_page+1) Capturista = db(db.capturistas.creadoPor==auth.user.id).select()

[web2py:36191] Re: How can I avoid this error in pagination?

2009-11-29 Thread drayco
> > {{=table[nota.field].otherfield if table[nota.field] else > 'undefined'}} > > Anyway, this code does a lot of DB access. I assume you are running on > GAE. if not, you should use a join instead. > > On Nov 29, 12:29 pm, drayco wrote: > > > This is

[web2py] Help, What this mean?

2010-01-14 Thread drayco
icket 127.0.0.1.2010-01-14.13-39-00.faf5f883-e4f2-48d2-96b6- c1a697eafdfb Error traceback Traceback (most recent call last): File "/home/drayco/web2py/gluon/main.py", line 478, in wsgibase serve_controller(request, response, session) File "/home/drayco/web2py/gluon/main

[web2py] Re: Help, What this mean?

2010-01-14 Thread drayco
pm, mdipierro wrote: > > > Never seen this before. which web2py version? > > > Can you try delete everything in the cache folder of your application? > > > On Jan 14, 7:16 pm, drayco wrote: > > > > I follow this: > > > >http://www.web2py.co

[web2py] Re: Help, What this mean?

2010-01-18 Thread drayco
me/cache folder? If so, > could you send me those files to look at. > > On Jan 16, 1:27 am, drayco wrote: > > > Does your app have write access to the applications folder? Yes, It > > was rw and x. > > > Even I try to run as root and it was still happen > > >

[web2py:14583] Re: T3 IF and FOR doubt

2009-01-05 Thread drayco
Hi, please, can You give any examples? On 25 dic 2008, 19:16, mdipierro wrote: > You cannot.T3does not support web2py templating language. > > On Dec 25, 6:10 pm, "Tito Garrido" wrote: > > > Hi Folks, > > > Why when I try to use: > > {{ifself.is_admin:}} > > Test > > {{pass}} > > > in a wiki pa

[web2py:14585] How can I use in t3 private procedures?

2009-01-05 Thread drayco
Hi, I try to use t3 and I need to @expose procedure if i want to use it in a wiki page in a self.create() method. This is my procedure that i need to use @expose def programafecha(): beneficiarios=db(db.beneficiarios.person_id==self.person_id).select () trabajadores=db(db.trabajadores.pe

[web2py:14596] Re: T3 IF and FOR doubt

2009-01-05 Thread drayco
ltiple {{}}{{}} as you can in the web2py template > language. > > Massimo > > On Jan 5, 1:18 pm, drayco wrote: > > > Hi, please, can You give any examples? > > > On 25 dic 2008, 19:16, mdipierro wrote: > > > > You cannot.T3does not support web

[web2py:14597] Re: How can I use in t3 private procedures?

2009-01-05 Thread drayco
ng wiki/two by exposing programfetcha directly. In > this case you need the decorator @expose and the wiki/one should say > > {{=self.create(db.beneficiarios,next='run/programfetcha')}} > > Massimo > > On Jan 5, 1:29 pm, drayco wrote: > > > Hi, I try to use t3

[web2py:14602] Re: T3 IF and FOR doubt

2009-01-05 Thread drayco
Thank's a lot. On 5 ene, 21:04, mdipierro wrote: > yes, here is another example > > {{=DIV(*[DIV(db.display(db.dog,query=db.dig.id==id)) for id in > [1,2,3]])}} > > Massimo > > On Jan 5, 7:46 pm, drayco wrote: > > > Ok, I understand. > > > Howev

[web2py:14698] example about group memberships and group based access control in t3

2009-01-07 Thread drayco
Hi, can you give a simple example about group memberships and group based access control in t3? Or how can i show or not some menu/submenu in t3? Can i do this whithout group memberships? --~--~-~--~~~---~--~~ You received this message because you are subscribed t

[web2py:14751] how can i use mysql in t3?

2009-01-08 Thread drayco
Hi, In web2py, i can to connect with mysql. Can I use the same form in t3, if I want to connect with mysql? Or how can i use mysql in t3? Thank's in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2p

[web2py:14754] Re: example about group memberships and group based access control in t3

2009-01-08 Thread drayco
ge has "menu" unchecked then it never appears in menus. > > You can find example of access control for other functionalities > inhttp://mdp.cti.depaul.edu/examples/static/t2.pdf > > Massimo > > On Jan 7, 7:54 pm, drayco wrote: > > > Hi, can you give a simple exa

[web2py:14756] Re: example about group memberships and group based access control in t3

2009-01-08 Thread drayco
Sorry, i want to say And in this answer, I would want to suggest something extensions for "view helpers -> menu" On Jan 8, 2:33 pm, drayco wrote: > Hi, thanks. I understand. > > However, I think, i don't explain my idea well. > > I would want to display or no

[web2py:14796] Re: example about group memberships and group based access control in t3

2009-01-09 Thread drayco
rn pages. > > Currently there is no mechinsm to enforce access control to the menu > items, only to the content of those pages. > > I will think about this it may not be too difficult to add this > mechanism. > > Massimo > > On Jan 8, 3:07 pm, drayco wrote: > > &

[web2py:16236] Re: t3 itemize and firefox

2009-02-12 Thread drayco
Yes, I see that effect in t3 and firefox. But, if you delete all the content and paste again in a new page, the problem disapper. On Feb 11, 3:59 pm, Wes James wrote: > Anyone else see the itemize list appearing in the middle of the > browser witht3on firefox? > > -wj --~--~-~--~~--

[web2py:16238] t3 backup/restore

2009-02-12 Thread drayco
Hi, I using t3 Version 0.4 (2009-01-07 09:01:19) and web2py 1.55.2 in a website in production enviroment. In this moment we have 750 users and more of 10,000 registers of diferent kind data and i am using sqlite. The web site is http://www.seccion36.org.mx. The problem is the following: when i u

[web2py:16241] question about t3 session

2009-02-12 Thread drayco
is it possible that in t3 Version 0.4 (2009-01-07 09:01:19) and web2py 1.55.2 diferent person with the same user can logg in? And, if it is possible, how can i fix that? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[web2py:16246] Re: t3 backup/restore

2009-02-12 Thread drayco
Ok, i wait the new version. Thank's in advanced. On Feb 12, 1:25 pm, mdipierro wrote: > there was a bug in backup/restore that is now fixed in trunk. > Can you want next Tuesday I post the next version? > > Massimo > > On Feb 12, 12:31 pm, drayco wrote: > > >

[web2py:16247] Re: question about t3 session

2009-02-12 Thread drayco
and in the same place but with diferrents machines and in this moment i have a lot of problems with that. And i don't want that this happend. What can i do? On Feb 12, 1:29 pm, mdipierro wrote: > I do not understand. Can you make an example? > > On Feb 12, 12:52 pm, drayco wrot

[web2py:16249] Re: question about t3 session

2009-02-12 Thread drayco
somebody else is currently > logged in as you" >              t2.logout(next='login') >     return dict(form=form) > > On Feb 12, 2:00 pm, drayco wrote: > > > I have many users with diferrents kinds of rights and they gave their > > passwords and user name t

[web2py:16257] Re: t3 itemize and firefox

2009-02-12 Thread drayco
quot; in a the same or new wiki/page. This tricks works with t3 Version 0.4 (2009-01-07 09:01:19) and web2py 1.55.2 On 12 feb, 17:42, Wes James wrote: > This trick works until a log out.  If I log back in it goes back to > where it should be - go figure.... > > -wj > > On Thu, F

[web2py:16258] Re: question about t3 session

2009-02-12 Thread drayco
I tested it and the problem is the same. Do you have other suggestion? On 12 feb, 15:37, drayco wrote: > Thanks in advanced. I will try to fix that this afternoon. > > On 12 feb, 14:33, mdipierro wrote: > > > Yes you can but this is not one line change. Assuming you have a

[web2py:16266] Re: question about t3 session

2009-02-12 Thread drayco
Yes, I tested with two diferrent and two diferrent IP addresses. I use share hosting with apache and wsgi in webfaction. On 12 feb, 23:05, mdipierro wrote: > Did you test logging from two different machines? Different IP > addresses? > > Massimo > > On Feb 12, 8:15 pm, dray

[web2py:16304] Re: question about t3 session

2009-02-13 Thread drayco
    if client and client!=request.client:  ### if no match, force > logout >              session.flash="sorry, somebody else is currently logged > in as you" >              redirect(URL(r=request)) >     return dict(form=t2.login()) > > On Feb 13, 1:26 am, drayco

[web2py:16321] Re: question about t3 session

2009-02-13 Thread drayco
guess I need to try this myself before sending it. Sorry I have not > > done so. I will test it, debug it and get back to you. > > > massimo > > > On Feb 13, 11:27 am, drayco wrote: > > > > Sorry, I tested it again and the problem is the same. > > > >

[web2py:16349] Re: question about t3 session

2009-02-15 Thread drayco
quest.client when the two users login from different > IP using the same password within 5 minutes? > > Massimo > > On Feb 13, 6:44 pm, drayco wrote: > > > Hi mdipierro, Thank's for your help. > > > However, the problem is the same. > > > Please,

[web2py:16410] Re: question about t3 session

2009-02-16 Thread drayco
, can you help me? On 15 feb, 10:59, drayco wrote: > I use a share hosting with wgsi and apache2 in webfaction. > > Ok, I will try to do the test. > > Thank's for your help. > > On Feb 15, 8:46 am, mdipierro wrote: > > > That should have worked. Can you tell me

[web2py:16423] Re: question about t3 session

2009-02-16 Thread drayco
inactivity. > > You can change the 300 in the cache.ram(...,300). > > On Feb 16, 7:05 pm, drayco wrote: > > > Hi massimo, i did other test in the school with 2 machines with 2 > > diferent ip. > > At first, I felt happy to see that it worked. > > > However, I w

[web2py:16510] Re: t3 backup/restore

2009-02-18 Thread drayco
oment. On 12 feb, 13:41, drayco wrote: > Ok, i wait the new version. > > Thank's in advanced. > > On Feb 12, 1:25 pm, mdipierro wrote: > > > there was a bug in backup/restore that is now fixed in trunk. > > Can you want next Tuesday I post the next version? > &g

[web2py] Can any help me with crud.search?

2010-12-08 Thread drayco
Hi I have this code in the model: db36.define_table('benefs2', #Field('id','integer'), Field('unique_id','string', writable=False, readable=False), Field('active','string', writable=False, readable=False), Field('creadoEl','datetime', writable=False, readable=False), Field('cr

[web2py] Can any help me with crud.archive?

2010-12-08 Thread drayco
Hi I have this in model #audit field group audit = db.Table(db,'audit', Field('unique_id', 'string',default=uuid.uuid4(), writable=False, readable=False), Field('active', 'boolean', default=True, writable=False, readable=False, label='Activo',comment='Desactiva para eliminar este registro

[web2py] Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
total = SQLTABLE(db((db.notas.created_on>inicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&(db.notas.created_oninicio)&am

[web2py] Re: Can any help me with crud.archive?

2010-12-08 Thread drayco
Ups, my bad I tested on web2py version 1.89.5 and trunk On Dec 8, 7:58 pm, mdipierro wrote: > which web2py version? > > On Dec 8, 6:30 pm, drayco wrote: > > > Hi > > > I have this in model > > > #audit field group > > audit = db.Table(db,'audi

[web2py] Re: Can any help me with crud.search?

2010-12-08 Thread drayco
Ups, my bad I tested on web2py version 1.89.5 and trunk On Dec 8, 5:56 pm, drayco wrote: > Hi > > I have this code in the model: > > db36.define_table('benefs2', >     #Field('id','integer'), >     Field('unique_id','stri

[web2py] Re: Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
Hi, I updated trunk version, but error still happens this the track Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/opticaluz/controllers/ gerencia

[web2py] Re: Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
Hi, I updated trunk version, but error still happens, but now all my functions that use crud.(search,read,create) doesn't work this the track Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environmen

[web2py] Re: Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
:D wel olny crud.create doesn't work this is the track Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/opticaluz/controllers/ ventas.py&quo

[web2py] Re: Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
:D, well only for this function "realizar_venta", because other crud.create works well On Dec 8, 10:35 pm, drayco wrote: > :D wel olny crud.create doesn't work > > this is the track > > Traceback (most recent call last): >   File "/home/drayco/web

[web2py] Re: Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
Ok, it's work's now, I reset my instance and all work well Thank's On Dec 8, 10:43 pm, drayco wrote: > :D, well only for this function "realizar_venta", because other > crud.create works well > > On Dec 8, 10:35 pm, drayco wrote: > > > :D wel o

[web2py] Re: Can any help me with SQLFORM.factory?

2010-12-08 Thread drayco
quot;,default=(request.now +datetime.timedelta(14)), label='Fecha de Entrega'), Field("optometrista",db.auth_user, default=None,requires=IS_NULL_OR(IS_IN_DB(optometristas,'auth_user.id','% (first_name)s %(last_name)s %(end_name)s'))), Field('retiO

[web2py] Can any help me with crud.create?

2010-12-09 Thread drayco
x27;), Field("optometrista",db.auth_user, default=None,requires=IS_NULL_OR(IS_IN_DB(optometristas,'auth_user.id','% (first_name)s %(last_name)s %(end_name)s'))), Field('retiOdEsf','double', default=None,requires=IS_NULL_OR(IS_FLOAT

[web2py] Re: Can any help me with crud.create?

2010-12-09 Thread drayco
Hi, this is the new traceback Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/opticaluz/controllers/ ventas.py", line 1086, in File "

[web2py] Re: Can any help me with crud.create?

2010-12-09 Thread drayco
) a minimalist app to reproduce the > problem? > > On Dec 9, 9:08 am, drayco wrote: > > > Hi, in web2py 1.89.5 works but in trunk no > > > This is in the controller > > > def realizar_venta(): > >     return dict(form=crud.create(db.notas, next=URL(

[web2py] Can any help me with new dal in trunk?

2011-01-07 Thread drayco
CRIZAL ALIZÉ']))), Field('limitup','double', writable=False, readable=False), Field('limitdown','double', writable=False, readable=False), Field("promo", "double", requires=[IS_NOT_EMPTY(error_message='No puede estar va

[web2py] Can any help me with new dal in trunk (2)?

2011-01-07 Thread drayco
#x27;integer' , length = 1 ), Field('ClaveMediciones', 'integer' , length = 6 ), primarykey=['DireccionUTR','Indice'], migrate = False) This is the traceback Traceback (most recent call last): File "/home/drayco/web2py/glu

[web2py] Re: Can any help me with new dal in trunk?

2011-01-07 Thread drayco
#x27;string', > > On Jan 8, 12:57 am, drayco wrote: > > > Hi, this code works with web2py 1.89.5 with mysql > > > but with web2py in trunk and mysql it dosent works. > > > db.define_table("lentes", > >     audit, > >     Field("te

[web2py] Re: Can any help me with crud.archive?

2011-01-07 Thread drayco
Well, only a litle typo in page 324 db.define_table('notas_archive', Field('current_record',db.notas), db.notas) However all it's works ok. On Dec 8 2010, 7:58 pm, mdipierro wrote: > which web2py version? > > On Dec 8, 6:30 pm, drayco wrote: &

[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread drayco
I need that some of you guys check this, in my case, Pymysql have some issues with legacy databases (First, I think this issue is of new dal, but I'm not sure) However mysqldb, my application work well this is my report: http://groups.google.com/group/web2py/browse_thread/thread/72e91e281e0610d8/

[web2py] Re: Using mysqldb instead of pymysql

2011-01-18 Thread drayco
t=port, charset=charset, )) In dal.py However, the error is still appear Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/models/cfe

[web2py] Re: Can any help me with new dal in trunk?

2011-01-18 Thread drayco
not sure how it could have worked before, but the key (technogradua) > > > > > in .keys() is not being picked up... dal is simply pointing that out > > > > > with the exception being thrown. I did notice when I made the switch > > > > > that a few more of m

[web2py] Re: Using mysqldb instead of pymysql

2011-01-20 Thread drayco
Hi, I did my test with trunk version this is the issue Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/models/cfedb.py", line 16, in

[web2py] Re: Can any help me with new dal in trunk?

2011-01-27 Thread drayco
Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/models/cfedb.py", line 16, in migrate = False) File "/home/drayco/web2py/g

[web2py] Re: Can any help me with new dal in trunk?

2011-01-28 Thread drayco
Hi, I updated my trunk version However, The same issue is still This is the new traceback Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/

[web2py] help, how enable cron in webfaction with wgsi and apache2?

2012-12-05 Thread drayco
In file wgsihandler.py # change these parameters as required LOGGING = False SOFTCRON = True What does i miss? --

[web2py] help with IS_IN_DB?

2012-03-28 Thread drayco
I can try to show in form of input and output a dbset, but i want to modify prices, because it depends of store In model if store.store_id<7: armazones = db((db.eyewear.observaciones== '')&(db.eyewear.modelo!='SOLAR')) elif store.store_id>6: armazones = db((db.eyewear.observaciones!='2DA

[web2py] Help with vitrualfields

2011-09-16 Thread drayco
Hi, I want to display the porcentaje of some fields I put this in the end of model db.define_table("notas", Field("total", "double", default=0, writable=False), Field("anticipo", "double", default=0, requires=[IS_NOT_EMPTY(error_message='No puede estar vacio'),IS_FLOAT_IN_RANGE(0,1,er

[web2py] Re: Can any help me with new dal in trunk?

2011-01-31 Thread drayco
las 2 legadas. Suena raro pero eso necesitan en la escuela en la que trabajo en México. Gracias de antemano On Jan 28, 4:15 pm, DenesL wrote: > Are you sure it worked before? > As far as I know mysql is not supported for legacy DBs using > primarykey. > > On Jan 28, 5:04 pm, drayco

[web2py] Re: Can any help me with new dal in trunk?

2011-02-04 Thread drayco
that. Now, I have a problem with one database that it didn't is legacy database in the same old application This is the issue Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File

[web2py] Compatibility issues between versions 1.89.5 and 1.94.6 with legacy applications

2011-03-31 Thread drayco
_ALPHANUMERIC(error_message='¡Deben ser caracteres alfanumericos!'), \ IS_NOT_IN_DB(db,'benefs2.rfcWorked',error_message='El RFC ya existe')], label='Trabajador RFC'), IS_FLOAT_IN_RANGE(0,1e1000,error_message='Debe ser Numero positivo')], labe

[web2py] Re: Compatibility issues between versions 1.89.5 and 1.94.6 with legacy applications

2011-03-31 Thread drayco
the case in models that may trigger a > migration and data loss unless you convert the .table files. I will be > happy to do that for you if needed. > > Massimo > > On Mar 31, 1:03 pm, drayco wrote: > > > > > > > > > Good morning to all, our case i

[web2py] Re: Compatibility issues between versions 1.89.5 and 1.94.6 with legacy applications

2011-03-31 Thread drayco
to the model And when reviewing the MySQL database we see that the field is defined as sexoWorked. Any advice? On Mar 31, 12:47 pm, drayco wrote: > Please, we want you to help us confirm > > We have reviewed and benefs2.table SQL.LOG and we observe that the > field sexoWorke

[web2py] Re: Compatibility issues between versions 1.89.5 and 1.94.6 with legacy applications

2011-03-31 Thread drayco
Thanks. We put fake_migrate = True at all and we got it define_table Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 189, in restricted exec ccode in environment File "/home/drayco/web2py/applications/init/models/db.py", lin

[web2py] Re: Compatibility issues between versions 1.89.5 and 1.94.6 with legacy applications

2011-03-31 Thread drayco
Ok, We change to sexoworked and we got this Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 189, in restricted exec ccode in environment File "/home/drayco/web2py/applications/init/models/db.py", line 334, in Field(&#

[web2py] Re: Compatibility issues between versions 1.89.5 and 1.94.6 with legacy applications

2011-03-31 Thread drayco
Hi Dr.Massimo Following your advice, we changed in the model, all of fields names that use upper case with lower case, and we use fake_migrate = True and now we work with web2py 1.94.6 Thank you very much. On Mar 31, 1:52 pm, drayco wrote: > Ok, We change to sexoworked and we got t

[web2py] curious case of crud.search

2011-04-07 Thread drayco
:'Armazon1', 'lente1':'Lente1','lc4':'L/C 4','total':'Total','anticipo':'Anticipo','pagos':'Pagos','saldo':'Saldo', \ 'vendedor':'Vendedor','optometrista':'Op

[web2py] Re: MySQL, migration, and lower()

2011-04-20 Thread drayco
1.- Put in your model in every table fake_migrate=True 2.- Remove your *name_of_your_table.table 3.- Run web2py and go to admin application database 4.- Remove fake_migrate Your rebuild your *name_of_your_table.table On 20 abr, 14:15, Praneeth Bodduluri wrote: > 1) If you have no other schema c

[web2py] Re: MySQL, migration, and lower()

2011-04-20 Thread drayco
It's work for me On 20 abr, 23:46, drayco wrote: > 1.- Put in your model in every table fake_migrate=True > 2.- Remove your *name_of_your_table.table > 3.- Run web2py and go to admin application database > 4.- Remove fake_migrate > > Your rebuild your  *name_of_your_table.

[web2py] Re: Code insert-er for Pydev Eclipse users

2011-04-27 Thread drayco
Thank's a lot. On 27 abr, 16:21, pierreth wrote: > OK I see, > > This way, Pydev automatically had the missing imports when we are > coding. Personally, I added the library project by project so the > feature is working for me too. > > But this does not solve the problem of the missing imports fo

  1   2   >