vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=248042

ForceHSS 22 Oct 2013 04:26

Quote:

Originally Posted by adnedarn (Post 2455202)
What spam o matic db? It says that it pulls the details from stopforumspam.com (SFS) ... which it is listed and has been for days. http://stopforumspam.com/search
Ones that I caught and were not in the above link I submit... I'm not aware of a seperate spam o matic db. ???

sfs = db its what i call it use to making games so I use this

ForceHSS 22 Oct 2013 04:27

Quote:

Originally Posted by Terrablade (Post 2455212)
Does anyone know if placing the moderated words in brackets {dog} works better?

Like the censorship mod. if you use dog. it will ban any word starting with Dog. Thats what i think happens witg spamomatic.

In censorship mod if you place {dog} it will only ban the word dog not dogma for example

Why not test it then you will see how it works

adnedarn 22 Oct 2013 04:48

so if we are both looking at the same database, why do I see that the IP address has been listed there for a few days yet the IP is getting passed through on my board?

ForceHSS 22 Oct 2013 05:21

Strange it is now showing. Sometimes there db goes down have seen that in the pass. I use this along with the plugin helps when it does that

Jon12345 22 Oct 2013 16:23

Couple of questions:

1. I have v2.1.0 - is it important to upgrade to v2.1.2? If so, how do I upgrade?

2. I am getting some errors:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Any idea why?

Terrablade 22 Oct 2013 22:56

Maybe deleting the log file?

ForceHSS 23 Oct 2013 07:18

Quote:

Originally Posted by Jon12345 (Post 2455327)
Couple of questions:

1. I have v2.1.0 - is it important to upgrade to v2.1.2? If so, how do I upgrade?

2. I am getting some errors:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Any idea why?

Talk to your host about this problem "MySQL server has gone away"

djbaxter 24 Oct 2013 23:21

Quote:

Originally Posted by ForceHSS (Post 2455508)
Talk to your host about this problem "MySQL server has gone away"

Not that simple. I'm getting similar errors with the other mod from which this was derived:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

They usually also say


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

but that's a red herring. I'm on a dedicated server and that is the ONLY time I'm getting these errors. There are no other MySQL issues at the times these occur and it happens on two different 4.2.2 forums.

It's the Invalid SQL error that needs attention. Note the double occurrence of ";;" at the end. That looks malformed to me.

It may well have to do with upgrading to PHP 5.4.20 after the vBulletin 4.2.2 upgrade. I'm not certain.

A satisfactory workaround for now I think would be to turn off logging since the rest of the functions seem to be still working. There is no option to do that in vbStopForumSpam and I don't recall such an option for this mod either (I found it to be overkill for my needs so I reverted to the simpler version).

ForceHSS 24 Oct 2013 23:30

MySQL server has gone away is a server issue you need to talk to your host

fly 24 Oct 2013 23:32

Agreed. Something is happening to your SQL server. That's a PHP error and is happening at a lower level then this mod.

djbaxter 24 Oct 2013 23:48

Quote:

Originally Posted by ForceHSS (Post 2455941)
MySQL server has gone away is a server issue you need to talk to your host

Quote:

Originally Posted by fly (Post 2455942)
Agreed. Something is happening to your SQL server. That's a PHP error and is happening at a lower level then this mod.

So which is it? PHP or MySQL? And why is it only happening when this mod or the other one tries to write to the log file?

Seems to me it has more to do with something in the mod that needs to be updated for 4.2.2 or PHP 5.4.20.

fly 24 Oct 2013 23:51

It's PHP alerting you that it can't make a connection to the MYSQL database. I take it you recently upgraded to 5.4? Maybe something with that upgrade?

djbaxter 24 Oct 2013 23:58

One more point:

The log IS being updated normally and I am ONLY seeing this error when the SFS database can't be accessed: Note the [REMOTEERR] part of the error message. Any other time, there is no error.

djbaxter 25 Oct 2013 00:01

Quote:

Originally Posted by fly (Post 2455944)
It's PHP alerting you that it can't make a connection to the MYSQL database. I take it you recently upgraded to 5.4? Maybe something with that upgrade?

I run two forums, four blogs, a directory, and several other PHP scripts on this dedicated server. Nothing else is having any problems connecting to MySQL.

Again, the only errors I am getting are with writing to the log when the mod cannot connect to the SFS database.

That's a little too specific for me to believe it's the standard "MySQL has gone away" error.

squidsk 25 Oct 2013 17:59

Remove the second ; and see what happens. Having a second ; will immediately try to redo the last mysql statement and if you're using myslqi in your vbulletin it will allow multiple mysql statements in a single query attempt.


All times are GMT. The time now is 21:26.

Powered by vBulletin® Version 3.8.14
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.