bibsonomy / BibSonomy / issues / #2732 - Some SQL Statements are not compatible with MySQL 5.7 — Bitbucket

Issue #2732 open

Daniel Zoller created an issue 2016-12-13

Please adapt these queries.

Here is a list:

getBibTexByConceptForUser
getBibTexByConceptForGroup
getSyncBibTex
getBookmarkByConceptForUser
getBookmarkByConceptForGroup
getAllConcepts
updateReviewRatingsCacheDelete

Comments (4)

Daniel Zoller reporter
- changed status to open
- 2016-12-13T20:20:42+00:00
Andreas Hotho
How about using MariaDB insteat of MySql?
- 2016-12-13T20:38:53+00:00
Daniel Zoller reporter
MariaDB has the same problems
- 2016-12-13T20:40:12+00:00

Daniel Zoller reporter

Current workaround is to set the SQL Mode to:

sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

2016-12-13T20:41:54+00:00

Log in to comment

Assignee: –

Type: bug

Priority: major

Status: open

Component: database

Milestone: –

Version: 3.7.2

Votes: 0

Watchers: 1

Jira: the preferred issue tracker for Bitbucket. Join the team!