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)

invitezone 02-13-2011 02:59 PM

can the notification be turn off in the pro version ?

thanks

DragonByte Tech 02-13-2011 03:01 PM

Not yet, that will be added to a future feature update :)


Fillip

grunty1 02-14-2011 09:57 PM

For some reason this product is causing seemingly random and indiscriminant double posting. Any idea how to fix this?

Also, I only use the like/dislike feature...could you let me know what script I would go into to change the line "Thanks / Likes" in the postbit and the bar above the button? Also to remove the "thanks" stats from the postbit stats?

Thanks!

DragonByte Tech 02-14-2011 10:13 PM

Quote:

Originally Posted by grunty1 (Post 2162616)
For some reason this product is causing seemingly random and indiscriminant double posting. Any idea how to fix this?

Nope, it's not something anybody's been able to pin down to a specific hook location that causes it, much less a way to reproduce it.

Without that info, I'm sadly unable to look into it any further.

Quote:

Originally Posted by grunty1 (Post 2162616)
Also, I only use the like/dislike feature...could you let me know what script I would go into to change the line "Thanks / Likes" in the postbit and the bar above the button? Also to remove the "thanks" stats from the postbit stats?

Phrase Manager for the phrase, removing the stats is a Pro-only feature :)


Fillip

grunty1 02-14-2011 10:26 PM

Even if I just want to edit out that one part of the stats?

And thanks for the quick support!

DragonByte Tech 02-14-2011 10:35 PM

That's correct, in v1.1 buttons changed from being static to dynamic (in the Pro version, you can add your own custom ones) and as such it's not as easy to hide stats from postbit anymore.

Fillip

looker2010 02-14-2011 11:15 PM

Installed on 4.1.1 and seem to be going fine. Just noticed though that my stats summary page (up off the top nav) is not working at all. (this page http://www.xxxxxx.com/thanks.php?do=statistics )

This is the error
PHP Code:

Database error in vBulletin 4.1.1:

Invalid SQL:

        
SELECT
            thanks_given 
AS value,
            
userid,
            
username,
            
user.usergroupid,
            
infractiongroupid,
            
displaygroupid                
        FROM dbtech_thanks_statistics 
AS dbtech_thanks_statistics
        LEFT JOIN user 
AS user USING(userid)
        
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid user.usergroupid)
        
WHERE (usergroup.genericoptions 32)
        
GROUP BY userid
        ORDER BY value DESC
username ASC
        LIMIT 5



DragonByte Tech 02-15-2011 01:40 PM

You did not post the full error message, beneath that there was a very important line which tells me what's wrong, please post the complete message :)


Fillip

looker2010 02-15-2011 02:46 PM

Here is the full message:

PHP Code:

Database error in vBulletin 4.1.1:

Invalid SQL:

        
SELECT
            thanks_given 
AS value,
            
userid,
            
username,
            
user.usergroupid,
            
infractiongroupid,
            
displaygroupid                
        FROM dbtech_thanks_statistics 
AS dbtech_thanks_statistics
        LEFT JOIN user 
AS user USING(userid)
        
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid user.usergroupid)
        
WHERE (usergroup.genericoptions 32)
        
GROUP BY userid
        ORDER BY value DESC
username ASC
        LIMIT 5
;

MySQL Error   Column 'userid' in field list is ambiguous
Error Number  
1052
Request Date  
TuesdayFebruary 15th 2011 11:43:45 AM
Error Date    
TuesdayFebruary 15th 2011 11:43:46 AM
Script        
http://www.xxxxxxx.com/thanks.php?do=statistics
Referrer      http://xxxxxxx.com/
IP Address    xx.xxx.xxx.xxx
Username      
xxxxx
Classname     
vB_Database
MySQL Version 
4.1.22-standard 


DragonByte Tech 02-15-2011 02:52 PM

Is there any way you can update MySQL to 5.0.x?

I can fix it, but MySQL 4.1 is what, 8 years old now? And it's no longer supported by MySQL. vBulletin 4 recommends 5.0.19 or later, which might improve your experience as well :)

I'll have it fixed in the next bugfix rollup :)


Fillip


All times are GMT. The time now is 08:08 PM.

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.02851 seconds
  • Memory Usage 1,763KB
  • 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
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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