On Jan 28, 9:46 am, João Olavo Baião de Vasconcelos <joaool...@gmail.com> wrote: > On Wed, Jan 28, 2009 at 1:31 PM, Karen Tracey <kmtra...@gmail.com> wrote: > > You are including the __name in your manual search but you left it out of > > the search_fields you listed in your ModelAdmin. So what happens if you > > make search_fields = ['title', 'authors__name']? > > I did it, and got this error message: > *DatabaseError: ORA-00932: inconsistent datatypes: expected - got CLOB* > > As it's an Oracle error, I tried with a sqlite database and it worked just > fine! > > But, as I wanna continue using oracle, how can I solve it? Is this a bug?
What are the Oracle types of the columns associated with the title and name fields? Both are declared as CharFields, for which Django normally uses a VARCHAR2 column. If either is actually a CLOB column for some reason (perhaps you changed the model but didn't drop and recreate the table), you would get that error when you tried to search over it. To fix it, either replace the offending CharField with a TextField, or change the offending CLOB to a VARCHAR2. Hope that helps, Ian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
