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)

sigh 01-04-2010 11:50 PM

Doing a quick test on the refresh issue:

Starting URL:
example.com/forums/showthread.php/12345-Article-Title?p=294521#post294521

Hit Thanks, page refreshes ...

New URL:
example.com/forums/showthread.php/12345-Article-Title?p=294521

mmhmm 01-05-2010 12:52 AM

to avoid database error:
make sure you uninstall the previous one first.

and install this one as a 'fresh' install as oppose to an upgrade.
works perfectly.

thank you.


error if you don't uninstall first.
Code:

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error  : Unknown column '0Array' in 'where clause'
Error Number  : 1054
Request Date  : Monday, January 4th 2010 @ 09:50:41 PM
Error Date    : Monday, January 4th 2010 @ 09:50:42 PM
MySQL Version : 5.0.85-community


S4RFamily 01-05-2010 05:11 AM

Quote:

Originally Posted by S4RFamily (Post 1946821)
Thanks but my problem is the "Thanked 0 times..." is not straight with the "Thanks:" above.

Albe plx help me to fix.

I.am 01-05-2010 09:14 AM

Abe db error fixed i've manually removed the "post_thanks_user_amount" column from the 'user' table using phpmyadmin.

Upgraded to the next version right now and seem to work fine the only problem is that the "Thanked 0 Times in 0 Posts" it is not aligned to the left under "Thanks 0" ho to fix it?

Thanks

Darkimmortal 01-05-2010 03:44 PM

Code:

Database error in vBulletin 4.0.0:

Invalid SQL:

                        REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
                        VALUES (0, '208.115.111.243', 1, 'shadiku', '', 'post.dateline', 'DESC', 0.00032, 1, '45371', 1262569673, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:205;s:7:\"shadiku\";}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\";}}', '93ba3cebb32266d635fc1600bc5fabbe');

MySQL Error  : Table 'forum.search' doesn't exist
Error Number  : 1146
Request Date  : Monday, January 4th 2010 @ 01:47:53 AM
Error Date    : Monday, January 4th 2010 @ 01:47:53 AM
Script        : http://www.gamingmasters.co.uk/post_thanks.php?do=findthanks&u=205
Referrer      :
IP Address    : 208.115.111.243
Username      : Unregistered
Classname    : vB_Database
MySQL Version :

Code:

Database error in vBulletin 4.0.0:

Invalid SQL:

                        REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
                        VALUES (0, '208.115.111.243', 1, 'shadiku', '', 'post.dateline', 'DESC', 0.00021, 1, '45432,45054,44755', 1262569654, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:205;s:7:\"shadiku\";}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\";}}', 'aa2cf5c6dd7ff757d6f63558e8453e9b');

MySQL Error  : Table 'forum.search' doesn't exist
Error Number  : 1146
Request Date  : Monday, January 4th 2010 @ 01:47:34 AM
Error Date    : Monday, January 4th 2010 @ 01:47:34 AM
Script        : http://www.gamingmasters.co.uk/post_thanks.php?do=findthanks_user_gave&u=205
Referrer      :
IP Address    : 208.115.111.243
Username      : Unregistered
Classname    : vB_Database
MySQL Version :


Sworm 01-05-2010 04:26 PM

Uninstalling the mod, don't forget that all the "Thanks" will be losed!!!!!

exyuteam 01-05-2010 10:31 PM

1 Attachment(s)
I have this "problem" (see Capture.png). If someone not see, BLOG ENTRIES - 1 need to be in one line.. Not number 1 up, and text down :) You can see what I meen... ;)

Problem is here:
Code:

<dd style="white-space: nowrap; display: inline; float: right;">
Please fix this. Maybee not using float - juts add text in next line..... ?

Thanks for great hack!!!!

Athena1984 01-06-2010 04:27 AM

Yeah, I have the same problem as exyuteam using your latest version of this hack.

War.Frog 01-06-2010 04:30 AM

Strange - I was playing with this again tonight on my test forum and when I entered a multi-page thread, jumped to a later page (page 11 in this case) and clicked on Thanks, the URL changed back to the first page of the thread!?

So, e.g. on page 11 of the thread: http://www.example.com/vb4test/showt...-thread/page11

...the /page11 is stripped off and I'm brought back to the first page. I have the most up-to-date version of this hack installed.

MrKramer 01-06-2010 03:22 PM

I got this database error:

PHP Code:

Database error in vBulletin 4.0.0:
 
Invalid SQL:
 
            
REPLACE INTO search (useridipaddresspersonalsearchuserforumchoicesortbysortordersearchtimeshowpostsorderedidsdatelinedisplaytermssearchhash)
            
VALUES (0'81.167.x.xxx'1'icey''''post.dateline''DESC'0.918641'1709'1262778281'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:615;s:4:\"icey\";}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\";}}''1f9934b83b2cd7905cad1ae232f6d7da');
 
MySQL Error   Table 'forum.search' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, January 6th 2010 @ 06:44:41 AM
Error Date    : Wednesday, January 6th 2010 @ 06:44:43 AM
Script        : http://www.vind-het-met-rapidlinks.com/post_thanks.php?do=findthanks_user_gave&u=615
Referrer      : 
IP Address    : 81.167.x.xxx
Username      : Niet geregistreerd
Classname     : vB_Database
MySQL Version : 

Do i now have to uninstall whole product and get a fresh install? but what if i dont wanna lose al thankes?


All times are GMT. The time now is 03:50 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.03460 seconds
  • Memory Usage 1,758KB
  • 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
  • (4)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)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