vBulletin Mods

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

Why not test it then you will see how it works

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?

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

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?

Maybe deleting the log file?

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).

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

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.

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?

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.

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.

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.