找回密码
 立即注册

扫一扫,访问微社区

QQ登录

只需一步,快速开始

查看: 3669|回复: 1

[代码与实例] django的admin管理问题

1

主题

2

帖子

2

积分

贫民

积分
2
2541193176 发表于 2017-4-18 15:04:58 | 显示全部楼层 |阅读模式
django 运行后进入admin登陆之后点击管理的站点报错
QQ截图20170418150406.png
回复

使用道具 举报

1

主题

2

帖子

2

积分

贫民

积分
2
2541193176  楼主| 发表于 2017-4-18 15:05:26 | 显示全部楼层
TypeError at /admin/blog/article/
unorderable types: NoneType() > int()
Request Method:        GET
Request URL:        http://127.0.0.1:8000/admin/blog/article/
Django Version:        1.10.6
Exception Type:        TypeError
Exception Value:       
unorderable types: NoneType() > int()
Exception Location:        G:\Python34\lib\site-packages\django\db\backends\oracle\base.py in _rowfactory, line 580
Python Executable:        G:\Python34\python.exe
Python Version:        3.5.3
Python Path:       
['G:\\mylesson\\myblog',
'G:\\Python34\\lib\\site-packages\\web.py-0.40.dev0-py3.4.egg',
'G:\\Python34\\python35.zip',
'G:\\Python34\\DLLs',
'G:\\Python34\\lib',
'G:\\Python34',
'G:\\Python34\\lib\\site-packages']
Server time:        星期二, 18 四月 2017 15:03:57 +0800
Traceback Switch to copy-and-paste view

G:\Python34\lib\site-packages\django\core\handlers\exception.py in inner
            response = get_response(request) ...
▶ Local vars
G:\Python34\lib\site-packages\django\core\handlers\base.py in _get_response
                response = self.process_exception_by_middleware(e, request) ...
▶ Local vars
G:\Python34\lib\site-packages\django\core\handlers\base.py in _get_response
                response = wrapped_callback(request, *callback_args, **callback_kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\contrib\admin\options.py in wrapper
                return self.admin_site.admin_view(view)(*args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\utils\decorators.py in _wrapped_view
                    response = view_func(request, *args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\views\decorators\cache.py in _wrapped_view_func
        response = view_func(request, *args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\contrib\admin\sites.py in inner
            return view(request, *args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\utils\decorators.py in _wrapper
            return bound_func(*args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\utils\decorators.py in _wrapped_view
                    response = view_func(request, *args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\utils\decorators.py in bound_func
                return func.__get__(self, type(self))(*args2, **kwargs2) ...
▶ Local vars
G:\Python34\lib\site-packages\django\contrib\admin\options.py in changelist_view
                self.list_max_show_all, self.list_editable, self, ...
▶ Local vars
G:\Python34\lib\site-packages\django\contrib\admin\views\main.py in __init__
        self.get_results(request) ...
▶ Local vars
G:\Python34\lib\site-packages\django\contrib\admin\views\main.py in get_results
            full_result_count = self.root_queryset.count() ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\models\query.py in count
        return self.query.get_count(using=self.db) ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\models\sql\query.py in get_count
        number = obj.get_aggregation(using, ['__count'])['__count'] ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\models\sql\query.py in get_aggregation
        result = compiler.execute_sql(SINGLE) ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\models\sql\compiler.py in execute_sql
                val = cursor.fetchone() ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\utils.py in inner
                return func(*args, **kwargs) ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\backends\oracle\base.py in fetchone
        return _rowfactory(row, self.cursor) ...
▶ Local vars
G:\Python34\lib\site-packages\django\db\backends\oracle\base.py in _rowfactory
            elif precision > 0: ...
▶ Local vars
Request information

USER
admin
GET
No GET data
POST
No POST data
FILES
No FILES data
COOKIES
Variable        Value
csrftoken       
'W1nBClLFNymVTLHMWHXBRMyCmDbt3cLuIjFr7P2Vq7WGXdWM3li8887fgFNjeFcJ'
sessionid       
'vcn0thch1ynwf8oqklzjlnhetbr9ix04'
META
Variable        Value
#ENVTSLOGSHELLEXT2928       
'185962464'
ALLUSERSPROFILE       
'C:\\ProgramData'
APPDATA       
'C:\\Users\\41799\\AppData\\Roaming'
CLASS_PATH       
'.;C:\\Java\\jdk1.8.0_91\\lib;'
COMMONPROGRAMFILES       
'C:\\Program Files\\Common Files'
COMMONPROGRAMFILES(X86)       
'C:\\Program Files (x86)\\Common Files'
COMMONPROGRAMW6432       
'C:\\Program Files\\Common Files'
COMPUTERNAME       
'VS'
COMSPEC       
'C:\\WINDOWS\\system32\\cmd.exe'
CONTENT_LENGTH       
''
CONTENT_TYPE       
'text/plain'
CSRF_COOKIE       
'W1nBClLFNymVTLHMWHXBRMyCmDbt3cLuIjFr7P2Vq7WGXdWM3li8887fgFNjeFcJ'
DJANGO_SETTINGS_MODULE       
'myblog.settings'
FPS_BROWSER_APP_PROFILE_STRING       
'Internet Explorer'
FPS_BROWSER_USER_PROFILE_STRING       
'Default'
GATEWAY_INTERFACE       
'CGI/1.1'
HOMEDRIVE       
'C:'
HOMEPATH       
'\\Users\\41799'
HTTP_ACCEPT       
'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'
HTTP_ACCEPT_ENCODING       
'gzip, deflate'
HTTP_ACCEPT_LANGUAGE       
'zh-CN,zh;q=0.8'
HTTP_CONNECTION       
'keep-alive'
HTTP_COOKIE       
('csrftoken=W1nBClLFNymVTLHMWHXBRMyCmDbt3cLuIjFr7P2Vq7WGXdWM3li8887fgFNjeFcJ; '
'sessionid=vcn0thch1ynwf8oqklzjlnhetbr9ix04')
HTTP_DNT       
'1'
HTTP_HOST       
'127.0.0.1:8000'
HTTP_REFERER       
'http://127.0.0.1:8000/admin/'
HTTP_UPGRADE_INSECURE_REQUESTS       
'1'
HTTP_USER_AGENT       
('Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) '
'Chrome/47.0.2526.106 BIDUBrowser/8.7 Safari/537.36')
LOCALAPPDATA       
'C:\\Users\\41799\\AppData\\Local'
LOGONSERVER       
'\\\\VS'
NLS_LANG       
'.UTF8'
NUMBER_OF_PROCESSORS       
'8'
ONEDRIVE       
'C:\\Users\\41799\\OneDrive'
ORA_NCHAR_LITERAL_REPLACE       
'TRUE'
OS       
'Windows_NT'
PATH       
('E:\\oracledatabase\\product\\12.1.0\\dbhome_2\\bin;E:\\oracledatabase\\product\\12.1.0\\dbhome_1\\bin;C:\\ProgramData\\Oracle\\Java\\javapath;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0\\;E:\\PB\\Shared\\PowerBuilder;C:\\Java\\jdk1.8.0_91\\bin;G:\\Python34;C:\\Program '
'Files\\Intel\\WiFi\\bin\\;C:\\Program Files\\Common '
'Files\\Intel\\WirelessCommon\\;G:\\Python34\\Scripts\\;G:\\Python34\\;C:\\Program '
'Files\\Intel\\WiFi\\bin\\;C:\\Program Files\\Common '
'Files\\Intel\\WirelessCommon\\;C:\\Users\\41799\\AppData\\Local\\Microsoft\\WindowsApps;G:\\Python34;G:\\Python34\\Scripts;')
PATHEXT       
'.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC'
PATH_INFO       
'/admin/blog/article/'
PROCESSOR_ARCHITECTURE       
'AMD64'
PROCESSOR_IDENTIFIER       
'Intel64 Family 6 Model 94 Stepping 3, GenuineIntel'
PROCESSOR_LEVEL       
'6'
PROCESSOR_REVISION       
'5e03'
PROGRAMDATA       
'C:\\ProgramData'
PROGRAMFILES       
'C:\\Program Files'
PROGRAMFILES(X86)       
'C:\\Program Files (x86)'
PROGRAMW6432       
'C:\\Program Files'
PROMPT       
'$P$G'
PSMODULEPATH       
'C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules\\'
PUBLIC       
'C:\\Users\\Public'
QUERY_STRING       
''
REMOTE_ADDR       
'127.0.0.1'
REMOTE_HOST       
''
REQUEST_METHOD       
'GET'
RUN_MAIN       
'true'
SCRIPT_NAME       
''
SERVER_NAME       
'vs'
SERVER_PORT       
'8000'
SERVER_PROTOCOL       
'HTTP/1.1'
SERVER_SOFTWARE       
'WSGIServer/0.2'
SESSIONNAME       
'Console'
SYSTEMDRIVE       
'C:'
SYSTEMROOT       
'C:\\WINDOWS'
TEMP       
'C:\\Users\\41799\\AppData\\Local\\Temp'
TMP       
'C:\\Users\\41799\\AppData\\Local\\Temp'
USERDOMAIN       
'VS'
USERDOMAIN_ROAMINGPROFILE       
'VS'
USERNAME       
'41799'
USERPROFILE       
'C:\\Users\\41799'
VBOX_MSI_INSTALL_PATH       
'F:\\oracle VM\\'
WINDIR       
'C:\\WINDOWS'
wsgi.errors       
<_io.TextIOWrapper name='<stderr>' mode='w' encoding='cp936'>
wsgi.file_wrapper       
''
wsgi.input       
<_io.BufferedReader name=1640>
wsgi.multiprocess       
False
wsgi.multithread       
True
wsgi.run_once       
False
wsgi.url_scheme       
'http'
wsgi.version       
(1, 0)
Settings
Using settings module myblog.settings
Setting        Value
ABSOLUTE_URL_OVERRIDES       
{}
ADMINS       
[]
ALLOWED_HOSTS       
[]
APPEND_SLASH       
True
AUTHENTICATION_BACKENDS       
['django.contrib.auth.backends.ModelBackend']
AUTH_PASSWORD_VALIDATORS       
'********************'
AUTH_USER_MODEL       
'auth.User'
BASE_DIR       
'G:\\mylesson\\myblog'
CACHES       
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
CACHE_MIDDLEWARE_ALIAS       
'default'
CACHE_MIDDLEWARE_KEY_PREFIX       
'********************'
CACHE_MIDDLEWARE_SECONDS       
600
CSRF_COOKIE_AGE       
31449600
CSRF_COOKIE_DOMAIN       
None
CSRF_COOKIE_HTTPONLY       
False
CSRF_COOKIE_NAME       
'csrftoken'
CSRF_COOKIE_PATH       
'/'
CSRF_COOKIE_SECURE       
False
CSRF_FAILURE_VIEW       
'django.views.csrf.csrf_failure'
CSRF_HEADER_NAME       
'HTTP_X_CSRFTOKEN'
CSRF_TRUSTED_ORIGINS       
[]
DATABASES       
{'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CONN_MAX_AGE': 0,
             'ENGINE': 'django.db.backends.oracle',
             'HOST': 'localhost',
             'NAME': 'orcl',
             'OPTIONS': {},
             'PASSWORD': '********************',
             'PORT': '1521',
             'TEST': {'CHARSET': None,
                      'COLLATION': None,
                      'MIRROR': None,
                      'NAME': None},
             'TIME_ZONE': None,
             'USER': 'c##blog'}}
DATABASE_ROUTERS       
[]
DATA_UPLOAD_MAX_MEMORY_SIZE       
2621440
DATA_UPLOAD_MAX_NUMBER_FIELDS       
1000
DATETIME_FORMAT       
'N j, Y, P'
DATETIME_INPUT_FORMATS       
['%Y-%m-%d %H:%M:%S',
'%Y-%m-%d %H:%M:%S.%f',
'%Y-%m-%d %H:%M',
'%Y-%m-%d',
'%m/%d/%Y %H:%M:%S',
'%m/%d/%Y %H:%M:%S.%f',
'%m/%d/%Y %H:%M',
'%m/%d/%Y',
'%m/%d/%y %H:%M:%S',
'%m/%d/%y %H:%M:%S.%f',
'%m/%d/%y %H:%M',
'%m/%d/%y']
DATE_FORMAT       
'N j, Y'
DATE_INPUT_FORMATS       
['%Y-%m-%d',
'%m/%d/%Y',
'%m/%d/%y',
'%b %d %Y',
'%b %d, %Y',
'%d %b %Y',
'%d %b, %Y',
'%B %d %Y',
'%B %d, %Y',
'%d %B %Y',
'%d %B, %Y']
DEBUG       
True
DEBUG_PROPAGATE_EXCEPTIONS       
False
DECIMAL_SEPARATOR       
'.'
DEFAULT_CHARSET       
'utf-8'
DEFAULT_CONTENT_TYPE       
'text/html'
DEFAULT_EXCEPTION_REPORTER_FILTER       
'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE       
'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL       
'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE       
''
DEFAULT_TABLESPACE       
''
DISALLOWED_USER_AGENTS       
[]
EMAIL_BACKEND       
'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST       
'localhost'
EMAIL_HOST_PASSWORD       
'********************'
EMAIL_HOST_USER       
''
EMAIL_PORT       
25
EMAIL_SSL_CERTFILE       
None
EMAIL_SSL_KEYFILE       
'********************'
EMAIL_SUBJECT_PREFIX       
'[Django] '
EMAIL_TIMEOUT       
None
EMAIL_USE_SSL       
False
EMAIL_USE_TLS       
False
FILE_CHARSET       
'utf-8'
FILE_UPLOAD_DIRECTORY_PERMISSIONS       
None
FILE_UPLOAD_HANDLERS       
['django.core.files.uploadhandler.MemoryFileUploadHandler',
'django.core.files.uploadhandler.TemporaryFileUploadHandler']
FILE_UPLOAD_MAX_MEMORY_SIZE       
2621440
FILE_UPLOAD_PERMISSIONS       
None
FILE_UPLOAD_TEMP_DIR       
None
FIRST_DAY_OF_WEEK       
0
FIXTURE_DIRS       
[]
FORCE_SCRIPT_NAME       
None
FORMAT_MODULE_PATH       
None
IGNORABLE_404_URLS       
[]
INSTALLED_APPS       
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'blog']
INTERNAL_IPS       
[]
LANGUAGES       
[('af', 'Afrikaans'),
('ar', 'Arabic'),
('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'),
('be', 'Belarusian'),
('bn', 'Bengali'),
('br', 'Breton'),
('bs', 'Bosnian'),
('ca', 'Catalan'),
('cs', 'Czech'),
('cy', 'Welsh'),
('da', 'Danish'),
('de', 'German'),
('dsb', 'Lower Sorbian'),
('el', 'Greek'),
('en', 'English'),
('en-au', 'Australian English'),
('en-gb', 'British English'),
('eo', 'Esperanto'),
('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'),
('eu', 'Basque'),
('fa', 'Persian'),
('fi', 'Finnish'),
('fr', 'French'),
('fy', 'Frisian'),
('ga', 'Irish'),
('gd', 'Scottish Gaelic'),
('gl', 'Galician'),
('he', 'Hebrew'),
('hi', 'Hindi'),
('hr', 'Croatian'),
('hsb', 'Upper Sorbian'),
('hu', 'Hungarian'),
('ia', 'Interlingua'),
('id', 'Indonesian'),
('io', 'Ido'),
('is', 'Icelandic'),
('it', 'Italian'),
('ja', 'Japanese'),
('ka', 'Georgian'),
('kk', 'Kazakh'),
('km', 'Khmer'),
('kn', 'Kannada'),
('ko', 'Korean'),
('lb', 'Luxembourgish'),
('lt', 'Lithuanian'),
('lv', 'Latvian'),
('mk', 'Macedonian'),
('ml', 'Malayalam'),
('mn', 'Mongolian'),
('mr', 'Marathi'),
('my', 'Burmese'),
('nb', 'Norwegian Bokmål'),
('ne', 'Nepali'),
('nl', 'Dutch'),
('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'),
('pa', 'Punjabi'),
('pl', 'Polish'),
('pt', 'Portuguese'),
('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'),
('ru', 'Russian'),
('sk', 'Slovak'),
('sl', 'Slovenian'),
('sq', 'Albanian'),
('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'),
('sw', 'Swahili'),
('ta', 'Tamil'),
('te', 'Telugu'),
('th', 'Thai'),
('tr', 'Turkish'),
('tt', 'Tatar'),
('udm', 'Udmurt'),
('uk', 'Ukrainian'),
('ur', 'Urdu'),
('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')]
LANGUAGES_BIDI       
['he', 'ar', 'fa', 'ur']
LANGUAGE_CODE       
'zh_Hans'
LANGUAGE_COOKIE_AGE       
None
LANGUAGE_COOKIE_DOMAIN       
None
LANGUAGE_COOKIE_NAME       
'django_language'
LANGUAGE_COOKIE_PATH       
'/'
LOCALE_PATHS       
[]
LOGGING       
{}
LOGGING_CONFIG       
'logging.config.dictConfig'
LOGIN_REDIRECT_URL       
'/accounts/profile/'
LOGIN_URL       
'/accounts/login/'
LOGOUT_REDIRECT_URL       
None
MANAGERS       
[]
MEDIA_ROOT       
''
MEDIA_URL       
''
MESSAGE_STORAGE       
'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE       
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware']
MIDDLEWARE_CLASSES       
['django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware']
MIGRATION_MODULES       
{}
MONTH_DAY_FORMAT       
'F j'
NUMBER_GROUPING       
0
PASSWORD_HASHERS       
'********************'
PASSWORD_RESET_TIMEOUT_DAYS       
'********************'
PREPEND_WWW       
False
ROOT_URLCONF       
'myblog.urls'
SECRET_KEY       
'********************'
SECURE_BROWSER_XSS_FILTER       
False
SECURE_CONTENT_TYPE_NOSNIFF       
False
SECURE_HSTS_INCLUDE_SUBDOMAINS       
False
SECURE_HSTS_SECONDS       
0
SECURE_PROXY_SSL_HEADER       
None
SECURE_REDIRECT_EXEMPT       
[]
SECURE_SSL_HOST       
None
SECURE_SSL_REDIRECT       
False
SERVER_EMAIL       
'root@localhost'
SESSION_CACHE_ALIAS       
'default'
SESSION_COOKIE_AGE       
1209600
SESSION_COOKIE_DOMAIN       
None
SESSION_COOKIE_HTTPONLY       
True
SESSION_COOKIE_NAME       
'sessionid'
SESSION_COOKIE_PATH       
'/'
SESSION_COOKIE_SECURE       
False
SESSION_ENGINE       
'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE       
False
SESSION_FILE_PATH       
None
SESSION_SAVE_EVERY_REQUEST       
False
SESSION_SERIALIZER       
'django.contrib.sessions.serializers.JSONSerializer'
SETTINGS_MODULE       
'myblog.settings'
SHORT_DATETIME_FORMAT       
'm/d/Y P'
SHORT_DATE_FORMAT       
'm/d/Y'
SIGNING_BACKEND       
'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS       
[]
STATICFILES_DIRS       
[]
STATICFILES_FINDERS       
['django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder']
STATICFILES_STORAGE       
'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT       
None
STATIC_URL       
'/static/'
TEMPLATES       
[{'APP_DIRS': True,
  'BACKEND': 'django.template.backends.django.DjangoTemplates',
  'DIRS': [],
  'OPTIONS': {'context_processors': ['django.template.context_processors.debug',
                                     'django.template.context_processors.request',
                                     'django.contrib.auth.context_processors.auth',
                                     'django.contrib.messages.context_processors.messages']}}]
TEST_NON_SERIALIZED_APPS       
[]
TEST_RUNNER       
'django.test.runner.DiscoverRunner'
THOUSAND_SEPARATOR       
','
TIME_FORMAT       
'P'
TIME_INPUT_FORMATS       
['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
TIME_ZONE       
'UTC'
USE_ETAGS       
False
USE_I18N       
True
USE_L10N       
True
USE_THOUSAND_SEPARATOR       
False
USE_TZ       
True
USE_X_FORWARDED_HOST       
False
USE_X_FORWARDED_PORT       
False
WSGI_APPLICATION       
'myblog.wsgi.application'
X_FRAME_OPTIONS       
'SAMEORIGIN'
YEAR_MONTH_FORMAT       
'F Y'
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表