Roger Cain
Trekkie
 Offline
Posts: 12
|
 |
« on: October 26, 2006, 10:08:38 PM » |
|
Searched through quite a few past pages, can't find anyone that made the dumb mistake I made.
Due to lots of spam, I attempted to delete all the registered spammers, and made the mistake of taking out my own user name. As I run this board, I have no idea how to get back into it. In the meantime, the porn and drug industry continues to load up my message board as I get the notice that "User name does not exist"
I am very basic at this, and could really use a blow by blow step on how to fix this stupid mistake. I looked through the Control Panel, but got lost quickly (yes I can still log into there).
I lost my last PHP board and our organization went four months without a board. I am currently using Fantastico, and it looks almost as plain as when I loaded it.
Thank you for any assistance you can provide.
Roger the dummy
|
|
|
|
|
Logged
|
|
|
|
|
RandyT
Guest
|
|
« Reply #1 on: October 26, 2006, 10:22:44 PM » |
|
OUCH !! This may be tricky but let`s see if we can figure out how to get you back into your board !
You may still have the default admin account , you could check in the mysql DB for it, usually in the users table. Let me know if this helps,
RandyT
|
|
|
|
|
Logged
|
|
|
|
Roger Cain
Trekkie
Offline
Posts: 12
|
|
« Reply #2 on: October 26, 2006, 10:27:59 PM » |
|
Under my Current Users, this is what it shows (Where the XXXX's are is my user name):
Current Users:
XXXXXX_smf1
Username:
Password:
now what?
|
|
|
|
|
Logged
|
|
|
|
|
RandyT
Guest
|
|
« Reply #3 on: October 26, 2006, 10:46:56 PM » |
|
Is that the database for your forums ? If so then that should be your username, of course usernames in databases are written twice like username_username , does it ring a bell to you ? Is it the one you had for the forum board ? If not then you may have an issue !
Hope this helps,
RandyT
|
|
|
|
|
Logged
|
|
|
|
Roger Cain
Trekkie
Offline
Posts: 12
|
|
« Reply #4 on: October 26, 2006, 10:50:46 PM » |
|
Yeah, I used the same user name and password for the forum board. In the "MySQL Account Maintenance" nothing shows my user name twice, just the XXXXX_smf1
I've got to crash now, but will check tomorrow for any help you or anyone else can offer. Thanks............Roger
|
|
|
|
|
Logged
|
|
|
|
|
RandyT
Guest
|
|
« Reply #5 on: October 26, 2006, 10:56:26 PM » |
|
|
|
|
|
|
Logged
|
|
|
|
Roger Cain
Trekkie
Offline
Posts: 12
|
|
« Reply #6 on: October 28, 2006, 12:08:22 AM » |
|
I accidentally deleted my admin account, what do I do?
Register again, and then run this query in phpMyAdmin:
UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'yourusername';
Replace smf_ with your database prefix and yourusername with the username you're using on the board. I reregistered as suggested, but didn't find the " phpMyAdmin " mentioned above in my CPanel. I tend to think I might just be better off to delete this board and try reloading it again? |
|
|
|
|
Logged
|
|
|
|
|
MichaelT
|
|
« Reply #7 on: October 28, 2006, 12:39:13 AM » |
|
I reregistered as suggested, but didn't find the " phpMyAdmin " mentioned above in my CPanel. I tend to think I might just be better off to delete this board and try reloading it again?
Hi Roger, You need to log into your Cpanel, then MySQL Databases and scroll to the bottom of the screen. You should see some colored text (in my Cpanel it is light blue/green) and click on that text. That will provide access to your phpMyAdmin. |
|
|
|
|
Logged
|
|
|
|
Roger Cain
Trekkie
Offline
Posts: 12
|
|
« Reply #8 on: October 28, 2006, 12:53:21 AM » |
|
Thank you, I somehow just didn't see it. I'm in there now looking around. I've found "smf_members" on the left side and am looking around in it, but haven't found the "SET ID_GROUP" yet.
|
|
|
|
|
Logged
|
|
|
|
|
JamesG
|
|
« Reply #9 on: October 28, 2006, 02:12:54 AM » |
|
can you register a new member on the forum?
since you deleted your username, i would guess re-registering would be easiest, then you can loginto pypmyadmin of your SMF database, and change a few settings to make you an admin!
|
|
|
|
|
Logged
|
|
|
|
|
DSB
|
|
« Reply #10 on: October 28, 2006, 04:21:44 AM » |
|
|
|
|
|
|
Logged
|
|
|
|
|
JamesG
|
|
« Reply #11 on: October 28, 2006, 11:41:37 AM » |
|
ok that seems pretty simple, if you have any trouble PM me on the forum and i'll do it for ya  , make sure to tell me which account you want to make administrator. |
|
|
|
|
Logged
|
|
|
|
Roger Cain
Trekkie
Offline
Posts: 12
|
|
« Reply #12 on: October 28, 2006, 11:52:41 AM » |
|
can you register a new member on the forum?
since you deleted your username, i would guess re-registering would be easiest, then you can loginto pypmyadmin of your SMF database, and change a few settings to make you an admin!
Yes, I'm able to re-register. I've tried to understand both your message and the link from DSB, and I'm feeling like a complete idiot. I have followed the link phpmyadmin and end up with two sections in the window. On the left side are half a dozen icons with my user name under it and as XXXXX_smf1 (35) showing the links below it. On the right side of the divider bar is MySQL - 4.1.21-standard (and on its right side) phpMyAdmin - 2.8.0.2 (with info under both) If I click on any of the links below my user name, most of them show ID_GROUP with a check box before them, but I don't see where anything will allow me to change a number to "1" Roger the idiot |
|
|
|
|
Logged
|
|
|
|
|
DSB
|
|
« Reply #13 on: October 28, 2006, 11:25:45 PM » |
|
On the left you should see a table ending in "_members". Click on that table link. After it loads, click the "browse" tab near the top on the right hand side. You should now see each user registered on the forum. You will notice there is a field labeled ID_GROUP in each row. You need to edit that value.
Look for the administrator or pick an account you want to make administrator, then click the pencil icon near the check box. The next screen will allow you to type in a new value into the ID_GROUP field for the specified user. Change the value to "1", then click "go" at the bottom of the page.
|
|
|
|
|
Logged
|
|
|
|
Roger Cain
Trekkie
Offline
Posts: 12
|
|
« Reply #14 on: October 29, 2006, 10:09:58 AM » |
|
DSB and everyone else who helped to walk me through this,
I'm back in, and appreciate it very much. I have book marked this page and will be very careful in the future on my deletes. Thank you again very much.
Roger
|
|
|
|
|
Logged
|
|
|
|
|
