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)
-   -   New Posting Features - [DBTech] Advanced Post Thanks / Like v3 (vB4) [AJAX] (https://vborg.vbsupport.ru/showthread.php?t=243510)

n00bl3t 11-15-2011 03:37 AM

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!

ecitizen 11-15-2011 07:39 AM

hi
my fireands help me
i instal this and its very good but my Post_Thanks_DBTech dont save point in vBExperience i
plz help me

DragonByte Tech 11-15-2011 08:25 AM

Quote:

Originally Posted by n00bl3t (Post 2268076)
I'm having bit of a problem and I don't know if should post here or create a new thread...

[...]

That is Abe's Post Thank You Hack, not this mod :)

Quote:

Originally Posted by ecitizen (Post 2268109)
hi
my fireands help me
i instal this and its very good but my Post_Thanks_DBTech dont save point in vBExperience i
plz help me

Please ask the developer of vBExperience to support this mod :)


Fillip

popular 11-15-2011 04:50 PM

Hi DB-tech check my post #1040
thanks

DragonByte Tech 11-15-2011 05:02 PM

It doesn't, if you believe otherwise please post a new bug report at our forums and include as much detail as possible :)


Fillip

n00bl3t 11-15-2011 05:04 PM

Quote:

Originally Posted by DragonByte Tech (Post 2268116)
That is Abe's Post Thank You Hack, not this mod :)

That's strange...I don't even have his mod. Well, I use to, but I uninstalled it for this one. Strange.

sadiq6210 11-16-2011 02:50 PM

Fillip, can I show how many users thanked this post (the total)?

i.e
10 users said thank you for Fillip for the previous post.

DragonByte Tech 11-16-2011 03:39 PM

The Pro version shows the latest 5 users to click a button, followed by "and X others" :)


Fillip

sadiq6210 11-17-2011 04:51 AM

Quote:

Originally Posted by DragonByte Tech (Post 2268562)
The Pro version shows the latest 5 users to click a button, followed by "and X others" :)


Fillip

You mean auto collapse?
I don't want to collapse any names, I just need to show the total thanks for each post.

i.e
10 users said thank you for Fillip for the previous post.

Can I do that in pro version?

Thanks Fillip

DragonByte Tech 11-17-2011 11:06 PM

Only if you hide who can see clicks from a button, which affects more than just that display :(

If you would like a separate option, you can post a feature suggestion @ our forums :)


Fillip


All times are GMT. The time now is 11:04 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.02955 seconds
  • Memory Usage 1,747KB
  • 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
  • (4)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