[web2py] Issues with cpdb - references invalid table

Hi, While migrating data from postgresql to ms-sql-server I am getting following error: * EXCEPTION: could not make a copy of the database ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Foreign key 'admission_clinic__constraint' references invalid table 'clinic'.") * It is

Re: [web2py] Re: uwsgi respawning

Oh, OK. Will do. Thank you. On Thu, Nov 28, 2013 at 10:20 AM, Roberto De Ioris wrote: > > > In my case, the rss is pretty OK (a 4 GB machine, 12 workers). But > address > > space is high - > > {address space usage: 284536832 bytes/271MB} {rss usage: 22073344 > > bytes/21MB} > > And why you are

Re: [web2py] Re: uwsgi respawning

> In my case, the rss is pretty OK (a 4 GB machine, 12 workers). But address > space is high - > {address space usage: 284536832 bytes/271MB} {rss usage: 22073344 > bytes/21MB} And why you are worried ? It is virtual memory, i could allocate 2GB of address space without wasting more than few k of

[web2py] Re: web2py 2.8.1 is OUT

an error occured during upgrade on pythonanywhere from web2py admin panel and manually from bash console, both return same error. Internal errorTicket issued: admin/139.192.163.182.2013-11-28.04-40-34.c74c4e23-0068-4e9a-addd-a1a8cb3de97b

Re: [web2py] Re: uwsgi respawning

In my case, the rss is pretty OK (a 4 GB machine, 12 workers). But address space is high - {address space usage: 284536832 bytes/271MB} {rss usage: 22073344 bytes/21MB} On Thu, Nov 28, 2013 at 10:00 AM, Roberto De Ioris wrote: > > > OK. My real doubt is more about how uwsgi works. It scanned th

Re: [web2py] Re: uwsgi respawning

> OK. My real doubt is more about how uwsgi works. It scanned through many > files and probably loaded quite a bit of those in memory. When a new > process is spawned, will this (buffer) be passed to that? If so, it is > better to increase the limit. On the other than hand, if it is some > bootstr

Re: [web2py] Re: uwsgi respawning

OK. My real doubt is more about how uwsgi works. It scanned through many files and probably loaded quite a bit of those in memory. When a new process is spawned, will this (buffer) be passed to that? If so, it is better to increase the limit. On the other than hand, if it is some bootstrap process

[web2py] Re: web2py 2.8.1 is OUT

How can i remove existing sessions? -- 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 Gr

[web2py] Re: web2py 2.8.1 is OUT

You need to remove existing sessions. The format is a little different (faster). On Wednesday, 27 November 2013 21:59:43 UTC-6, webpypy wrote: > > > Hi, > > I got the error: > 'dict' object has no attribute 'is_mobile' > it works fine in 2.7.4 > -- Resources: - http://web2py.com - http://web2

[web2py] Re: web2py 2.8.1 is OUT

Hi, I got the error: 'dict' object has no attribute 'is_mobile' it works fine in 2.7.4 -- 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 th

[web2py] Re: Formatting the Time Field

ok so the format now looks Great on the form however on submitting it i get this invalid literal for int() with base 10: '00PM'> It seems like its trying to store the value 00PM as mins which should be an integer... however i was under the impression that the dal handled time conversion for th

[web2py] Re: web2py 2.8.1 is OUT

A word about this the blocked generic.jsonp for security reasons: Upgrading the file in old apps is recommended. If you are using it for your app, it is advicesed to create a copy for each function used, and avoid the generic view. On Wednesday, November 27, 2013 10:31:05 PM UTC+2, Massimo Di P

[web2py] Re: Install web2py in virtualenv

w2p_clone works fine and clones web2py to your virtual environment where you can launch it by doing the standard *cd web2py* then *python web2py.py* The original pypi version installs a slimmed down version of gluon only. I would change it but perhaps someone is using it. To complicate matters

[web2py] modify session value that store query as_list()

hi, is it possible to modify session value that store query as_list()? e.g. *controllers/**purchase_transaction.py* def purchase_return_form(): fields = ['purchase_order_no', 'notes'] form = SQLFORM(db.purchase_return_header, fields = fields) if form.validate(): session.purchase_return_header = di

[web2py] Re: Cron job every 30 seconds

web2py's scheduler will let you set the repeat period in seconds so you could probably do 30 seconds that way. On Tuesday, November 26, 2013 2:55:16 PM UTC-6, melmg wrote: > > Is is possible to set up a cron job to run every 30 seconds instead of a > minute? I have a function that does an HTTP G

[web2py] Re: Form self-submit broken after redirection

@Niphlod -- thanks for your insights. Sorry, I have not enough juice to dig deep enough into the web2py_component to see how it's done and then port signature into it. But if I did I would definitely submit it as web2py_component is about the single most cool thing in all of web2py. That said,

Re: [web2py] web2py 2.8.1 is OUT

Did this work before? Nothing changed there. On Wednesday, 27 November 2013 16:22:21 UTC-6, mweissen wrote: > > I get: > > D:\web2py>\Python27\python.exe .\web2py.py -p 8000 -a 123 -i 0.0 > .0.0 -K secure -X > web2py Web Framework > Created by Massimo Di Pierro, Copyright 2007-2013 > Version 2.8.1

Re: [web2py] web2py 2.8.1 is OUT

rname is there but there is a pending patch that will change the syntax. I wanted to get everything else out of the way before touching the DAL again. ;-) On Wednesday, 27 November 2013 14:44:39 UTC-6, Richard wrote: > > Congrats! > > No, rname yet? > > Richard > > > On Wed, Nov 27, 2013 at 3:3

[web2py] Re: web2py 2.8.1 is OUT

i got an error during bulk_insert (the same script is work fine in 2.7.4) code : db.rack.bulk_insert([{'rack' : '1', 'branch' : 1, 'name' : 'B1R1'}, {'rack' : '2', 'branch' : 1, 'name' : 'B1R2'}, {'rack' : '3', 'branch' : 1, 'name' : 'B1R3'}, ]) traceback : Traceback (most recent call last):

[web2py] Very intersting article about a radio station & web2py

http://www.reddit.com/r/Python/comments/1rlcwl/scaling_stereodose_a_web2py_internet_radio_station/ -- 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 rec

[web2py] Re: Formatting the Time Field

On Wednesday, November 27, 2013 11:05:18 AM UTC-8, Jesse Ferguson wrote: > > OK I figured it out! > {{include 'web2py_ajax.html'}} > > jQuery.timeEntry.setDefaults({show24Hours: false, showSeconds: false, > timeSteps:[1,30,1]}); > > > > Glad to hear that you've got things working! /dps

[web2py] Re: Strange Issue with Executesql

I'm assuming @Josh isn't actually doing a straight 'select * from table' but is rather using that here as a placeholder for his real query which is presumably doing more and therefore might benefit from some indexing. If it really was just 'select * from table' why bother with executesql instead

[web2py] Re: web2py 2.8.1 is OUT

Hello Massimo, congratulations!!! Hello Massimo, congratulations! What would db().select().as_tree()? Has example? Em quarta-feira, 27 de novembro de 2013 18h31min05s UTC-2, Massimo Di Pierro escreveu: > > Changelog > > > - no more winservice (use nssm instead) > - better imap support in DAL >

[web2py] Re: web2py 2.8.1 is OUT

Auto upgrade worked perfectly. -- 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

Re: [web2py] web2py 2.8.1 is OUT

I get: D:\web2py>\Python27\python.exe .\web2py.py -p 8000 -a 123 -i 0.0 .0.0 -K secure -X web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2013 Version 2.8.1-stable+timestamp.2013.11.27.20.07.10 Database drivers available: SQLite(sqlite3), MySQL(pymysql), PostgreSQL(pg8000), MSSQ

[web2py] Re: Recreating a table

nope. you have to delete the corresponding .table file from the databases/ folder. web2py doesn't do "introspection" of a database. It stores in the .table files what it thinks the database actually looks like, and compares .table contents to what models are, eventually triggering a migration.

Re: [web2py] web2py routes.py

Webfaction have restart my application Apache process, now it works with init. I'm gone make more test, grazie ! Il giorno mercoledì 27 novembre 2013 19:43:47 UTC+1, Dave S ha scritto: > > > > On Wednesday, November 27, 2013 12:14:22 AM UTC-8, Gael Princivalle wrote: >> >> Sorry Dave for my bad E

[web2py] Re: Recreating a table

had you define migrate=True on your models and delete sql.log on your databases folder? best regards, stifan -- 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)

Re: [web2py] web2py 2.8.1 is OUT

Congrats! No, rname yet? Richard On Wed, Nov 27, 2013 at 3:31 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Changelog > > > - no more winservice (use nssm instead) > - better imap support in DAL > - db().select().as_tree() > - bootstrap 2.3.2 > - codemirror 3.19 > - virtual fiel

[web2py] web2py 2.8.1 is OUT

Changelog - no more winservice (use nssm instead) - better imap support in DAL - db().select().as_tree() - bootstrap 2.3.2 - codemirror 3.19 - virtual fields in grid - improved mongoDB support, thanks Alan - support for wiki custom render function - Wiki(...groups=['x','y']) allows bypassing def

[web2py] Re: Formatting the Time Field

OK I figured it out! {{include 'web2py_ajax.html'}} jQuery.timeEntry.setDefaults({show24Hours: false, showSeconds: false, timeSteps:[1,30,1]}); -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goog

[web2py] Recreating a table

After defining a model it automatically migrated this to the DB and the table was created. I was feeling adventurous so I deleted this table in the hope that the migration will automatically recreate the table but it tries to alter an already existing table which it thinks it created already. Ho

[web2py] Re: Running Scheduler in Openshift with Web2py

does openshift allow for a separate non-web related process to be launched ? I'm not sure that it does. If so, you can't use the scheduler. On Tuesday, November 26, 2013 6:16:18 PM UTC+1, Boris Aguilar wrote: > > Hi I'm currently running web2py in an openshift instance using > [1]

[web2py] Re: Form self-submit broken after redirection

if you want to "port" the code that does the signature in python to javascript, feel free to submit it :D However, you should pass along the hmac_key, and doing so, you're exposing what you're trying hard to mask. However, it's kinda of a non-question as per the markup you posted. if your j

[web2py] Re: Strange Issue with Executesql

On Wednesday, November 27, 2013 6:48:50 AM UTC+1, Brian M wrote: > > Querying out 47K rows is taking 4.5-5.5 seconds on my laptop (and its > specs are nothing special). Not sure how the complexity of my query > compares to yours but 20-150 seconds seems slow. Heck I can get back over > 800K ro

[web2py] Re: uwsgi respawning

as long as you indeed want to relaunch any process going upper that limit (that, as every other "template" is a rule of thumb) yes. Alter it if you feel that your app needs more memory On Wednesday, November 27, 2013 1:04:23 PM UTC+1, Jayadevan M wrote: > > Hi, > I used > > https://github.com/we

Re: [web2py] web2py routes.py

On Wednesday, November 27, 2013 12:14:22 AM UTC-8, Gael Princivalle wrote: > > Sorry Dave for my bad English. > > I have no Italian, save for a few terms from music, so you're ahead of me :-) > You've understand exactly what I was saying, also if I'm confused, thanks. > > I'm still making t

[web2py] Model and Controller with Web2Py, View with Excel ??

Hi, the combination web2py-DAL with python code (controller) and Excel to manipulate and chart table data would be wonderful. That would mean rapid prototyping with a lot of databases and the option to go to web later. So, is it possible to use „only“ the model and controller level from web

[web2py] Re: Admin access on hostmonster account

Over a year gone, I'm trying again, and still no luck. At this point, I don't even get this error message anymore. I just get a 500 error when trying to access the page. I've also added in tips/tricks from: https://groups.google.com/forum/#!searchin/web2py/hostmonster/web2py/h8uLiDCerx0/l5isz

[web2py] multiple select plugin and list reference

I found this wonderfull plugin: http://dev.s-cubism.com/plugin_multiselect_widget which looks awesome for the things I wonna do. But I don't get ist to work with a field which has a list reference table I want the field to be either empty of filled with an unlimeted amount of entries. So I had no

Re: [web2py] LDAP Auth

ldap_auth need care, to me it's a draft that need code review, but it works... I had many issue when I deploy ldap_auth with AD... But I didn't have time to work further on these issues, we figure it out what was the bottom of them, but refatoring ldap_auth need time and the most important tests...

[web2py] Re: Files toggle sidebar pop-up on initial page load

patch issued https://code.google.com/p/web2py/issues/detail?id=1792 Please note that I can't attach the patched file in issue tracker app since it gives me the following message: Issue attachment storage quota exceeded. Anyway you'll find the patched file here attached. Il giorno mercoledì 2

Re: [web2py] Re: DAL pool_size

Forever until drop by the database server. On Wednesday, 27 November 2013 05:58:21 UTC-6, Jayadevan M wrote: > > I did. I don't see any mention of how long the connections are retained - > 5 seconds/5 minutes? > Regards, > Jayadevan > > > On Wed, Nov 27, 2013 at 4:58 PM, 黄祥 >wrote: > >> please r

[web2py] uwsgi respawning

Hi, I used https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-nginx-uwsgi-centos64.sh to set up our environment. Probably because of the setting reload-on-as = 256, I see many entries like "{address space usage: 284729344 bytes/271MB} {rss usage: 22147072 bytes/21MB} [pid: 26452|

Re: [web2py] Re: DAL pool_size

I did. I don't see any mention of how long the connections are retained - 5 seconds/5 minutes? Regards, Jayadevan On Wed, Nov 27, 2013 at 4:58 PM, 黄祥 wrote: > please read the book about connection pooling. > > ref: > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer

[web2py] Re: single datable record formatting

Hi. In the "custom code to display record" how is it possible to call record data ? table.field1 table.field2 Same thing for headers ? Thanks. Il giorno martedì 15 maggio 2012 16:51:43 UTC+2, Marian Siwiak ha scritto: > > It worked as expected. > Thank you very much! > Marian > > W dniu wtor

Re: [web2py] Re: Can't store query in session

why not adopt that slice into web2py feature? so that user just call it function e.g. taken from that slice : #==Controller 1== session.query = query_as_dict(query) #==Controller 2== query = query_from_dict(db, session.query) ref: http://www.web2pyslices.com/slice/show/1489/save-query-in-sessio

[web2py] Re: DAL pool_size

please read the book about connection pooling. ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-pooling best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - h

Re: [web2py] Cron job every 30 seconds

Linux standard cron doesn't allow it. Bu you can have a process that enters a loop, do something, sleeps for n seconds e try again. On Tue, Nov 26, 2013 at 6:55 PM, melmg wrote: > Is is possible to set up a cron job to run every 30 seconds instead of a > minute? I have a function that does an HT

[web2py] Re: disk cache problem

Hello! Nobody has problem with disk cache? 2013. november 26., kedd 9:16:31 UTC+1 időpontban szimszon a következőt írta: > > http://code.google.com/p/web2py/issues/detail?id=1791&thanks=1791&ts=1385453629 > > I have an app with lot of disk cache usage in selects after 2.7 - don't know > exactl

[web2py] DAL pool_size

How long does web2py retain the connections it obtains? -- 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 subscrib

Re: [web2py] web2py routes.py

Sorry Dave for my bad English. You've understand exactly what I was saying, also if I'm confused, thanks. I'm still making the same test on another application in another web2py installation with a different domain.com, Problems are still the same. Anyway I'm gone use the "init" application name