Sorry for the delay. I was out of the office. Like I said, it works if I comment out the size1 and size2 fields.
This is the error I get: Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > > Traceback (most recent call last): > File "Applications/web2py/gluon/restricted.py", line 227, in restricted > exec ccode in environment > File > "Applications/web2py/applications/MosaicCatalogBuilder/controllers/default.py" > > <http://localhost:8000/admin/default/edit/MosaicCatalogBuilder/controllers/default.py>, > line 144, in <module> > File "Applications/web2py/gluon/globals.py", line 412, in <lambda> > self._caller = lambda f: f() > File > "Applications/web2py/applications/MosaicCatalogBuilder/controllers/default.py" > > <http://localhost:8000/admin/default/edit/MosaicCatalogBuilder/controllers/default.py>, > line 72, in manageseries > grid = SQLFORM.smartgrid(db[table],showbuttontext=False) > File "Applications/web2py/gluon/sqlhtml.py", line 3027, in smartgrid > user_signature=user_signature, **kwargs) > File "Applications/web2py/gluon/sqlhtml.py", line 2279, in grid > next=referrer) > File "Applications/web2py/gluon/html.py", line 2301, in process > self.validate(**kwargs) > File "Applications/web2py/gluon/html.py", line 2238, in validate > if self.accepts(**kwargs): > File "Applications/web2py/gluon/sqlhtml.py", line 1686, in accepts > self.id_field_name]).update(**fields) > File "Applications/web2py/gluon/packages/dal/pydal/objects.py", line 2020, > in update > ret = db._adapter.update("%s" % table._tablename,self.query,fields) > File "Applications/web2py/gluon/packages/dal/pydal/adapters/base.py", line > 996, in update > raise e > IntegrityError: FOREIGN KEY constraint failed > > On Friday, July 17, 2015 at 11:05:25 AM UTC-7, Dave S wrote: > > > > On Thursday, July 16, 2015 at 10:11:16 PM UTC-7, greenpoise wrote: >> >> Well, if I comment out the sizes, everything works. I have tried using >> double as my field type. It doesn't work either. > > > As Alex said, the error you posted is a Foreign Key exception ... a > reference to another table has gone awry. > > If that's still the error being reported, then the size1 and size2 fields > are red herrings. If it is not the error being reported, please update > with the current error message. > > /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 [email protected]. For more options, visit https://groups.google.com/d/optout.
