Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (A-GATE, Jake), 31 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/09/11
Posts: 140
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
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
#213501 - 05/27/08 12:55 PM Importer missed all attachments
Gardener Offline
member
Registered: 06/06/06
Posts: 189
Loc: Sweden
For some reason the importer seems to have skipped all attachments.

Looking at the code it seems to be a real problem fixing this afterwards as well. Since the temporary tables are removed.

Each post seems to get a new post id during the import, and the only place the connection between this new id and the file items was in the filetemp table.

Am I totally screwed here? I guess I could write a script which compares data between post tables and tries to find the new id of the post. But it seems like a bit of work.
_________________________
aka Olle Johansson
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."
#213535 - 05/27/08 10:06 PM Re: Importer missed all attachments [Re: Gardener]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Is this the classic importer, the threads importer; or the UBB7 upgrade script?
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#213549 - 05/28/08 03:30 AM Re: Importer missed all attachments [Re: Gizmo]
Gardener Offline
member
Registered: 06/06/06
Posts: 189
Loc: Sweden
Bugger me, I forgot to mention it. Sorry about that.

It was an upgrade from UBB.threads 6.1.1 originally (then import from v6.5.5).

The data seems fine in the v6.5.5 tables.
_________________________
aka Olle Johansson
Top
#213572 - 05/28/08 09:53 AM Re: Importer missed all attachments [Re: Gardener]
Gardener Offline
member
Registered: 06/06/06
Posts: 189
Loc: Sweden
Ah! There's an ubbt_IMPORT_MAP table. Seems to contain the data I need. I realized it when I wondered how redirects from old UBB.threads post links were done.

Shouldn't be too hard to fix now.

Although, if someone has a script ready, that would of course be much better.


Edited by Gardener (05/28/08 09:54 AM)
_________________________
aka Olle Johansson
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