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)

DragonByte Tech 04-01-2014 05:59 PM

Advanced Post Thanks / Like v3.2.5

New Features Added

Caching
  • List of users who clicked buttons for individual pieces of content is merged into a single row for improved performance when displaying the data
  • Button clicks in the last X days are duplicated in another table to speed up the profile block

vBulletin Options
  • Turn off Profile Block
  • Turn off "Hottest Threads / Posts"
  • Entry List
  • Disable APTL buttons in threads, leaving them enabled for other pieces of content


Fillip

Disco_Dave 04-01-2014 08:29 PM

Just upgraded guys, getting this error:

PHP Code:

Database error in vBulletin 4.2.2:

Invalid SQL:

                        
SELECT contentiddata FROM vbdbtech_thanks_entrycache
                        WHERE contentid IN
(75731757337573475735757367573775738757397574075741)
                                AND 
contenttype 'post';

MySQL Error   Table 'nirc_vB4forum.vbdbtech_thanks_entrycache' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, April 1st 2014 @ 03:53:19 PM
Error Date    : Tuesday, April 1st 2014 @ 03:53:20 PM
Script        : http://nirc.co.uk/supersized/*****-tank-build.html
Referrer      : http://nirc.co.uk/forum59/
IP Address    : 90.
Username      : Pete
Classname     : vB_Database_MySQLi
MySQL Version : 


rr2000 04-02-2014 02:43 PM

anyone updated their Lite version? has it cleared the bug with the search.php..

shahidbaloch 04-02-2014 06:30 PM

bugs are fixed or not in Advanced Post Thanks / Like v3.2.5?

louva-a-Deus 04-02-2014 11:44 PM

How do I remove this mod entirely from the database tables? I've installed and uninstalled several times and I can not.
I realized that post and several related topics that contained likes are gone.

Code:


Database error in vBulletin 4.2.2:

Invalid SQL:

                                        SELECT languageid,
                        phrasegroup_global AS phrasegroup_global,
                        phrasegroup_dbtech_thanks AS phrasegroup_dbtech_thanks,
                        phrasegroup_user AS phrasegroup_user,
                        phrasegroup_posting AS phrasegroup_posting,
                        phrasegroup_album AS phrasegroup_album,
                        phrasegroup_messaging AS phrasegroup_messaging,
                        phrasegroupinfo AS lang_phrasegroupinfo,
                        options AS lang_options,
                        languagecode AS lang_code,
                        charset AS lang_charset,
                        locale AS lang_locale,
                        imagesoverride AS lang_imagesoverride,
                        dateoverride AS lang_dateoverride,
                        timeoverride AS lang_timeoverride,
                        registereddateoverride AS lang_registereddateoverride,
                        calformat1override AS lang_calformat1override,
                        calformat2override AS lang_calformat2override,
                        logdateoverride AS lang_logdateoverride,
                        decimalsep AS lang_decimalsep,
                        thousandsep AS lang_thousandsep
                                        FROM language
                                        WHERE languageid = 2;

MySQL Error  : Unknown column 'phrasegroup_dbtech_thanks' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, April 2nd 2014 @ 05:23:29 PM
Error Date    : Wednesday, April 2nd 2014 @ 05:23:29 PM
Script        : http://.../thanks.php?do=statistics
Referrer      :
IP Address    : 183.60.215.32
Username      :
Classname    : vB_Database_MySQLi
MySQL Version :


DragonByte Tech 04-03-2014 01:45 PM

Advanced Post Thanks / Like v3.2.5 Patch Level 2

Bug Fixes And Issue Fixes:
  • Posts with high number of button clicks will now once again work as intended.


Fillip

DragonByte Tech 04-03-2014 01:46 PM

Quote:

Originally Posted by louva-a-Deus (Post 2491120)
How do I remove this mod entirely from the database tables? I've installed and uninstalled several times and I can not.
I realized that post and several related topics that contained likes are gone.

Code:


Database error in vBulletin 4.2.2:

Invalid SQL:

                                        SELECT languageid,
                        phrasegroup_global AS phrasegroup_global,
                        phrasegroup_dbtech_thanks AS phrasegroup_dbtech_thanks,
                        phrasegroup_user AS phrasegroup_user,
                        phrasegroup_posting AS phrasegroup_posting,
                        phrasegroup_album AS phrasegroup_album,
                        phrasegroup_messaging AS phrasegroup_messaging,
                        phrasegroupinfo AS lang_phrasegroupinfo,
                        options AS lang_options,
                        languagecode AS lang_code,
                        charset AS lang_charset,
                        locale AS lang_locale,
                        imagesoverride AS lang_imagesoverride,
                        dateoverride AS lang_dateoverride,
                        timeoverride AS lang_timeoverride,
                        registereddateoverride AS lang_registereddateoverride,
                        calformat1override AS lang_calformat1override,
                        calformat2override AS lang_calformat2override,
                        logdateoverride AS lang_logdateoverride,
                        decimalsep AS lang_decimalsep,
                        thousandsep AS lang_thousandsep
                                        FROM language
                                        WHERE languageid = 2;

MySQL Error  : Unknown column 'phrasegroup_dbtech_thanks' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, April 2nd 2014 @ 05:23:29 PM
Error Date    : Wednesday, April 2nd 2014 @ 05:23:29 PM
Script        : http://.../thanks.php?do=statistics
Referrer      :
IP Address    : 183.60.215.32
Username      :
Classname    : vB_Database_MySQLi
MySQL Version :


Try removing all files that came with the product :)


Fillip

louva-a-Deus 04-03-2014 05:22 PM

Hi Fillip,

I've tried that, all files were removed


Quote:

Originally Posted by DragonByte Tech (Post 2491208)
Try removing all files that came with the product :)


Fillip


ForceHSS 04-03-2014 05:45 PM

Quote:

Originally Posted by louva-a-Deus (Post 2491228)
Hi Fillip,

I've tried that, all files were removed

Code:

ALTER TABLE `language`
ADD COLUMN `phrasegroup_dbtech_thanks`  mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`;

Will give you this in case its needed
Code:

ALTER TABLE `language`
DROP COLUMN `phrasegroup_dbtech_thanks`,


louva-a-Deus 04-03-2014 07:13 PM

Hi ForceHSS

Erro

Query SQL:

ALTER TABLE `language`
ADD COLUMN `phrasegroup_dbtech_thanks` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`

Mensagem do MySQL: Documenta??o
#1054 - Unknown column 'phrasegroup_dbtech_vbshout' in 'language'






Quote:

Originally Posted by ForceHSS (Post 2491231)
Code:

ALTER TABLE `language`
ADD COLUMN `phrasegroup_dbtech_thanks`  mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`;

Will give you this in case its needed
Code:

ALTER TABLE `language`
DROP COLUMN `phrasegroup_dbtech_thanks`,



ForceHSS 04-03-2014 07:21 PM

Quote:

Originally Posted by louva-a-Deus (Post 2491242)
Hi ForceHSS

Erro

Query SQL:

ALTER TABLE `language`
ADD COLUMN `phrasegroup_dbtech_thanks` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`

Mensagem do MySQL: Documenta??o
#1054 - Unknown column 'phrasegroup_dbtech_vbshout' in 'language'

From your admincp run these querys
Code:

ALTER TABLE `language`
  DROP `phrasegroup_dbtech_thanks`;

This will add the line in the table pick whatever one you need
Code:

ALTER TABLE `language`
ADD COLUMN `phrasegroup_dbtech_thanks`  mediumtext CHARACTER SET utf8  COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`;

Both have been tested and will work for your admincp/Maintenance/Execute SQL Query

louva-a-Deus 04-03-2014 08:51 PM

Hi ForceHSS


C?digo do erro: 1091
Descri??o do erro: Can't DROP 'phrasegroup_dbtech_thanks'; check that column/key exists

Powered by vBulletin™ Version 4.2.2 Patch Level 1 Copyright ? 2014 vBulletin Solutions, Inc. All rights reserved.

doogie88 04-03-2014 09:49 PM

Swear I asked this before but it appears I have no posts in this thread.
How do I fix this error. Get about 100 per day.

Database error in vBulletin 4.2.1:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice,
sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms,
searchhash)
VALUES (0, '66.249.75.34', 1, 'Rotator', '', 'post.dateline', 'DESC', 0.00062, 1,
'150517,150480', 1386700209,
'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:684;s:7: \"Rotator\";}s:6:\"forums\";i:0;s:7:\"options\";a: 3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i :1;s:6:\"action\";s:7:\"process\";}}',
'5b2dbcc6a301bea5afb8a7fce3c08fbf');

MySQL Error : Table 'wxxw_xxx.search' doesn't exist
Error Number : 1146
Request Date : Tuesday, December 10th 2013 @ 12:30:09 PM
Error Date : Tuesday, December 10th 2013 @ 12:30:09 PM
Script : http://www.xxx.com/post_thanks.php?do=findthanks&u=684
Referrer :
IP Address : 66.249.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

ForceHSS 04-03-2014 09:56 PM

That table was removed some time ago in vb4 but the info seems to be stored in some of your tables. The table is now called searchlog from what I remember

ForceHSS 04-03-2014 09:58 PM

Quote:

Originally Posted by louva-a-Deus (Post 2491263)
Hi ForceHSS


C?digo do erro: 1091
Descri??o do erro: Can't DROP 'phrasegroup_dbtech_thanks'; check that column/key exists

Powered by vBulletin? Version 4.2.2 Patch Level 1 Copyright ? 2014 vBulletin Solutions, Inc. All rights reserved.

You can't drop what you don't have run the other query

doogie88 04-03-2014 10:05 PM

Quote:

Originally Posted by ForceHSS (Post 2491276)
That table was removed some time ago in vb4 but the info seems to be stored in some of your tables. The table is now called searchlog from what I remember

Are you replying to me?
if so how do I fix it?

sovatoli 04-03-2014 10:18 PM

Thank's

ForceHSS 04-03-2014 11:19 PM

Quote:

Originally Posted by doogie88 (Post 2491278)
Are you replying to me?
if so how do I fix it?

Try posting in unpaid section if that does not work try paid section

doogie88 04-04-2014 12:05 AM

Sorry I don't come here often, what do you mean by unpaid section? I thought this is where I was?

ForceHSS 04-04-2014 12:19 AM

Quote:

Originally Posted by doogie88 (Post 2491322)
Sorry I don't come here often, what do you mean by unpaid section? I thought this is where I was?

No this is where the plugin is unpaid section is here and paid section is here but before you post there can you post all plugins being used and if possible a link to each one. If you have ever used this plugin I posted a fix for it sometime ago here

doogie88 04-04-2014 12:26 AM

Oh okay. I just assumed since it was a problem with the plugin you'd be able to help.

ForceHSS 04-04-2014 12:28 AM

Post above updated reload please

doogie88 04-04-2014 12:33 AM

Oh I see. Thank you.

ForceHSS 04-04-2014 01:03 AM

Quote:

Originally Posted by doogie88 (Post 2491337)
Oh I see. Thank you.

So did you ever use that plugin I posted above?

louva-a-Deus 04-04-2014 01:08 AM

Hi ForceHSS


run the other query

C?digo do erro: 1054
Descri??o do erro: Unknown column 'phrasegroup_dbtech_vbshout' in 'language'

doogie88 04-04-2014 01:49 AM

Quote:

Originally Posted by ForceHSS (Post 2491343)
So did you ever use that plugin I posted above?

Yes, that's the thread I was looking for. Sorry.
I don't know why this one showed up when I logged in so I thought this was it.

ForceHSS 04-04-2014 01:59 AM

Quote:

Originally Posted by doogie88 (Post 2491363)
Yes, that's the thread I was looking for. Sorry.
I don't know why this one showed up when I logged in so I thought this was it.

I see, you did not install the plugin here put the one I linked you to

brandon515 04-14-2014 10:41 PM

1 Attachment(s)
I just moved off of VbSeo and started using this mod in place of the VbSeo likes system. My question is, is there anyway to have a like button in the top upper right of a thread like VbSeo had?

See attachedAttachment 148903

Chadi 04-17-2014 01:00 PM

When I choose to manually insert code in postbit option in settings, the default placement still stays there below the post even after clearing cache, doing a hard refresh. Is this a known bug? I want it to be inserted inside the post, not separately below it. Something similar to here at vb org

microscopes 04-23-2014 12:29 AM

Has anyone figured out why on certain forums when you click "Like/Dislike" it simply does nothing?

Chadi 04-23-2014 10:23 PM

Quote:

Originally Posted by Chadi (Post 2493550)
When I choose to manually insert code in postbit option in settings, the default placement still stays there below the post even after clearing cache, doing a hard refresh. Is this a known bug? I want it to be inserted inside the post, not separately below it. Something similar to here at vb org

Anyone know about this?

leemart44 04-23-2014 11:43 PM

Not showing in postbit at all :(

DragonByte Tech 04-25-2014 10:09 PM

Quote:

Originally Posted by brandon515 (Post 2493185)
I just moved off of VbSeo and started using this mod in place of the VbSeo likes system. My question is, is there anyway to have a like button in the top upper right of a thread like VbSeo had?

See attachedAttachment 148903

Unfortunately not, sorry :(

Quote:

Originally Posted by Chadi (Post 2493550)
When I choose to manually insert code in postbit option in settings, the default placement still stays there below the post even after clearing cache, doing a hard refresh. Is this a known bug? I want it to be inserted inside the post, not separately below it. Something similar to here at vb org

The setting you're referring to is to deploy the statistics, not the Thanks Cloud. The position you want is a Pro-only feature.

Quote:

Originally Posted by microscopes (Post 2494217)
Has anyone figured out why on certain forums when you click "Like/Dislike" it simply does nothing?

Does it only happen for certain forums?

Quote:

Originally Posted by leemart44 (Post 2494384)
Not showing in postbit at all :(

Can you try disabling all other modifications and let me know if that works for you?


Fillip

greenpk2 04-26-2014 05:22 AM

I have the same problem as leemart44.

I tried to import but I got this error message from sql:
Code:

SELECT thanks.*, post.userid AS receiveduserid
                        FROM post_thanks AS thanks
                        LEFT JOIN post AS post ON(post.postid = thanks.postid)
                        WHERE id >= 0
                        ORDER BY id
                        LIMIT 250;

MySQL Error  : Table 'maxingrs_forum.post_thanks' doesn't exist
Error Number  : 1146
Request Date  : Saturday, April 26th 2014 @ 02:20:17 AM
Error Date    : Saturday, April 26th 2014 @ 02:20:17 AM
Script        : http://domainname.net/forum/admin-login/thanksimport.php?do=doimport
Referrer      : http://domainname.net/forum/admin-login/thanksimport.php
IP Address    : **.***.***.***
Username      : Username
Classname    : vB_Database
MySQL Version : 5.1.73-cll


greenpk2 04-26-2014 05:22 AM

The mod won't show up at all in postbit, only display the stats on the user, but no buttons below any posts.

greenpk2 04-26-2014 05:32 AM

^ Suddenly it worked, yesterday it did not. That's odd.

mohammad6006 04-27-2014 01:59 PM

i update to new version but i have more than 1000,000 post in my forum

so Finalising Install take mane times

not have other way?

DragonByte Tech 04-27-2014 02:08 PM

Quote:

Originally Posted by greenpk2 (Post 2494833)
I have the same problem as leemart44.

I tried to import but I got this error message from sql:
Code:

SELECT thanks.*, post.userid AS receiveduserid
                        FROM post_thanks AS thanks
                        LEFT JOIN post AS post ON(post.postid = thanks.postid)
                        WHERE id >= 0
                        ORDER BY id
                        LIMIT 250;

MySQL Error  : Table 'maxingrs_forum.post_thanks' doesn't exist
Error Number  : 1146
Request Date  : Saturday, April 26th 2014 @ 02:20:17 AM
Error Date    : Saturday, April 26th 2014 @ 02:20:17 AM
Script        : http://domainname.net/forum/admin-login/thanksimport.php?do=doimport
Referrer      : http://domainname.net/forum/admin-login/thanksimport.php
IP Address    : **.***.***.***
Username      : Username
Classname    : vB_Database
MySQL Version : 5.1.73-cll


You appear to not have Abe's Thank You Hack installed, so you can't import from it.

Quote:

Originally Posted by greenpk2 (Post 2494837)
^ Suddenly it worked, yesterday it did not. That's odd.

It was probably a cache issue, next time you can try clicking "Repair Cache" if another one of our mods exhibit a similar issue :)

Quote:

Originally Posted by mohammad6006 (Post 2495054)
i update to new version but i have more than 1000,000 post in my forum

so Finalising Install take mane times

not have other way?

The finalisation step is required in order for the modification to work as expected when upgrading to the latest version.


Fillip

mohammad6006 04-28-2014 08:14 AM

Quote:

Originally Posted by DragonByte Tech (Post 2495058)

The finalisation step is required in order for the modification to work as expected when upgrading to the latest version.


Fillip

but from yesterday final step is working and not finish

from yesterday proccess reach to 270000 and i dont know how time this step end

and in forum not show old thans under posts

zoolander 05-05-2014 03:23 AM

I need help with this part.

Quote:

Configure your Usergroup settings by clicking "Manage Buttons" under
"DBTech - Post Thanks" in your AdminCP navigation menu, then
editing each button and setting your usergroup permissions from there.
I don't see anything like that anywhere in my admincp? Am I looking in the right place or is this broken? Is there supposed to be a link for DBTech thanks options in the menu somewhere? If I'm supposed to have a dbtech button can someone tell me how to fix it so I have one?

I'm assuming I need to find it somehow because I don't see any thanks button yet.


All times are GMT. The time now is 03:21 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.03934 seconds
  • Memory Usage 1,876KB
  • 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
  • (10)bbcode_code_printable
  • (1)bbcode_php_printable
  • (22)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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