On Tuesday, July 11, 2017 at 2:39:46 PM UTC-7, Scheme Lab wrote:
>
> I think the filename ends with .sqlite doesnt it?
>
That's the actual database (if you're using sqlite3). The dot-table files
are part of pydal, with schema information used by the driver, etc, and are
present for any database engine.
/dps
>
> 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.
