Thread

Hi,
Peace!

Following is what has started to appear today all of a sudden. This is only occurring on Home page (/index.php) rest of the site is running perfectly. Any immediate help would be highly appreciated.

Error Number: 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 ‘ascc’ at line 10

SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_channel_titles AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (10160,339,7591,7712,10177) ORDER BY rand(), t.entry_id ascc

Filename: modules/channel/mod.channel.php

Line Number: 298

Hey there Ahmed,

Thank you for your question, it looks like there may be some errors in your template code. Are you using any SQL in your template? I believe that in the SQL you mean “asc” and not “ascc”.

Can you double check that and let me know?

Thank you,

Dear Eckert,

Thank you for your response. I am not sure why and how but the error is gone as it had appeared without any reason three days ago. The good news is that all is perfect and working fine. However, my new concern is that the response came very late. Can we expect quick response in issues as critical as this in future?

Anyways, thank you for showing up. You can close the thread.

Love, light and peace.

Hello Ahmed,

I am glad to hear it!

I am sorry that you feel the wait time was too long. Our support policy is to respond in 2 business days. Since we do not work weekends and you filed your case on Friday the 14th, we met the standards of that policy. So we were not actually late! 😊

Please be watching the blog for news about ExpressionEngine Support!

Have a wonderful week!

Cheers,