Previous Thread
Next Thread
Print Thread
Hop To
Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
I'm not the license holder for the particular forum we're wanting to overhaul, but I do hold a license for another forum, and I'm an administrator at the forum we do want to redo. That being said...

We're running Version: 7.2.2, and due to some crazily explosive drama and a general distaste for the users that have caused it, we're wanting to overhaul it. We'd like to find a way to keep the forum and styles in tact while completely resetting the user count.

The way we have our forum set up {as an RPG}, we also have a corresponding WIKI that lists the avatars to each corresponding member number. However, after the purge of many of the accounts, it leaves a lot of empty and unseemly space.

Is there a way to reset the user count so that, instead of a new user signing up and being #700-something, they could be user #3 or #4 instead? A way to reset all of that without deleting the original Admin account, without deleting styles or forums or post islands etc, and without deleting existing posts? Or is the ONLY way to totally restart the user count to do a total re-install?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You could delete users excluding the admin and reset the auto increment field, however all of the posts are not going to be visible, since they are tied to the actual userid, so without it, they just won't display.

You could delete the users through the control panel and that would tie all of the posts to the guest user, but not too sure if that's what you want?

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Hm.. Let me see if I can explain this better.. because I think we're on the same page but I'm not totally sure.

Users 3-400 have been deleted, as an example. We want someone else to be able to sign up and re-write the User 3 id space. #3, 3.jpg/3.png in the avatar database, etc. Is that what deleting everyone but the admin and resetting the auto-increment field would do?

We're not as worried about posts {we've archived everything in another spot} as we are about not having to totally redo the board.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Also, would the login names still show up as taken if deleting those accounts happened to be the case? As in..

Login name: abcde
password: 12345

Account's deleted, numbers are reset - would that free up Login name "abcde" again or would we have to figure out different/new login names?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Ok, so if you were to go through and delete users 3-400, then you'd run the following query:

ALTER TABLE ubbt_USERS set AUTO_INCREMENT=3

So the next user will get userid 3. As long as you delete everyone through the control panel, that will free up those user accounts.

I would recommend making a backup of your database first however wink

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
We're about to switch domain hosting, registration, and SQL databases anyway...

Reminds me - not part of this topic but what will happen if I transfer from one domain reg/host to another and create a new mysql database? Will the forums fail to work?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
When you transfer the domain to a new host, you'll need to transfer the database along with it and then update the config file to point at the new mysql database.

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
nope... i've done this many times wink

just watch out if you are going from linux to windows or vice versa..

facepalm , Rick is faster on the draw than me frown

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53

Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Did you transfer your stuff? Did you edit your config file if you change database name, pass, etc?

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
I got into the mySQL admin and was trying to export for the transfer. Then that happened.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You'll want to edit libs/mysql.inc.php and look for the $showerror ='0'; line and change it to $showerror='1'; so you can see the actual error.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Alright, got that done...

We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Access denied for user 'LightSide'@'208.109.181.224' (using password: YES)
SQL Error #: 1045
Query: Unable to connect to the database!

Please click back to return to the previous page.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
I think I know what the issue is - it's the password. I changed it to something else.

EDIT:

I'm not sure how to go about changing which password it asks for.

Last edited by Realta Gaoth; 01/08/2010 10:40 PM.
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
If you need to change it for UBB.threads, then you're going to need to edit the includes/config.inc.php file. You'll see the settings for the database at the top.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Alright, I've got the forum fixed, back and up and running again.

Now I have to figure out how to transfer this database.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Alright, when I go to run the Query, I get this:

Control panel message
ALTER TABLE ubbt_USERS set AUTO_INCREMENT=3

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set AUTO_INCREMENT=3' at line 1

» Return

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Also, I went into the Prune Topics and set the dates to "older than Jan 7 2010" and "newer than March 7 2008" - and it said that all had been pruned, but there are still a number of topics laying about...

And now when I try to do it again to delete everything, it says that nothing exists that fits the query I submitted.

Is there any way to mass-delete all of the posts other than the pruning option?

Last edited by Realta Gaoth; 01/09/2010 12:20 AM.
Joined: Jan 2010
Posts: 25
J
newbie
newbie
J Offline
Joined: Jan 2010
Posts: 25
That alter table should actually be

SQL Query
alter table ubbt_USERS AUTO_INCREMENT=3

You will need to use the prune topics to clean out the tables properly, however if it's not working, open up a support ticket with the following info and one of us will manually do it.

In your support ticket you'll need to supply the following info:

Forum URL
Admin Login Info

and the date range that of topics/posts that you want deleted.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Would the same command work if we wanted to reset the forum number?

We deleted all forums and their contents to get rid of the posts, but when we make a new forum instead of starting at "1" it starts at "132" {in the "Keyword" column}

Would the Query be

alter table ubbt_FORUMS AUTO_INCREMENT=1 ?

Joined: Jan 2010
Posts: 34
newbie
newbie
Joined: Jan 2010
Posts: 34
Yes, that query will work for the forums table as well.

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Deleted all forums, used that query, created a new forum - but it still showed up as 134... frown

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
I tried running it again today, just to see if it would work, but now when I go to create a new forum I get this:

Control panel message
insert into ubbt_FORUM_PERMISSIONS values ( '1' , '134' , '1' , '1' , '1' )

Duplicate entry '1-134' for key 1

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
also, when I go into "forum settings" it says that I don't have any forums, but the test forums I created show up on the forum list. >_<

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It sounds like maybe some tables aren't emptied. Run these queries to make sure the proper tables are empty, the first one should also reset the auto_increment.

SQL Query
truncate table ubbt_FORUMS

SQL Query
delete from ubbt_FORUM_PERMISSIONS where FORUM_ID <> 'New Forum Template'

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
AWESOME, thank you!

Joined: May 2009
Posts: 53
R
journeyman
journeyman
R Offline
Joined: May 2009
Posts: 53
Originally Posted by Rick
When you transfer the domain to a new host, you'll need to transfer the database along with it and then update the config file to point at the new mysql database.

When you refer to this, which config file do you mean? smile

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
The one inside the includes directory. includes/config.inc.php


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 458 guests, and 91 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)