abc123,
I deleted my Django install and started from scratch. I installed the
latest SVN, applied the patch, and created a new project. I still
didn't see an error, so I'm thinking that the problem could be one of
two things:
1. There's a problem with MSSQL 2005
2. A portion of the patch wasn't applied correctly.
At first glance, your problem with string substitution points to #2
because the patch specifically corrects that problem. The suspect
file is located in django\db\backends\ado_mssql\base.py. Can you
send me that file along with your settings.py file? If that's not it,
then I'm going to have you zip up your Django installation and send it
to me so I can debug it locally.
It seems like both you and Carlos are in completely different
timezones than I am (USA - West Coast), so I'll be checking my email
until I go to bed tonight for your replies.
By the way, which version of Django are you using?
Thanks,
Sean
On 10/26/06, abc123 <[EMAIL PROTECTED]> wrote:
>
> Sean De La Torre wrote:
> > 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 can, the full traceback is rather long:
>
> E:\test>python manage.py syncdb
> # Note: Any fields that are named 'id', are of type 'AutoField', and
> # and are Primary Keys will NOT appear in the model output below.
> # By default Django assumes that the each model's Primary Key is an
> # AutoField with a name of 'id', so there is no need to add it to the
> # model description.
>
> Creating table auth_message
> Creating table auth_group
> Creating table auth_user
> Creating table auth_permission
> Creating table django_content_type
> Creating table django_session
> Creating table django_site
>
> You just installed Django's auth system, which means you don't have any
> superusers defined.
> Would you like to create one now? (yes/no): yes
> Username: root
> Traceback (most recent call last):
> File "manage.py", line 11, in ?
> execute_manager(settings)
> File "d:\python24\django\django\core\management.py", line 1439, in
> execute_manager
> execute_from_command_line(action_mapping, argv)
> File "d:\python24\django\django\core\management.py", line 1347, in
> execute_from_command_line
> action_mapping[action](int(options.verbosity), options.interactive)
> File "d:\python24\django\django\core\management.py", line 505, in
> syncdb
> verbosity=verbosity, interactive=interactive)
> File "d:\python24\django\django\dispatch\dispatcher.py", line 347, in
> send sender=sender,
> File "d:\python24\django\django\dispatch\robustapply.py", line 47, in
> robustApply
> return receiver(*arguments, **named)
> File "d:\python24\django\django\contrib\auth\management.py", line 45,
> in create_superuser
> do_create()
> File "d:\python24\django\django\contrib\auth\create_superuser.py",
> line 51, in
> createsuperuser
> User.objects.get(username=username)
> File "d:\python24\django\django\db\models\manager.py", line 67, in
> get
> return self.get_query_set().get(*args, **kwargs)
> File "d:\python24\django\django\db\models\query.py", line 211, in get
> obj_list = list(clone)
> File "d:\python24\django\django\db\models\query.py", line 103, in
> __iter__
> return iter(self._get_data())
> File "d:\python24\django\django\db\models\query.py", line 430, in
> _get_data
> self._result_cache = list(self.iterator())
> File "d:\python24\django\django\db\models\query.py", line 172, in
> iterator
> cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "") +
> ",".join (select) + sql, params)
> File "d:\python24\django\django\db\backends\util.py", line 13, in
> execute
> return self.cursor.execute(sql, params)
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 592,
> in execute
> self.executeHelper(operation,0,parameters)
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 552,
> in executeHelper
> self._raiseCursorError(DatabaseError,tracebackhistory)
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 407,
> in _raiseCursorError
> eh(self.conn,self,errorclass,errorvalue)
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 38,
> in standardErrorHandler
> raise errorclass(errorvalue)
> adodbapi.adodbapi.DatabaseError:
> -----------
> Strategy 1: Traceback:Traceback (most recent call last):
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 539,
> in executeHelper
> raise DatabaseError(e)
> DatabaseError: (-2147352567, 'Exception occurred.', (0,
> 'ADODB.Parameters', 'Item cannot be found in the collection
> corresponding to the requested name or ordinal.',
> 'C:\\WINDOWS\\HELP\\ADO270.CHM', 1240649, -2146825023), None)
>
>
> -----------
> Strategy 2: Traceback:Traceback (most recent call last):
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 540,
> in executeHelper
> adoRetVal=self.cmd.Execute()
> File "<COMObject ADODB.Command>", line 3, in Execute
> File "D:\Python24\lib\site-packages\win32com\client\dynamic.py",
> line 251, in _ApplyTypes_
> result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType,
> argTypes) + args)
> com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE DB
> Provider
> for SQL Server', "Incorrect syntax near 's'.", None, 0, -2147217900),
> None)
>
>
> -----------
> Strategy 3: Traceback:Traceback (most recent call last):
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 539,
> in executeHelper
> raise DatabaseError(e)
> DatabaseError: (-2147352567, 'Exception occurred.', (0,
> 'ADODB.Parameters', 'Item cannot be found in the collection
> corresponding to the requested name or ordinal.',
> 'C:\\WINDOWS\\HELP\\ADO270.CHM', 1240649, -2146825023), None)
>
>
> -----------
> Strategy 4: Traceback:Traceback (most recent call last):
> File "D:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 540,
> in executeHelper
> adoRetVal=self.cmd.Execute()
> File "<COMObject ADODB.Command>", line 3, in Execute
> File "D:\Python24\lib\site-packages\win32com\client\dynamic.py",
> line 251, in
> _ApplyTypes_
> result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType,
> argTypes) + args)
> 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']
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
