Just can't stay away
Posted on: 2009/2/10 19:36
XOOPS Version: XOOPS 2.3.1
PHP Version: 5.2.5
MySQL Version: 4.1.22-standard
Server API Version: apache2handler
OS Version: Linux
New categories aren't shown in admin or public side. The sql appears to not be given the full list of forums to show..
SELECT `forum_id` FROM `xxxx_bb_forums` WHERE (parent_forum = '0' AND cat_id IN (1) AND forum_id IN (1))
I would have through that 'IN(1)' should be IN '(1,2,3)' for this to function. I looked at the permissions section and group_permissions table and these seem ok.
I had the problem with posting on my local testing site, which I think also returned the "Array( )" problem when debuging the forum, and when I turned on the portal debuging I found that there was an SQL error, and that there was a column in the table that he couldn't find.
I think it was "poster_ip" in "xoops_bb_posts".
Then I noticed that the ip info for all posts when browsing the forum was 0.0.0.0.
I renamed it and then it worked... I really don't know how that happened.
 => post text insert error