vb.org Archive - DNSBL/Open Proxy-Blocking

Page 15 of 18

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - DNSBL/Open Proxy-Blocking (https://vborg.vbsupport.ru/showthread.php?t=96318)

NickCat

10-12-2006 11:57 PM

Quote:

Originally Posted by TMM-TT

Can you see if it has a primary key?
If you think it hasn't, try the command I gave before -
ALTER TABLE proxycache ADD PRIMARY KEY(`ip`);

Hopefully, that'll help..If not, you can try to reinstall the product or use...
OPTIMIZE TABLE proxycache
alt.
REPAIR TABLE proxycache

...instead

I am trying to install this on 3.6.0 and I'm getting the same database errors this user was.

Code:

Invalid SQL:

INSERT INTO proxycache (ip, listed, dateline) VALUES ('75.11.10.116', 0, 1160700950);



MySQL Error  : Duplicate entry '75.11.10.116' for key 1

Error Number : 1062

Date         : Thursday, October 12th 2006 @ 08:55:54 PM

Script       : http://forums.nasioc.com/forums/forumdisplay.php?f=112

Referrer     : http://forums.nasioc.com/forums/forumdisplay.php?f=23

IP Address   : 75.11.10.116

Username     : Unregistered

Classname    : vb_database

And the IPs do already have records, so it's trying to insert a ip that's already been inserted. Shouldn't the code check to see if it's been inserted before trying to insert it again or run an update?

I have the primary key setup properly for ip.

I have repaired, optimized the proxycache table, but still no luck getting away from this error.

Necrosaro420

11-03-2006 10:35 PM

Quote:

Originally Posted by DementedMindz

TMM-TT do you know if this works on 3.6.x

I get nothing but errors with this sent to my email =(

zagman76

12-06-2006 11:52 PM

I added 'aol.com' to the 'exclude from monitor' section, but it is still blocking AOL users from registering. as much as i'd like to block AOL users... :) ... is this a bug or am I doing something wrong?

Thanks!

TrIn@dOr

12-13-2006 12:53 PM

Thanks, really usefull!

StEaLtH666

12-20-2006 09:05 PM

i have just installed this and first must say thanks :)

however im having a few problems with a few of my regular behaved members getting blocked, and so far it just seems those who are with pipex, and bulldog isp's but only those with a static ip.

i have added exceptions etc but the only thing i could do to get them working is input their whole ip, whereas id rather be able to put in a partial ip to the exception list such as 81.86.*.* , but this doesnt work.

is there anyway i can make this happen, or maybe possible to add it to an update please :)

many thanks

zagman76

12-25-2006 06:33 PM

Quote:

Originally Posted by StEaLtH666 (Post 1142456)

just out of curiosity - did you try entering the exception as:
81.86.*
rather than: 81.86.*.* ...?

vBul seems to favor the x.y.* format.

I still can't get this add-on to work properly with AOL users.

zagman76

01-16-2007 04:15 AM

If this setting:

Code:

Block on registration

Only block users on newuser-registrations

is set to "No" - does that make it so this mod checks when people have already registered? In other words - expanding the mod out from only new user registration?

Apophis

03-15-2007 01:30 AM

Quote:

Originally Posted by NickCat (Post 1095887)

I am trying to install this on 3.6.0 and I'm getting the same database errors this user was.

I have the primary key setup properly for ip.

I have repaired, optimized the proxycache table, but still no luck getting away from this error.

I am encountering the same problems as well. I configured this product to only block new registrations. I assumed that if you only block new registrations it will only check to see if an IP is blocked when a user tries to register. No such luck. :(

Is there any fix for this "Duplicate entry" issue?

Richy R

05-14-2007 08:33 PM

There is no like manual with it, where on earth do you put it in the ACP??

Richy R

05-15-2007 03:48 AM

worked it out :) thanks

All times are GMT. The time now is 06:14 PM.

Page 15 of 18

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01195 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: