Announcement

Collapse
No announcement yet.

SQL Error when showing contact list

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

  • 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

  • #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


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

      Comment


      • #4
        Do you use any seved filter?

        Comment

        Working...
        X