AttributeError at /admin/ 'NoneType' object has no attribute 'empty_strings_allowed' Request Method: GET Request URL: http://localhost:5000/admin/ Exception Type: AttributeError Exception Value: 'NoneType' object has no attribute 'empty_strings_allowed' Exception Location: c:\Python24\Lib\site-packages\django\db\backends\oracle\base.py in resolve_columns, line 473 Template error In template C:\Python24\lib\site-packages\django\contrib\admin\templates\admin/index.html, error at line 56 Caught an exception while rendering: 'NoneType' object has no attribute 'empty_strings_allowed' 46 47 {% endblock %} 48 49 {% block sidebar %} 50 Traceback (innermost last) Switch to copy-and-paste view * c:\Python24\Lib\site-packages\django\template\__init__.py in render_node 734. 735. def render_node(self, node, context): 736. return(node.render(context)) 737. 738. class DebugNodeList(NodeList): 739. def render_node(self, node, context): 740. try: 741. result = node.render(context) ... 742. except TemplateSyntaxError, e: 743. if not hasattr(e, 'source'): 744. e.source = node.source 745. raise 746. except Exception, e: 747. from sys import exc_info ▶ Local vars Variable Value context Error in formatting:'NoneType' object has no attribute 'empty_strings_allowed' e exc_info node self [ 0) and \ 470. (combined._order_by is None or len(combined._order_by) == 0): 471. combined._order_by = self._order_by 472. return combined 473. 474. def _get_data(self): 475. if self._result_cache is None: 476. self._result_cache = list(self.iterator()) ... 477. return self._result_cache 478. 479. def _get_sql_clause(self): 480. opts = self.model._meta 481. 482. # Construct the fundamental parts of the query: SELECT X FROM Y WHERE Z. ▶ Local vars Variable Value self Error in formatting:'NoneType' object has no attribute 'empty_strings_allowed' * c:\Python24\Lib\site-packages\django\db\backends\oracle\base.py in iterator 311. # 2. convert NCLOBs 312. 313. while 1: 314. rows = cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE) 315. if not rows: 316. raise StopIteration 317. for row in rows: 318. row = self.resolve_columns(row, fields) ... 319. if fill_cache: 320. obj, index_end = get_cached_row(klass=self.model, row=row, 321. index_start=0, max_depth=self._max_related_depth) 322. else: 323. obj = self.model(*row[:index_end]) 324. for i, k in enumerate(extra_select): ▶ Local vars Variable Value EmptyResultSet GET_ITERATOR_CHUNK_SIZE 100 connection cursor extra_select [] fields [, , , , , , , ] fill_cache True full_query 'SELECT * FROM\n (SELECT "DJANGO_ADMIN_LOG"."ID" AS ID0,"DJANGO_ADMIN_LOG"."ACTION_TIME","DJANGO_ADMIN_LOG"."USER_ID","DJANGO_ADMIN_LOG"."CONTENT_TYPE_ID","DJANGO_ADMIN_LOG"."OBJECT_ID","DJANGO_ADMIN_LOG"."OBJECT_REPR","DJANGO_ADMIN_LOG"."ACTION_FLAG","DJANGO_ADMIN_LOG"."CHANGE_MESSAGE","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",\n ROW_NUMBER() OVER (ORDER BY "DJANGO_ADMIN_LOG"."ACTION_TIME" DESC ) AS rn\n FROM "DJANGO_ADMIN_LOG" , "AUTH_USER" WHERE ("DJANGO_ADMIN_LOG"."USER_ID" = %s) AND "DJANGO_ADMIN_LOG"."USER_ID" = "AUTH_USER"."ID" ORDER BY "DJANGO_ADMIN_LOG"."ACTION_TIME" DESC)\nWHERE rn > 0 AND rn <= 10' get_cached_row index_end 8 params [1] row (2, datetime.datetime(2007, 5, 30, 17, 15, 0, 421000), 1, 9, , 'NetworkPlanning object', 2, , 1, 'murali', None, None, 'rt@r.com', 'sha1$88aab$6458a6a6ea0c02b6860c242c2ab4079ca6821f91', 1, 1, 1, datetime.datetime(2007, 5, 30, 17, 23, 25, 250000), datetime.datetime(2007, 5, 30, 17, 2, 37, 281000), 1) rows [(2, datetime.datetime(2007, 5, 30, 17, 15, 0, 421000), 1, 9, , 'NetworkPlanning object', 2, , 1, 'murali', None, None, 'rt@r.com', 'sha1$88aab$6458a6a6ea0c02b6860c242c2ab4079ca6821f91', 1, 1, 1, datetime.datetime(2007, 5, 30, 17, 23, 25, 250000), datetime.datetime(2007, 5, 30, 17, 2, 37, 281000), 1), (1, datetime.datetime(2007, 5, 30, 17, 14, 23, 31000), 1, 9, , 'NetworkPlanning object', 1, None, 1, 'murali', None, None, 'rt@r.com', 'sha1$88aab$6458a6a6ea0c02b6860c242c2ab4079ca6821f91', 1, 1, 1, datetime.datetime(2007, 5, 30, 17, 23, 25, 250000), datetime.datetime(2007, 5, 30, 17, 2, 37, 281000), 2)] select ['"DJANGO_ADMIN_LOG"."ID" AS ID0', '"DJANGO_ADMIN_LOG"."ACTION_TIME"', '"DJANGO_ADMIN_LOG"."USER_ID"', '"DJANGO_ADMIN_LOG"."CONTENT_TYPE_ID"', '"DJANGO_ADMIN_LOG"."OBJECT_ID"', '"DJANGO_ADMIN_LOG"."OBJECT_REPR"', '"DJANGO_ADMIN_LOG"."ACTION_FLAG"', '"DJANGO_ADMIN_LOG"."CHANGE_MESSAGE"', '"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"'] self Error in formatting:'NoneType' object has no attribute 'empty_strings_allowed' sql ' FROM "DJANGO_ADMIN_LOG" , "AUTH_USER" WHERE ("DJANGO_ADMIN_LOG"."USER_ID" = %s) AND "DJANGO_ADMIN_LOG"."USER_ID" = "AUTH_USER"."ID" ORDER BY "DJANGO_ADMIN_LOG"."ACTION_TIME" DESC' * c:\Python24\Lib\site-packages\django\db\backends\oracle\base.py in resolve_columns 466. for value, field in map(None, row, fields): 467. if isinstance(value, Database.LOB): 468. value = value.read() 469. # Oracle stores empty strings as null. We need to undo this in 470. # order to adhere to the Django convention of using the empty 471. # string instead of null, but only if the field accepts the 472. # empty string. 473. if value is None and field.empty_strings_allowed: ... 474. value = '' 475. # Convert 1 or 0 to True or False 476. elif value in (1, 0) and isinstance(field, (BooleanField, NullBooleanField)): 477. value = bool(value) 478. # Convert floats to decimals 479. elif value is not None and isinstance(field, DecimalField): ▶ Local vars Variable Value BooleanField DateField DateTimeField DecimalField NullBooleanField TimeField field None fields [, , , , , , , ] row (2, datetime.datetime(2007, 5, 30, 17, 15, 0, 421000), 1, 9, , 'NetworkPlanning object', 2, , 1, 'murali', None, None, 'rt@r.com', 'sha1$88aab$6458a6a6ea0c02b6860c242c2ab4079ca6821f91', 1, 1, 1, datetime.datetime(2007, 5, 30, 17, 23, 25, 250000), datetime.datetime(2007, 5, 30, 17, 2, 37, 281000), 1) self Error in formatting:'NoneType' object has no attribute 'empty_strings_allowed' value None values [2, datetime.datetime(2007, 5, 30, 17, 15, 0, 421000), 1, 9, 'aaa-bbb-001', 'NetworkPlanning object', 2, 'No fields changed.', 1, 'murali'] Traceback (most recent call last): File "c:\Python24\Lib\site-packages\django\template\__init__.py" in render_node 741. result = node.render(context) File "c:\Python24\Lib\site-packages\django\template\defaulttags.py" in render 211. if (value and not ifnot) or (ifnot and not value): File "c:\Python24\Lib\site-packages\django\db\models\query.py" in __len__ 106. return len(self._get_data()) File "c:\Python24\Lib\site-packages\django\db\models\query.py" in _get_data 476. self._result_cache = list(self.iterator()) File "c:\Python24\Lib\site-packages\django\db\backends\oracle\base.py" in iterator 318. row = self.resolve_columns(row, fields) File "c:\Python24\Lib\site-packages\django\db\backends\oracle\base.py" in resolve_columns 473. if value is None and field.empty_strings_allowed: AttributeError at /admin/ 'NoneType' object has no attribute 'empty_strings_allowed' Request information GET No GET data POST No POST data COOKIES Variable Value sessionid '9c2b30dc0f388273b95384dfd230c3e2' META Variable Value ALLUSERSPROFILE 'C:\\Documents and Settings\\All Users' APPDATA 'C:\\Documents and Settings\\murali\\Application Data' APR_ICONV_PATH 'c:\\subversion\\iconv' CLASSPATH '.;C:\\Program Files\\Java\\jre1.6.0\\lib\\ext\\QTJava.zip;C:\\Program Files\\Adobe\\Flex Builder 2\\Flex SDK 2\\bin;' CLIENTNAME 'Console' COMMONPROGRAMFILES 'C:\\Program Files\\Common Files' COMPUTERNAME 'SEAN' COMSPEC 'C:\\WINDOWS\\system32\\cmd.exe' CONTENT_LENGTH '' CONTENT_TYPE 'text/plain' DJANGO_SETTINGS_MODULE 'oradrive.settings' FP_NO_HOST_CHECK 'NO' GATEWAY_INTERFACE 'CGI/1.1' HAXEPATH 'C:\\Documents and Settings\\murali\\Desktop\\haxe\\haxe-1.13-win\\' HOMEDRIVE 'C:' HOMEPATH '\\Documents and Settings\\murali' HTTP_ACCEPT 'application/x-shockwave-flash,text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5' HTTP_ACCEPT_CHARSET 'ISO-8859-1,utf-8;q=0.7,*;q=0.7' HTTP_ACCEPT_ENCODING 'gzip,deflate' HTTP_ACCEPT_LANGUAGE 'en-us,en;q=0.5' HTTP_CACHE_CONTROL 'max-age=0' HTTP_CONNECTION 'keep-alive' HTTP_COOKIE 'sessionid=9c2b30dc0f388273b95384dfd230c3e2' HTTP_HOST 'localhost:5000' HTTP_KEEP_ALIVE '300' HTTP_REFERER 'http://localhost:5000/admin/' HTTP_USER_AGENT 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3' LOGONSERVER '\\\\SEAN' NEKO_INSTPATH 'C:\\Documents and Settings\\murali\\Desktop\\haxe\\neko' NUMBER_OF_PROCESSORS '1' OS 'Windows_NT' PATH 'C:\\oraclexe\\app\\oracle\\product\\10.2.0\\server\\bin;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\Python24;c:\\Python24\\Scripts;c:\\postgresql\\bin;C:\\Program Files\\QuickTime\\QTSystem\\;c:\\subversion\\bin;C:\\Program Files\\Adobe\\Flex Builder 2\\Flex SDK 2\\bin;;C:\\Documents and Settings\\murali\\Desktop\\haxe\\haxe-1.13-win\\;C:\\Documents and Settings\\murali\\Desktop\\haxe\\neko' PATHEXT '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH' PATH_INFO '/admin/' PROCESSOR_ARCHITECTURE 'x86' PROCESSOR_IDENTIFIER 'x86 Family 15 Model 2 Stepping 9, GenuineIntel' PROCESSOR_LEVEL '15' PROCESSOR_REVISION '0209' PROGRAMFILES 'C:\\Program Files' PROMPT '$P$G' QTJAVA 'C:\\Program Files\\Java\\jre1.6.0\\lib\\ext\\QTJava.zip' QUERY_STRING '' REMOTE_ADDR '127.0.0.1' REMOTE_HOST '' REQUEST_METHOD 'GET' RUN_MAIN 'true' SCRIPT_NAME '' SERVER_NAME 'localhost' SERVER_PORT '5000' SERVER_PROTOCOL 'HTTP/1.1' SERVER_SOFTWARE 'WSGIServer/0.1 Python/2.4.4' SESSIONNAME 'Console' SYSTEMDRIVE 'C:' SYSTEMROOT 'C:\\WINDOWS' TEMP 'C:\\DOCUME~1\\murali\\LOCALS~1\\Temp' TMP 'C:\\DOCUME~1\\murali\\LOCALS~1\\Temp' USERDOMAIN 'SEAN' USERNAME 'murali' USERPROFILE 'C:\\Documents and Settings\\murali' WINDIR 'C:\\WINDOWS' wsgi.errors ', mode 'w' at 0x00A0E0B0> wsgi.file_wrapper wsgi.input wsgi.multiprocess False wsgi.multithread True wsgi.run_once False wsgi.url_scheme 'http' wsgi.version (1, 0) Settings Using settings module oradrive.settings Setting Value ABSOLUTE_URL_OVERRIDES {} ADMINS () ADMIN_FOR () ADMIN_MEDIA_PREFIX '/media/' ALLOWED_INCLUDE_ROOTS () APPEND_SLASH True AUTHENTICATION_BACKENDS ('django.contrib.auth.backends.ModelBackend',) BANNED_IPS () CACHE_BACKEND 'simple://' CACHE_MIDDLEWARE_KEY_PREFIX '' COMMENTS_ALLOW_PROFANITIES False COMMENTS_BANNED_USERS_GROUP None COMMENTS_FIRST_FEW 0 COMMENTS_MODERATORS_GROUP None COMMENTS_SKETCHY_USERS_GROUP None DATABASE_ENGINE 'oracle' DATABASE_HOST 'localhost' DATABASE_NAME 'XE' DATABASE_OPTIONS {} DATABASE_PASSWORD '********************' DATABASE_PORT '' DATABASE_USER 'abiba' DATETIME_FORMAT 'N j, Y, P' DATE_FORMAT 'N j, Y' DEBUG True DEFAULT_CHARSET 'utf-8' DEFAULT_CONTENT_TYPE 'text/html' DEFAULT_FROM_EMAIL 'webmaster@localhost' DISALLOWED_USER_AGENTS () EMAIL_HOST 'localhost' EMAIL_HOST_PASSWORD '********************' EMAIL_HOST_USER '' EMAIL_PORT 25 EMAIL_SUBJECT_PREFIX '[Django] ' EMAIL_USE_TLS False FIXTURE_DIRS () IGNORABLE_404_ENDS ('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php') IGNORABLE_404_STARTS ('/cgi-bin/', '/_vti_bin', '/_vti_inf') INSTALLED_APPS ['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.admin', 'oradrive.test'] INTERNAL_IPS () JING_PATH '/usr/bin/jing' LANGUAGES (('ar', 'Arabic'), ('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), ('es_AR', 'Argentinean Spanish'), ('fi', 'Finnish'), ('fr', 'French'), ('gl', 'Galician'), ('hu', 'Hungarian'), ('he', 'Hebrew'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ko', 'Korean'), ('kn', 'Kannada'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pl', 'Polish'), ('pt', 'Portugese'), ('pt-br', 'Brazilian'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese')) LANGUAGES_BIDI ('he', 'ar') LANGUAGE_CODE 'en-us' LOGIN_REDIRECT_URL '/accounts/profile/' LOGIN_URL '/accounts/login/' LOGOUT_URL '/accounts/logout/' MANAGERS () MEDIA_ROOT '' MEDIA_URL '' MIDDLEWARE_CLASSES ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.middleware.doc.XViewMiddleware') MONTH_DAY_FORMAT 'F j' PREPEND_WWW False PROFANITIES_LIST '********************' ROOT_URLCONF 'oradrive.urls' SECRET_KEY '********************' SEND_BROKEN_LINK_EMAILS False SERVER_EMAIL 'root@localhost' SESSION_COOKIE_AGE 1209600 SESSION_COOKIE_DOMAIN None SESSION_COOKIE_NAME 'sessionid' SESSION_COOKIE_SECURE False SESSION_EXPIRE_AT_BROWSER_CLOSE False SESSION_SAVE_EVERY_REQUEST False SETTINGS_MODULE 'oradrive.settings' SITE_ID 1 TEMPLATE_CONTEXT_PROCESSORS ('django.core.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n') TEMPLATE_DEBUG True TEMPLATE_DIRS () TEMPLATE_LOADERS ('django.template.loaders.filesystem.load_template_source', 'django.template.loaders.app_directories.load_template_source') TEMPLATE_STRING_IF_INVALID '' TEST_DATABASE_NAME None TEST_RUNNER 'django.test.simple.run_tests' TIME_FORMAT 'P' TIME_ZONE 'America/Chicago' TRANSACTIONS_MANAGED False URL_VALIDATOR_USER_AGENT 'Django/0.96pre (http://www.djangoproject.com)' USE_ETAGS False USE_I18N True YEAR_MONTH_FORMAT 'F Y' You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard 500 page.