Can you post the entire traceback? I don't see this behavior with SQL Server 2000 or MSDE. I may have to get a copy of SQL Server 2005.
I'll also try using the latest Django version from the trunk - my production installation is the current official Django release (0.95) modified with the patch from ticket 2358. Sean On 10/25/06, abc123 <[EMAIL PROTECTED]> wrote: > > Hello Sean, > > I'm also trying this; I've updated from SVN recently (a week or so > ago), then applied ticket 2358 diff 5 (by hand, but I have checked it > more than once), and am running against SQL Server 2005. > > Starting from scratch, I can run python manage.py syncdb, and get some > tables inserted into the database. I then get a prompt to create a root > user, and that bombs out with an exception that seems to be a problem > with the string interpolation. It's coming down from > contrib\auth\create_superuser.py (line 51, > "User.objects.get(username=username)") , and the traceback finishes > with: > > """com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE > DB Provider for SQL Server', "Incorrect syntax near 's'.", None, 0, > -2147217900), None)""" > > """--- ADODBAPI on command:SELECT [auth_user].[id], > [auth_user].[username], [auth_user].[first_name], > [auth_user].[last_name], [auth_user].[email], [auth_user].[password], > [auth_user].[is_staff], [auth_user].[is_active], > [auth_user].[is_superuser], [auth_user].[last_login], > [auth_user].[date_joined] FROM [auth_user] WHERE > ([auth_user].[username] = %s) with parameters: ['root']""" > > > After this, I can run python manage.py inspectdb and get a nice model > list for the tables it inserted, so the introspection part is working. > > I haven't tried anything further, but I have watched the SQL Server > Profiler while this runs, and what's actually getting to the server is: > > """SELECT [auth_user].[id], [auth_user].[username], > [auth_user].[first_name], [auth_user].[last_name], [auth_user].[email], > [auth_user].[password], [auth_user].[is_staff], > [auth_user].[is_active], [auth_user].[is_superuser], > [auth_user].[last_login], [auth_user].[date_joined] FROM [auth_user] > WHERE ([auth_user].[username] = %s)""" > > No parameter substitution seems to happen... > > > Cheers, > abc123. > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
