Database error

[bosanci28]

Hello,

I am getting some emails with "Database error" message from my forum and not really sure why!

This is what i get:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT location, badlocation FROM session WHERE userid = n AND lastactivity > 0 ORDER BY lastactivity DESC LIMIT 1;

MySQL Error : Unknown column 'n' in 'where clause'
Error Number : 1054
Request Date : Wednesday, May 20th 2015 @ 10:36:02 PM
Error Date : Wednesday, May 20th 2015 @ 10:36:03 PM
Script : forum link it is in here....(deleted by me)
Referrer :
IP Address : xxx.xx.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Ip address is changed all the time,in every email ! so i guess there are from different people.

Thank for any advice on this.
B.

[Lynne]

How can you have a userid of "n"? "n" is a letter, not a number and the userid must be a number.

[bosanci28]

Hmm, i am not sure whats with the "n" in there as is not in the user groups.

[MarkFL]

I would guess it is a "Who's Online" related query...have you recently installed any new add-ons that report user location or activity of any kind?

[ForceHSS]

The Script part of the error can you post it we need to see what script caused the error

[bosanci28]

See attached , i did installed quite few mods as my forum is new and getting started.
But i suspect maybe is the mod: "member tracking" but not sure.

[ETS|LuucEarth]

My guess is that the n should be a variable $n or something along that line. Depends on the script that is calling this Query.

[ForceHSS]

Disable plugins via config if this fixes the problem enable plugins again via config, then disable one plugin at a time until you find the problem one

To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);To enable plugins again just comment out the line
//define('DISABLE_HOOKS', true);Use notepad++ (http://notepad-plus-plus.org/download/v6.6.8.html) to edit any files

[bosanci28]

Thank you to all for helping!

Okay, So i have disabled , that plugin "Member Tracking" and today i still got about 6 emails with the same message .

So i have i disabled all plugins via config.php and now will give it a day or two to see if the error
comes back.

Thank you.
B.

[Lynne]

If you get the error again, can you please include the Script and Referrer so we can see what script and page the error is coming from.

[bosanci28]

So is all most 24 hr's , from the time i have disabled all the plugins, and my last email that i got
regarding the database error was 05/23/2015 @ 5:58pm. So at this point i don't think is the script i guess. But will try to enable the mods one by one and see.

[ForceHSS]

If you want help please follow what post 10 is asking