Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
6 registered (Fishtails, Gismo der erste, Ian, Mark S, PianoWorld, 1 invisible), 17 Guests and 22 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/15/08
Posts: 1
Top Posters (30 Days)
Ruben Rocha 165
Rick 116
Gizmo 105
Thelockman 61
driv 52
AllenAyres 35
ScriptKeeper 34
Mark S 30
Ian 30
phoebe 25
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
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: 11968
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
Eric Flyxe, mark_l_88@yahoo.com
Recent Topics
restricting a media tag to a single forum...
by bakerzdosen
Yesterday at 12:52 PM
Recover topics??
by femistyle
Yesterday at 12:22 PM
duplicate entries in viewmessage.php lang file (7.4.1)
by alnadabi
Yesterday at 05:54 AM
Order of variables in language files should be permanent
by alnadabi
Yesterday at 05:12 AM
How do I set Moderation Queue for an individual user?
by luket
11/20/08 11:28 AM
Forum Stats
4249 Members
33 Forums
30488 Topics
154659 Posts

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