On Wed, Jan 28, 2009 at 11:46 AM, João Olavo Baião de Vasconcelos < [email protected]> wrote:
> On Wed, Jan 28, 2009 at 1:31 PM, Karen Tracey <[email protected]> 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? > > Using CentOS 5.2, Django 1.0.2, cx_Oracle 4.4.1_10g, Oracle 9i and > oracle-instantclient-basic-10.2.0.4-1 > > Thanks for the reply, Karen. > Are you absolutely sure you were using the exact same code for the working sqlite test as the failing Oracle one? I cannot recreate any problem using your sample models (fixed up to include the missing bits like max_length and correcting case of 'authors' in the ManyToMany) on my Oracle setup. I'm using Oracle 10g Express on Windows, cx_Oracle 4.4, Django 1.0 (and I don't know what that instantclient thing is so I'm not sure I have any corresponding thing on Windows). (The fact that you can get the query to work when you fixup the search URL manually implies to me that your Oracle setup can process the correct query properly, and that somehow what you specified in search_fields is resulting in a slightly different query than expected.) Karen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django 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/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
