Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 registered (Sirdude, 1 invisible), 20 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 08/11/06
Posts: 14
Top Posters (30 Days)
Ruben Rocha 103
Rick 81
Mark S 72
Thelockman 56
Gizmo 51
driv 35
ntdoc 32
Sirdude 30
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#3100 - 09/07/06 02: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
#3103 - 09/08/06 08:08 AM Re: importing the superuser account [Re: Nate]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3115 - 09/09/06 09:42 AM Re: importing the superuser account [Re: Rick]
Daryl Fawcett Offline
addict

Registered: 06/05/06
Posts: 445
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 12:44 PM Re: importing the superuser account [Re: Daryl Fawcett]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Your admin user should be #1. That's the placeholder user. Your main admin account should be user #2 in threads.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3161 - 09/11/06 12: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 12:19 PM Re: importing the superuser account [Re: Nate]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
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-'
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3167 - 09/11/06 01: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


Shout Box

Today's Birthdays
GOTMYSELFA...., smilinjack
Recent Topics
New members don't get access and are not displayed in the config panel
by Yomar
Today at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
Yesterday at 10:00 PM
Chaging the "max online" number and date
by wanted
Yesterday at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Yesterday at 10:26 AM
Custom island with sql connection
by Robje01
Yesterday at 09:13 AM
Forum Stats
4296 Members
33 Forums
30687 Topics
156016 Posts

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