SQL Error when showing contact list

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chrismc
    Member
    • Jun 2019
    • 47

    SQL Error when showing contact list

    Hi, when opening the contact list EspoCRM shows an error in the upper part. Looking into the logs I find:

    [2019-08-13 18:00:14] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 10' at line 1; GET /espo-crm/api/v1/Contact?select=salutationName%2CfirstName%2ClastNa me%2Cname&maxSize=10&offset=0&orderBy=users&order= desc&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5 Bvalue%5D=all [] []

    Any ideas? Everything seems to be correct in the GUI
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hi,
    Sometimes it may occurs when your browser's cache is stucked. Just clear the cache via the advanced settings of your browser. Do not try to use Ctrl + F5. It will not help.

    Comment

    • chrismc
      Member
      • Jun 2019
      • 47

      #3
      Thanks for your reply. Unfortunately it does not help. Cleared browser cache, used other browser. Still same error. Any other ideas?

      Comment

      • Maximus
        Senior Member
        • Nov 2018
        • 2731

        #4
        Do you use any seved filter?

        Comment

        Working...