OperationalError at /buscar

(1305, 'PROCEDURE sigpa_prd.sp_sgp_obt_busqueda_v2 does not exist')
Request Method: GET
Request URL: https://www.sigpa.cl/buscar
Django Version: 1.6.1
Exception Type: OperationalError
Exception Value:
(1305, 'PROCEDURE sigpa_prd.sp_sgp_obt_busqueda_v2 does not exist')
Exception Location: /home/webmaster/webapps/sigpa.cl/lib/python2.7/site-packages/MySQLdb/cursors.py in _do_query, line 318
Python Executable: /home/webmaster/webapps/sigpa.cl/bin/python2.7
Python Version: 2.7.0
Python Path:
['/home/webmaster/webapps/sigpa.cl/sigpa',
 '/home/webmaster/webapps/sigpa.cl/bin',
 '/home/webmaster/webapps/sigpa.cl/sigpa',
 '/home/webmaster/webapps/sigpa.cl/lib/python27.zip',
 '/home/webmaster/webapps/sigpa.cl/lib/python2.7',
 '/home/webmaster/webapps/sigpa.cl/lib/python2.7/plat-linux2',
 '/home/webmaster/webapps/sigpa.cl/lib/python2.7/lib-tk',
 '/home/webmaster/webapps/sigpa.cl/lib/python2.7/lib-old',
 '/home/webmaster/webapps/sigpa.cl/lib/python2.7/lib-dynload',
 '/usr/local/lib/python2.7',
 '/usr/local/lib/python2.7/plat-linux2',
 '/usr/local/lib/python2.7/lib-tk',
 '/home/webmaster/webapps/sigpa.cl/lib/python2.7/site-packages']
Server time: Lun, 18 Mar 2024 23:44:46 -0300

Traceback Switch to copy-and-paste view



Request information

GET

No GET data

POST

No POST data

FILES

No FILES data

No cookie data

META

Variable Value
SERVER_SOFTWARE
'gunicorn/19.3.0'
SCRIPT_NAME
u''
REQUEST_METHOD
'GET'
HTTP_X_FORWARDED_SCHEME
'https'
SERVER_PROTOCOL
'HTTP/1.0'
QUERY_STRING
''
HTTP_X_REAL_IP
'3.93.173.205'
HTTP_USER_AGENT
'claudebot'
HTTP_CONNECTION
'close'
SERVER_NAME
'www.sigpa.cl'
REMOTE_ADDR
''
wsgi.url_scheme
'https'
SERVER_PORT
'443'
HTTP_X_FORWARDED_PROTO
'https'
wsgi.input
<gunicorn.http.body.Body object at 0x2f9d490>
HTTP_HOST
'www.sigpa.cl'
wsgi.multithread
False
HTTP_ACCEPT
'*/*'
wsgi.version
(1, 0)
RAW_URI
'/buscar'
wsgi.run_once
False
wsgi.errors
<gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x2f9d890>
wsgi.multiprocess
True
gunicorn.socket
<socket._socketobject object at 0x36bcc20>
HTTP_X_FORWARDED_FOR
'3.93.173.205, 172.16.40.21'
wsgi.file_wrapper
''
CSRF_COOKIE
u'7E3X7QhgmOnQ9o7ZK3WcNfU6e5XJ5Qnp'
PATH_INFO
u'/buscar'

Settings

Using settings module sigpa.settings

Setting Value
USE_L10N
True
USE_THOUSAND_SEPARATOR
False
CSRF_COOKIE_SECURE
False
LANGUAGE_CODE
'es'
ROOT_URLCONF
'sigpa.urls'
MANAGERS
(('Reporte Problemas', 'sigpa.contacto@gmail.com'),)
MAINTENANCE_IGNORE_URLS
('^/media/.*',)
BASE_DIR
'/home/webmaster/webapps/sigpa.cl/sigpa'
DEFAULT_CHARSET
'utf-8'
SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer'
STATIC_ROOT
''
ALLOWED_HOSTS
'*'
MESSAGE_STORAGE
'django.contrib.messages.storage.cookie.CookieStorage'
EMAIL_SUBJECT_PREFIX
'SIGPA'
SEND_BROKEN_LINK_EMAILS
False
STATICFILES_FINDERS
('django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder')
SESSION_CACHE_ALIAS
'default'
SESSION_COOKIE_DOMAIN
None
SESSION_COOKIE_NAME
'sessionid'
CSRF_COOKIE_NAME
'csrftoken'
ADMIN_FOR
()
TIME_INPUT_FORMATS
('%H:%M:%S', '%H:%M:%S.%f', '%H:%M')
DATABASES
{'acreditacion': {'ATOMIC_REQUESTS': False,
                  'AUTOCOMMIT': True,
                  'CONN_MAX_AGE': 0,
                  'ENGINE': 'django.db.backends.mysql',
                  'HOST': 'localhost',
                  'NAME': 'acreditacion',
                  'OPTIONS': {},
                  'PASSWORD': u'********************',
                  'PORT': '',
                  'TEST_CHARSET': None,
                  'TEST_COLLATION': None,
                  'TEST_MIRROR': None,
                  'TEST_NAME': None,
                  'TIME_ZONE': 'America/Santiago',
                  'USER': 'root'},
 'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CONN_MAX_AGE': 0,
             'ENGINE': 'django.db.backends.mysql',
             'HOST': 'localhost',
             'NAME': 'sigpa_prd',
             'OPTIONS': {},
             'PASSWORD': u'********************',
             'PORT': '',
             'TEST_CHARSET': None,
             'TEST_COLLATION': None,
             'TEST_MIRROR': None,
             'TEST_NAME': None,
             'TIME_ZONE': 'America/Santiago',
             'USER': 'root'}}
FILE_UPLOAD_PERMISSIONS
None
FILE_UPLOAD_HANDLERS
('django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
TEMPLATE_CONTEXT_PROCESSORS
('django.contrib.messages.context_processors.messages',
 'django.contrib.auth.context_processors.auth',
 'sigpa_front.context_processors.url_site')
DEFAULT_CONTENT_TYPE
'text/html'
URL_SITIO
'http://sigpa.cl/'
APPEND_SLASH
True
FIRST_DAY_OF_WEEK
0
DATABASE_ROUTERS
[]
YEAR_MONTH_FORMAT
'F Y'
STATICFILES_STORAGE
'django.contrib.staticfiles.storage.StaticFilesStorage'
CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
SERVER_EMAIL
'sigpa.contacto@gmail.com'
SESSION_COOKIE_PATH
'/'
MIDDLEWARE_CLASSES
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'maintenancemode.middleware.MaintenanceModeMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'reversion.middleware.RevisionMiddleware')
USE_I18N
True
THOUSAND_SEPARATOR
','
SECRET_KEY
u'********************'
LANGUAGE_COOKIE_NAME
'django_language'
DEFAULT_INDEX_TABLESPACE
''
TRANSACTIONS_MANAGED
False
LOGGING_CONFIG
'django.utils.log.dictConfig'
TEMPLATE_LOADERS
('django.template.loaders.filesystem.Loader',
 'django.template.loaders.app_directories.Loader')
WSGI_APPLICATION
'sigpa.wsgi.application'
TEMPLATE_DEBUG
True
X_FRAME_OPTIONS
'SAMEORIGIN'
LISTA_REGISTROS_ADMIN
{'cultor_colectivo': 10,
 'cultor_individual': 10,
 'fiestas': 10,
 'gastronomia': 10}
FORCE_SCRIPT_NAME
None
USE_X_FORWARDED_HOST
False
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
SESSION_COOKIE_SECURE
False
URL_SITE
'http://www.sigpa.cl/'
CSRF_COOKIE_DOMAIN
None
FILE_CHARSET
'utf-8'
DEBUG
True
SESSION_FILE_PATH
None
DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
INSTALLED_APPS
('django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.messages',
 'django.contrib.admin',
 'sigpa',
 'sigpa_front',
 'sigpa_conceptos',
 'sigpa_geo',
 'sigpa_usuario',
 'sigpa_fiesta',
 'sigpa_gastronomia',
 'sigpa_gestion',
 'sigpa_region',
 'sigpa_reportes',
 'sigpa_buscador',
 'sigpa_widget',
 'sigpa_revision',
 'sigpa_solicitud',
 'sigpa_api',
 'sigpa_utils',
 'maintenancemode',
 'sigpa_arcgis',
 'reversion')
LANGUAGES
(('af', 'Afrikaans'),
 ('ar', 'Arabic'),
 ('az', 'Azerbaijani'),
 ('bg', 'Bulgarian'),
 ('be', 'Belarusian'),
 ('bn', 'Bengali'),
 ('br', 'Breton'),
 ('bs', 'Bosnian'),
 ('ca', 'Catalan'),
 ('cs', 'Czech'),
 ('cy', 'Welsh'),
 ('da', 'Danish'),
 ('de', 'German'),
 ('el', 'Greek'),
 ('en', 'English'),
 ('en-gb', 'British English'),
 ('eo', 'Esperanto'),
 ('es', 'Spanish'),
 ('es-ar', 'Argentinian Spanish'),
 ('es-mx', 'Mexican Spanish'),
 ('es-ni', 'Nicaraguan Spanish'),
 ('es-ve', 'Venezuelan Spanish'),
 ('et', 'Estonian'),
 ('eu', 'Basque'),
 ('fa', 'Persian'),
 ('fi', 'Finnish'),
 ('fr', 'French'),
 ('fy-nl', 'Frisian'),
 ('ga', 'Irish'),
 ('gl', 'Galician'),
 ('he', 'Hebrew'),
 ('hi', 'Hindi'),
 ('hr', 'Croatian'),
 ('hu', 'Hungarian'),
 ('ia', 'Interlingua'),
 ('id', 'Indonesian'),
 ('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'),
 ('my', 'Burmese'),
 ('nb', 'Norwegian Bokmal'),
 ('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-cn', 'Simplified Chinese'),
 ('zh-tw', 'Traditional Chinese'))
COMMENTS_ALLOW_PROFANITIES
False
STATICFILES_DIRS
()
PREPEND_WWW
False
MAPS_API_KEY
u'********************'
SESSION_COOKIE_HTTPONLY
True
DEBUG_PROPAGATE_EXCEPTIONS
False
MONTH_DAY_FORMAT
'F j'
LOGIN_URL
'/sigpa/login/'
SESSION_EXPIRE_AT_BROWSER_CLOSE
True
MAINTENANCE_LOCKFILE_PATH
'/home/webmaster/webapps/sigpa.cl/lib/python2.7/site-packages/maintenancemode/maintenance.lock'
TIME_FORMAT
'P'
AUTH_USER_MODEL
'auth.User'
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')
AUTHENTICATION_BACKENDS
('django.contrib.auth.backends.ModelBackend',)
EMAIL_HOST_PASSWORD
u'********************'
PASSWORD_RESET_TIMEOUT_DAYS
u'********************'
CACHE_MIDDLEWARE_ALIAS
'default'
SESSION_SAVE_EVERY_REQUEST
False
ADMIN_MEDIA_PREFIX
'/media/admin/'
NUMBER_GROUPING
0
EMAIL_CONTACTO
['jorge.maldonado@cultura.gob.cl',
 'agustin.ruin@gmail.com',
 'sigpa.contacto@gmail.com']
SESSION_ENGINE
'django.contrib.sessions.backends.db'
CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure'
CSRF_COOKIE_PATH
'/'
LOGIN_REDIRECT_URL
'/'
FICHA_CONTACTO
['jorge.maldonado@cultura.gob.cl',
 'agustin.ruin@gmail.com',
 'sigpa.contacto@gmail.com']
DECIMAL_SEPARATOR
'.'
IGNORABLE_404_URLS
()
LISTA_REGISTROS_HOME
{'cultor_colectivo': 18,
 'cultor_individual': 18,
 'fiestas': 18,
 'gastronomia': 18,
 'usuarios': 24}
LOCALE_PATHS
()
TEMPLATE_STRING_IF_INVALID
''
LOGOUT_URL
'sigpa/logout'
EMAIL_USE_TLS
True
FIXTURE_DIRS
()
EMAIL_HOST
'smtp.gmail.com'
DATE_FORMAT
'N j, Y'
MEDIA_ROOT
'/home/webmaster/webapps/assets/'
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
ADMINS
(('Reporte Problemas', 'sigpa.contacto@gmail.com'),)
FORMAT_MODULE_PATH
None
DEFAULT_FROM_EMAIL
'sigpa.contacto@gmail.com'
MEDIA_URL
'/assets/'
DATETIME_FORMAT
'N j, Y, P'
TEMPLATE_DIRS
('/home/webmaster/webapps/sigpa.cl/public/templates',)
SITE_ID
1
DISALLOWED_USER_AGENTS
()
ALLOWED_INCLUDE_ROOTS
()
LOGGING
{'disable_existing_loggers': False,
 'handlers': {'mail_admins': {'class': 'django.utils.log.AdminEmailHandler',
                              'level': 'ERROR'}},
 'loggers': {'django.request': {'handlers': ['mail_admins'],
                                'level': 'ERROR',
                                'propagate': True}},
 'version': 1}
SHORT_DATE_FORMAT
'm/d/Y'
SECURE_PROXY_SSL_HEADER
None
TEST_RUNNER
'django.test.runner.DiscoverRunner'
CACHE_MIDDLEWARE_KEY_PREFIX
u'********************'
TIME_ZONE
'America/Santiago'
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
DEFAULT_TABLESPACE
''
CRISPY_TEMPLATE_PACK
'bootstrap3'
SESSION_COOKIE_AGE
1209600
SETTINGS_MODULE
'sigpa.settings'
USE_ETAGS
False
LANGUAGES_BIDI
('he', 'ar', 'fa', 'ur')
FILE_UPLOAD_TEMP_DIR
None
INTERNAL_IPS
()
STATIC_URL
'/static/'
EMAIL_PORT
587
USE_TZ
False
SHORT_DATETIME_FORMAT
'm/d/Y P'
PASSWORD_HASHERS
u'********************'
ABSOLUTE_URL_OVERRIDES
{}
CONTACTS
['jorge.maldonado@cultura.gob.cl']
MAINTENANCE_MODE
False
CACHE_MIDDLEWARE_SECONDS
600
CSRF_COOKIE_HTTPONLY
False
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')
EMAIL_HOST_USER
'sigpa.contacto@gmail.com'
PROFANITIES_LIST
u'********************'

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.