Re: [web2py] ORA-00910 on table creation

Thank you Richard. I shall try your suggestions this morning. On Monday, 23 April 2012 17:12:36 UTC+2, Richard wrote: > > Also, since you have a lot of column, you may start with fewer column and > identify the exact column that trigger the error. > > I will be easier to help you with simpler mo

[web2py] table which references another table in another db

Hi, I'm trying to build a relation between two database of the same postgresql instance. I have these two files: a_database.py db.define_table('title', Field('title'), Field('year'), migrate = False, fake_migrate = True ) main.py import a_database db.d

[web2py] Re: Little little Document Management System with flatbed scanners

Thank Szimszon. I am using windows 7 it with errors of Windows plaforms. Could you help me? Traceback (most recent call last): File "E:\web2py1997\gluon\restricted.py", line 205, in restricted exec ccode in environment File "E:/web2py1997/applications/dms/controllers/default.py"

[web2py] Re: Using _before_insert to implement subsecond precision?

Bump. Anyone know the answer? On Wednesday, April 18, 2012 4:02:37 PM UTC-4, nick name wrote: > > A question I keep bugging (and submitting patches about) is the > implementation of subsecond precision in the database. With the new code, I > believe it is as simple as doing: > > def change_datet

[web2py] Re: Little little Document Management System with flatbed scanners

try now https://github.com/szimszon/dms/commit/7398fffbd117dbfbbaa1ebb07c23fe207d626c98 2012. április 24., kedd 9:46:03 UTC+2 időpontban IVINH a következőt írta: > > > Thank Szimszon. > I am using windows 7 it with errors of Windows plaforms. Could you help > me? > > > Traceback (most recent cal

[web2py] Re: how can one replace an element in html?

I think the regex method may be the best answer. I guess there is no way of getting at the index subscript from elements()? On Tuesday, 24 April 2012 01:02:14 UTC+1, Anthony wrote: > > I'm not sure there's an easy way to delete or replace server-side DOM > components using the .elements() method

[web2py] IDE reinvented web2py-style...

Of interest to all of us programmers, and maybe an inspiration to web2py's future webbased-IDE iterations: Light Table by Chris Granger

[web2py] Re: IDE reinvented web2py-style...

* * > and If they hit $300k, Python will be the third language to be supported out of the gate

[web2py] Re: Little little Document Management System with flatbed scanners

On Mon, 23 Apr 2012 23:43:14 -0700 (PDT) szimszon wrote: > Now it is in github :) Sorry I had to move to a smaller virtual > server but now you can try :) I'll definitely try it. > Nowadays I have little time to work on it but I'm open to receive > pull requests :) I did abandon idea to use Ja

[web2py] Re: Little little Document Management System with flatbed scanners

It's work. You are good man. Thanks. Vào 15:21:17 UTC+7 Thứ ba, ngày 24 tháng tư năm 2012, szimszon đã viết: > > try now > https://github.com/szimszon/dms/commit/7398fffbd117dbfbbaa1ebb07c23fe207d626c98 > > 2012. április 24., kedd 9:46:03 UTC+2 időpontban IVINH a következőt írta: >> >> >> Tha

[web2py] Re: Little little Document Management System with flatbed scanners

2012. április 24., kedd 11:41:47 UTC+2 időpontban Gour a következőt írta: > > > I did abandon idea to use Java-based solutions and, so far, like Mayan > EDMS written in Django (http://rosarior.github.com/mayan/), but having > one in web2py would be even more cool. ;) > > Too bad, you're not occup

Re: [web2py] ORA-00910 on table creation

I've reduced the number of columns on the second table and I did not get an error starting up. But then I started getting errors on the first table after I changed a column. It seems to occur whenever I modify the database layout in any way. I also see that I am generating a bunch of weird trigge

[web2py] Cannot start web2py - Runtime error: Unable to import driver

I'm trying to use web2py on a Ubuntu install. I can start it up from the console, but as soon as I navigate to it in the browser I the internal error about not being able to import the driver. I haven't touched anything or done any type of special configuration. I've gotten it to work in WIndow

[web2py] DB with dynamic model

In the DB I am accessing the data is distributed into tables with the same structure but different names. With the parameters received in the HTTP request I can obtain the table name I have to use (I have something like an "index" for this) How can I use the table in web2py when its name is in a

[web2py] Re: I wish I could use a virtualfield in IS_IN_DB

El lunes, 23 de abril de 2012 22:43:39 UTC-3, Anthony escribió: > > tb_categorias.format = '%(nombre)s' #This does not work >> >> tb_obras.categoria.requires = IS_IN_DB(db, tb_categorias.id, >> '%(nombre)s') >> > > Both the "format" argument to define_table() and the "label" argume

[web2py] jquery-ui with grid: strange behaviour

I am using bootstrap.min.css and bootstrap.js that comes with the trunk. The two attachments show the different screens for the grids of two tables. In both cases the grid was called with ui = 'jquery-ui' As far as I can see the html produced is the same except for the url: Screenshot *13:0

[web2py] Re: Cannot start web2py - Runtime error: Unable to import driver

Can you paste the traceback of the ticket? On Monday, April 23, 2012 11:10:55 PM UTC-4, Goronmon wrote: > > I'm trying to use web2py on a Ubuntu install. I can start it up from the > console, but as soon as I navigate to it in the browser I the internal > error about not being able to import th

Re: [web2py] Cannot start web2py - Runtime error: Unable to import driver

On 24 April 2012 05:10, Goronmon wrote: > I'm trying to use web2py on a Ubuntu install. I can start it up from the > console, but as soon as I navigate to it in the browser I the internal > error about not being able to import the driver. > > I haven't touched anything or done any type of special

[web2py] Re: mailing with pgp

@szimszon: I was hoping to hear from you ... you are a gem for replying so quickly. The doc says to do the import, which is why I'm doing that. How about these other settings -- are they necessary? mail.settings.cipher_type = 'gpg' mail.settings.sign = True mail.settings.encrypt = Tr

[web2py] Help deploying Web2py on FluxFlex

Hi, I have followed the instructions on deploying web2py to fluxflex that i found here. My app was copied from local development on the path ...web2py/applications/myapp and placed in ../public_html/applications/myapp on t

Re: [web2py] Help deploying Web2py on FluxFlex

There might be two problems: - You uploaded the "setup.py" file included in web2py sources tar ball. Remove it -You pushed too many things: you only should push your app directory, not the web2py or applications directory from your local drive. I.e. git should be available only at myapp in ...web2p

[web2py] Re: DB with dynamic model

Yes, DAL and Table both inherit from dict, so you can do: db[tablename][fieldname] to refer to a particular table and/or field. There are some examples of this near the end of this section: http://web2py.com/books/default/chapter/29/6#Record-representation. Anthony On Tuesday, April 24, 2012

[web2py] Re: how can one replace an element in html?

> > I guess there is no way of getting at the index subscript from elements()? > No, and returning indexes for a given element would be tricky because it searches recursively through the DOM tree, so you might need to subscript the top-level element multiple times to traverse to an element foun

[web2py] Re: mailing with pgp

I'm still not getting this to work. Would you mind posting a complete example? Thanks.

[web2py] Re: how can one replace an element in html?

On Tuesday, April 24, 2012 9:00:25 AM UTC-4, Anthony wrote: > > I guess there is no way of getting at the index subscript from elements()? >> > > No, and returning indexes for a given element would be tricky because it > searches recursively through the DOM tree, so you might need to subscript >

Re: [web2py] Cannot start web2py - Runtime error: Unable to import driver

There is a bug with version 1.99.7 especially if you want to use postgresql. If you don't have psycopg2 installed then it will give the an error about get can't find you need to change the connection string if you want to use the built in driver that comes with this version of web2py, I have p

Re: [web2py] table which references another table in another db

I am doing the same kind of thing but using programming logic to map the two databases. I don't think it is possible to have a foreign key in one table point to another table. On Tue, Apr 24, 2012 at 12:37 AM, Vincenzo Ampolo wrote: > Hi, > > I'm trying to build a relation between two database o

[web2py] Re: why do posts not show?

I have been having problems with google groups recently. Some of may posts have disappeared and re-appeared. Please post your question again. Sorry for the trouble. massimo On Monday, 23 April 2012 23:45:21 UTC-5, Matt Thompson wrote: > > I posted something last week but it's not showing on the

[web2py] Re: Using _before_insert to implement subsecond precision?

I think this belongs to the validator. If the validator has already removed the subseconds you are in no luck. If it works for you, I do not see a problem. Anyway, remember that this API is experimental. They will stay but we may still change something before 2.0 On Wednesday, 18 April 2012 15:

[web2py] Re: IDE reinvented web2py-style...

Cool indeed. Not sure how it scales to more complex problems. On Tuesday, 24 April 2012 03:53:42 UTC-5, newnomad wrote: > > Of interest to all of us programmers, and maybe an inspiration to web2py's > future webbased-IDE iterations: > Light Table by Chris > Granger

Re: [web2py] Cannot start web2py - Runtime error: Unable to import driver

This problem was fixed in trunk some time ago. On Tuesday, 24 April 2012 08:15:11 UTC-5, Bruce Wade wrote: > > There is a bug with version 1.99.7 especially if you want to use > postgresql. If you don't have psycopg2 installed then it will give the an > error about get can't find you need t

Re: [web2py] table which references another table in another db

Definitively not possible. The DB does not allow it. You can make the reference field and integer and give it a IS_IN_DB validators pointing to the other table. It will work as you want to but bypass the DB restriction. On Tuesday, 24 April 2012 08:17:21 UTC-5, Bruce Wade wrote: > > I am doing t

Re: [web2py] ORA-00910 on table creation

Is the database (oracle) already existing or you create a new one? Do you leave web2py create and update the schema for you? If so, you should be aware that certain changes are not apply if they need a change in column type and other possible scenario. If you are the creator of the database and

Re: [web2py] Re: db._adapter.reconnect()

On 13 April 2012 21:46, Richard Vézina wrote: > This solution look great, because until now web2py was triggering a error > if postgres return not unique and won't insert the data... > > This problem has bitten me again. My previous test was in the console. Now in a controller I did the followin

Re: [web2py] Re: db._adapter.reconnect()

On 24 April 2012 15:41, Johann Spies wrote: > On 13 April 2012 21:46, Richard Vézina wrote: > >> This solution look great, because until now web2py was triggering a error >> if postgres return not unique and won't insert the data... >> >> > This problem has bitten me again. My previous test was

[web2py] Re: mailing with pgp

I have no little time sorry, I found the original testing code I used: #!/usr/bin/env python from gluon.tools import * mail=Mail() mail.settings.server='smtp server' mail.settings.sender='sender@address' mail.settings.login='user:pass' print mail.send('rec@address','test1','sign+encrypt',cipher

[web2py] Cannot log in with Opera

While testing different browsers I discovered that I cannot log in to my app using Opera 11.62. Opera just returns me to the login screen after submitting the login form. No problem with Firefox and Chrome. Any Opera users out there: do you have problems communicating with web2py? Regards Johann

[web2py] Re: DB with dynamic model

Thank you Anthony for your quick response, it works fine. I've been making some tests and have just found another way to access the table, just storing in a variable the result from define_table. In the model: *tb* = db.define_table(mytable, Field('myfield')) and in the controller : result = db(

[web2py] Re: Cannot log in with Opera

I have web2py 1.99.7 and Opera 11.62. I can log in to the Admin interface and the welcome application without problems. I don't have any other applications to test. Regards On Tuesday, 24 April 2012 16:21:12 UTC+2, Johann Spies wrote: > > While testing different browsers I discovered that I can

Re: [web2py] Cannot start web2py - Runtime error: Unable to import driver

I'm at work atm, so I can't provide specifics from my environment. It is extremely similar to the following http://stackoverflow.com/questions/8857953/why-does-web2py-crash-for-me-upon-startup Now that I've had some time to sleep on the issue, the only thing I can think of is that SQLite didn

[web2py] object is not callable

hi, my application on local host works fine but when i upload to server i got this error Traceback (most recent call last): File "/home/zerooo123/web2py/gluon/restricted.py", line 205, in restricted exec ccode in environment File "/home/zerooo123/web2py/applications/orhei/controllers/defa

[web2py] Problems creating and copying applications on remote server

I've just installed web2py on a fresh CentOS 6 instance on Rackspace, using the script here: http://code.google.com/p/web2py/source/browse/scripts/setup-web2py-fedora.sh I also enabled a

[web2py] Re: object is not callable

> > i think the problem is in request.args so i tried smth like this: > arg = request.args[0] rows = db(db.articles.reference == arg).select(*articles,limitby=(0,30)) return dict(row=db.menu[arg], rows = rows) and still have problems but another error: Traceback (most recent

[web2py] Cannot log in with Opera

Do you have cookies disabled on Opera? I had a user with the same symptoms on IE and that is what they had done.

[web2py] Re: Problems creating and copying applications on remote server

And another issue I'm having: When I pack an application in on my local Mac's web2py, and then try to install it on the remote server through the admin, I get an "unable to install" error. (Again, if the app was packed from the remote server, it installs fine.) I really need help with this as t

[web2py] Re: object is not callable

> > i think the problem is in request.args so i tried smth like this: >> > > arg = request.args[0] > rows = db(db.articles.reference == > arg).select(*articles,limitby=(0,30)) > return dict(row=db.menu[arg], rows = rows) > In general, I don't think request.args should be None

[web2py] MySQL issues

Hi I've recently updated my MySQL test server to version 5.1.61 on Ubuntu. In my db.py I specify my field names with mixed case. In my.cnf I have: lower-case-table-names = 1 In the past this has always worked for me. But today, once I upgraded MySQL, I'm getting the following on any request

[web2py] Re: Time to move from Google Groups to a web2py or python??

And that's why you use dogfooding, so your software is solid. I'm sure the web2py.com site is solid and bug-free, but that issue tracking is not dogfooded and it is very buggy and difficult to use, if usable at all. It may be a starting point for building an app, but for example the issues link

[web2py] Google Drive with free 5Gb

I notice that "Google Drive" has launched with free 5Gb of storage and a python test app to demonstrate access via API. As this seems like a very good way of storing files with more features than Dropbox, if anyone links a Web2py app and has code to share, please let us know. https://develop

[web2py] Re: Time to move from Google Groups to a web2py or python??

> > So, why does the issue tracking suck? Because it was just written as a > proof of concept. Why isn't it getting any better? because we aren't using > it. Why aren't we using it? Because it sucks. I think if others saw that > web2py was a stable solution by virtue of the fact that we are usi

[web2py] Re: Time to move from Google Groups to a web2py or python??

Google Groups is very good so I don't see any need to move away from it. StackOverflow doesn't work very well for these types of discussions. As far as dogfood, it would be nice to have a package or two getting some usage such as Blog, CMS or wiki. A wiki for tips, tricks and sample code would

[web2py] Re: Time to move from Google Groups to a web2py or python??

+1 for StackOverflow/StackExchange- Forget the latest google groups iteration, StackOverflow is just the best proven system for software QA by miles, and it bothers me that the best web framework out there still hasn't taken the plunge and embraced it. Every time I have a web2py question I'm fo

Re: [web2py] Re: Time to move from Google Groups to a web2py or python??

Any project such as bug tracking or CMS should go on their own. That would be the best solution. It would do the following: - prove that a different group of people not directly involved in web2py core development can build a complex app on top of web2py. - help testing web2py on a large project w

[web2py] need help combine autocomplete and web2py slice SELECT_OR_ADD_OPTION

Hello, I modify SELECT_OR_ADD_OPTION in order to combine autocomplete widget and the SELECT_OR_ADD_OPTION widget, but only thing I get from autocomplete in form is it instance id : Here what I change in SELECT_OR_ADD_OPTION : class SELECT_OR_ADD_OPTION(object): def __init__(self, contro

[web2py] Re: Google Drive with free 5Gb

Fascinating. Is there any internet company, google is not trying to complete with? On Tuesday, 24 April 2012 13:49:38 UTC-5, villas wrote: > > I notice that "Google Drive" has launched with free 5Gb of storage and a > python test app to demonstrate access via API. As this seems like a very > g

Re: [web2py] Re: Time to move from Google Groups to a web2py or python??

On Mon, Apr 23, 2012 at 2:41 PM, Gour wrote: > On Mon, 23 Apr 2012 08:07:13 +0200 > Tim Michelsen > wrote: > >> What is wrong with Google groups via Gmane? > > Probably nothing wrong except that we're growing old and youngsters > believe everything should be available via (web) forums. :-) I fee

[web2py] Re: Time to move from Google Groups to a web2py or python??

On Tue, 24 Apr 2012 12:58:27 -0700 (PDT) Yarin wrote: > Every time I have a web2py question I'm forced to weigh the benefits > of posting on SO, where I know I'll get an answer within 10 minutes, > vs posting in this forum where I'll wait a few hours to get an answer > from Massimo/Anthony. If

[web2py] Connections per viewer

Curious what is the common connections that a web server should have per user? Using netstat -an | grep :80 | sort I noticed that one user could have around 10 connections for some reason. Maybe this is caused by my lack of nginx + uwsgi knowledge but that seems very high per viewer. -- -- Regar

Re: [web2py] Connections per viewer

It depends on how many links to objects are in a view and browser configuration. You must count all css, js and img at least. The browser has an upper configurable limit to parallel connections after reaching that limit it starts queuing connections. One thing that comes also into play is http kee

[web2py] Default Layout Maze

I have been reading the book and this is what I found for the default layout: "skeleton.css" contains reset, grid layout and form styles "web2py.css" contains web2py specific styles "superfish.css" contains menu styles Then somewhere on top, I found base.css and its explanation. Then you have ske

[web2py] Re: mailing with pgp

I'm running 1.99.7 and none of the arguments to mail.send are valid. All the mail variables must be set via mail.settings as far as I can tell. That said, I have all my settings in place but things still not working. I'm going to start digging into mail logs next. On Tuesday, April 24, 2012 9:4

[web2py] Re: Default Layout Maze

I don't think it's that bad. Actually, skeleton is deprecated for Bootstrap. So now you just have bootstrap.min.css and web2py.css. You can create a new file for your own styling or add to the bottom of web2py.css. App frameworks generally have less theming than a CMS like MODx.

[web2py] Language translations options

Hi, I have been noticing members having read errors on the server when trying to load the translation file as it is to large/or slow. Any suggestions on how to make this work as our language file only has 1407 lines in it. -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://ww

[web2py] Re: Default Layout Maze

I hardly use that stuff, if ever. It's easy enough to roll your own. In the longer term, it's moving to some opensource css templates. On Wednesday, April 25, 2012 6:53:58 AM UTC+8, greenpoise wrote: > > I have been reading the book and this is what I found for the default > layout: > > "skeleto

Re: [web2py] Connections per viewer

Yeah that makes since. I am trying to figure out how to scale this. What is the largest site running web2py? My site is getting around 1000 new members a day and around 10-30 million page views a day. Just from the last two days I have ~53,000+ session files per server so * 3 at least which I need

[web2py] Re: Cannot start web2py - Runtime error: Unable to import driver

I figured it out. I forgot that I had built python from source and I had to install libsqlite3-dev so that I could then rebuild python to get sqlite to install correctly. That ended up taking care of the issue.

Re: [web2py] Connections per viewer

> > Just from the last two days I have ~53,000+ session files per server so * > 3 at least which I need to write a cron script to remove if they are over X > time old. > http://code.google.com/p/web2py/source/browse/scripts/sessions2trash.py

[web2py] Re: Default Layout Maze

The idea is you use skeleton.css (now bootstrap instead) and superfish.css if you want to stick with the scaffold app style, but you can drop them completely otherwise. web2py.css is for some framework-specific things that you might want to keep even if you don't keep the scaffold app style (fla

[web2py] Re: Reading web2py tickets on app engine

i think that the tickets tables are defined somewhere in the ticket handleryou need to define the table before you can query it. i don't remember where - i see some stuff in restricted.py On Monday, April 23, 2012 4:57:11 PM UTC-7, David Phillips wrote: > > I don't know how to read the ti

Re: [web2py] Reading web2py tickets on app engine

On Tue, Apr 24, 2012 at 12:57 AM, David Phillips wrote: > I don't know how to read the tickets web2py generates on app engine. On > devserver, the tickets are shown in their entirety, but on the production > server, the datastore viewer only shows the first 1000 or so characters. I > can't figure

Re: [web2py] shared host deployment of my web2py site

I got SSH enabled on my account. Currently using putty but when i run this: "./configure --prefix=$HOME" i get the following error: *checking for --enable-universalsdk... no* *checking for --with-universal-archs... 32-bit* *checking MACHDEP... linux2* *checking EXTRAPLATDIR...* *checking machine

[web2py] Re: Language translations options

Please open a ticket about it. I will see if I can add caching. On Tuesday, 24 April 2012 19:09:50 UTC-5, Bruce Wade wrote: > > Hi, > > I have been noticing members having read errors on the server when trying > to load the translation file as it is to large/or slow. Any suggestions on > how to

Re: [web2py] Re: CMS question

I updated https://github.com/mdipierro/editablebody Now only the content of tags with class="editable" are editable unless the ?body=true is set. This needs to be set server side based on permission and also validated server side using, for example, beautifulsoup. Although validation is not re

Re: [web2py] Cannot log in with Opera

On 24 April 2012 17:59, Ron McOuat wrote: > Do you have cookies disabled on Opera? I had a user with the same symptoms > on IE and that is what they had done. Thanks Ron. That was the problem. I rarely use Opera and upon checking I saw that both javascript and cookies were disabled. Regards J

[web2py] Re: mailing with pgp

Sorry for that. I have little time :( Is there anything in mail.error after the mail.send(...)? The user running web2py has a pgp keyring with the right keys? Is there any exception during mail.send? Can you post the code you are using? 2012. április 25., szerda 1:06:14 UTC+2 időpontban weheh a