4
Okay so I hated the nested posting thing of the od NewBB so I figured updating to NewBB2 would be the best thing as far as I could see, since I have been stalking these forums for a few days....
In any case I was a little confused with the installation instructions that came with it. So as per instructions:
I deleted the old Newbb folder.
Then I think things went a little wrong.
I uploaded all the newbb2 files into the directory for the site. Made sure permissions were correct.
Lauched site, and gave it a try. Well things looked good for a moment. New options were there under forum admin panel... etc. However whenever I try to add a new category I got database error. No further message just database error.
So I turned the site off and turned on debug mode sql.
Here are results of that..
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 = 'c2c21fe1472483645007894991131d7e'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
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 = 5))
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(report_id) as report_count FROM xoops_bb_report r, xoops_bb_posts p WHERE r.post_id= p.post_id AND report_result = 0
Error number: 1146
Error message: Table 'cubefile_xoop1.xoops_bb_report' doesn't exist
SELECT COUNT(report_id) as report_count FROM xoops_bb_report r, xoops_bb_posts p WHERE r.post_id= p.post_id AND report_result = 1
Error number: 1146
Error message: Table 'cubefile_xoop1.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'
One thing that may be of some relevance may be that the database is named cube. not xoops. If this is the cause of the problem, what files should I change in order to point to correct database.
I know what I am doing when it comes to HTML (dont we all) Flash, and design aspects. Its the coding that really causes me headaches. Can someone with a good amount more knowledge and expertise give me a clue as to what I did wrong / what happened. Or perhaps tell me how to fix it ?
