Got it. Thanks.
So lets repeat some steps to see how this happened.
Production Database
-> Open appadmin: Everything OK.
-> print db(db.category.id > 0).select(orderby=~db.category.id).first()
category.id -> 4059 # this is the highest category in databases
category.name -> "sports"
-> db.export_to_csv_file(open('/tmp/dumps.csv', 'w'))
mv /tmp/dumps.csv -> local://home/dumps.csv
Local Environment
-> Delete everything under databases.
-> Refresh appadmin
-> db.import_from_csv_file(open('/home/dumps.csv', 'r'))
-> Refresh appadmin
-> Raises -> Undefined Exception -> get record id.
-> bad_reference = db(db.category.parent == bad_record_id).select()
-> len(bad_reference) = 1
-> print bad_reference.parent == 4057
-> print db(db.category.id > 0).select(orderby=~db.category.id).first()
category.id -> 4053 # this is the highest category in databases
category.name -> "sports"
Am I missing something here or doing something wrong?
-Thadeus
On Thu, Apr 1, 2010 at 10:05 AM, Yarko Tymciurak
<[email protected]> wrote:
> I'd first (quickly) try: save table (or tables) as csv, then grep
> 4057 to see where it shows up, and work from there.
>
> - Yarko
>
> On Apr 1, 10:56 am, Thadeus Burgess <[email protected]> wrote:
>> Yes but out of 4050 records, how do I determine the one record that
>> got borked, since obviously record 4057 does not exist. I have queried
>> reference fields and nothing refers to a record 4057 either.
>>
>> p.s. this was with using sqlite browser
>>
>> -Thadeus
>>
>> On Thu, Apr 1, 2010 at 9:53 AM, Yarko Tymciurak
>>
>> <[email protected]> wrote:
>> > On Apr 1, 9:52 am, Thadeus Burgess <[email protected]> wrote:
>> >> Somehow, I am getting the "Undefined Record Exception" being raised,
>> >> from line 1429 in sql.py.
>>
>> >> When I comment out the exception, appadmin works just fine. It looks
>> >> as if the reference is an ID that does not exist in my table.
>>
>> > ... implied: NOT a clean install....
>>
>> >> Somehow, the ID is 4057, when the highest ID in my table is only 4052,
>> >> any ideas on how this could have happened, or how to even fix this!?
>>
>> > Guess: has to do with your table references....
>>
>> > .... for action in [debuggin, info]: provide action
>>
>> > ;-)
>>
>> > - Yarko
>>
>> >> -Thadeus
>>
>> > --
>> > You received this message because you are subscribed to the Google Groups
>> > "web2py-users" group.
>> > To post to this group, send email to [email protected].
>> > To unsubscribe from this group, send email to
>> > [email protected].
>> > For more options, visit this group
>> > athttp://groups.google.com/group/web2py?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
