Viewing 15 posts - 1 through 15 (of 23 total)
  • Author
    Posts
  • palos Friend
    #1066999

    Hi,
    My clients are in trouble as they are getting many times the "MySQL Error 1064: You have an error in your SQL syntax". Moreover there are annoying issues when frontend editing. Editor header disappears and sometimes they are unable to save, etc. It seems to be some jquery error imho. 🙁

    Saguaros Moderator
    #1067229

    Hi,

    You can share the credentials of site which you have issue with, and clarify the steps to replicate issue so I will take a look.

    Regards

    palos Friend
    #1067270
    This reply has been marked as private.
    Saguaros Moderator
    #1067382

    Hi,

    I can access backend of your site, try to navigate around but can’t see that error message. Could you clarify the steps to replicate issue?

    palos Friend
    #1068366

    Hi,
    Just try to create and edit an item (K2) via frontend and it sometimes (more often than sometimes) suffering by the issue. JCE is the active editor but the issue is on with the basic ones too.

    Saguaros Moderator
    #1068484
    This reply has been marked as private.
    palos Friend
    #1074009

    Hi Saguaros,
    Just set it to English… sorry for the delay!
    Error screenshot attached (it is on the front page right now other pages looks good right now)
    Thank you!


    1. Screenshot_1064_error
    palos Friend
    #1074015

    So interesting… the error remains if I delete browser cache and push a Full reload but error gone when opening in Chrome incognito window. :/

    Saguaros Moderator
    #1074149

    So it may due to the cache & cookies of your browser, pls try to delete them all first.

    palos Friend
    #1074216

    It could be browser caching of course but the editors (people) are continuously suffering from this issue.
    I was able to reproduce the error and it is browser independent (ff, chrome).
    Only the HOME page is involved.
    Only happens with NEX template (I use many of your templates/quickstarts).
    It happens with different workstations on different network.
    It happens accidentally.
    It can be good again in approx. 30-60 minutes.

    palos Friend
    #1074218

    Some more investigations after deleting cache and cookies:

    1. login (frontend)
    2. click HOME
    3. 1064 error

    Tested in chrome and in incognito mode!

    palos Friend
    #1074232

    Well, I have GOT IT!
    No Browser cache.
    No K2.
    Nor any theoretical 3rd party extension.

    It is the: JA News Featured module at top-home1
    Please help me to get rid this annoying issue what exists since months… year(s)!

    palos Friend
    #1074237
    This reply has been marked as private.
    Saguaros Moderator
    #1074467

    Did you try this suggestion? https://www.joomlart.com/forums/topic/ja-news-featured-and-k2-2-7-1/

    If it still doesn’t work, you can share the FTP account also.

    Saguaros Moderator
    #1074471

    I updated for you in the file mod_janews_featured/helpers/adapter/k2.php

    This line was wrong $aid = $user->get(‘aid’);
    The correct one is $aid = $user->get(‘aid’) ? $user->get(‘aid’) : 1;


    1. 1213
Viewing 15 posts - 1 through 15 (of 23 total)

This topic contains 22 replies, has 2 voices, and was last updated by  Saguaros 7 years ago.

We moved to new unified forum. Please post all new support queries in our New Forum