17
As Xantius, i fixed the first issue with memeĀ“s code,
i have the no news story problem too using XOOPS 2.0.6 (i not have wfsection installed)
grettings
this is a MySQL debug:
SELECT item, auto, image, auto_image, imagealign FROM xoops_spotlight WHERE sid = 1 LIMIT 0, 1
Error number: 1054
Error message: Unknown column 'imagealign' in 'field list'
SELECT storyid, uid, title, hometext, topicdisplay, topicalign, comments, bodytext, nohtml, nosmiley FROM xoops_stories WHERE storyid= LIMIT 0, 1
Error number: 1064
Error message: You have an error in your SQL syntax near 'LIMIT 0, 1' at line 1
SELECT uname, uid FROM xoops_users WHERE uid= LIMIT 0, 1
Error number: 1064
Error message: You have an error in your SQL syntax near 'LIMIT 0, 1' at line 1
SELECT storyid, hometext, bodytext, title, published, expired, counter, nohtml, nosmiley FROM xoops_stories WHERE published < 1081083004 AND published > 0 AND (expired = 0 OR expired > 1081083004) AND storyid != ORDER BY published DESC LIMIT 0, 5
Error number: 1064
Error message: You have an error in your SQL syntax near 'ORDER BY published DESC LIMIT 0, 5' at line 1
phpdebug:
Warning [PHP]: Invalid argument supplied for foreach() in file c:\phpdev5\www\3dmax\include\common.php line 99
(always put that , is not spotlight module related)
other problem i noticed is the admin panel not save the news block configuration options.