I am using sqlite... I agree it is strange. I can still do operations on
other tables just fine, and the creation controller does successfully
create the record, but problems occur when trying to read/view it. If the
file is corrupted, how would I go about repairing/replacing it?
On Wednesday, December 12, 2012 6:46:00 PM UTC-8, Massimo Di Pierro wrote:
>
> Are you using sqlite? This is a strange error and it comes from the
> database. Perhaps the file got corrupted?
>
> On Wednesday, 12 December 2012 14:18:58 UTC-6, David Tucker wrote:
>>
>> I am having a similar problem. I did an insert using crud.create and it
>> went through, but now I get the error described above whenever I do
>> anything related to tht table... I tried this, but my notnull constraint
>> got in the way so I tried:
>>
>> db(db.youtable.id>0).update(thedatetimefield=datetime.datetime.utcnow())
>>
>> and now I'm getting this traceback:
>>
>> Traceback (most recent call last):
>> File "gluon/main.py", line 564, in wsgibase
>> File "gluon/dal.py", line 529, in close_all_instances
>> File "gluon/dal.py", line 509, in close
>> File "gluon/dal.py", line 1652, in commit
>> OperationalError: SQL logic error or missing database
>>
>>
>> Any idea what's going on?
>>
>>
>> On Sunday, April 5, 2009 10:01:13 PM UTC-7, mdipierro wrote:
>>>
>>> Let me guess... you changed a field from 'string' to 'datetime' using
>>> sqlite? sqlite does not enforces field types hence it let you do the
>>> migration even if there was data in there that is not of type
>>> 'datetime'. You need to clean up that column.
>>>
>>> In your model do this
>>>
>>> db(db.youtable.id>0).update(thedatetimefield=None)
>>>
>>> run appadmin once than remove the above line.
>>>
>>> Massimo
>>>
>>>
>>>
>>> On Apr 5, 9:10 pm, "web2py <<<at>>> technicalbloke.com"
>>> <technicalbl...@googlemail.com> wrote:
>>> > Hi,
>>> >
>>> > Somehow (don't ask me how!) I've managed to bork my database :-/
>>> > Appadmin let's me see all my tables except one, when I click on it's
>>> > name it spews the message below. I don't care about the data inside,
>>> > I'd just like to have my database rebuilt from the model so what's the
>>> > best way to do that?
>>> >
>>> > db.my_table.truncate?
>>> > db.my_table.drop?
>>> > delete the contents of the 'databases' folder?
>>> >
>>> > Traceback (most recent call last):
>>> > File "/rahrahrah/web2py/gluon/restricted.py", line 98, in restricted
>>> > exec ccode in environment
>>> > File "/rahrahrah/web2py/applications/tcrm/views/appadmin.html", line
>>> > 102, in <module>
>>> > File "/rahrahrah/web2py/gluon/sqlhtml.py", line 605, in __init__
>>> > for (rc, record) in enumerate(sqlrows):
>>> > File "/rahrahrah/web2py/gluon/sql.py", line 2127, in __iter__
>>> > yield self[i]
>>> > File "/rahrahrah/web2py/gluon/sql.py", line 2082, in __getitem__
>>> > str(value)[:10].strip().split('-')]
>>> > ValueError: need more than 1 value to unpack
>>> >
>>> > Cheers,
>>> >
>>> > Roger.
>>
>>
--
