Re: ProgrammingError ... after adding new field to my model ...

2006-03-19 Thread Kenneth Gonsalves
On Monday 20 Mar 2006 2:54 am, ZebZiggle wrote: > For now, I did a u"My Unicode String".encode('ascii') and it > works fine. good to know - am planning a project with lots and lots of utf8 stuff, so can avoid this error -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://av

Re: ProgrammingError ... after adding new field to my model ...

2006-03-19 Thread ZebZiggle
SOLVED! The text I was using for the value was unicode. This resulted in the string not being quoted when the SQL was being fabricated. For now, I did a u"My Unicode String".encode('ascii') and it works fine. Cheers, Zeb --~--~-~--~~~---~--~~ You received this

Re: ProgrammingError ... after adding new field to my model ...

2006-03-19 Thread ZebZiggle
Good point. Sadly, I'm not constructing the SQL, Django is. It could very well be that postgres is mangling the value string (thinking it's a column) ... that would possibly also explain why the exception message is truncated. I was looking at the django code last night and can't see anything obvi

Re: ProgrammingError ... after adding new field to my model ...

2006-03-18 Thread Kenneth Gonsalves
On Sunday 19 Mar 2006 7:17 am, ZebZiggle wrote: > Thoughts? if its postgres and you have put double quotes " instead of ' around a variable, postgres thinks it is a column name -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.org.in ಇಂಡ್ಲಿನಕ್ಸ வாழ்க! --~--~---

Re: ProgrammingError ... after adding new field to my model ...

2006-03-18 Thread ZebZiggle
It's definitely there and the database looks fine. I suspect the problem is elsewhere ... the value being inserted into the database is being mangled (as illustrated above), which makes me believe it's confusing the value for the field name or something. Essentially ... how did the value get conve

Re: ProgrammingError ... after adding new field to my model ...

2006-03-18 Thread Kenneth Gonsalves
On Sunday 19 Mar 2006 7:04 am, ZebZiggle wrote: > I did a django-admin "sqlclear" followed by an "install"... as > I've done every other time I modify my model. Is there something > else I need to do? the error message says the field is not there - inspect the database and check if it is there

Re: ProgrammingError ... after adding new field to my model ...

2006-03-18 Thread Kenneth Gonsalves
On Sunday 19 Mar 2006 6:55 am, Kenneth Gonsalves wrote: > On Sunday 19 Mar 2006 12:01 am, ZebZiggle wrote: > > ERROR: relation "ph01990j" does not exist INSERT INTO > > "mydarksecret_scriptelements" > > ("script_id","scene","type","characterFirstName","characterLast > >Na me","characterNickName","

Re: ProgrammingError ... after adding new field to my model ...

2006-03-18 Thread ZebZiggle
I did a django-admin "sqlclear" followed by an "install"... as I've done every other time I modify my model. Is there something else I need to do? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group

Re: ProgrammingError ... after adding new field to my model ...

2006-03-18 Thread Kenneth Gonsalves
On Sunday 19 Mar 2006 12:01 am, ZebZiggle wrote: > ERROR: relation "ph01990j" does not exist INSERT INTO > "mydarksecret_scriptelements" > ("script_id","scene","type","characterFirstName","characterLastNa >me","characterNickName","avatarFilename","isMurdeR you have added the field in the model bu