Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Bjab), 25 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 469
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
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
#3100 - 09/07/06 05:42 PM importing the superuser account
Nate Offline
stranger
Registered: 09/06/06
Posts: 6

Why did the importer change my Superuser account when I imported all my data from threads 6.5? The account USER_LOGIN_NAME and USER_DISPLAY_NAME where changed to **DONOTDELETE** and the USER_MEMBERSHIP_LEVEL was "User".

I'm wondering why it did that and how to make that the functional Superuser account again. We have alot of posts under that user and would like it to not display Anonymous.

The last step of the installation process asked if I want to create a super user account or if I was going to import data from threads or classic. Was I supposed to create an account there?

Thanks.
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."
#3103 - 09/08/06 11:08 AM Re: importing the superuser account [Re: Nate]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
That's a bit strange. It sounds like your donotdelete user in your 6.5 forum was user number 2 when it should have been user number 1. The importer doesn't import user #1 at all. If you your old 6.5 database take a look and see what usernames you have for #1 and #2.
Top
#3115 - 09/09/06 12:42 PM Re: importing the superuser account [Re: Rick]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
How will this affect us as Administrators when we do the upgrade from 6.5.5 to version 7? My Admin number isn't #1.
Top
#3119 - 09/09/06 03:44 PM Re: importing the superuser account [Re: Daryl Fawcett]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Your admin user should be #1. That's the placeholder user. Your main admin account should be user #2 in threads.
Top
#3161 - 09/11/06 03:16 PM Re: importing the superuser account [Re: Rick]
Nate Offline
stranger
Registered: 09/06/06
Posts: 6
We are using version 6.5.1.1.

I just checked and we actually don't have a row associated with #1 in our w3t_Users table. I can't give any background on why we don't have a value in there.

Rick, could you please advise me on the best way to fix the problem? Seems like I could just enter the user **DONOTDELETE** in as U_Number #1.

Our main superuser account is #2 in w3t_Users as you said it should be.

Thanks
Top
#3162 - 09/11/06 03:19 PM Re: importing the superuser account [Re: Nate]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Nate, do you have a **DONOTDELETE** user anywhere in the database. Before adding a new one try this query:

select U_Number from w3t_Users where U_Username='**DONOTDELETE**'

If you get a result back, just change that to #1. That would be the easiest way.

If you don't get a result, then yes you'll want to add a **DONOTDELETE** user as user #1. You'll want to give it some sort of random password and assign the U_Groups field to '-4-'
Top
#3167 - 09/11/06 04:08 PM Re: importing the superuser account [Re: Rick]
Nate Offline
stranger
Registered: 09/06/06
Posts: 6
Rick, I added the **DONOTDELETE** user as id #1 and started the importer. Looks like it is working, our superuser account was maintained this time.

Thanks for your help.
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