vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=231666)

Nook_Neformat 11-22-2011 06:11 PM

Thanks a lot, man!

n00bl3t 11-22-2011 11:00 PM

I tried asking this on DBtechs Post Thank you mod because that is the mod I have installed however he replied saying that it is your mod. I am really confused and I just need an answer and help. I originally posted this:

Quote:

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!
I just had another user run into this problem and now both are unable to get into the forums section.

ForceHSS 11-22-2011 11:19 PM

Quote:

Originally Posted by n00bl3t (Post 2270956)
I tried asking this on DBtechs Post Thank you mod because that is the mod I have installed however he replied saying that it is your mod. I am really confused and I just need an answer and help. I originally posted this:



I just had another user run into this problem and now both are unable to get into the forums section.

the error is not from dbtech thanks plugin it is from the plugin from this post just take the one from my sig install the uninstall making sure you remove all files from the ftp. If you have already removed the plugin then remove all files from the ftp and mysql tables

n00bl3t 11-22-2011 11:59 PM

Quote:

Originally Posted by ForceHSS (Post 2270962)
the error is not from dbtech thanks plugin it is from the plugin from this post just take the one from my sig install the uninstall making sure you remove all files from the ftp. If you have already removed the plugin then remove all files from the ftp and mysql tables

How do I find the mysql tables?

Much appreciated! Thanks.

Hippy 11-23-2011 12:12 AM

phpmyadmin or you can use the compare mod for admincp

Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

n00bl3t 11-23-2011 12:34 AM

Quote:

Originally Posted by Hippy (Post 2270975)

I'm sorry I should have been more clear; could you possibly walk me through or quickly give the steps to finding the tables. I know it is within PHPmyadmin but I have 0 experience in that area unfortunately.

Hippy 11-23-2011 12:42 AM

search the xml file.. for the tables added then search for them in your DB via phpmyadmin..
but you can do it easy wit hthat mod I posted it will show all tables not stock to vb and you can pick out the post thank ones and kill them there..

if you want install that mod and pm me details and I will do it for you..

ForceHSS 11-23-2011 12:48 AM

you can also use navicat to login to see all the tables this would be the easy option but you can only do that if your servername does not say locolhost check config for that info if it does not I can help you with that pm me if you need help

Videx 11-23-2011 01:25 AM

Personally I would just leave the old tables alone. Nothing is calling them and it's not like they're taking up a lot of space (?).

thenamesgould 11-23-2011 10:09 AM

Quote:

Originally Posted by Videx (Post 2270748)
Then you must have neglected to uninstall it properly. You've left one or more of the uploaded files on your server.

Thanks Videx ... I stupidly ALWAYS forget to delete the uploaded files when I uninstall a mod! Cleaned them up (as well as a few from another mod I removed) and it's all fixed.

THANKS!!! :D


All times are GMT. The time now is 12:50 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08284 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete