Everybody are banned!

[Dkangel]

Hi,

Recently, I lost my DB. After re-install the forum, and restore the DB, all users are with the Flag "Currently Banned", but the permissions are running ok...

In the Ban Control, nobody are listed, but the red flag is active in the topics and Profile.

What can I do?

[Dkangel]

Hi,

I soppose that the ban flag (red card) appear in all users of my forum, because I recover my DB using my MySQL Server on my Host Server (phpMyAdmin), and not using the tool à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€¦Ã¢â‚¬Å“Recover DBà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€š

[Teelk]

Your english is much better then my portuguese I'm sure. <img>

Run the following SQL using phpmyadmin. It will remove the red flags from all users and remove all users from the banlist.

Code: Select all

ALTER TABLE phpbb_users DROP user_warnings;ALTER TABLE phpbb_users ADD user_warnings smallint(5) default '0';DROP TABLE phpbb_banlist;CREATE TABLE phpbb_banlist (   ban_id mediumint(8) unsigned NOT NULL auto_increment,   ban_userid mediumint(8) NOT NULL default '0',   ban_ip varchar(8) NOT NULL default '',   ban_email varchar(255) default NULL,   PRIMARY KEY  (ban_id),   KEY ban_ip_user_id (ban_ip,ban_userid)) TYPE=MyISAM;

[Dkangel]

Hi, Teelk!

Tks of the help, but... :S

I submit this code using the phpMyAdin in the ACP, and not is happend. So, I submit this code using the phpMyAdmin of my MySQL Server... and not again...

Have more that can I do?

Tks again...

[Teelk]

Hmmm... try this in phpmyadmin...

Code: Select all

ALTER TABLE `phpbb_users`   DROP `user_warnings`;ALTER TABLE `phpbb_users` ADD `user_warnings` smallint(5) default '0';DROP TABLE `phpbb_banlist`;CREATE TABLE `phpbb_banlist` (   ban_id mediumint(8) unsigned NOT NULL auto_increment,   ban_userid mediumint(8) NOT NULL default '0',   ban_ip varchar(8) NOT NULL default '',   ban_email varchar(255) default NULL,   PRIMARY KEY  (ban_id),   KEY ban_ip_user_id (ban_ip,ban_userid)) TYPE=MyISAM;

[Dkangel]

Well, letÂÂÂ ´s go:
I use the phpMyAdmin of the à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€¦Ã¢â‚¬Å“General Adminà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€š

[Okki]

I think Teelk is saying, use the

phpMyAdmin of your MySQL Server

[Dkangel]

Ops! Hehehe...

Anyway, I run this code in my phpMyAdin of my SQL Server, and this is the result:

[code]ALTER TABLE `phpbb_users`  DROP `user_warnings` ;# Registro(s) afetado(s)]

But, I note that this tables (user_warnings and phpbb_banlist) alredy was empty!

Tks, again! hehehe

[Teelk]

The user_warnings column in the users table should be set to 0 for all users now... is this the case?

[Dkangel]

Yes, Teelk... this column is set to 0 for all...
<img>

[kronow]

help! i jsut did the transfer from phpbb to the intergraMOD then this.


It appears you have been banned from this website. If this is a mistake or you are not sure why you are banned, please contact the board administrator.

Board Administrator: Forum [at] yourdivision.com

You have been blocked because you have permission to be staff, but the admins did not grant you permission in the security panel.

[kronow]

also i get this error now

DEBUG MODE

SQL Error : 1146 Table 'yourdivision.phpbb_contact_list' doesn't exist

SELECT c.user_id, c.contact_id, c.alert, c.alert_status, c.display_name, u.username FROM phpbb_contact_list c, phpbb_users u WHERE u.user_id = c.contact_id AND c.user_id = -1 AND c.disallow = 0 AND c.user_ignore = 0 ORDER BY u.username ASC

Line : 120
File : class_contact.php

[kronow]

now this when i try log in

Email message was blank

DEBUG MODE

Line : 104
File : smtp.php

[kronow]

dont worry i got the toolkit mod to help me

[kronow]

and it didnt work :@ so anouying now!!!