Do not know what to say. I do ot use MySQL because it has lots of undocumented quirks. I quick search revealed other cases when the problem may occur (look at the comments):
http://www.danieltome.com/blog/2008/01/17/mysql-errno-150/ Anyway. This do not solve your problem. Try give the category reference a default=0 and/or ondelete="NO ACTION" attribute. Does it solve the problem? Massimo On Sep 21, 7:53 am, bally boy <[email protected]> wrote: > 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)") > >
