[web2py] Install web2py on hostgator hatchling package

I 've bought Hatchling package hosting on hostgator. I tried install web2py on subfolder public_html/web2py but it was not successful. Server response 500 default status of hostgator: http://moneytweak.com/web2py/ This is my .htaccess and index.fcgi in web2py folder: ###.htaccess: AddHandler fc

[web2py] Install in hostgator

I 've bought Hatchling package hosting on hostgator. I tried install web2py on subfolder public_html/web2py but it was not successful. Server response 500 default status of hostgator: http://moneytweak.com/web2py/ This is my .htaccess and index.fcgi in web2py folder: ###.htaccess: AddHandler fcgi

[web2py] How can I start contributing to web2py?

http://web2py.com/books/default/chapter/29/15/helping-web2py is a place to start -- 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

[web2py] Re: web2py don't start

All fixed. Thanks. Marc On Wednesday, 5 March 2014 04:18:07 UTC, Massimo Di Pierro wrote: > > Please download it again in 10 minutes. > > On Tuesday, 4 March 2014 03:19:46 UTC-6, Marc wrote: >> >> I have the same problem, downloaded the latest version of web2py.exe for >> Windows and it doesn't

[web2py] 1054, "Unknown column in 'field list'... Help me

Hi. I tried adding new columns, but I got that error 1054, "Unknown column in 'field list'. As web2py document (set fake_migrate=True and after the metadata has been rebuilt, set fake_migrate=False and migrate the table again).--- I'm using MySQL), I did it but the problem was not sol

[web2py] gluon.contrib.populate error

I have defined the following table in a model: def define_customers(): db.define_table('customers', Field('ActiveMember', 'boolean', default=True, label=T("Active")), Field('FirstName', required=True, requires=IS_NOT_EMPTY(), label=T("First name")), Field('LastName', r

[web2py] Re: IS_IN_DB() validator only validating on form fields?

Okay, so the doc clearly says the validators are for input field validations (chapter 7). What would be the recommended way to add referential integrity check for the database to avoid something like what I described? Also I am currently using SQLite (and I realize the result will vary dependin

[web2py] Re: jinja2 -> web2py templates

Here is a better version: https://gist.github.com/mdipierro/9459290 On Sunday, 9 March 2014 22:26:34 UTC-5, Massimo Di Pierro wrote: > > Until today I had not realized how similar Jinja2 is to web2py templates. > In fact here is some code to convert the former to the latter: > > BEGIN jin

[web2py] Re: IS_IN_DB() validator only validating on form fields?

Make sure you define it as a reference field, and then you can set notnull=True -- in that case, the database will not all NULL values in that field. Also, you can always set up database constraints outside of web2py using other database clients to alter table definitions. Anthony On Monday, M

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

Generally helps to show the code and full traceback. On Monday, March 10, 2014 2:58:29 AM UTC-4, sujin...@gmail.com wrote: > > Hi. > I tried adding new columns, but I got that error 1054, "Unknown column in > 'field list'. > As web2py document > (set fake_migrate=True and after the me

[web2py] When I try to modify a table: invalid controller (undefined/index)

Hello all. When I try to modify some tables in the database admin page web2py returns me: invalid controller (undefined/index) It tries to go to the same URL that it use for all over applications: mydomain.com/myapp/appadmin/select/db?query=db.mytable.id>0 With all over applications in the same

Re: [web2py] Make grid view larger & add scroll bar to top

Thank you for the ideas, Tim. I like the idea of the wide_layout.html. I'll poke around and see if I can find where web2py sets the page width. Cheers! Austin On Sat, Mar 8, 2014 at 10:59 PM, Tim Richardson wrote: > > Tip, in case you didn't know: exploring CSS with a tool like Firefox's > Fire

[web2py] Re: Problem with upgrade to 2.9.4 with SQLTABLE

With the change, this is the result File "/home/drayco/web2py/applications/movil/controllers/cobros.py" , line 335, in pagos select(db.pagos.id.count()), headers={db.pagos.id.count():'Total Pagos'}) File "/home/drayco/we

Re: [web2py] Re: Problem with upgrade to 2.9.4 with SQLTABLE

Could you try to print the value of sqlrows.colnames in sqlhtml? What database are you using? 2014-03-10 18:22 GMT+01:00 drayco : > With the change, this is the result > > File "/home/drayco/web2py/applications/movil/controllers/cobros.py" >

Re: [web2py] Re: Problem doing a sortby in Smartgird

Stifan, Thanks for your help this solved the problem after 1 year. On Fri, Mar 7, 2014 at 6:53 PM, 黄祥 wrote: > you must set it on the dict for each table. > e.g. > *models/db.py* > db.define_table('category', > Field('name'), > format = '%(name)s') > > db.define_table('product', > Field('name'

[web2py] Re: Problem with upgrade to 2.9.4 with SQLTABLE

Variables c 'COUNT(pagos.id)' sqlrows.db ).groups undefined sqlrows.colnames ['COUNT(pagos.id)'] sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD <_sre.SRE_Pattern object> '.'.join undefined sqlrows.db._adapter sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.match sqlrows columns None El vi

Re: [web2py] Re: smartgrid orderby descending

Hi Dan. Sorry, but I can't remember if I ever got that problem solved. I did have this response to the question "I believe the keys of the orderby dict should be the actual table names, not the literal keys "parent" and "child"." I've not actually touched web2py in a while since I moved on to fl

[web2py] Re: Problem with upgrade to 2.9.4 with SQLTABLE

On Sunday, March 9, 2014 3:52:23 AM UTC-7, Niphlod wrote: > > that's because you're using the most unrecommended way to refer to an > aggregate (relying on a fixed representation...). > Did you try > > count = db.pagos.count() > Does drayco want to display the count of all the pages in the dat

[web2py] Help with SQL Query without using executesql preferably :)

This is the result i get from a simple select like this: legacy_db(legacy_db.cursodado.gp_pro_id==course).select() cursodado.gp_id cursodado.gp_pro_id cursodado.gp_historicdate cursodado.gp_curso_id 10003600042014-01-27 16:02:10None 10003600042014-01-27 17:18:31None 10003600042014-01-27 17

Re: [web2py] Re: session not recognising membership

unfortunately I can't replicate the issue. The strange thing is that if the session gets loaded, so **should** groups attached to it (because update_groups() is called WITHIN login_bare()). Without any replicable scenario, can you just try to add a few debug lines on gluon/tools.py within update

[web2py] Re: When I try to modify a table: invalid controller (undefined/index)

Wow. I've found the problem. I've add this line to the layout.html: Seems that main.js is already used by web2py, so with site.js it works. Il giorno lunedì 10 marzo 2014 16:11:42 UTC+1, Gael Princivalle ha scritto: > > Hello all. > > When I try to modify some tables in the database admin page w

[web2py] janrain google is not being displayed any longer

Used to have a basic janrain account, and yesterday morning Google login button disappeared, while other 3 are still there. Any suggestions what could be the reason? Afterwards I upgraded a service level to plus, regenerated Google+ key, and added Facebook and Twitter, but the original 3 (aol,

[web2py] Re: Help with SQL Query without using executesql preferably :)

The DAL chapter of the online Web2py manual explains how to fetch the max value, same as a SQL GROUP BY. On Monday, March 10, 2014 3:54:59 PM UTC-4, brahama von wrote: > > This is the result i get from a simple select like this: > > legacy_db(legacy_db.cursodado.gp_pro_id==course).select() > > cu

[web2py] Re: Problem with upgrade to 2.9.4 with SQLTABLE

drayco, correct me if I'm wrong but it looks like you didn't make the change Niphlod suggested. The error trace shows you still use db.pagos.id.count() rather than the suggested syntax. On Monday, March 10, 2014 1:22:04 PM UTC-4, drayco wrote: > > With the change, this is the result > > File

[web2py] Pass reference name in json

Hi I have a database table with a reference field. I'm passing the contents back as JSON but the reference field gets passed as ref_id rather than the format name. Is there anyway to pass back the format name rather than just the id of the reference record. many thanks Dave -- Resources: -

Re: [web2py] Re: multiple response.menu

On 10 Mar 2014 at 01:29:03, Massimo Di Pierro (massimo.dipie...@gmail.com) wrote: On Friday, 7 March 2014 09:22:02 UTC-6, ureal frank wrote: Hi, I'm very new to web2py. I've started watching Massimo's vimeo posts and I like what I am seeing, even thinking some concepts are little strange at th

[web2py] http://www.web2pyslices.com/ - Unhandled Exception

Hi, Didn’t know where to report but http://www.web2pyslices.com/ is having some issues. Anyone?  Cheers, --  Frank -- 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 I

[web2py] Re: RuntimeError: no available driver pymongo

I commented that code here and the site stopped giving this error dbmongo = DAL ("mongodb :/ / meuuser: p...@ds033709.mongolab.com: 33709/bd" check_reserved = ["mongodb_nonreserved"], adapter_args = {"safe": False}) made the connection in the way that the pymongo documentation guides and is r

[web2py] Re: 2.9.4 stable error when calling login_bare.

Thanks! No worries will turn it into a PR next time. Matt On Monday, March 10, 2014 2:06:14 PM UTC+13, Massimo Di Pierro wrote: > > fixed in trunk. thanks for the patch. > > On Saturday, 8 March 2014 21:40:35 UTC-6, Matt wrote: >> >> Attached code change to the issue also >> >> On Sunday, March 9

[web2py] Admin and tickets broken after upgrade to 2.9.4

Just hit upgrade now to Version 2.9.4 button and in web2py/applications/admin/errors: sssg317 S'Traceback (most recent call last):\n File "/home/www-data/web2py/gluon/restricted.py", line 217, in restricted\n exec ccode in environment\n File "/home/www-data/web2py/applications/adm

[web2py] Re: Admin and tickets broken after upgrade to 2.9.4

What did you upgrade from? You may have to restart web2py. On Monday, 10 March 2014 19:02:55 UTC-5, shapova...@gmail.com wrote: > > Just hit upgrade now to Version 2.9.4 button and in > web2py/applications/admin/errors: > > sssg317 > S'Traceback (most recent call last):\n File > "/home/

[web2py] Re: Admin and tickets broken after upgrade to 2.9.4

Thanks form prompt reply! Upgrade from previous 2.9.3, Just did #apachectl restart and now it complains on wsgihandler.py [Tue Mar 11 02:07:03 2014] [notice] Apache/2.2.16 (Debian) PHP/5.3.3-7+squeeze18 with Suhosin-Patch mod_ssl/2.2.16 OpenSSL/0.9.8o mod_wsgi/3.3 Python/2.6.6 configured

Re: [web2py] Re: OT: movuca internal error on comment

On Thu, Jan 2, 2014 at 6:50 PM, rochacbruno wrote: > Hi Manuele, > > Thanks for the report. > > I will check the problem ASAP. > > Alan (spametki), Anthony and Massimo are also able to access the > web2pyslices admin. > > BTW: web2pyslices needs more contributors, some things needs rewrite, if >

[web2py] Re: Admin and tickets broken after upgrade to 2.9.4

Next, I've looked and found no regex_longcomments defined in myregex.py so I comment it's import out. Got rid of wsgi load error but obviously still get S'Traceback (most recent call last):\n File "/home/www-data/web2py/gluon/main.py", line 446, in wsgibase\n serve_controller(request, resp

[web2py] Re: Admin and tickets broken after upgrade to 2.9.4

It is there: https://github.com/web2py/web2py/blob/master/gluon/myregex.py#L24 something broke during your upgrade. Perhaps web2py did not have permission to overwrite the files. Download the latest web2py and unzip over the existing one. (make a backup first). On Monday, 10 March 2014 19:11:08

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

I had made MXPDEVICE table, and I added MXPPCPLATFORM table yesterday. Then definition of MXPDEVICE changed as below (Red part). - db.define_table('MXPDEVICE', Field('NAME','s

[web2py] grid coloum width

hi, i have the table field data that using represent on it but the coloumn width it's seems affected by the table field header. e.g. db.define_table('supplier', Field('name'), Field('address', 'text'), Field('phone', 'list:string'), Field('email', 'list:string'), Field('ym', 'list:string'),

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

Looks like the new fields didn't get added to the database. Do you have migrations turned off? On Monday, March 10, 2014 7:56:11 PM UTC-4, sujin...@gmail.com wrote: > > I had made MXPDEVICE table, and I added MXPPCPLATFORM table yesterday. > Then definition of MXPDEVICE changed as below (Red part