strange django_session sql error when accessing admin login page

33 views
Skip to first unread message

Aljoša Mohorović

unread,
Jul 25, 2012, 9:41:20 AM7/25/12
to ibm...@googlegroups.com
i'm trying to access django admin login page but getting a strange
error and can't figure out what's wrong:

error setting index [2] [SQLCode: 0]
DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ALJOSA.DJANGO_SESSION [SQLCode: -204], [SQLState: 42704]
DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ALJOSA.DJANGO_SESSION [SQLCode: -727], [SQLState: 56098]

added sql statments loggin in pybase.py:

python.execute: SELECT "DJANGO_SESSION"."SESSION_KEY",
"DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM
"DJANGO_SESSION" WHERE ( "DJANGO_SESSION"."EXPIRE_DATE" > ? AND
"DJANGO_SESSION"."SESSION_KEY" = ? ) (datetime.datetime(2012, 7, 25,
15, 30, 11, 970000), '6af15885d005559c7ea17b02a3538a1a')

python.execute: SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3" FROM (
SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3", ( ROW_NUMBER() OVER() )
AS "Z.__ROWNUM" FROM ( SELECT "DJANGO_SESSION"."SESSION_KEY" AS
"Z.__db2_1", "DJANGO_SESSION"."SESSION_DATA" AS "Z.__db2_2",
"DJANGO_SESSION"."EXPIRE_DATE" AS "Z.__db2_3" FROM "DJANGO_SESSION"
WHERE ( "DJANGO_SESSION"."EXPIRE_DATE" > ? AND
"DJANGO_SESSION"."SESSION_KEY" = ? ) ) AS M ) Z WHERE "Z.__ROWNUM" <=
21 (datetime.datetime(2012, 7, 25, 15, 30, 11, 970000),
'6af15885d005559c7ea17b02a3538a1a')

python.execute: SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3" FROM (
SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3", ( ROW_NUMBER() OVER() )
AS "Z.__ROWNUM" FROM ( SELECT "DJANGO_SESSION"."SESSION_KEY" AS
"Z.__db2_1", "DJANGO_SESSION"."SESSION_DATA" AS "Z.__db2_2",
"DJANGO_SESSION"."EXPIRE_DATE" AS "Z.__db2_3" FROM "DJANGO_SESSION" )
AS M ) Z WHERE "Z.__ROWNUM" <= 21 ()

python.execute: SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3" FROM (
SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3", ( ROW_NUMBER() OVER() )
AS "Z.__ROWNUM" FROM ( SELECT "DJANGO_SESSION"."SESSION_KEY" AS
"Z.__db2_1", "DJANGO_SESSION"."SESSION_DATA" AS "Z.__db2_2",
"DJANGO_SESSION"."EXPIRE_DATE" AS "Z.__db2_3" FROM "DJANGO_SESSION"
WHERE ( "DJANGO_SESSION"."EXPIRE_DATE" > ? AND
"DJANGO_SESSION"."SESSION_KEY" = ? ) ) AS M ) Z WHERE "Z.__ROWNUM" <=
21 (datetime.datetime(2012, 7, 25, 15, 30, 11, 970000),
'6af15885d005559c7ea17b02a3538a1a')

python.execute: SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3" FROM (
SELECT "Z.__db2_1", "Z.__db2_2", "Z.__db2_3", ( ROW_NUMBER() OVER() )
AS "Z.__ROWNUM" FROM ( SELECT "DJANGO_SESSION"."SESSION_KEY" AS
"Z.__db2_1", "DJANGO_SESSION"."SESSION_DATA" AS "Z.__db2_2",
"DJANGO_SESSION"."EXPIRE_DATE" AS "Z.__db2_3" FROM "DJANGO_SESSION"
WHERE ( "DJANGO_SESSION"."EXPIRE_DATE" > ? AND
"DJANGO_SESSION"."SESSION_KEY" = ? ) ) AS M ) Z WHERE "Z.__ROWNUM" <=
21 (datetime.datetime(2012, 7, 25, 15, 30, 11, 970000),
'6af15885d005559c7ea17b02a3538a1a')

[25/Jul/2012 15:30:15] "GET /admin/ HTTP/1.1" 500 162048

any ideas?

Aljosa
Reply all
Reply to author
Forward
0 new messages