Announcement

Collapse
No announcement yet.

Database error after upgrade to 5.1.1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error after upgrade to 5.1.1

    Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 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 ‘ASC LIMIT 0, 50’ at line 1, Code: 42000 URL: /api/v1/Task?maxSize=50&offset=0&sortBy=type&asc=true&wher e%5B0%5D%5Btype%5D=bool&where%5B0%5D%5Bvalue%5D%5B %5D=onlyMy&where%5B1%5D%5Btype%5D=primary&where%5B 1%5D%5Bvalue%5D=actual [] []

    This error occurs when trying to load "Tasks". Any ideas how to fix it? Is this a database problem?

  • #2
    Oh never mind, the problem was database table collations, changed everything to utf8_general_ci and it's working now.

    Comment

    Working...
    X