Email Address:
Password:

Lost your password?

This is the legacy website; please use the new website.
There appears to be a problem with this page.
dbSelect failed:DBD::mysql::st execute failed: Expression #1 of ORDER BY clause is not in SELECT list, references column 'articles.a.articleDate' which is not in SELECT list; this is incompatible with DISTINCT at /home/sites/siliconchip.com.au/docs/../content/cms/attachments/show.code line 3.
	Query: '
SELECT distinct enabled,subtitle,a.articleid,description,filename,articletitle,year(from_unixtime(articledate)) as year,monthname(from_unixtime(articledate)) as month 
FROM articles.allArticles as a, articles.attachments AS at 
WHERE a.articleid = at.articleid 
	AND year(from_unixtime(articledate)) = '2004' 
        AND year(from_unixtime(articledate)) < 1993 
	
	AND site = 5
	ORDER BY articledate,articleid desc
	'
Expression #1 of ORDER BY clause is not in SELECT list, references column 'articles.a.articleDate' which is not in SELECT list; this is incompatible with DISTINCT at /usr/local/lib/WebPubs/WP/Apache2/LNF.pm line 87.
Privacy Policy  |  Advertise  |  Contact Us

Copyright © 1996-2019 Silicon Chip Publications Pty Ltd All Rights Reserved