Ошибка "A server error occurred".
При попытке выбрать какой нибудь жанр:
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
-
Topic Author
- Offline
- Новый участник
-
- Posts: 9
Please Войти or Create an account to join the conversation.
- nesmit
-
Topic Author
- Offline
- Новый участник
-
- Posts: 9
Please Войти or Create an account to join the conversation.
- mitshel
-
- Offline
- Администратор
-
- Posts: 297
- Karma: 8