I've just installed newbb 2.02 on a XOOPS installation, upgrading from version 1 (which worked fine)
The install seemed to go ok, but now when I try to create a category it simply says 'Database Error' and returns to the 'new category' page. I found a very similar entry to this already on the forums, with the main reply being 'upgrade to CBB3.xx, however the version of XOOPS being used doesn't support this, and i'd rather try and figure out why i'm getting this problem at this point, in case i've done any major damage!
When I try to view the forum, everything is there (all icons etc) except any categories/forums, the space is just blank. I've documented below the debug messages.
I'm new at using xoops, and i'm just trying to update a site for someone.
It might be as simple as wrong file permissions or something, but i've no idea.
Using php debug I got the following messages on the actual forum page.
Warning [PHP]: Invalid argument supplied for foreach() in file modules/newbb/index.php line 90
Warning [PHP]: Invalid argument supplied for foreach() in file modules/newbb/index.php line 124
Notice [PHP]: Undefined variable: category_array in file modules/newbb/index.php line 158
Warning [PHP]: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag in file modules/newbb/index.php line 158
Notice [PHP]: Undefined variable: category_array in file modules/newbb/index.php line 160
Notice [PHP]: Undefined variable: display in file modules/newbb/index.php line 161
And on the forum admin menu page i got these messages.
Notice [PHP]: Undefined variable: row in file modules/newbb/class/report.php line 141
Notice [PHP]: Undefined variable: row in file modules/newbb/class/report.php line 141
Using MySQL Debug on the Forum admin page I get this:
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '00c3f4fd4382dc92061ef09f48c07784'
SELECT * FROM xoops_users WHERE uid=2
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '3') ORDER BY conf_order ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))
SELECT * FROM xoops_modules WHERE dirname = 'xoopspoll'
SELECT COUNT(*) AS total FROM xoops_bb_topics
SELECT COUNT(*) AS total FROM xoops_bb_posts
SELECT sum(topic_views) FROM xoops_bb_topics
SELECT COUNT(*) as report_count FROM xoops_bb_report WHERE report_result = 0
Error number: 1146
Error message: Table 'xoops_community.xoops_bb_report' doesn't exist
SELECT COUNT(*) as report_count FROM xoops_bb_report WHERE report_result = 1
Error number: 1146
Error message: Table 'xoops_community.xoops_bb_report' doesn't exist
SELECT p.*, t.post_text FROM xoops_bb_posts p LEFT JOIN xoops_bb_posts_text t ON p.post_id=t.post_id LEFT JOIN xoops_bb_topics tp ON tp.topic_id=p.topic_id WHERE p.approved='0'
Error number: 1054
Error message: Unknown column 'p.approved' in 'where clause'
SELECT t.* FROM xoops_bb_topics t LEFT JOIN xoops_bb_posts p ON p.topic_id=t.topic_id WHERE p.pid = 0 AND p.approved = 1 AND t.approved = 0
Error number: 1054
Error message: Unknown column 'p.approved' in 'where clause'
Hope someone can shed some light on this.
It may well be that I should just upgrade to CBB 1.16, but I just worry that i might have done something with this install that may effect any future install.
Info
XOOPS Version:2.0.13.2
Module Name/Version:newbb - 2.02
PHP Version: 5.0.5
MySQL Version: 4.1.20
Web Server Software (Apache/IIS/Other):Apache/2.2.2
Operating System:
Theme you are using:blue lagoon
Custom template: (Yes/No)
PHP Debug Messages: See above
MySQL Debug Messages: See above
Thanks,
Nick
