Hello.
On the website http://wynalazki.andrej.edu.pl
I'm using version 3.2.21 stable. Until yesterday everything worked, did not I changed anything. Recent changes 25.07 (entries). Today, when I wanted to see the details of the event - I see it:
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 'ORDER BY RAND() LIMIT 1' at line 1 SQL=SELECT * FROM (SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, c.title as category, c.alias as category_alias, @num := @num + 1 AS position FROM #__content a JOIN (SELECT @num := 0) n LEFT JOIN #__categories as c ON c.id = a.catid WHERE a.state = 0 AND a.access = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-08-01 08:37:32') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-08-01 08:37:32') ORDER BY a.ordering) as sub WHERE sub.id != ORDER BY RAND() LIMIT 1
Please help <!-- s:?: --><img src="{SMILIES_PATH}/icon_question.gif" alt=":?:" title="Question" /><!-- s:?: -->
Regards
Andrzej