|
Joined: May 2009
Posts: 53
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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
journeyman
|
journeyman
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
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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
|
|
|
|
Joined: May 2009
Posts: 53
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
nope... i've done this many times just watch out if you are going from linux to windows or vice versa.. , Rick is faster on the draw than me
|
|
|
|
Joined: May 2009
Posts: 53
journeyman
|
journeyman
Joined: May 2009
Posts: 53 |
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
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
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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
journeyman
|
journeyman
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
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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
journeyman
|
journeyman
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
journeyman
|
journeyman
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
journeyman
|
journeyman
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
newbie
|
newbie
Joined: Jan 2010
Posts: 25 |
That alter table should actually be
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
journeyman
|
journeyman
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
journeyman
|
journeyman
Joined: May 2009
Posts: 53 |
Deleted all forums, used that query, created a new forum - but it still showed up as 134...
|
|
|
|
Joined: May 2009
Posts: 53
journeyman
|
journeyman
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
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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.
truncate table ubbt_FORUMS
delete from ubbt_FORUM_PERMISSIONS where FORUM_ID <> 'New Forum Template'
|
|
|
|
Joined: May 2009
Posts: 53
journeyman
|
journeyman
Joined: May 2009
Posts: 53 |
|
|
|
|
Joined: May 2009
Posts: 53
journeyman
|
journeyman
Joined: May 2009
Posts: 53 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
The one inside the includes directory. includes/config.inc.php
|
|
|
1 members (Ruben),
1,101
guests, and
206
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|