 | Vehicles Board Gone! |  |
 Posted: 07/22/2007 5:22 AM |
 |
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 5:00 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
 |
Hello NightRider,
I have given full admin ship to one of my friend for vehicles board and she said me to remove all the users and I went to PHPMyAdmin and i opened the database of vehicles and clicked empty on phpbb_users and than went to see the forum and it says This board has no forums
I than added 2 new users through the same phpbb_users by INSERT command but the message is same.
What I did wrong and what steps should be taken now  |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 5:34 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 2:00 PM
Location: Birmingham, UK.
|
|
|
|
|
|
Hey Abdul,
Did you make a backup before deleting the phpbb_users? 
It sounds to me like you completely removed the phpbb_users table in the database. Where I think all you needed to do was remove the user tables from within the phpbb_users table. If that makes sense... |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 2:10 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 9:00 AM
Location: St Pete, FL
|
|
|
|
|
|
You forgot to re-add the Anonymous record, so no one had the ability to view the forum. I added the record, plus I cleaned up your phpbb_user_groups and phpbb_groups tables to match your current memberlist...
You will also want to clean up your phpbb_posts, phpbb_posts_text, phpbb_topics, phpbb_privmsgs, phpbb_privmsgs_frequent, phpbb_privmsgs_text, phpbb_friends, phpbb_friends_comments, phpbb_friends_invite, phpbb_friends_pending, phpbb_ina_challenge_tracker, phpbb_ina_challenge_users, phpbb_ina_cheat_fix, phpbb_ina_favorites, phpbb_ina_hall_of_fame, phpbb_ina_last_game_played, phpbb_ina_rating_votes, phpbb_ina_scores, phpbb_ina_top_scores, phpbb_ina_trophy_comments, phpbb_marriage, phpbb_marriage_update, phpbb_medal_user, phpbb_refer_plus, phpbb_refer_top, phpbb_reputation, phpbb_reputation_text, phpbb_sessions, phpbb_sessions_keys, phpbb_thanks, phpbb_topics_watch, phpbb_vote_desc, phpbb_vote_results, phpbb_vote_voters, phpbb_xuinfo, phpbb_album, phpbb_album_comment, phpbb_album_rate, phpbb_attach_quota, phpbb_attachments, phpbb_attachments_desc, phpbb_banlist, phpbb_bookmarks, phpbb_cash_log, phpbb_chat_user_options, phpbb_chat_users, phpbb_confirm, and phpbb_contact_msgs tables...
In addition, you would want to correct the forum_posts, forum_topics, forum_last_post_id fields in the phpbb_forums table...
|
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 2:34 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 5:00 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Chris Powell wrote:
|
Hey Abdul,
Did you make a backup before deleting the phpbb_users?
It sounds to me like you completely removed the phpbb_users table in the database. Where I think all you needed to do was remove the user tables from within the phpbb_users table. If that makes sense...
|
Hi Chris,
No, I didn't know how to make backup of that each table. I removed/cleaned all the users in that group which created the problem... |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 2:37 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 5:00 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Nightrider wrote:
|
You forgot to re-add the Anonymous record, so no one had the ability to view the forum. I added the record, plus I cleaned up your phpbb_user_groups and phpbb_groups tables to match your current memberlist...
You will also want to clean up your phpbb_posts, phpbb_posts_text, phpbb_topics, phpbb_privmsgs, phpbb_privmsgs_frequent, phpbb_privmsgs_text, phpbb_friends, phpbb_friends_comments, phpbb_friends_invite, phpbb_friends_pending, phpbb_ina_challenge_tracker, phpbb_ina_challenge_users, phpbb_ina_cheat_fix, phpbb_ina_favorites, phpbb_ina_hall_of_fame, phpbb_ina_last_game_played, phpbb_ina_rating_votes, phpbb_ina_scores, phpbb_ina_top_scores, phpbb_ina_trophy_comments, phpbb_marriage, phpbb_marriage_update, phpbb_medal_user, phpbb_refer_plus, phpbb_refer_top, phpbb_reputation, phpbb_reputation_text, phpbb_sessions, phpbb_sessions_keys, phpbb_thanks, phpbb_topics_watch, phpbb_vote_desc, phpbb_vote_results, phpbb_vote_voters, phpbb_xuinfo, phpbb_album, phpbb_album_comment, phpbb_album_rate, phpbb_attach_quota, phpbb_attachments, phpbb_attachments_desc, phpbb_banlist, phpbb_bookmarks, phpbb_cash_log, phpbb_chat_user_options, phpbb_chat_users, phpbb_confirm, and phpbb_contact_msgs tables...
In addition, you would want to correct the forum_posts, forum_topics, forum_last_post_id fields in the phpbb_forums table...
|
I will correct it but currently I can't login through Founder or Admin ID. It says You have specified an incorrect or inactive username, or an invalid password.  |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 3:00 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 9:00 AM
Location: St Pete, FL
|
|
|
|
|
|
I can set the Founder password to blank so that you don't need to enter one to log in. But since that would be a major security risk, you would want to immediately go into Profile and create a new password. I can do that now if you're ready to log in and change the password...
 |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 3:05 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 5:00 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Yes, you can create a new password. I don't know how to go to profile without getting logged in. Without entering password for Founder username, it's not logging in still! |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 3:18 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 9:00 AM
Location: St Pete, FL
|
|
|
|
|
|
Go ahead and login to Founder without using a Password. Just leave the field blank. Then immediately go in and change the password in Profile...
I can see that you hardcoded the passwords, so you will have to correct the admin password once you successfully log in as Founder...
|
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 3:28 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 5:00 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Okay, I changed the password for Founder but now I went to change the password and after successfully changing it, the language of ACP panel and under that many tool's language is changed!
For example you go to General Admin, Configuration and many other tools having different language in it! |
|
|
|
|
| Back to Top |
|
|
| Re: Vehicles Board Gone! | |
| Posted: 07/22/2007 3:33 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 9:00 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, it was set to Albanian. I changed it to English...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
