When I do this, it works fine..but still I am not able to link the
categories table to the product table, that is when the error pops up!:-
db.define_table('product',
Field('name',requires=IS_NOT_IN_DB(db,'product.name')),
Field('image','upload'),
Field('icon','upload'),
Field('price','double',requires=IS_FLOAT_IN_RANGE(0,1000)),
Field('info','text',default=''),
Field('category'),
format='%(name)s ($%(price)s)')
db.define_table('categories',
Field('category',requires=IS_NOT_IN_DB(db,'categories.category')),format='%(category)s')
db.define_table('order_item',
Field('product',db.product),
Field('buyer',db.auth_user),
Field('quantity','integer'),
Field('price','double'),
Field('ordered_on','datetime',default=request.now))
I am able to link product table to the order_item table but am not able to
do the same with product and categories table!... I dont understand that!
On Tue, Sep 21, 2010 at 6:07 PM, mdipierro <[email protected]> wrote:
> this is not a web2py error. OperationalError is a database error. I do
> not think it is caused by this code. Soemthing is wrong with the db
> config.
>
> On Sep 21, 5:04 am, bally boy <[email protected]> wrote:
> > Ok so this is a little tweaked code of the estore which Massimo posted.
> The
> > original one works fine, but here I am just adding a table categories :-
> >
> > db.define_table('categories',
> >
> >
>
> Field('category',requires=IS_NOT_IN_DB(db,'categories.category')),format='%(category)s')
> >
> > db.define_table('product',
> > Field('name',requires=IS_NOT_IN_DB(db,'product.name')),
> > Field('image','upload'),
> > Field('icon','upload'),
> >
> Field('price','double',requires=IS_FLOAT_IN_RANGE(0,1000)),
> > Field('info','text',default=''),
> > Field('category',db.categories),
> > format='%(name)s ($%(price)s)')
> >
> > db.define_table('order_item',
> > Field('product',db.product),
> > Field('buyer',db.auth_user),
> > Field('quantity','integer'),
> > Field('price','double'),
> > Field('ordered_on','datetime',default=request.now))
> >
> > But I get this error here:-
> >
> > Traceback (most recent call last):
> > File "/home/sathyavivek/web2pynew/gluon/restricted.py", line 186, in
> > restricted
> > exec ccode in environment
> > *File
> **"/home/sathyavivek/web2pynew/applications/sathya/models/db_store.py"*
> > <http://127.0.0.1:8000/admin/default/edit/sathya/models/db_store.py>*,
> > line 11, in <module>
> > format='%(name)s ($%(price)s)'*)
> > File "/home/sathyavivek/web2pynew/gluon/sql.py", line 1359, in
> define_table
> > t._create(migrate=migrate, fake_migrate=fake_migrate)
> > File "/home/sathyavivek/web2pynew/gluon/sql.py", line 1845, in _create
> > fake_migrate=fake_migrate)
> > File "/home/sathyavivek/web2pynew/gluon/sql.py", line 1914, in _migrate
> > self._db._execute(sub_query)
> > File "/home/sathyavivek/web2pynew/gluon/sql.py", line 980, in <lambda>
> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
> execute
> > self.errorhandler(self, exc, value)
> > File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35,
> > in defaulterrorhandler
> > raise errorclass, errorvalue
> > OperationalError: (1005, "Can't create table 'web2new.#sql-3e4_2bb'
> > (errno: 150)")
>
