mysql Errore [1064] : EXECUTE
URI: index.php?mylang=italian
Message: 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 'link='index.php?option=com_content&task=blogsection§ionid=6'
AND published=' at line 2
SELECT id FROM elx_menu WHERE published='1'
link='index.php?option=com_content&task=blogsection§ionid=6'
AND published='1' AND ((language IS NULL) OR (language LIKE '%italian%')) LIMIT 0,1
mysql Errore [1054] : EXECUTE
URI: index.php?option=com_content&task=blogcategory§ionid=6&id=20&Itemid=0
Message: Unknown column 'f.ordering' in 'order clause'
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype,
cc.name AS category, cc.seotitle AS catseotitle, s.name AS section, s.seotitle AS secseotitle, g.name AS groups
FROM elx_content a
LEFT JOIN elx_categories cc ON cc.id = a.catid
LEFT JOIN elx_users u ON u.id = a.created_by
LEFT JOIN elx_content_rating v ON a.id = v.content_id
LEFT JOIN elx_sections s ON a.sectionid = s.id
LEFT JOIN elx_core_acl_aro_groups g ON a.access = g.group_id
WHERE a.state = '1'
AND UNIX_TIMESTAMP(a.publish_up) <= '1328452510'
AND (a.publish_down = '2060-01-01 00:00:00' OR UNIX_TIMESTAMP(a.publish_down) >= '1328452510')
AND a.access IN (29)
AND a.catid IN ( 20 )
AND s.access IN (29)
AND a.access IN (29)
AND cc.published = '1'
AND s.published = '1'
AND ((a.language LIKE '%italian%') OR (a.language IS NULL))
AND ((cc.language LIKE '%italian%') OR (cc.language IS NULL))
AND ((s.language LIKE '%italian%') OR (s.language IS NULL))
ORDER BY f.ordering
