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

djscoop 11-18-2011 01:08 AM

Fatal error: Class 'THANKS' not found in /home/djscoop/public_html/Forums/dbtech/thanks/actions/admin/button.php on line 34

I reinstalled 3 times....i dont usually have issues...what am i doing wrong?

mitch84 11-18-2011 04:12 AM

a file is missing I think, reupload folder

DragonByte Tech 11-18-2011 08:43 AM

Are you using this mod, per chance: https://vborg.vbsupport.ru/showthread.php?t=269582 (i.s.s.w. "security" mod)?

If so, that mod is the problem and the author has acknowledged the bug that is causing this issue.

More info here: https://vborg.vbsupport.ru/showpost....postcount=1014


Fillip

Consoleopen 11-20-2011 01:47 PM

Hi, I've installed it on vBulletin 4.1.8, and setted up it with permission, but I don't see the button on post.
How i can resolve?

DragonByte Tech 11-20-2011 03:22 PM

Ensure you have set the Can Click permission, flush any cache system like vB Optimise, and try a default (unmodified) skin :)


Fillip

Baltar 11-20-2011 03:52 PM

This is probably a dumb question but step 2, 2. CHMOD the following folders to 0777
/dbtech/thanks/vbactivity_type, I'm not understanding what that means. what does CHMOD mean?

DragonByte Tech 11-20-2011 04:01 PM

This is what Google has to say about CHMOD, hopefully this'll help: http://php.about.com/od/phpbasics/ht/chmod.htm :)


Fillip

Baltar 11-20-2011 04:10 PM

Thanks a nd one last question, all I have to do is make it to 777, don't need to change any other permissions, right?

DragonByte Tech 11-20-2011 04:20 PM

777 gives it all permissions :)


Fillip

Consoleopen 11-20-2011 04:43 PM

I've found the problem... there where wrong permission... I've fixed and all work perfectly...

I've just an little question: is possible to move the button in the right bottom corner of the post insted under post?

DragonByte Tech 11-20-2011 05:21 PM

The Pro version has options for moving the buttons and the results bar :)


Fillip

mitch84 11-21-2011 04:13 AM

hi, after upgrade to vb4.1.8, when I click on thank button the link don't appear except if I refresh my page, a idea? thx

DragonByte Tech 11-21-2011 08:39 AM

Please check Firefox' error console for any JavaScript errors :)


Fillip

thenamesgould 11-21-2011 09:12 AM

Since I've installed this I keep getting databse errors emailed to me ... mainly:

Table 'jgould08_forum.post_thanks' doesn't exist

and

Unknown column 'post.post_thanks_amount' in 'where clause'

Any idea what I need to do to fix them?

Thanks.

DragonByte Tech 11-21-2011 09:30 AM

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


Fillip

mitch84 11-21-2011 04:33 PM

Quote:

Originally Posted by mitch84 (Post 2270212)
hi, after upgrade to vb4.1.8, when I click on thank button the link don't appear except if I refresh my page, a idea? thx

Quote:

Originally Posted by DragonByte Tech (Post 2270268)
Please check Firefox' error console for any JavaScript errors :)


Fillip

same with IE I have this problem

thenamesgould 11-22-2011 03:58 AM

Quote:

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


Fillip

Ahh, thanks. I've uninstalled it, but I'm still getting these errors ... hmm, what to do now ...

DragonByte Tech 11-22-2011 08:55 AM

Check to see if any plugins remain from the uninstall, or any file edits you made needs to be reverted.

If neither of those help, then reinstall the mod and simply leave it deactivated :)


Fillip

CouponWCents 11-22-2011 05:34 PM

I'm so scared about losing members thanks from the other thanks mod

DragonByte Tech 11-22-2011 05:41 PM

The importer won't erase that mod's thanks :)


Fillip

CouponWCents 11-22-2011 05:44 PM

Thanks...cause if it does, I will have about 1000 crazy couponing ladies trying to knock down your front door. LMAO

CouponWCents 11-22-2011 05:55 PM

I have installed it and now after members name it says this:
Post Thanks / Like

Thanks (Given)
0
Thanks (Received)
0
Likes (Given)
0
Likes (Received)
0
Dislikes (Given)
0
Dislikes (Received)
0

Where are the old thanks?

DragonByte Tech 11-22-2011 06:02 PM

Did you run the importer? :p

Btw, there's an issue with the importer where it will not correctly update the "Thanks (Received)" stat. There will be a new Maintenance action added for this in a future version. It does not affect anything except the display of that stat.


Fillip

CouponWCents 11-22-2011 06:04 PM

I must have missed the importer.

Also, I do not want like & dislike, just the thanks. Anyway to remove like & dislike from the stats as shown above?

CouponWCents 11-22-2011 06:07 PM

Where is the importer?

DragonByte Tech 11-22-2011 06:21 PM

Quote:

Originally Posted by CouponWCents (Post 2270827)
Also, I do not want like & dislike, just the thanks. Anyway to remove like & dislike from the stats as shown above?

Disable the buttons in the Button Manager :)

Quote:

Originally Posted by CouponWCents (Post 2270830)
Where is the importer?

Please follow the instructions in Readme_import.txt :)

It's also a good idea to read the main Readme.txt file as it has important information regarding first-time setup :)


Fillip

CouponWCents 11-22-2011 06:39 PM

1. Upload all files from the "upload" folder to your forums directory.

2. Go to [your admin dir]/thanksimport.php

What do I do after step 2?

DragonByte Tech 11-22-2011 06:41 PM

Step 3: ????

Step 4: Profit.

Fillip

CouponWCents 11-22-2011 06:43 PM

Huh? I guess I am totally confused. I have the thanksimport.php open but not sure what to do next.

DragonByte Tech 11-22-2011 06:51 PM

There's a button named "Submit" on there, if you click it it will begin the import process :)


Fillip


All times are GMT. The time now is 05:55 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.03102 seconds
  • Memory Usage 1,825KB
  • 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
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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