Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Bjab), 25 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 469
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#2801 - 08/20/06 06:38 AM B3 classic import v4
Mtier Offline
journeyman
Registered: 07/09/06
Posts: 59
Loc: Germany, Mainz
Hi there,

another question. I´ve imported my classic board and i'm missing some posts in our new board - they are not displayed in the post-list when i look into a forum ("../forums/ubbthreads.php?ubb=postlist&Board=10&page=1"). The threads are imported correctly - I can see them searching them in PHP-MyAdmin by using:
Code:
SELECT * FROM `ubbt_TOPICS` WHERE TOPIC_SUBJECT like '%SomeTExt%'

and they are visible in the forum when I enter the direct link like "../forums/ubbthreads.php?ubb=showflat&Number=2846".

After i visited the direct links manually, the topic is displayed in the post-list.

The Thread and Post count match with the source from witch we imported the forum.
In the end of the post-list there are 2 - 3 blank pages (when i´m click on last post)

Do you have an idea why not all of our threads/posts are displayed?

Firstone
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#2819 - 08/21/06 08:48 PM Re: B3 classic import v4 [Re: Mtier]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Just a question,
could the missing posts be from a member that no loger exists?
(Deleted).

Just wondering if there is something unique
about those missing.

Are the missing posts across all forums?
Or just one?

Were they Months / years old,
or fairly new topics / posts?

Just trying to help get to the bottom of it?
Ive done an import but i didnt notice any
blanks but to be honnest i never looked?
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#2828 - 08/22/06 12:43 PM Re: B3 classic import v4 [Re: Mark S]
Mtier Offline
journeyman
Registered: 07/09/06
Posts: 59
Loc: Germany, Mainz
The missing posts are neither started from a deleted member nor really old posts. The latest answers are from april or may, that's not very old for me. It seems almost randomly for me which post is displayed and which not. I saw that some posts are missing while I was looking for 'sticky' posts - some were there and some not (not only sticky posts, after I saw that some of them are missing I've looked through the board and found some more missing posts).

I'll have a look if deleted users have answered in the missing posts, maybe this is something unique. But on the other hand I saw posts written by deleted members and they were displayed correctly. Sorry but I have no clear answer :/
Top
#2829 - 08/22/06 12:48 PM Re: B3 classic import v4 [Re: Mtier]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Can you check and see if the FORUM_ID field is empty on one of the ones that aren't showing up on the postlist page? It might be easiest if I can get admin access again to your site and if you can supply me with a couple of topic id's so I can do a few queries and see what's going on.
Top
#2830 - 08/22/06 01:51 PM Re: B3 classic import v4 [Re: Rick]
Mtier Offline
journeyman
Registered: 07/09/06
Posts: 59
Loc: Germany, Mainz
The field FORUM_ID is not null or empty frown

I´ll send you a pm with url etc wink


Edited by Firstone (08/22/06 01:58 PM)
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image