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!!!

[kronow]

ok how do i do this if i cant get access to admin rights !?

[Helter]

since I am not at home I dont have the files available to give you the exact names, but you need to open your db in phpmyadmin and open phpbb_config.
look for admins allowed and mods allowed. edit these numbers to reflect your current staff

[kronow]

ok but what if you cant get into admin?

[Helter]

phpmyadmin is a database tool. You should have a link to it in your webhost control panel. Not your forum control panel

[kronow]

ok i will talk to my host lol hes my mate so he will sort it and then what i need to do is what you said above?

[kronow]

error when installing prill

[Helter]

what is the error?

[kronow]

Critical Error!
message_die() was called multiple times.

--------------------------------------------------------------------------------
Error #1



--------------------------------------------------------------------------------
Error #2
Could not get contacts list:buddy

Line : 120
File : D:Clients8538yourdivision.comyourdivision.comphpbb2modscontactclass_contact.php
SQL : 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 = 93 AND c.disallow = 0 AND c.user_ignore = 0 ORDER BY u.username ASC

[kronow]

do you want to talk in chat might be easyer?

[kronow]

ok im in phpmyadmin on the cpannel and opened phpbb_users and phpbb_config

[XanaduRanch]

I have the same issue, that is, all users show a little red square and the words "Currently Banned" below their names. Permissions and acess to the board are not affected. Admin functions show no one to "unban". Even a brand new user who signs up and makes a post gets the infamous red square and is listed as banned.

I am not sure how or when it occurred, it had to do with an upgrade from an old version, around 2.0.17. We're running 2.0.22 and IM 1.4.0. I've tried to go back and upgrade from there but the problem persists.

I applied the SQL queries listed at the beginning of this thread. No effect. But I too can't find whatever it is in the DB that may be causing the portion of the .script that is printing that on screen to decide everyone is currently banned but can post anyway.

Was there ever a solution found to this?

Does anyone know exactly what php .script is displaying the information on the page there? If so I could perhaps look at the code and see what database entry is causing this.

Thanks.