Adrian Holovaty wrote:
Hi Adrian,
> Could you paste the entire traceback you get? Also, would any other MS
> SQL users in the audience be able to help?
Here is an entire traceback I get when attempting to access the /admin
site:
Traceback (most recent call last):
File "C:\Python24\lib\site-packages\django\core\servers\basehttp.py",
line 272, in run
self.result = application(self.environ, self.start_response)
File "C:\Python24\lib\site-packages\django\core\servers\basehttp.py",
line 615, in __call__
return self.application(environ, start_response)
File "C:\Python24\lib\site-packages\django\core\handlers\wsgi.py",
line 161, in __call__
response = middleware_method(request, response)
File "C:\Python24\lib\site-packages\django\middleware\sessions.py",
line 74, in process_response
session_key = request.session.session_key or
sessions.get_new_session_key()
File "C:\Python24\lib\site-packages\django\models\core.py", line 110,
in _module_get_new_session_key
get_object(session_key__exact=session_key)
File "C:\Python24\lib\site-packages\django\utils\functional.py", line
3, in _curried
return args[0](*(args[1:]+moreargs), **dict(kwargs.items() +
morekwargs.items()))
File "C:\Python24\lib\site-packages\django\core\meta\__init__.py",
line 1355, in function_get_object
obj_list = function_get_list(opts, klass, **kwargs)
File "C:\Python24\lib\site-packages\django\core\meta\__init__.py",
line 1395, in function_get_list
return list(function_get_iterator(opts, klass, **kwargs))
File "C:\Python24\lib\site-packages\django\core\meta\__init__.py",
line 1378, in function_get_iterator
cursor.execute("SELECT " + (kwargs.get('distinct') and "DISTINCT "
or "") + ",".join(select) + sql, params)
File "C:\Python24\lib\site-packages\adodbapi\adodbapi.py", line 592,
in execute
self.executeHelper(operation,0,parameters)
File "C:\Python24\lib\site-packages\adodbapi\adodbapi.py", line 552,
in executeHelper
self._raiseCursorError(DatabaseError,tracebackhistory)
File "C:\Python24\lib\site-packages\adodbapi\adodbapi.py", line 407,
in _raiseCursorError
eh(self.conn,self,errorclass,errorvalue)
File "C:\Python24\lib\site-packages\adodbapi\adodbapi.py", line 38,
in standardErrorHandler
raise errorclass(errorvalue)
DatabaseError:
-----------
Strategy 1: Traceback:Traceback (most recent call last):
File "C:\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 "C:\Python24\lib\site-packages\adodbapi\adodbapi.py", line 540,
in executeHelper
adoRetVal=self.cmd.Execute()
File "<COMObject ADODB.Command>", line 3, in Execute
File "C:\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', "Line 1: Incorrect syntax near 's'.", None,
0, -2147217900), None)
-----------
Strategy 3: Traceback:Traceback (most recent call last):
File "C:\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 "C:\Python24\lib\site-packages\adodbapi\adodbapi.py", line 540,
in executeHelper
adoRetVal=self.cmd.Execute()
File "<COMObject ADODB.Command>", line 3, in Execute
File "C:\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', "Line 1: Incorrect syntax near 's'.", None,
0, -2147217900), None)
--- ADODBAPI on command:SELECT
[core_sessions].[session_key],[core_sessions].[session_data],[core_sessions].[expire_date]
FROM [core_sessions] WHERE [core_sessions].[session_key] = %s with
parameters: ['1be3c794e7f7b0758d8b108f406bbd19']
Here is the exact SQL that is passed to MS SQL:
SELECT
[core_sessions].[session_key],[core_sessions].[session_data],[core_sessions].[expire_date]
FROM [core_sessions] WHERE [core_sessions].[session_key] = %s
As you can see, it has stopped at %s.
Is there anything I can do to help?
Rich
