I think the filename ends with .sqlite doesnt it?
On Wednesday, July 5, 2017 at 3:07:46 AM UTC-4, Dave S wrote:
>
>
>
> On Tuesday, July 4, 2017 at 11:34:11 PM UTC-7, mostwanted wrote:
>>
>> Hey Santi, how do i go about doing that, deleting all the tables in the
>> database backup folder?
>>
>
> The easiest way is to use a command line, and delete the .table files. In
> a linux system, and picking the application name from the ticket,
>
> cd [web2pydir]/applications/formulator/databases
> rm *.table
>
> For Windows, the same except substitute del for rm.
>
> (the "backup" mentioned may be a nod to a hosting service, where you might
> not manipulate the file system directly.. For instance, for heroku, I
> think you'd actually do a git delete of any dot-table files, but I've only
> done node.js on heroku, so I'm just waving my hands.)
>
> /dps
>
>
>
>> On Tuesday, July 4, 2017 at 12:08:44 AM UTC+2, Santiago Cartasegna wrote:
>>>
>>> Go to the database folder backup and delete all the .tables. Perhaps a
>>> change was not reflected on the creation of the table.
>>>
>>> A similar error ocurred to me and it was on the creation of the id's
>>> references on the forange. But your code looks ok
>>>
>>> El lunes, 3 de julio de 2017, 15:50:45 (UTC-3), mostwanted escribió:
>>>>
>>>> this is the actual code Santi:
>>>>
>>>> db.define_table('government',
>>>> Field('govName', requires=IS_NOT_EMPTY()),
>>>> Field('tel', requires=IS_NOT_EMPTY()),
>>>> Field('email', requires=IS_NOT_EMPTY()),
>>>> format='%(govName)s', migrate=False,fake_migrate=True)
>>>>
>>>>
>>>> db.define_table(govmntForm',
>>>>
>>>> Field('formImage', 'upload'),
>>>> Field('filledformImage', 'upload'),
>>>> Field('formName',requires=IS_NOT_EMPTY()),
>>>> Field('governmentName', 'reference government'),
>>>> format='%(formName)s',migrate=False,fake_migrate=True)
>>>>
>>>> db.define_table('governmetFormPages',
>>>> Field('formImage', 'upload'),
>>>> Field('formTitle',requires=IS_NOT_EMPTY()),
>>>> Field('formName', 'reference
>>>> govmntForm'),migrate=False,fake_migrate=True)
>>>>
>>>>
>>>> On Monday, July 3, 2017 at 4:51:47 PM UTC+2, Santiago Cartasegna wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> You should reference the table with the same name that is created so
>>>>> the table sould be like:
>>>>>
>>>>> db.define_table('governmetFormPages',
>>>>> Field('formImage', 'upload'),
>>>>> Field('formTitle',requires=IS_NOT_EMPTY()),
>>>>> Field('formName', 'reference governmenttForm
>>>>> '),migrate=False,fake_migrate=True)
>>>>>
>>>>> Best regards
>>>>>
>>>>>
>>>>> El lunes, 3 de julio de 2017, 4:15:18 (UTC-3), mostwanted escribió:
>>>>>>
>>>>>> It is the actually code Tony, i just changed it after posting it. The
>>>>>> table name was initially *govmntForm* as it is referenced in the
>>>>>> *governmetFormPages* table.
>>>>>>
>>>>>> On Sunday, July 2, 2017 at 7:48:43 PM UTC+2, Anthony wrote:
>>>>>>>
>>>>>>> Not sure if you're showing your actual code, but the table name is
>>>>>>> spelled "governmenttForm" (note the extra "t"), and for the field type,
>>>>>>> you
>>>>>>> have "reference govmntForm".
>>>>>>>
>>>>>>> Anthony
>>>>>>>
>>>>>>> On Sunday, July 2, 2017 at 4:37:22 AM UTC-4, mostwanted wrote:
>>>>>>>>
>>>>>>>> Hi guys, i need help, i'm pulling my hairs out over here, i have a
>>>>>>>> website where when i'm trying to record an entry i get an error:
>>>>>>>> <class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed
>>>>>>>>
>>>>>>>>
>>>>>>>> I have been able to create 2 forms but other attempts to create
>>>>>>>> more forms fail!!
>>>>>>>>
>>>>>>>>
>>>>>>>> These are my tables;
>>>>>>>>
>>>>>>>>
>>>>>>>> db.define_table('government',
>>>>>>>> Field('govName', requires=IS_NOT_EMPTY()),
>>>>>>>> Field('tel', requires=IS_NOT_EMPTY()),
>>>>>>>> Field('email', requires=IS_NOT_EMPTY()),
>>>>>>>> format='%(govName)s',
>>>>>>>> migrate=False,fake_migrate=True)
>>>>>>>>
>>>>>>>>
>>>>>>>> db.define_table('governmenttForm',
>>>>>>>> Field('formImage', 'upload'),
>>>>>>>> Field('filledformImage', 'upload'),
>>>>>>>> Field('formName',requires=IS_NOT_EMPTY()),
>>>>>>>> Field('governmentName', 'reference government'),
>>>>>>>>
>>>>>>>> format='%(formName)s',migrate=False,fake_migrate=True)
>>>>>>>>
>>>>>>>> db.define_table('governmetFormPages',
>>>>>>>> Field('formImage', 'upload'),
>>>>>>>> Field('formTitle',requires=IS_NOT_EMPTY()),
>>>>>>>> Field('formName', 'reference
>>>>>>>> govmntForm'),migrate=False,fake_migrate=True)
>>>>>>>>
>>>>>>>>
>>>>>>>> I am able to create a form for the governmentForm table but when i
>>>>>>>> try to load up the pages for governmentFormPages table i get the error
>>>>>>>> <class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed
>>>>>>>>
>>>>>>>>
>>>>>>>> Below is the stack
>>>>>>>> Error ticket for "formulator" Ticket ID
>>>>>>>>
>>>>>>>> 127.0.0.1.2017-07-02.10-06-22.18c363e3-13c2-47f7-ace4-3692239493c4
>>>>>>>> <class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed
>>>>>>>> Version
>>>>>>>> web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
>>>>>>>> Traceback
>>>>>>>>
>>>>>>>> 1.
>>>>>>>> 2.
>>>>>>>> 3.
>>>>>>>> 4.
>>>>>>>> 5.
>>>>>>>> 6.
>>>>>>>> 7.
>>>>>>>> 8.
>>>>>>>> 9.
>>>>>>>> 10.
>>>>>>>> 11.
>>>>>>>> 12.
>>>>>>>> 13.
>>>>>>>> 14.
>>>>>>>> 15.
>>>>>>>> 16.
>>>>>>>>
>>>>>>>> Traceback (most recent call last):
>>>>>>>> File "/home/mostwanted/web2py/gluon/restricted.py", line 227, in
>>>>>>>> restricted
>>>>>>>> exec ccode in environment
>>>>>>>> File
>>>>>>>> "/home/mostwanted/web2py/applications/formulator/controllers/appadmin.py"
>>>>>>>>
>>>>>>>> <http://127.0.0.1:8000/admin/default/edit/formulator/controllers/appadmin.py>,
>>>>>>>> line 703, in <module>
>>>>>>>> File "/home/mostwanted/web2py/gluon/globals.py", line 417, in
>>>>>>>> <lambda>
>>>>>>>> self._caller = lambda f: f()
>>>>>>>> File
>>>>>>>> "/home/mostwanted/web2py/applications/formulator/controllers/appadmin.py"
>>>>>>>>
>>>>>>>> <http://127.0.0.1:8000/admin/default/edit/formulator/controllers/appadmin.py>,
>>>>>>>> line 151, in insert
>>>>>>>> if form.accepts(request.vars, session):
>>>>>>>> File "/home/mostwanted/web2py/gluon/sqlhtml.py", line 1746, in
>>>>>>>> accepts
>>>>>>>> self.vars.id = self.table.insert(**fields)
>>>>>>>> File "/home/mostwanted/web2py/gluon/packages/dal/pydal/objects.py",
>>>>>>>> line 726, in insert
>>>>>>>> ret = self._db._adapter.insert(self, self._listify(fields))
>>>>>>>> File
>>>>>>>> "/home/mostwanted/web2py/gluon/packages/dal/pydal/adapters/base.py",
>>>>>>>> line 746, in insert
>>>>>>>> raise e
>>>>>>>> IntegrityError: FOREIGN KEY constraint failed
>>>>>>>>
>>>>>>>>
>>>>>>>> Please help me, i dont know what to do, i have tried to look for
>>>>>>>> solutions online but i just dont understand them, may someone please
>>>>>>>> give
>>>>>>>> me light on what i'm doing wrong.
>>>>>>>>
>>>>>>>
--
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.
