Hi i got an error 1064 with this Traceback
Environment:
Request Method: GET
Request URL: https://xxxxxxxx:8090/
Django Version: 3.1.3
Python Version: 3.8.10
Installed Applications:
[‘django.contrib.admin’,
‘django.contrib.auth’,
‘django.contrib.contenttypes’,
‘django.contrib.sessions’,
‘django.contrib.messages’,
‘django.contrib.staticfiles’,
‘baseTemplate’,
‘loginSystem’,
‘packages’,
‘websiteFunctions’,
‘tuning’,
‘serverStatus’,
‘dns’,
‘ftp’,
‘userManagment’,
‘databases’,
‘mailServer’,
‘serverLogs’,
‘firewall’,
‘backup’,
‘managePHP’,
‘manageSSL’,
‘api’,
‘filemanager’,
‘manageServices’,
‘pluginHolder’,
‘emailPremium’,
‘emailMarketing’,
‘cloudAPI’,
‘highAvailability’,
‘s3Backups’,
‘dockerManager’,
‘containerization’,
‘CLManager’,
‘IncBackups’]
Installed Middleware:
[‘django.middleware.security.SecurityMiddleware’,
‘django.contrib.sessions.middleware.SessionMiddleware’,
‘django.middleware.locale.LocaleMiddleware’,
‘django.middleware.common.CommonMiddleware’,
‘django.middleware.csrf.CsrfViewMiddleware’,
‘django.contrib.auth.middleware.AuthenticationMiddleware’,
‘django.contrib.messages.middleware.MessageMiddleware’,
‘django.middleware.clickjacking.XFrameOptionsMiddleware’,
‘CyberCP.secMiddleware.secMiddleware’]
Traceback (most recent call last):
File “/usr/local/CyberCP/loginSystem/views.py”, line 147, in loadLoginPage
userID = request.session[‘userID’]
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/contrib/sessions/backends/base.py”, line 65, in getitem
return self._session[key]
During handling of the above exception (‘userID’), another exception occurred:
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/utils.py”, line 82, in _execute
return self.cursor.execute(sql)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/usr/local/CyberCP/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/usr/local/CyberCP/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/usr/local/CyberCP/lib/python3.8/site-packages/MySQLdb/connections.py”, line 259, in query
_mysql.connection.query(self, query)
The above exception ((1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘@SQL_AUTO_IS_NULL’ at line 1”)) was the direct cause of the following exception:
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/core/handlers/exception.py”, line 47, in inner
response = get_response(request)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/core/handlers/base.py”, line 179, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/utils/decorators.py”, line 130, in _wrapped_view
response = view_func(request, *args, **kwargs)
File “/usr/local/CyberCP/loginSystem/views.py”, line 166, in loadLoginPage
numberOfAdministrator = Administrator.objects.count()
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/models/manager.py”, line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/models/query.py”, line 411, in count
return self.query.get_count(using=self.db)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/models/sql/query.py”, line 515, in get_count
number = obj.get_aggregation(using, [‘__count’])[‘__count’]
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/models/sql/query.py”, line 500, in get_aggregation
result = compiler.execute_sql(SINGLE)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/models/sql/compiler.py”, line 1154, in execute_sql
cursor = self.connection.cursor()
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/base/base.py”, line 259, in cursor
return self._cursor()
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/base/base.py”, line 235, in _cursor
self.ensure_connection()
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/base/base.py”, line 219, in ensure_connection
self.connect()
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/base/base.py”, line 202, in connect
self.init_connection_state()
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/mysql/base.py”, line 238, in init_connection_state
if self.features.is_sql_auto_is_null_enabled:
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/utils/functional.py”, line 48, in get
res = instance.dict[self.name] = self.func(instance)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/mysql/features.py”, line 90, in is_sql_auto_is_null_enabled
cursor.execute(‘SELECT @@SQL_AUTO_IS_NULL’)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/utils.py”, line 98, in execute
return super().execute(sql, params)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/utils.py”, line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/utils.py”, line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/utils.py”, line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/utils.py”, line 82, in _execute
return self.cursor.execute(sql)
File “/usr/local/CyberCP/lib/python3.8/site-packages/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/usr/local/CyberCP/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/usr/local/CyberCP/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/usr/local/CyberCP/lib/python3.8/site-packages/MySQLdb/connections.py”, line 259, in query
_mysql.connection.query(self, query)
Exception Type: ProgrammingError at /
Exception Value: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘@SQL_AUTO_IS_NULL’ at line 1”)
I will be really appreciate the help