Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
6 registered (Ruben, Pilgrim, driv, Gizmo, Dunny, doug), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 12/20/03
Posts: 4423
Top Posters (30 Days)
Ruben 51
DennyP 24
Gizmo 23
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
SD 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
#179155 - 02/22/07 04:18 PM Any way to stop the renumbering of users when upgrading?
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
Hi,

We have lots of scripts that are linked to our ubb 6.5.2 forum user database. Now there's already lots of work in updating the queries, but the usernumbers have also been changed.

Anyone know of a hack or something else in the import proces to stop the renumbering proces? Or is there a table like ubbt_IMPORT_MAP which makes it easy for me to find out new usernumbers?
_________________________
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."
#179164 - 02/22/07 05:28 PM Re: Any way to stop the renumbering of users when upgrading? [Re: Yarp™]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
the import map should remember users, threads, and posts; should mind you..
_________________________
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
#179251 - 02/23/07 12:43 PM Re: Any way to stop the renumbering of users when upgrading? [Re: Gizmo]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
 Originally Posted By: Gizmo
the import map should remember users, threads, and posts; should mind you..


I just see a post translation table, not a "this old user# is now this new user#"-table.
_________________________
Top
#179255 - 02/23/07 12:54 PM Re: Any way to stop the renumbering of users when upgrading? [Re: Yarp™]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The table that maps the old usernumber to the new usernumber is just temporary and is deleted after the import is finished. You could comment out the portion that drops that table at the end so it's still there.

Around line 1658 of threads_import you'll see a line where it drops the table called memtemp.
Top
#179272 - 02/23/07 04:46 PM Re: Any way to stop the renumbering of users when upgrading? [Re: Rick]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
 Originally Posted By: Rick
Around line 1658 of threads_import you'll see a line where it drops the table called memtemp.


ok, found it. I see it drops a few more interesting tables for me \:\)
_________________________
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
10489 Members
36 Forums
33841 Topics
181703 Posts

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