UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Non Bugs [NOTABUG] Banning Bug in 6.5.5 That Could Also Be A Bug In Version 7?

I discovered a banning bug in 6.5.5 that could also be a problem in version 7, if this feature hasn't been tested yet.

Here is the error message in the 6.5.5 bug:

Script: /home/virtual/site5/fst/var/www/html/ubbthreads/admin/doupdatebanlists.php - Line: 69
INSERT INTO w3t_Banned
VALUES
('68.186.88.5')
- Column count doesn't match value count at row 1

I would appreciate a fix for 6.5.5 as well as a test request here for version 7.

Hmm, that looks like your Banned table has a field in there that should no longer be there. That table used to have a couple fields, but in 6.5 it was reduced to 1 field. Definitely not an issue with 7.0.

Run this command from the SQL area:


The only field that should be there is B_Hostname. If there are more than that, the others need to be dropped. If you're not sure how to drop the field, just post here what fields came back from the query above.

This is what it is showing:

B_Uid tinyint(4) 0
B_Hostname varchar(60)
B_Reason tinyint(4) 0

Ok, you'll need to drop 2 of those fields.

alter table w3t_Banned
drop B_Uid,
drop B_Reason

Did it and it's working good now.

Thank you.