I was getting this error when I attempted to acknowledge a trigger.
* Error in query [SELECT s.* FROM scripts s WHERE (s.scriptid div 100000000000000) in (0) AND (s.groupid IN (1,2,5,3,4,0)) AND (s.usrgrpid IN (2,0)) ORDER BY scriptid ASC] [Unknown column 's.groupid' in 'where clause']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/apache/htdocs/zabbix/include/db.inc.php:490]
I added the 2 columns and the error went away. I upgraded from 1.4.5 to 1.5.2 and ran the upgrade db script for mysql.
* Error in query [SELECT s.* FROM scripts s WHERE (s.scriptid div 100000000000000) in (0) AND (s.groupid IN (1,2,5,3,4,0)) AND (s.usrgrpid IN (2,0)) ORDER BY scriptid ASC] [Unknown column 's.groupid' in 'where clause']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/apache/htdocs/zabbix/include/db.inc.php:490]
I added the 2 columns and the error went away. I upgraded from 1.4.5 to 1.5.2 and ran the upgrade db script for mysql.