Public Forums 71,145 posts

[hadi yaz Friend hadi yazJoin date: December 2013Posts: 8Downloads:0Uploads:0 Thanks: 2]

#179806

Help me please. error in my My frontpage:
………………
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 ‘2,12,8,9,10,11,13,14,15,16,17) GROUP BY a.id, a.title, a.alias, a.title_alias, a’ at line 15 SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ‘ ‘ THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM…….

[Sherlock Friend SherlockJoin date: September 2014Posts: 11453Downloads:0Uploads:88 Thanks: 221 Thanked: 2478 times in 2162 posts]

#463816

Hi hadiyaz,

it’s hard to help you out just by seeing this error message, Can you let me know what you did right before this error popped up.

[hadi yaz Friend hadi yazJoin date: December 2013Posts: 8Downloads:0Uploads:0 Thanks: 2]

#463887

Installed template in ( Joomla 2.5.6 ) wasn’t problem..
and after select: main menu > category blog > select all articles
no shown joomla articles or k2 items
only show this error messages.

not: intalled template quick installation. After shown all demo windows. no problem.. everything is OK..

what is different?
if problem was about server, didn’t work quick installation template demo site… demo site is working.

[Sherlock Friend SherlockJoin date: September 2014Posts: 11453Downloads:0Uploads:88 Thanks: 221 Thanked: 2478 times in 2162 posts]

#463979

<em>@hadiyaz 333961 wrote:</em><blockquote>Installed template in ( Joomla 2.5.6 ) wasn’t problem..
and after select: main menu > category blog > select all articles
no shown joomla articles or k2 items
only show this error messages.

not: intalled template quick installation. After shown all demo windows. no problem.. everything is OK..

what is different?
if problem was about server, didn’t work quick installation template demo site… demo site is working.</blockquote>

Did you mean it’s only occurring when you installed a quickstart package ? Installed template no problem ? Can you try to install a fresh qs package again to see if it occurring one more time ?

[Author]

Posts