Okay
  Public Ticket #176682
Sql Error
Closed

Comments

  • Daithí started the conversation
    I am receiving an SQL error for the module when in this position. I have another module further down the page that functions ok?!
  • Daithí replied

    This is the error:

     

    fetch 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 ') GROUP BY comments.itemID' at line 11 SQL=SELECT content.id AS id, COUNT(comments.itemID) AS count FROM h8yx0_k2_items AS content LEFT JOIN h8yx0_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;

  •  948
    Max replied

    Hi, I don't see this sql is connected to the slider. Are you sure it's related? Maybe it's there even if the slider don't published. 

     

  • [deleted] replied

    I have this same problem: betasite.calvertstreetgroup.com

    It worked when i installed the "quickstart" for the template it was in, but when I went to edit slides, this error popped up. I uninstalled and reinstalled to no avail. Running Joomla 2.5.16

  •  948
    Max replied

    Hi Chris. Please open a private ticket, give us joomla access and we'll check the issue more closely.