1
pipwax
NewBB 2.0.2 (update issue)
  • 2006/9/29 21:02

  • pipwax

  • Not too shy to talk

  • Posts: 132

  • Since: 2005/9/12


I am using XOOPS version 2.0.13. I just upgraded the module NewBB 1.1 to version 2.0.2. everything works fine, until I try to view all topics. I get this,

++++++++++++++++++++++ error code +++++++++++++++++++++
An Error Occured
SELECT t.*, u.name, u.uname,u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id FROM xoo__bb_topics t LEFT JOIN xoo__users u ON u.uid = t.topic_poster LEFT JOIN xoo__bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoo__users u2 ON u2.uid = p.uid WHERE p.post_time > 1150924696 AND t.approved = 1 AND p.approved = 1 ORDER BY p.post_time DESC

++++++++++++++++++++end error code+++++++++++++++++++++++==
Can anyone help?

Thanks pipwax@hotmail.com




[edit by Bender] Subject slightly modified to separate threads with two identical subjects.
pipwax1@bellsouth.net
Quote:
To win in life one must be fluid like water, taking the shape needed to prevail


aspring IT Professional

2
Bender
Re: NEWBB 2,0.2
  • 2006/9/29 21:13

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


You did run the update script and you updated the module in "system - modules" right?

Try deleting the templates and regenerating them. (including deleting files in /templates_c folder except for index.html)
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

3
pipwax
Re: NEWBB 2.0.2
  • 2006/9/29 21:54

  • pipwax

  • Not too shy to talk

  • Posts: 132

  • Since: 2005/9/12


I did that with the templates folder. The only update script that I ran was in modules admin. I see the update file in the package, but how do you use it?
pipwax1@bellsouth.net
Quote:
To win in life one must be fluid like water, taking the shape needed to prevail


aspring IT Professional

4
gerasimos
Re: NEWBB 2.0.2
  • 2006/9/30 20:08

  • gerasimos

  • Not too shy to talk

  • Posts: 114

  • Since: 2005/4/28


Check the Posts_text table thur phpadmin... 99% its 'in use' check it and then click repair.

Then try again....

i hope this help u!!

5
Bender
Re: NewBB 2.0.2 (update issue)
  • 2006/9/30 21:11

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


Ok, one question first: Why do you want to go for newbb 2.02 and not cbb (3.05 at the moment) which is its successor?

----------------------------------------------

Quote:

pipwax wrote:
I did that with the templates folder. The only update script that I ran was in modules admin. I see the update file in the package, but how do you use it?



Tables have been changed so without running the update script you will have no luck.

Lets look at the readme:

Quote:
MUST-DOs to Enjoy NewBB 2.0.2 if you update from NewBB 1.0:
1. Delete all Files in your old newbb folder
2. Upload the New Files [b]and Run the Proper Update Script

3. Update the NewBB Module in the Moduleadmin
4. Set Permissions for the Categories and Forums
5. To make the Popup Menu work, make sure that the <{$xoops_module_header}> is included in your theme.html
6. Update the newbb templates[/b]


Lets have a look at the folders ...

There is a folder called \newbb\update and it includes the file newbb1_to_newbb2.php.

Checking with the readme:

Quote:
Update Scripts Along with the Package:
-- Newbb 1 to Newbb 2.0.2 ( newbb1_to_newbb2.php )
-- Newbb 2.0 RC1 to Newbb 2.0.2 ( newbb2rc1_to_newbb2.php )
-- Newbb 2.0 RC2 to Newbb 2.0.2 ( newbb2rc2_to_newbb2.php )
-- Newbb 2.0 RC3 to Newbb 2.0.2 ( newbb2rc3_to_newbb2.php )
-- Newbb Pro 1.03 to Newbb 2.0.2 ( newbbpro_to_newbb2.php )


Yep we should be good to go


So delete the old newbb files. Upload the new ones. In your browser use [size=x-small]http://www.yoursitesurl.xxx/modules/newbb/update/newbb2rc1_to_newbb2.php[/size].

Then continue with updating the module itself in modules admin as in step 3. Do the rest and you should be good to go.
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

Login

Who's Online

324 user(s) are online (199 user(s) are browsing Support Forums)


Members: 0


Guests: 324


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits