Sorry to be slow but I don't get it.
This is what I did :
* changed the sqldb to dal
* changed the sqlfield to field
* check that the params were good (the "text" type you mention).
tested on this table, defined in db.py :
--
db.define_table('product_pages',
Field('title', 'string', length="128"),
Field('text', 'text'))
db.product_pages.title.requires = IS_NOT_EMPTY()
db.product_pages.text.requires = IS_NOT_EMPTY()
---
I still get the error whe trying to update the table. I use the
appadmin.
What's wrong ?
L.
On Jul 27, 6:32 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> P.S. you problem is 2 years old. You may also want to replace SQLField
> with Field and SQLDB with DAL for aesthetic reasons.
>
> On Jul 27, 11:31 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > One of your fields has a length=None. Change it to a value or (better)
> > set the type to 'text'.
>
> > Massimo
>
> > On Jul 27, 11:26 am, Lionel Barret <lionel.bar...@gmail.com> wrote:
>
> > > Hi all,
>
> > > We are moving our app from one host to the other.
>
> > > We used v1.44 on our old host, the new one use the current version.
>
> > > And as I test the new host, I discovered our database cannot be
> > > updated/written to anymore.
>
> > > It can be read, though as the site does work, and the admin app does
> > > display the db content.
>
> > > I tested with our app and the admin app.
>
> > > I get the same error in both case :
>
> > > Traceback (most recent call last):
> > > File "gluon/restricted.py", line 178, in restricted
> > > exec ccode in environment
> > > File "/srv/Web/www/web2py/applications/g2009_current/controllers/
> > > appadmin.py", line 281, in <module>
> > > File "gluon/globals.py", line 96, in <lambda>
> > > self._caller = lambda f: f()
> > > File "/srv/Web/www/web2py/applications/g2009_current/controllers/
> > > appadmin.py", line 103, in insert
> > > if form.accepts(request.vars, session):
> > > File "gluon/sqlhtml.py", line 1029, in accepts
> > > self.vars.id = self.table.insert(**fields)
> > > File "gluon/sql.py", line 1933, in insert
> > > query = self._insert(**fields)
> > > File "gluon/sql.py", line 1913, in _insert
> > > value = value[:field.length]
> > > TypeError: slice indices must be integers or None or have an __index__
> > > method
>
> > > Any ideas ? Massimo ?
