Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
8 registered (carolinasoutdoor, David Dreezer, DougMM, Mark S, Ruben Rocha, Sirdude, 2 invisible), 22 Guests and 20 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/04/09
Posts: 1
Top Posters (30 Days)
Ruben Rocha 96
Rick 85
Mark S 74
Gizmo 50
Thelockman 49
driv 35
Sirdude 32
ntdoc 28
packlite 26
AllenAyres 26
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#213501 - 05/27/08 09:55 AM Importer missed all attachments
Gardener Offline
member

Registered: 06/06/06
Posts: 157
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
#213535 - 05/27/08 07:06 PM Re: Importer missed all attachments [Re: Gardener]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Is this the classic importer, the threads importer; or the UBB7 upgrade script?
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#213549 - 05/28/08 12:30 AM Re: Importer missed all attachments [Re: Gizmo]
Gardener Offline
member

Registered: 06/06/06
Posts: 157
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 06:53 AM Re: Importer missed all attachments [Re: Gardener]
Gardener Offline
member

Registered: 06/06/06
Posts: 157
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 06:54 AM)
_________________________
aka Olle Johansson

Top


Shout Box

Today's Birthdays
theregit
Recent Topics
7.4.1 show/hide category bug
by Seattlebrian
Today at 11:56 AM
7.4.2 Discussion
by Rick
Today at 10:21 AM
UBBCentral now running 7.4.2
by Rick
Today at 10:21 AM
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
01/07/09 10:00 PM
Forum Stats
4298 Members
33 Forums
30692 Topics
156037 Posts

Max Online: 978 @ 06/24/07 08:19 PM