|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
|
Member
Joined: Mar 2000
Posts: 180 |
As the title says, I'm wanting to search & ban a block of IPs via my control panel, but I guess I'm not using the correct variable. I *thought* it was xxx.xxx.xxx.%, or xxx.xxx.xxx.*, but it ain't working...I'm on 6.5
Any help is appreciated!
|
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
|
Member
Joined: Mar 2000
Posts: 180 |
Ok, I see they still use the "%" wildcard, but I'm getting this error when I ban an IP: Script: /home/yenko/public_html/ubbthreads/admin/doupdatebanlists.php <br />Line#: 69 <br />SQL Error: Column count doesn't match value count at row 1 <br />SQL Error #: 1136 <br />Query: INSERT INTO w3t_Banned VALUES ('24.151.173.69')
|
|
|
|
|
Joined: Sep 2003
Posts: 488
Code Monkey
|
|
Code Monkey
Joined: Sep 2003
Posts: 488 |
That error occurs when the number of colums in the database table listed (w3t_Banned) doesn't match the number of values being INSERTed INTO it ('24.151.173.69').
In this case, there needs to be other values listed within the brackets. Something like...
(0, '24.151.173.69', '');
...since the w3t_Banned table has at least 3 rows.
Thus it looks like there's a bug in the script.
I can't help you any more because I don't use 6.5, but that's the issue anyway.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 69
Joined: January 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
