View Single Post
  #1042  
Old 11-15-2011, 03:37 AM
n00bl3t n00bl3t is offline
 
Join Date: Dec 2008
Posts: 89
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm having bit of a problem and I don't know if should post here or create a new thread...

Basically I am getting a report just from one user, no one else, saying that every time he tries to go to the forums page; he receives a database error. Now I keep receiving emails about it since I get an email every time a database error occurs. This is what he see's and I receive:

Code:
Database error in vBulletin 4.1.4:

Invalid SQL:

                       SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times
                       FROM user AS user
                       WHERE post_thanks_thanked_times > '0' AND user.usergroupid NOT IN (17, 3)
                       ORDER BY post_thanks_thanked_times DESC
                       LIMIT 0, 10;

MySQL Error   : Unknown column 'post_thanks_thanked_times' in 'field list'
Error Number  : 1054
Request Date  : Monday, November 14th 2011 @ 08:08:31 PM
Error Date    : Monday, November 14th 2011 @ 08:08:31 PM
Script        : http://www.MYWEBSITE.com/forum.php
Referrer      :
IP Address    : ***.***.***.***
Username      : USERNAME
Classname     : vB_Database
MySQL Version : 5.1.56
The stuff in red I just made red to indicated what I changed in the error to protect identity. The rest is directly what I and him received.

Now I am replying here because the error mentions post_thanks_thanked_times so my first thought is that it is an error relating to this script/mod. HOWEVER I don't think this script/mod is interfering with anything because I actually temporarily disabled the entire mod in plugins manager and he was still receiving the database error. He said it first started when he received a notification that he received a Like/Thanks and when he clicked the notification it happened. Basically he can see the home page; his profile, and all other pages EXCEPT for the /forum.php area; so basically the forums is the only area he can't access and when he tries he gets this error. Basically I made him register a new account and everything is working fine now on his new account however I feel like I should still bring this up because he has over 500 posts and I feel it kinda sucks to see or have him just kinda restart...

So my questions are

1) Does anyone know what is up with this?

2) Is this related or tied into this plugin/mod and any way to fix? It is strange to see only this 1 person is having this problem.


Thanks for the feedback!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01193 seconds
  • Memory Usage 1,770KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete