After updating from 1.7.1 to 1.8.1 I encounter many errors.
Clicking polls results in this:
256 - An SQL error has occurred. Please see error.log for details. /system/databases/mysql.class.php line 260
Mo 09 Apr 2012 23:24:26 CEST - 1054: Unknown column 'created' in 'field list'. SQL in question: SELECT *,UNIX_TIMESTAMP(created) AS unixdate FROM gl_polltopics WHERE 1=1
Mo 09 Apr 2012 23:24:49 CEST - 1054: Unknown column 'created' in 'field list'. SQL in question: SELECT *,UNIX_TIMESTAMP(created) AS unixdate FROM gl_polltopics WHERE 1=1
Clicking a topic results in this:
Mo 09 Apr 2012 23:33:09 CEST - 1052: Column 'date' in field list is ambiguous. SQL in question: SELECT DISTINCT COUNT(*) AS dups, type, title, sid, max(date) AS lastdate FROM gl_comments, gl_polltopics pt WHERE type = 'polls' AND (pt.pid = sid) AND (pt.commentcode >= 0) AND (date >= (DATE_SUB(NOW(), INTERVAL 1209600 SECOND))) GROUP BY sid,type, title, sid ORDER BY 5 DESC LIMIT 15
It is php 5.3