Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2015, 07:25 PM
bosanci28's Avatar
bosanci28 bosanci28 is offline
 
Join Date: Feb 2008
Location: USA - West Coast
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error

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.
Reply With Quote
  #2  
Old 05-22-2015, 07:27 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How can you have a userid of "n"? "n" is a letter, not a number and the userid must be a number.
Reply With Quote
Благодарность от:
bosanci28
  #3  
Old 05-22-2015, 07:52 PM
bosanci28's Avatar
bosanci28 bosanci28 is offline
 
Join Date: Feb 2008
Location: USA - West Coast
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm, i am not sure whats with the "n" in there as is not in the user groups.
Attached Images
File Type: jpg 2015-05-22_14-51-49.jpg (52.1 KB, 0 views)
Reply With Quote
  #4  
Old 05-22-2015, 09:08 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
Благодарность от:
bosanci28
  #5  
Old 05-22-2015, 09:19 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The Script part of the error can you post it we need to see what script caused the error
Reply With Quote
Благодарность от:
bosanci28
  #6  
Old 05-22-2015, 09:50 PM
bosanci28's Avatar
bosanci28 bosanci28 is offline
 
Join Date: Feb 2008
Location: USA - West Coast
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Attached Images
File Type: jpg 2015-05-22_16-46-34.jpg (96.2 KB, 0 views)
Reply With Quote
  #7  
Old 05-22-2015, 09:51 PM
ETS|LuucEarth ETS|LuucEarth is offline
 
Join Date: Jul 2014
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Благодарность от:
bosanci28
  #8  
Old 05-22-2015, 10:01 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

PHP Code:
define('DISABLE_HOOKS'true); 
To enable plugins again just comment out the line
PHP Code:
//define('DISABLE_HOOKS', true); 
Use notepad++ to edit any files
Reply With Quote
Благодарность от:
bosanci28
  #9  
Old 05-24-2015, 02:34 AM
bosanci28's Avatar
bosanci28 bosanci28 is offline
 
Join Date: Feb 2008
Location: USA - West Coast
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Благодарность от:
MarkFL
  #10  
Old 05-24-2015, 08:03 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Благодарность от:
bosanci28
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:07 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04595 seconds
  • Memory Usage 2,285KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (7)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_attachment
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete