XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Old Threads Disappeared after newbb 2.0 install
Register
1
hightyde
Old Threads Disappeared after newbb 2.0 install

  • 2005/1/5 20:00

  • hightyde

  • Just popping in

  • Posts: 86

  • Since: 2003/7/11


I recently upgraded to newbb 2.0 and have enjoyed the new features. Kudos to the devs.

Just notice today that all our old threads have disappeared. I can neither access them thread the forum pagination or via the site search function.

Seems only threads with most recent posts within the last 100 days or so is still kept, the rest can't be found even when I ask the forum to display all threads from last year, or even the beginning.

Any help would be much appreciated.
2
hightyde
Re: Old Threads Disappeared

  • 2005/1/6 9:29

  • hightyde

  • Just popping in

  • Posts: 86

  • Since: 2003/7/11


I've check the MySQL table and all the old posts are still in the database, which is a great relief.

I've also reset the newbb 2.0 module and yet it still doesn't display my old posts (again, even when I set the display mode to show all posts "from last year" or "from the beginning").

I had a link to an old thread in another part of my site and when I click it it tells me that "You don't have the right to view this topic" then it displays the following error message before returning me to the main forum index.php page:

Quote:
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 x_bb_topics t LEFT JOIN x_users u ON u.uid = t.topic_poster LEFT JOIN x_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN x_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1096348921 OR t.topic_sticky=1) AND t.forum_id = AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC

If the page does not automatically reload, please click here


Now if I was not signin first and click on that link, I would only get a "You don't have the right to view this topic" followed by "You don't have the righ to access this forum." Then it returns me to the forum index.php page.

Please can anyone help me. Thanks in advance.
3
irmtfan
Re: Old Threads Disappeared

  • 2005/1/6 10:25

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


do you run the updater?
newbb\update\newbb1_to_newbb2.php
4
hightyde
Re: Old Threads Disappeared

  • 2005/1/7 7:53

  • hightyde

  • Just popping in

  • Posts: 86

  • Since: 2003/7/11


Quote:
by irmtfan on 2005/1/6 5:25:40

do you run the updater?
newbb\update\newbb1_to_newbb2.php

Thank you very much for your reply, irmtfan. No I did not run the updater.

What I did was...
(1) deactivate the old newbb module (but didn't uninstall, in order to keep the existing forum posts),
(2) rename the old newbb file folder,
(3) upload the new newbb file folder, and
(4) installed/activated the new newbb module.

I have a feeling I messed up, didn't I?

Is it too late to run the update script?
5
Anonymous
Re: Old Threads Disappeared

  • 2005/1/7 16:22

  • Anonymous

  • Posts: 0

  • Since:


Quote:

hightyde wrote:
Quote:
by irmtfan on 2005/1/6 5:25:40

do you run the updater?
newbb\update\newbb1_to_newbb2.php

Thank you very much for your reply, irmtfan. No I did not run the updater.

What I did was...
(1) deactivate the old newbb module (but didn't uninstall, in order to keep the existing forum posts),
(2) rename the old newbb file folder,
(3) upload the new newbb file folder, and
(4) installed/activated the new newbb module.

I have a feeling I messed up, didn't I?

Is it too late to run the update script?


No it`s not to late to run the updater, after this be sure the templates are also update with the new onces and to have <{$xoops_module_header}> in yout theme.html. All this should do the trick.
6
hightyde
Re: Old Threads Disappeared

  • 2005/1/7 22:11

  • hightyde

  • Just popping in

  • Posts: 86

  • Since: 2003/7/11


Quote:

Predator wrote:
No it`s not to late to run the updater, after this be sure the templates are also update with the new onces and to have <{$xoops_module_header}> in yout theme.html. All this should do the trick.

Thanks Predator, I run the updater and here are the various screen messages:

Message screen from step 1 of the updater...
Quote:
Create new Tables
Could not create x_bb_archive
Could not create x_bb_attachments
Could not create x_bb_digest
Could not create x_bb_online
Could not create x_bb_report
Could not create x_bb_votedata


I check my MySQL tables and these tables are all already there. In particular, I notice the already existing x_bb_archive table has a lot of the old threads/posts I want members to still be able to access through search & forum view.

And here is the message screen from step 2 of the updater...
Quote:
Change old Tables
Could not add field in x_bb_categories
Could not add field in x_bb_categories
Change field in x_bb_categories
Could not add field in x_bb_categories
Could not add field in x_bb_categories
Could not add field in x_bb_categories
Could not drop field in x_bb_forums
Could not drop field in x_bb_forums
Could not drop field in x_bb_forums
Could not add field in x_bb_forums
Change field in x_bb_forums
Change field in x_bb_forums
Change field in x_bb_forums
Change field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_forums
Could not add field in x_bb_posts
Change field in x_bb_posts
Could not change field in x_bb_posts
Could not change field in x_bb_posts
Could not add field in x_bb_posts
OK exist just to be sure x_bb_posts
OK exist just to be sure x_bb_posts
Could not add field in x_bb_posts
Could not add field in x_bb_posts
Could not add field in x_bb_posts
Could not add field in x_bb_posts
Could not add field in x_bb_posts_text
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics
Could not add field in x_bb_topics


And message screen from step 3 of the updater...
Quote:
Drop deprecated Tables
Could not drop x_bb_forum_access
Could not drop x_bb_forum_mods


Finally, message screen from final step of updater...
Quote:
Update finished
The update was successfull, please set the permissions for each Category and Forum in the Adminsection new.

Moderators have to be added new.

Enjoy the Newbb 2.0


When I finish going through the updater, my forum remains the same -- I still can't access any of my older threads/posts.
7
Anonymous
Re: Old Threads Disappeared

  • 2005/1/7 22:21

  • Anonymous

  • Posts: 0

  • Since:


Did you set the permission for each category new and for every forum?

If still trouble send me a PM with your URL and maybe a temp access, i´m tomorrow the whole day online.
8
hightyde
Re: Old Threads Disappeared

  • 2005/1/7 22:35

  • hightyde

  • Just popping in

  • Posts: 86

  • Since: 2003/7/11


Quote:

Predator wrote:
Did you set the permission for each category new and for every forum?

If still trouble send me a PM with your URL and maybe a temp access, i´m tomorrow the whole day online.


Yes, I've re-check the permissions I set for each category & each forum.

The problem is all of us (admin, member, visitor) can only view some of the thread in each forum, but not all of the threads in each forum -- particularly the older threads. So I'm assuming that is not a permission issue.

The forum search function also brings up results only from these newer forum threads.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

333 user(s) are online (291 user(s) are browsing Support Forums)

Members: 0

Guests: 333

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