[web2py] Re: web2py 2.16.1 is OUT

[lyn2py]

Hello,

The traceback for Python 3 is not like the ones in Python 2 and it can get 
difficult to debug the program, is it possible to see a fix soon?

Thank you!

On Tuesday, November 14, 2017 at 1:59:52 PM UTC+8, Massimo Di Pierro wrote:
>
> web2py 2.16.1 is OUT
>
> Lots of bugs fixes contributed by the community. Thanks Leonel, Paolo, 
> Giovanni, and all those who contributed.
>
> the most visible changes are:
>
> - welcome now defaults to bootstrap 4
> - lots of cleanup in the welcome app and new examples in default.py
> - simplified layout.html
>
> Massimo 
>
>
>
>

-- 
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 
"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/d/optout.

[web2py] Re: first use question

[Dave S]

On Friday, April 27, 2018 at 10:52:47 AM UTC-7, msul...@mail.ccsf.edu wrote:
>
> I'm trying to log into:   
>  http://127.0.0.1:8000/admin/default/index?send=%2Fadmin%2Fdefault%2Fsite 
> 
>so far,  I get a  "log into admin interface" message.However, when I 
> attempt? no result !
>  is this typical? Rather, is there a time length I'm to wait for my login 
> credential to validate?
>

Looking at the admin/controller/default.py code, it appears that index() 
expects you to be already authenticated (there would be a cookie for that), 
or to include the password var.

(I don't use admin directly much, although on my dev machine I use 
myapp/admin which is related)

/dps
 

-- 
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 
"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/d/optout.

[web2py] Re: defining a field for current year in web2py using datetime for autofillin

[Dave S]

On Thursday, April 26, 2018 at 11:52:01 PM UTC-7, annika...@gmx.de wrote:
>
> Hm - could it be db.drop_table("orders")  in the controller? But how do I 
> make sure it is actually dropped?
>
> Sorry about the confusion...
>
>
For a onetime use, just the sqlite3 command line, you don't need to do it 
in a contoller.

If you have the migrate options set appropriately (which is the default 
when the "make new app" button is used, IIRC),
then the very next request should create the new version of the table.

(I use an integer for a year date in one of my apps, and it works very well 
for me.   I use it with the IN_RANGE() validator because I am not tracking 
coins older than 1965.)

/dps

 

-- 
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 
"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/d/optout.

[web2py] first use question

[msulli29]

I'm trying to log into:   
 http://127.0.0.1:8000/admin/default/index?send=%2Fadmin%2Fdefault%2Fsite 

   so far,  I get a  "log into admin interface" message.However, when I 
attempt? no result !
 is this typical? Rather, is there a time length I'm to wait for my login 
credential to validate?

-- 
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 
"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/d/optout.

Re: [web2py] DAL return all Fields

[Richard Vézina]

for f in db.table.fields:
print f

or

rows = db(db.fruits.id > 0).select(db.fruits.ALL)  # ALL means all fields

for r in rows:
print(r)

You can control which field you want with the previous example

myfields = [f for f in db.table.fields if
SOME_FILTERING_CHECK_OVER_THE_FIELD_YOU_WANT]


for r in rows:
for f in myfields:
print(r[f])


You can play around that you should be able to figure out how you can do
what you wanna do.

Richard

On Fri, Apr 27, 2018 at 10:08 AM, Maurice Waka 
wrote:

> Addendum
>
> I want a single list of  the items (the data from all fields)
>
> regards
>
> On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka 
> wrote:
>
>> There are several fields in my db such as this:
>>
>> db.define_table('fruit', Field('id', 'reference auth_user'), 
>> Field('apple','boolean',label=T('Apple')), 
>> Field('apricot','boolean',label=T('Apricot')), 
>> Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
>> label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
>> Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
>> label=T('Pear')), Field('plum','boolean', label=T('Plum')))
>> If i want to print items from a specific field i would do:
>>
>> rows = db(db.fruits)select()for row in rows:
>>  return row.apple
>>
>>
>> Now I want to return all data from all fields. How Can i go about it.
>>
>> I have tried:
>>
>> return rows and I get a blank screen.
>>
>> return [rows] and I get [].
>>
>> Kind regards
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/web2py/-Hlx1yh-4MU/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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
> "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/d/optout.
>

-- 
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 
"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/d/optout.

[web2py] Re: Validate a GET request using SQLFORM.factory and request vars

[Anthony]

On Friday, April 27, 2018 at 3:36:41 AM UTC-4, Alfonso Serra wrote:
>
> The auto id field, may not be a problem, i removed it for convenience for 
> a couple of reason:
> - iterate form.fields in the view to create the html. in this case was not 
> needed but also the special treatment as it should lie on hidden inputs.
>

You can instead iterate over form.custom.widget. It includes 'id' as a key 
as well, but its value is an empty string, so easy to conditionally exclude 
by checking that.
 

> - the type checking on this case was validating the id which was not part 
> of the factory declaration, not accepting the form. Ofc this could be 
> solved with some code refinement and leave everything how it is.
>

Not sure what workflow led to that, but I haven't seen any such issues with 
either SQLFORM or SQLFORM.factory.

Note, even with a standard SQLFORM based on a DAL table, "id" is included 
in form.fields even though it is not an input in the actual form nor 
processed upon form submission. I'm not sure if "id" serves any purpose in 
either case, but if we make a change, it should apply in all cases, not 
just SQLFORM.factory.
 

>  
>
>> We really don't want to try to replicate validation logic directly in the 
>> form methods -- you would not only need to validate the data but also 
>> provide a way to specify error messages as with the validators. It would be 
>> a big unnecessary mess.
>>
>
> Hmm i dont know if you would like this but i have also thought about it. 
> Validator's error messages could be done by web2py translator, kinda like 
> IS_DATE already does for date formats. If these messages are automated they 
> could be easily changed at the translation file instead of having to 
> declare them everytime on all the apps. Would also shorten the Fields 
> declarations this way.
>

That can already be done based on the default error messages associated 
with each validator (all validator error messages are passed to T() before 
being returned from the validator), but that is not a sufficient 
replacement for the current system, which allows custom messages to be 
associated with particular instances of particular validators dynamically.
 

> I have been recently involved in a project to translate a custom complex 
> app and been thinking on ways to improve web2py translator.
>

Probably worth a separate post in the web2py-developers Google group.

Anthony

-- 
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 
"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/d/optout.

Re: [web2py] DAL return all Fields

[Maurice Waka]

Addendum

I want a single list of  the items (the data from all fields)

regards

On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka  wrote:

> There are several fields in my db such as this:
>
> db.define_table('fruit', Field('id', 'reference auth_user'), 
> Field('apple','boolean',label=T('Apple')), 
> Field('apricot','boolean',label=T('Apricot')), 
> Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
> label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
> Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
> label=T('Pear')), Field('plum','boolean', label=T('Plum')))
> If i want to print items from a specific field i would do:
>
> rows = db(db.fruits)select()for row in rows:
>  return row.apple
>
>
> Now I want to return all data from all fields. How Can i go about it.
>
> I have tried:
>
> return rows and I get a blank screen.
>
> return [rows] and I get [].
>
> Kind regards
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/-Hlx1yh-4MU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 
"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/d/optout.

[web2py] DAL return all Fields

[Maurice Waka]

There are several fields in my db such as this:

db.define_table('fruit', Field('id', 'reference auth_user'), 
Field('apple','boolean',label=T('Apple')), 
Field('apricot','boolean',label=T('Apricot')), 
Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
label=T('Pear')), Field('plum','boolean', label=T('Plum')))
If i want to print items from a specific field i would do:

rows = db(db.fruits)select()for row in rows:
 return row.apple


Now I want to return all data from all fields. How Can i go about it.

I have tried:

return rows and I get a blank screen.

return [rows] and I get [].

Kind regards

-- 
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 
"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/d/optout.

Re: [web2py] Re: Updated Version of web2py and sending emails stopped working

[Richard Vézina]

Can you show us your code (omit your credential)... You mention you use
Office 365, they might have made some change you may want to have a look in
the account config if SMTP has change. Or you could also try ot use the
SMTP of the FAI with a no-reply email...

Richard

On Thu, Apr 26, 2018 at 10:09 PM, James O' Driscoll <
james.odrisc...@gmail.com> wrote:

> I am not using AWS, just standard methods IMAP/SMTP.
>
> On Wed, 25 Apr 2018 at 7:36 am, Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> Notice that web2py in trunk supports sending emails from AWS+SNS
>>
>> just do
>>
>> mail.settings.server='aws'
>>
>> the sender email must be authorized in the SNS config
>>
>>
>>
>> On Wednesday, 4 April 2018 20:17:20 UTC-5, Dave S wrote:
>>>
>>>
>>>
>>> On Wednesday, April 4, 2018 at 6:13:06 PM UTC-7, Dave S wrote:



 On Wednesday, April 4, 2018 at 6:10:28 PM UTC-7, Dave S wrote:
>
>
>
> On Wednesday, April 4, 2018 at 5:08:22 PM UTC-7, James O' Driscoll
> wrote:
>>
>> Any insights??  Surely this is not preferable when people who have
>> clients and have to update web2py get no support.
>
>
> I updated from 2.14.6 to 2.15.4 with no issues to mail.  Not a very
> big jump, perhaps, but it went okay.
>
> Perhaps you can do a -M yourapp -S and try the commands by hand, and
> see if you get additional error messages.
>
> Is this code in a controller or a module?  Is it run during a normal
> request, or from the scheduler?
>
>
 Also, are you connecting to a third-party mail service such as Google
 or SparkPost?

>>>
>>> [I don't; I have an AWS Linux machine with a local sendmail, which may
>>> color my answers]
>>>
>>> And see Massimo's comments from last June:
>>> 
>>>
>>> /dps
>>>
>>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/
>> topic/web2py/Qf_LhJAsT7c/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> 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
> "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/d/optout.
>

-- 
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 
"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/d/optout.

[web2py] Users Procedure in python for Kanboard

[Alejandra Montiel Saavedra]

Hello!
I do not know much about how to code to link to Kanboard.
I have a question about how to configure the user creation parameters (for me 
it is a bit confusing) in Python
def newuser():
from kanboard import Kanboard
kb = Kanboard('http://localhost/kanboard/jsonrpc.php', 'jsonrpc', 'API 
token')}
results = kb.createUser({username, password, name, email, role})
return dict(users=results)

I saw it in the documentation.

   - Parameters:
  - *username* Must be unique (string, required)
  - *password* Must have at least 6 characters (string, required)
  - *name* (string, optional)
  - *email* (string, optional)
  - *role* (string, optional, example: app-admin, app-manager, app-user)
   - Result on success: *user_id*
   - Result on failure: *false*

-- 
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 
"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/d/optout.

[web2py] Insert data in firebird database

[Константин Комков]

Hello! I'm trying add data in my table.
tables.py
db_xml.define_table('xml_files',
Field('F'),
Field('I'), 
Field('O'),
Field('IS_IMPORTED'),
Field('XML_FILE'),
format='%(id)s %(F)s %(I)s %(O)s %(IS_IMPORTED)s %(XML_FILE)s',
migrate=False)
default.py

db_xml.xml_files.insert(F='Castle', I='Rick' O='Middlename' IS_IMPORTED='0' 
XML_FILE='something')

DatabaseError: ('Error while preparing SQL statement:\n- SQLCODE: -104\n- 
invalid request BLR at offset 51\n- generator GENID_XML_FILES is not defined', 
-104, 335544343)

(('Error while preparing SQL statement:\n- 
SQLCODE: -104\n- invalid request BLR at offset 51\n- generator GENID_XML_FILES 
is not defined', -104, 335544343))




-- 
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 
"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/d/optout.

[web2py] Re: Validate a GET request using SQLFORM.factory and request vars

[Alfonso Serra]

The auto id field, may not be a problem, i removed it for convenience for a 
couple of reason:
- iterate form.fields in the view to create the html. in this case was not 
needed but also the special treatment as it should lie on hidden inputs.
- the type checking on this case was validating the id which was not part 
of the factory declaration, not accepting the form. Ofc this could be 
solved with some code refinement and leave everything how it is.
 

> We really don't want to try to replicate validation logic directly in the 
> form methods -- you would not only need to validate the data but also 
> provide a way to specify error messages as with the validators. It would be 
> a big unnecessary mess.
>

Hmm i dont know if you would like this but i have also thought about it. 
Validator's error messages could be done by web2py translator, kinda like 
IS_DATE already does for date formats. If these messages are automated they 
could be easily changed at the translation file instead of having to 
declare them everytime on all the apps. Would also shorten the Fields 
declarations this way.

I have been recently involved in a project to translate a custom complex 
app and been thinking on ways to improve web2py translator. 

Improvable things im planning to change on my project would be. 

- Load the translations within a module to stay in memory when the server 
starts. Not sure if this is already happening or are being read from disk 
on demnand.
- Plurals should not be translated by themselves without their contexts as 
they may change the grammatical form of sentences depending on the language.

There is a mechanism that i like which is to store pluralizable sentences 
as dictionaries, for example:

"15 items found."

the translation declaration could be:

{"%(count) items found": {
  "zero": "No items found"
 , "one": "one item found"
 , "many": "some items found"
 , "other": "%(count)s items found" 
   }
}

then T("%(count) items found", count=1)

will detect this is a pluralizable string since the translation is a 
dictionary expecting the count parameter. 
Then will choose the right pluralized translation. 
The "many" keyword could be also configurable.
There would be no need to have 2 separate translation files (not a problem 
if they are), neither isolate plural words from phrases to be translated. 
Also take care of plurals genetive saxon "The children's ballons" and other 
syntaxis or grammars on other languages.
Translators would have context to translate the sentences.

It goes without saying this would break compatibility but it would make my 
app much more easy to handle.

Please let me know any thoughts.

Best Regards.

-- 
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 
"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/d/optout.

[web2py] Re: defining a field for current year in web2py using datetime for autofillin

[annika . elting]

Hm - could it be db.drop_table("orders")  in the controller? But how do I 
make sure it is actually dropped?

Sorry about the confusion...


-- 
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 
"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/d/optout.

[web2py] Re: defining a field for current year in web2py using datetime for autofillin

[annika . elting]

Thanks for the hint at stackoverflow, Anthony. Just how do I drop a table 
in web2py? I know how to drop a table in sql but where would I do it in 
web2py? In the model most likely but how is this done? 

So far I have commented out the old table and created a new one. But that's 
just a workaround.

Thanks.
Annika

Am Donnerstag, 26. April 2018 16:29:52 UTC+2 schrieb annika...@gmx.de:
>
> Hello,
>
> I am completely new to Web2Py (please bear with me) and have the following 
> problem:
>
> I am trying to define a database and have the current year as a field 
> which should be automatically filled in using datetime. 
>
> But when I try to open the database and look at the entries I get a 
> traceback which I do not understand (see below). 
>
>
> Edit: I think it has to do something with strftime having only one 
> argument. When I am using strftime("%Y%m%d") it is working perfectly. But I 
> really only need the current year.
>
>
> Thank you
>
> **Code**
>
> import datetime
>
>db.define_table('orders',
> Field("current_year", "string",Label=T('Current 
> Year'), rdefault=datetime.datetime.now().strftime("%Y"),eadable=True, 
> writable=False))
>
>
>
> **Code using IS_DATETIME**
>
> After reading the web2py documentation I also tried this: 
>
> Field('current_year', 'string', label=T('Current Year'), 
> default=IS_DATETIME(format=T('%Y')),readable=True, writable=False))
>
>
> But I get the same traceback (see below)
>
> Thanks, any help would be appreciated
>
> **Traceback:**
>
> Traceback (most recent call last):
>   File 
> "/home/PyCatUB/web2py/applications/contacts/controllers/appadmin.py", line 
> 269, in select
> *fields, limitby=(start, stop))
>   File "/home/PyCatUB/web2py/gluon/packages/dal/pydal/objects.py", line 
> 2020, in select
> return adapter.select(self.query, fields, attributes)
>   File "/home/PyCatUB/web2py/gluon/packages/dal/pydal/adapters/sqlite.py", 
> line 123, in select
> return super(SQLiteAdapter, self).select(query, fields, attributes)
>   File "/home/PyCatUB/web2py/gluon/packages/dal/pydal/adapters/base.py", 
> line 1296, in select
> return self._select_aux(sql,fields,attributes)
>   File "/home/PyCatUB/web2py/gluon/packages/dal/pydal/adapters/base.py", 
> line 1253, in _select_aux
> self.execute(sql)
>   File "/home/PyCatUB/web2py/gluon/packages/dal/pydal/adapters/base.py", 
> line 1388, in execute
> return self.log_execute(*a, **b)
>   File "/home/PyCatUB/web2py/gluon/packages/dal/pydal/adapters/base.py", 
> line 1382, in log_execute
> ret = self.get_cursor().execute(command, *a[1:], **b)
>   File "/usr/lib/python2.7/sqlite3/dbapi2.py", line 66, in 
> convert_timestamp
> datepart, timepart = val.split(" ")
> ValueError: need more than 1 value to unpack
>

-- 
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 
"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/d/optout.