Ошибка "A server error occurred".

7 years 7 months ago #657 by nesmit
nesmit created the topic: Ошибка "A server error occurred".
Обновился с Ubuntu 14.04 на 16.06. До этого все работало отлично.
При попытке выбрать какой нибудь жанр:
http://192.168.1.100:8081/web?id=1419&news=1
Ответ:

A server error occurred. Please contact the administrator.

Влогах:

192.168.1.110 - - [09/Sep/2016 12:15:34] "GET /favicon.ico HTTP/1.1" 200 1860
Traceback (most recent call last):
File "/usr/lib/python3.5/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/opt/sopds/py/sopdserve.py", line 40, in app
sopds.make_response()
File "/opt/sopds/py/sopdscli.py", line 780, in make_response
self.response_genres_subsections()
File "/opt/sopds/py/sopdscli.py", line 413, in response_genres_subsections
for (genre_id,genre_subsection,cnt) in self.opdsdb.getgenres_subsections(self.slice_value,self.cfg.DUBLICATES_SHOW,self.np):
File "/opt/sopds/py/sopdsdb.py", line 746, in getgenres_subsections
cursor.execute(sql)
File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute
self._handle_result(self._connection.cmd_query(stmt))
File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query
result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result
raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sopds.a.genre_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Please Войти or Create an account to join the conversation.

  • nesmit
  • nesmit's Avatar Topic Author
  • Offline
  • Новый участник
  • Новый участник
More
7 years 7 months ago #659 by nesmit
nesmit replied the topic: Ошибка "A server error occurred".
mysql> SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Please Войти or Create an account to join the conversation.

  • nesmit
  • nesmit's Avatar Topic Author
  • Offline
  • Новый участник
  • Новый участник
More
7 years 7 months ago #660 by mitshel
mitshel replied the topic: Ошибка "A server error occurred".

Please Войти or Create an account to join the conversation.

  • mitshel
  • mitshel's Avatar
  • Offline
  • Администратор
  • Администратор
More
Time to create page: 0.101 seconds