Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 Registered (auduntvedt, ehm1, Mors, Thelockman, 1 invisible), 22 Guests and 22 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11702
Rick 7567
Ian 4107
Mark S 3983
ntdoc 3110
Sirdude 2041
jgeoff 1882
David Dreezer 1759
driv 1568
AllenAyres 1529
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
Topic Options
Rate This Topic
#213501 - 05/27/08 09:55 AM Importer missed all attachments
Gardener Offline
member

Registered: 06/06/06
Posts: 152
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: 11702
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: 152
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: 152
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

Recent Topics
Changing title of forum
by Baby Boomer
Today at 07:38 AM
Disable PM's for one group
by Musky
Today at 07:10 AM
SQL Error: Got error 28 from storage engine ?
by jgeoff
Yesterday at 05:03 PM
Stop All E-mail
by Mark S
Yesterday at 11:16 AM
Ability to Truncate a thread from any point at any time.
by Naz
Yesterday at 07:37 AM
Forum Stats
4025 Members
33 Forums
30880 Topics
156803 Posts

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