Huge thanks!
That worked!
Den fredagen den 8:e mars 2013 kl. 12:45:34 UTC+8 skrev weheh:
What kind of error message are you getting?
I assume the request.vars['lesson'] and request.vars.answer are both
indices into their respective tables. However, request.vars will be holding
these
deviating from the standards can be a pain, but if you set the migration
off, change your column datatype outside web2py, the default typecasting
would kick in and it should work anyway.
PS: legacy db is where there are yet tables you can't change. The scheduler
creates its own tables, so
That's true.
But 'Serial' gives four-byte integer (no other option).
In MySQL's autoincrement, we can define it on any size of variable
(tinyint, mediumint, int, etc.).
This would make a difference when data size is large.
--
---
You received this message because you are subscribed to the
Greetings,
I have some issues with SQLTABLE when I want to use the headers argument.
If I call
SQLTABLE(data, _class='table table-bordered small', headers =
'fieldname:capitalize', columns = columns)
I get a table with the capitalized field names
If I call
SQLTABLE(data, _class='table
The need of smallint as boolean is required for my application...
I don't knows if the word legacy is correct, I can't change the table
structure but I can insert and delete records...
In any case I expect that running ./web2py.py-K logistica it reads my db.py
and my defines.
What's happen if my
This is going nuts. He was fine until now with SQLite, either one of mysql
or postgres will do fine, with a total preference on postgres if he doesn't
want to employ a legal office to know if he can use mysql or not.
PS: the day I'm going to choose mysql over postgres for the combined
Ok, got it. it's not the scheduler's table you want with the booleans to
work, it's the things the scheduler execute that needs to interact with
some other tables in the environment...to be polite, that little hack you
do is nice, but not the recommended way this is a case for your own
Hello,
I've been having this exact same problem for a long, long time.
I would also be interested in a solution, but I doubt there will be one. I
think it might be a design issue with Web2py.
Tamas
On Saturday, March 2, 2013 9:48:38 PM UTC+1, Marin Pranjić wrote:
It seems that the problem
A quote from the book:
Notice that distinct can also be an expression for example:
for row in db().select(db.person.name,distinct=db.person.name):
print row.name
Alex
Bob
Carl
While this works on PostgreSQL, others raise an exception.
OperationalError: near ON: syntax error
This is
On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:
Hello,
I've been having this exact same problem for a long, long time.
I would also be interested in a solution, but I doubt there will be one. I
think it might be a design issue with Web2py.
Tamas
I'm correct when I think that
On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote:
On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:
Hello,
I've been having this exact same problem for a long, long time.
I would also be interested in a solution, but I doubt there will be one.
I think it might be a
It's not just the legal aspect.
After seeing how poorly Oracle supported OpenOffice, I would be concerned
about their future support for MySQL as well.
On Friday, March 8, 2013 4:43:06 AM UTC-5, Niphlod wrote:
This is going nuts. He was fine until now with SQLite, either one of mysql
or
Field('is_correct', 'boolean', default=False)
In the form you get a checkbox widget unless you choose otherwise.
In the controller:
if form.vars.is_correct:
# do something
else:
#do otherwise
Less typing.
Also, look in your database back end and see how it represents the values.
You will
Cliff is absolutely right! If all you're storing is True or False, make the
field a boolean. It's much more efficient in all respects. The list: string
and list: reference are most useful if you're storing a reasonably small
number of one to many relationships.
--
---
You received this
That makes sense.
Thank you.
On Thursday, March 7, 2013 2:50:29 PM UTC-5, Niphlod wrote:
seems that whatever dict you pass only the values pertaining to the table
gets filled.
It's useful, e.g. for fields coming from multiple tables that needs to be
inserted , e.g. in a SQLFORM holding 2
why not define it on models like :
db.branch.address.label=T('Address')
hope this can help...
On Friday, March 8, 2013 4:17:32 PM UTC+7, Geo wrote:
Greetings,
I have some issues with SQLTABLE when I want to use the headers argument.
If I call
SQLTABLE(data, _class='table table-bordered
please try :
db.SuggestionCategorizationIntersection.taxonomyDataID.requires=IS_IN_DB(db(db.
TaxonomyData.taxonomyID==db.SuggestionCategorization.TaxonomyID),
db.TaxonomyData.id http://db.taxonomydata.id/, '%(taxonomyName)s')
hope this can help
--
---
You received this message because you
@Cliff MariaDB!!
:)
Richard
On Fri, Mar 8, 2013 at 7:36 AM, Cliff Kachinske cjk...@gmail.com wrote:
It's not just the legal aspect.
After seeing how poorly Oracle supported OpenOffice, I would be concerned
about their future support for MySQL as well.
On Friday, March 8, 2013 4:43:06
wait a sec who binds to that socket is apache, not web2py :D
On Friday, March 8, 2013 1:29:23 PM UTC+1, Tamas wrote:
On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote:
On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:
Hello,
I've been having this exact same problem
I'm a routes.py newbie! Amazing it's taken me this long to really dive in.
This should be trivial, but I'm struggling to get mydomain/robots.txt to
map to mydomain/static/robots.txt. In fact, none of my routes_in are
working. My non-working routes.py file:
#!/usr/bin/python
# -*- coding: utf-8
True, but... Apache is not raising errors, web2py is. The error message is
strange. At least we could have a nicer error if this can't be fixed.
However in my example, both instances work until i try to log in. I can use
the site without database i/o. Both instances work.
Now, why would web2py
Hello,
I am using Web2py on the Heroku servers with the gunicorn server (also
tried rocket) and using the helloFacebook example made by Michele Comitini
( https://code.google.com/r/michelecomitini-facebookaccess/ ).
I have updated with the latest facebookforpython facebook.py file, and
doing
why?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Hello,
I have a facebook app hosted on heroku working with the lastest stable
Web2py.
Initially everything works perfect (in local and in production server), but
sometimes, when restarting (in case of local on local modifications; and in
case of production, either when heroku restarts the
for the logging part
alter those to DEBUG
https://github.com/web2py/web2py/blob/master/logging.example.conf#L59
https://github.com/web2py/web2py/blob/master/logging.example.conf#L99
and you should read it in the console.
On Friday, March 8, 2013 3:08:22 PM UTC+1, weheh wrote:
I'm a
can you explain what triggers view refresh after
thing.update_record(active=not thing.active)
On Thursday, March 7, 2013 5:09:01 PM UTC-5, wwwgong wrote:
I am using v2.4.2 on win7, tried both chrome and firefox, same issue, I
have to do a refresh to see Active field checked/unchecked
On
Sorry, I don't follow. Alter what to DEBUG? Don't know what that means. Can
you see anything wrong with my routes.py file that causes
www.mydomain.com/robots.txt to generate a 404 error?
On Friday, March 8, 2013 10:18:25 PM UTC+8, Niphlod wrote:
for the logging part
alter those to DEBUG
This is a moderated group to avoid spam, but you have been cleared for
posting now :)
On Friday, March 8, 2013 5:41:22 AM UTC-5, Leo Rocha wrote:
why?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and
Hello François,
On Fri, Mar 1, 2013 at 4:06 AM, François Delpierre
francois.delpie...@gmail.com wrote:
I'm using Web2Py for 6 months now, and I'm very happy with it. But here
are the most missing features I found in Web2Py. Most of those missing
features concerns grids/smartgrids.
-
after those there was a pointer to the relevant line in logging.conf
embedded in the web2py repository: unfortunately I can't help you further
because I have no python available right now, so no web2py either ^_^
On Friday, March 8, 2013 3:29:16 PM UTC+1, weheh wrote:
Sorry, I don't follow.
Update,
I found (testig with other facebook user) that the problem is not when
I reboot the server, but when a user tries to log in for the second
time.
Following the trace I finally found that there is a call to the
gluon/dal.py RecordUpdater.__call__(**fields)
Where fields = {registration_id:
On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote:
True, but... Apache is not raising errors, web2py is. The error message is
strange. At least we could have a nicer error if this can't be fixed.
However in my example, both instances work until i try to log in. I can
use the
yep, got that part: I don't use apache and never had any problems with
multiple version running concurrently, but I guess there's a ton of users
out there using apache...I don't think that is a problem related to having
multiple web2py instances responding to the same port because that's what
On 8 Mar 2013, at 6:08 AM, weheh richard_gor...@verizon.net wrote:
I'm a routes.py newbie! Amazing it's taken me this long to really dive in.
This should be trivial, but I'm struggling to get mydomain/robots.txt to map
to mydomain/static/robots.txt. In fact, none of my routes_in are working.
Would you mind emailing me the details?
I won't promise, but I plan to look into it next week.
Dana petak, 8. ožujka 2013. 15:49:42 UTC+1, korisnik Tamas napisao je:
On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote:
True, but... Apache is not raising errors, web2py is. The
Hello,
I would like to build a form that will contain many row for the same table
to make a kind of batch insert of record a given table.
Now I am searching a way to append many different instance of the same
fields definition for a given table into SQLFORM.factory... Something like
that :
Ok, forget about that, I didn't know I could just do this :
SQLFORM.factory(db.table1.field1, db.table1.field2)
Richard
On Fri, Mar 8, 2013 at 10:26 AM, Richard ml.richard.vez...@gmail.comwrote:
Hello,
I would like to build a form that will contain many row for the same table
to make a
How I could re-instanciate each field in my for loop?
If I do this :
inputs = []
for i in range(0,10):
inputs.append(db.table1.field1)
inputs.append(db.table1.field2)
Even if I get 10 inputs of each they all refer to the same instance so when
I render the form with
DISTINCT and DISTINCT ON are two differents things :
http://www.postgresql.org/docs/9.1/static/sql-select.html#SQL-DISTINCT
I think that this is a issue with differents adaptors...
And you maybe right that DISTINCT ON is only available on postgres...
Richard
On Fri, Mar 8, 2013 at 5:31 AM,
Please open a ticket about this.
On Friday, 8 March 2013 02:28:13 UTC-6, Massimiliano wrote:
Is there any chance to take a look on this problem?
Thank you
On Mon, Feb 25, 2013 at 7:42 PM, Massimiliano mbel...@gmail.comjavascript:
wrote:
Hi,
I'm working on a legacy database where all
Sorry I misunderstood your previous statement.
On Friday, 8 March 2013 03:09:31 UTC-6, Vineet wrote:
That's true.
But 'Serial' gives four-byte integer (no other option).
In MySQL's autoincrement, we can define it on any size of variable
(tinyint, mediumint, int, etc.).
IMHO, this
Are you saying you want the form dropdown dynamically populated with a
subset of records based on the selection in a different field? If so,
you'll have to do that with Javascript and an Ajax call. See
See
http://stackoverflow.com/questions/8146260/best-practice-for-populating-dropdown-based-on-other-dropdown-selection-in-web2p/8152910#8152910
.
On Friday, March 8, 2013 2:03:28 AM UTC-5, José Manuel López Muñoz wrote:
Thank you Niphlod,
I've do it with the Cities, but now I've to populate
In web2py, distinct can be boolean (distinct=True) or an expression, as
quoted from the book. Boolean works fine, but expression maps to DISTINCT
ON.
It is in BaseAdapter class, _select method. I think only nosql adapters
override that method.
Marin (mobile)
On Mar 8, 2013 4:48 PM, Richard
Hi all,
A question I think very simple but I don't resolve it :
Some informations that I want to introduce in my site with Web2py comes in
a cPickle's file. I have all the time the error that I don't resolve in the
framework Web2Py :
[Errno 2] No such file or directory
Thus I have 2
I have been using the autocomplete widget which makes is really convenient.
However, there are times where I would like to customise what is shown in
the SELECT say with a custom expression rather than being limited to each
OPTION being the value of the field in the row.
It appears that the
Leo,
I http_x_forwarded_for was for reversed proxy web2py installations. I
removed it until as you did until we find a better solution.
I will look into registration_id issue as soon as I get on a desk...
tnx
mic
2013/3/8 Leonardo M. Rocha leo.m.ro...@gmail.com:
Update,
I found (testig
web2py works nicely with Firebird DB. Highly recommended.
On Thursday, March 7, 2013 3:41:18 PM UTC-5, BlueShadow wrote:
Hi guys so I learned that using SQLlite for me wasn't a great
choice(thanks Niphlod). But since I started using databases when I started
to use web2py. I got no clue
@Richard
Yeah, I know. But what about documentation?
The MySQL code itself is free open source, but Oracle owns the copyright on
the MySQL documentation.
So as the MariaDB fork adds features, the MySQL documentation becomes more
and more inaccurate. At some point there will have to be a
Thanks Cliff I wasn't about that issue, it's good to know that.
I would be really curious to know if the MySQL user base had splitted since
the MariaDB fork and what the proportion that stays with MySQL and now with
MariaDB...
Richard
On Fri, Mar 8, 2013 at 3:17 PM, Cliff Kachinske
Even if you can modify tools.py, my suggestion is to modify your db.py
code. Remember that you can do many things sub-classing the OAuthAccount
class!
This is what I use these very days. Look what you can do in the get_user()
method. Just map any of the returned attributes from facebook
it was simple especially because it was writen in the book page 156 !
• request.folder: the application directory. For example if the application
is
welcome, request.folder is set to the absolute path /path/to/welcome.
In your programs, you should always use this variable and the
Thanks 黄祥 but I think Anthony is right. The == syntax you gave me just
grabbed the first record in the Taxonomy table regardless of which one was
selected during data entry.
At least now I have the == syntax for some other tasks I needed.
Much appreciated Anthony,
Alex
On Friday, March 8,
I like to change my db to postgresql.
So I installed it by the following guide:
# setting up secure ssh
adduser dbuser
export EDITOR=nano
visudo
# add this to the end of the file
# dbuser ALL=(ALL) ALL
ssh-keygen -t rsa
# fill everything out correctly
scp ~/.ssh/id_rsa.pub
On Thu, Mar 7, 2013 at 2:47 AM, Alec Taylor alec.tayl...@gmail.com wrote:
My attempt:
msg = (403, json.dumps({state: , error_message: None, error:
unauthorized_client}), None, {'Content-Type': 'application/json'})
If I recall correctly, you are missing a **
Should be:
msg = (403,
Hi,
I tried the websocket (comet_messaging.py) and followed the procedures inside,
but got the following error in ajax_form():
ImportError: No module named gluon.contrib.comet_messaging
How can I solve the problem?
Thanks.
--
---
You received this message because you are subscribed to
I don't know in terms of user numbers but mysql is getting replaced with
mariadb in Fedora, which will have some impact.
Current plan for Fedora 19 is this:
- mariadb package will provide mysql
- existing mysql package will be renamed to MySQL
- mariadb and MySQL pacakges conflict, they can't be
I've been able to send a message from a terminal to the browser, but when
the browser tries to send a message, the error occurs.
On Friday, March 8, 2013 6:56:30 PM UTC-5, surfnet3 wrote:
Hi,
I tried the websocket (comet_messaging.py) and followed the procedures
inside, but got the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Em 08-03-2013 23:19, BlueShadow escreveu:
I like to change my db to postgresql.
So I installed it by the following guide:
|
# setting up secure ssh
adduser dbuser
exportEDITOR=nano
visudo
# add this to the end of the file
# dbuser ALL=(ALL)
Hi,this is my db:
db.define_table('clsb_product',
Field('product_category', type = 'reference clsb_category', notnull =
True,
label = T('Category')),
Field('product_type', type = 'reference clsb_product_type', notnull =
True,
Should be websocket_messaging.py now.
Anthony
On Friday, March 8, 2013 6:56:30 PM UTC-5, surfnet3 wrote:
Hi,
I tried the websocket (comet_messaging.py) and followed the procedures
inside, but got the following error in ajax_form():
ImportError: No module named
You'll get much better help on a forum that's about your OS and/or
postgresql, as this doesn't have anything to do with web2py.
Regards,
Ales
On Saturday, March 9, 2013 12:19:04 AM UTC+1, BlueShadow wrote:
I like to change my db to postgresql.
So I installed it by the following guide:
#
I'm still using an older version (2.0.9)
On Friday, March 8, 2013 9:00:17 PM UTC-5, Anthony wrote:
Should be websocket_messaging.py now.
Anthony
On Friday, March 8, 2013 6:56:30 PM UTC-5, surfnet3 wrote:
Hi,
I tried the websocket (comet_messaging.py) and followed the procedures
Never mind, I found the solution.
Stupid me, restarting the computer solves the problem :)
On Friday, March 8, 2013 9:13:08 PM UTC-5, surfnet3 wrote:
I'm still using an older version (2.0.9)
On Friday, March 8, 2013 9:00:17 PM UTC-5, Anthony wrote:
Should be websocket_messaging.py now.
I don't know if this is the correct place to post this:
http://www.web2py.com/book/default/chapter/01#security
Serves me: invalid function (default/chapter)
Original page: http://web2py.com/init/default/what
(containing the link)
Greets Rene
--
---
You received this message because you are
Hi,
Precisely today i have send a patch to Massimo for the book
https://github.com/mdipierro/web2py-book/blob/master/sources/29-web2py-english/13.markmin
You can review what you need to do
Saludos,
Alfonso de la Guarda
Twitter: @alfonsodg
Redes sociales:
The error is a missing redirection as we moved the web2py host. Use this
link:
http://www.web2py.com/books/default/chapter/29/01#security
On Friday, 8 March 2013 21:07:28 UTC-6, Rene Dohmen wrote:
I don't know if this is the correct place to post this:
Hi. I'm trying to generate a package to deploy my web2py application on an
apache server but when I use the button Deploy to openshift the system tell
me Requires Distuttils, but not installed. what can I do?
--
---
You received this message because you are subscribed to the Google Groups
Hi. Does someone knows how to deploy web2py over cpanel in an apache server?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
I cannot reproduce the problem.
It would help if you could isolate it. Do you see the memory increase
during upload? After upload? During validation? After validation? When the
form is successfully uploaded or only when there is error in the form? Can
you reproduce it if there is only one
You need to install distutils. Use
ez_setup.py http://peak.telecommunity.com/dist/ez_setup.py
On Friday, 8 March 2013 12:47:24 UTC-6, cor...@xionex.cl wrote:
Hi. I'm trying to generate a package to deploy my web2py application on an
apache server but when I use the button Deploy to openshift
Why isn't the content-type inherited from response.headers in the HTTP
object construction?
def test():
response.headers['Content-Type'] = 'application/json'
raise HTTP(500, json.dumps(dict(test=True)), **response.headers)
HTTP/1.1 500 INTERNAL SERVER ERROR
Path=/
Content-Type:
(pasted output was in reverse order .)
On Sat, Mar 9, 2013 at 4:08 PM, Alec Taylor alec.tayl...@gmail.com wrote:
Why isn't the content-type inherited from response.headers in the HTTP
object construction?
def test():
response.headers['Content-Type'] = 'application/json'
raise
73 matches
Mail list logo