[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

I moved all of the table files to an archive directory and let everything rebuild and it worked great. Thanks, Anthony! Really appreciate the time you take to help us all. On Tuesday, October 3, 2017 at 11:42:47 AM UTC-4, LoveWeb2py wrote: > > I tried just renaming both databases and still recei

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

I tried just renaming both databases and still received the same error. On Tuesday, October 3, 2017 at 11:27:53 AM UTC-4, Anthony wrote: > > On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote: >> >> Still receiving same error... >> > > Maybe you didn't properly delete the table. No f

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote: > > Still receiving same error... > Maybe you didn't properly delete the table. No foreign key constraint is set for a list:reference field, so if you are getting that error, that means the database still has a foreign key constra

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Would it be easier to create a name field instead of a file and then just reference the name ID, and pull the file from the associated table? On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote: > > Still receiving same error... > > This is my html code: > > I'm taking values from js

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Still receiving same error... This is my html code: I'm taking values from jstree and then putting them into a database (trying to at least) $("#btn").click(function () { var checked = $('#tree').jstree(true).get_selected(); var testid = $('#test_id').val(); c

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Okay, just delete the table and then set migrate=True ? On Monday, October 2, 2017 at 8:46:21 PM UTC-4, Anthony wrote: > > On Monday, October 2, 2017 at 7:57:19 PM UTC-4, LoveWeb2py wrote: >> >> Yes... I believe so. >> >> On Monday, October 2, 2017 at 7:53:13 PM UTC-4, Anthony wrote: >>> >>> Was

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

On Monday, October 2, 2017 at 7:57:19 PM UTC-4, LoveWeb2py wrote: > > Yes... I believe so. > > On Monday, October 2, 2017 at 7:53:13 PM UTC-4, Anthony wrote: >> >> Was that field originally a regular reference field and then you changed >> it to a list:reference field? >> > I think that's the prob

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Yes... I believe so. On Monday, October 2, 2017 at 7:53:13 PM UTC-4, Anthony wrote: > > Was that field originally a regular reference field and then you changed > it to a list:reference field? > > On Monday, October 2, 2017 at 3:45:38 PM UTC-4, LoveWeb2py wrote: >> >> Anyone have feedback? I have

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Was that field originally a regular reference field and then you changed it to a list:reference field? On Monday, October 2, 2017 at 3:45:38 PM UTC-4, LoveWeb2py wrote: > > Anyone have feedback? I have been banging my head against this all day... > > On Sunday, October 1, 2017 at 4:52:39 PM UTC-4

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Anyone have feedback? I have been banging my head against this all day... On Sunday, October 1, 2017 at 4:52:39 PM UTC-4, LoveWeb2py wrote: > > Hello, I'm trying to create a simple interface that allows users to select > multiple files and create a name for the bundle. I've followed the example

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

481. 482. 483. 484. 485. 486. 487. 488. 489. 490. Here is the code listing self.execute(query) except: e = sys.exc_info()[1] if hasattr(table, '_on_insert_error'): return table._on_insert_error(table, fields, e) raise e

[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload

Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. Traceback (most recent call last): File "/Users/me/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "/Users/me/web-dev/web2py/applications/myapp/controllers/filegroups.py"