Could you email me the app (confidentially)?
On Jul 27, 12:07 pm, Lionel Barret <lionel.bar...@gmail.com> wrote:
> In fact, I can update a row but I cannot add a new one.
>
> On Jul 27, 7:01 pm, Lionel Barret <lionel.bar...@gmail.com> wrote:
>
> > 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 ?
