I installed newbb 2.0 Beta 3 because I wanted to see what the polls in forums looked like. I however now get this error anytime I click on a forum. Any Ideas? PHP Debug found nothing.

I had newbb 2.0 Beta 2 on it successfully.

I installed it by doing the following things,

used unzip to open the XOOPS file package, navigated to the newbb-beta3 folder and did a cp -rf * /var/www/html/modules/newbb/


Here is the error I am getting.

An Error Occured
SELECT t.*, u.uname, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon FROM xoops_bb_topics t LEFT JOIN xoops_users u ON u.uid = t.topic_poster LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1084899731 OR t.topic_sticky=1) AND t.forum_id = 16 AND p.approved = 1 ORDER BY topic_sticky DESC, p.post_time DESC
If the page does not automatically reload, please click here

There are numerous database changes from beta 2 to beta 3. A full uninstallation and reinstallation is recommended.

A few questions then,

Why when I enter a forum is there no Poll option, but once I make a post, then I can add a poll? Is it possible to add the poll in the main forum or not?

When i try to add a poll I get the following error
"Errors
Could not store data in the database."
Any Ideas?

This is on a test server obviously, but on a production/live environment, re-installing XOOPS is not an option. If I can re-install the forums without wiping out the data then sure. The live environment is on newbb 1.0

Thanks,
Andy

Here is what I get when I turn PHP Debug on and try to add a poll:

Errors
Could not store data in the database.
Notice [PHP]: Undefined variable: question in file modules/newbb/polls.php line 112
Notice [PHP]: Undefined variable: description in file modules/newbb/polls.php line 113
Notice [PHP]: Undefined variable: display in file modules/newbb/polls.php line 120
Notice [PHP]: Undefined variable: weight in file modules/newbb/polls.php line 121
Notice [PHP]: Undefined variable: multiple in file modules/newbb/polls.php line 122
Notice [PHP]: Undefined variable: notify in file modules/newbb/polls.php line 123

There are some Table changes in the Beta 3 as Mithy says above, so you have to make the changes by compare the tables via phpadmin or uninstall and reinstall.

One question, is the xoopspoll module installed on your xoopssite? The Polloption of the newbb used the shared resources from the xoopspoll module: tables and classes.

The newbb on the Testsite is exactly the same newbb as the Beta 3 and PHP Debug is on.

Here's where I'm at right now.

I wiped the html folder, dropped the DB, created a new DB, Re-installed XOOPS 2.07. Installed newbb 2.0 beta 3, and installed poll module, the one that comes with xoops2.07.

I can post to the forums and everythingg there works great. I can make polls through the poll module just fine, they can be seen and everything.

However when I try to attached a poll to a forum post, when the forum page reloads I get an empty box with the vote button on the top of the post. I'll try and link a picture of it. When I go into edit the polls the Poll I created in the forums is not there, however there is a blank line poll, that's associated to nothing.

Any Ideas?