vb.org Archive
Page 51 of 100 « First 414950 51 525361 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=92410)

C_P 02-13-2006 10:58 PM
Quote:
Originally Posted by C_P
Ditto! I get same error:
Code:
Database error in vBulletin 3.5.2:
Invalid SQL:
DELETE FROM reputation WHERE postid = 12795 AND AND whoadded = 1 reason = 'Thanked Post';
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND whoadded = 1 reason = 'Thanked Post'' at line 1
Error Number : 1064
Date : Monday, February 13th 2006 @ 06:08:34 AM
Script : http://www.cpfools.com/forum/showthr...e_user&p=12795
Referrer : http://www.cpfools.com/forum/showthr...2795#post12795
IP Address : xxxxxx
Username : CP
Classname : xxxxxxxxxx
Also at top of my page it shows this:
Code:
Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 131
 
Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 141
/*+--------------------------------------------------------------------------| Cascading Style Sheet for MKportal "Forum" Portal Template| ========================================| by Meo aka Luponero [Amedeo de longis]| visiblesoul [Don K. Colburn]| (c) 2004-2005 mkportal.it| http://www.mkportal.it| Email: luponero@mclink.it+--------------------------------------------------------------------------| > MKPortal| > Written By Amedeo de longis| > Date started: 9.2.2004+--------------------------------------------------------------------------*//*=============================MK global stylesP=============================*//* IMPORT body */body,body{        background: #FFFFFF;        color: #000000;        font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;                padding: 0px;}body {        font-size: 10px;        margin:0px;        padding:0px; /* Opera 0 margin */                text-align: center; /* center in IE */ }/* IMPORT body background (used for SMF) */.importbgbody {        font-size: 10px;}/* portal wrapper */#mkwrapper {        text-align:left; /* left-align text in IE */                margin: 0px auto 0px auto;}/* IMPORT logostrip */#mklogostrip,.page{        background: #FFFFFF;        color: #000000;}/* logostrip */#mklogostrip {        text-align: left;}/* IMPORT global font formatting */table,tr,td,.tdglobal,td, th, p, li{        font: 10pt 'trebuchet ms', verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/* global font formatting */table,tr,td,.tdglobal {        font-size: 10px;        }/* IMPORT main portal table bg (if different than body bg) */.tabmain,.page{        background: #FFFFFF;        color: #000000;}/* main portal table */.tabmain {        margin:0px;        padding:0px;        }/* image link border */img {                        border: 0px;}/*=============================MK IMPORT LIGHT BACKGROUNDP=============================*/.modulecell,.urlo2,.tabnews,.trattini,.trattini3,.tablemenu,.taburlo,.alt1, .alt1Active{        background: #DFE6EE;        color: #000000;}/*=============================MK IMPORT MEDIUM BACKGROUNDP=============================*/.navigatore,.tdblock,.moduleborder,.modulex,.mkpagecurrent,.alt2, .alt2Active{        background: #DFE6EE;        color: #000000;}/*=============================MK IMPORT DARK BACKGROUNDP=============================*/.urlo,.sottotitolo,.tcat{        background: #397DD0 url(../forum/images_pb/gradients/gradient_tcat.gif) repeat-x top left;        color: #FFFFFF;        font: bold 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/*=============================MK border and divider stylesP=============================*//* vertical spacer image used in portal skin *//* .vspacer {        background-image: url(../forum/../mkportal/templates/CPstyle/images/punto_vert.gif);        background-repeat: repeat-y;        background-color: transparent;        } *//* IMPORT border-color */.tabmain,.tablemenu, /* block wrapper, chat button strip */.taburlo,.urlo2,.tabnews,.trattini,.trattini2,.trattini3,.mkpagelink,.mkpagelinklast,.mkpagecurrent,.titadmin,.tborder{                color: #000000;        border: 1px solid #072A68;}        .trattini {        border-width: 1px 0 0 0;        border-style: dashed;}/* blocks admin */.trattini2 {        border-width: 0 1px 0 0;        border-style: dashed;}/* Quotes, Shoutbox */.trattini3 {        border-width: 0 0 1px 0;        border-style: dashed;}/*=============================MK hyperlink stylesP=============================*//* IMPORT global links */a:link,a:active,a.uno:link,a:link{        color: #000000;}a:visited,a.uno:visited,a:visited{        color: #000000;}a:hover,a.uno:hover,a:hover, a:active{        color: #465584;}/* a:active {        font-family: Verdana, Arial, Helvetica, sans-serif;        color: #496c9f;                text-decoration: none;        } *//* bold navbar, block, module links */a.uno:link {        font-size: 10px;        font-weight: bold;        text-decoration: none}a.uno:visited {                font-size: 10px;        font-weight: bold;        text-decoration: none}a.uno:hover {        font-size: 10px;        font-weight: bold;        text-decoration: underline;}/* block text links *//* .tablemenu a:link, a:visited {        font-family: Verdana, Arial, Helvetica, sans-serif;        color: #496c9f;                text-decoration: none;        }.tablemenu a:hover {        text-decoration: underline;}.tablemenu a:active {        text-decoration: none;        } *//* global contrasting text and hyperlink color */.mktxtcontr,a.mktxtcontr:link, a.mktxtcontr:visited {                color: #ff0000;        font-weight: bold;        text-decoration: none;}a.mktxtcontr:hover {        font-weight: bold;        text-decoration: underline;}/* contrasting text and hyperlink color 2 (admin) */.mktxtcontr2,a.mktxtcontr2:link, a.mktxtcontr2:visited {        color: #0000ff;        font-weight: bold;        text-decoration: none;}a.mktxtcontr2:hover {        font-weight: bold;        text-decoration: underline;}/*=============================MK form stylesP=============================*//* IMPORT form styles */input,textarea,select,.bgselect, /* input fields */.mkbutton, /* global submit buttons */.mkblkinput, /* block input */.mkradio, .bginput{        background: #FFFFFF;        color: #000000;        font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/* set form padding and margin *//*.mkbutton,*/ /* global submit buttons *//* textarea,*/input,select,.bgselect, /* input fields */.mkblkinput /* block input */{        margin: 0px;        padding: 0px;        font-size: 9px;        font-weight: normal; /* needed for Mozilla */        }/* radio/checkbox buttons - remove background color and border in IE */ /* .mkradio {        background-color: transparent;        border-width: 0px;} *//* configure blog textarea */textarea.mkwrap1 {        overflow: auto;        /* width: 230px; */        width: 100%;}/* edit blog textarea */textarea.mkwrap2 {        overflow: auto;        width: 500px ;}/*=============================MK navstrip stylesP=============================*//* top navstrip */.navigatore {                vertical-align: bottom;        text-align: center;        font-family: Verdana, Arial, Helvetica, sans-serif;        font-weight: 300;        font-size: 9px;        border: 0;}/*=============================MK block stylesP=============================*//* used in functions.php (function main_page) */.blocks {        padding: 0px;}/* block td cell */.tdblock {        font-family: Verdana, Arial, Helvetica, sans-serif;        font-size: 10px;        font-weight: bold;        border: 0;        margin: 2px;        }/* block title bar */.sottotitolo {        vertical-align: bottom;                text-align: left;        font-size: 11px;        font-weight: bold;        }/* horizontal spacer between blocks */.tdspacer {        line-height: 3px;}/*=============================MK module global stylesP=============================*//* IMPORT module table headings */th.modulex,.thead{        background: #BCCFEA url(../forum/images_pb/gradients/gradient_thead.gif) repeat-x top left;        color: #3A4F6D;        font: bold 11px tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.modulex {                border-width: 0 0 0 0;        white-space: nowrap;        /* font-weight: normal;*/}/* Reviews description text */.modulelite {        font-size: 8pt;        /* color:#a6bbcd;*/}/* block padding (news, admin) */.contents {        padding: 10px;        }/* module pagination links */.mkpagelink {        padding:1px 3px 1px 3px;        font-weight: normal;}.mkpagelinklast {        padding:1px 3px 1px 3px;        font-weight:normal;}.mkpagecurrent {        padding:1px 3px 1px 3px;        font-weight:normal;}/*=============================MK shoutbox module stylesP=============================*/td.taburlo{                margin:5px;        padding:5px;        border: 0;        }        /* shouter and date cell */.urlo {        line-height: 18px;        vertical-align: bottom;        text-align: left;                font-size: 11px;        font-weight: bold;        padding: 4px;                }/* shout cell */.urlo2 {        padding: 4px;        border-width: 0 0 1px 0;        border-style: solid;        text-align: left;        font-size: 11px;        font-weight: bold;}/* white shouter text *//* .urlocontrast {                color: #ffffff;} *//*=============================MK news module stylesP=============================*//* news table with border */.tabnews {        border-width: 1px;        border-style: dashed;        margin:0px;        padding:0px;        font-size: 10px;        }/*=============================MK admin cp stylesP=============================*//* admin cp titles with top border */.titadmin {        margin: 0px;        font-size: 11px;        font-weight: bold;        border-width: 1px 0 0 0;        border-style: dashed;}/*=============================MK font stylesP=============================*//* red error page text */.mkerror {                font-size: 12pt;        color: #ff0000;        font-weight:bold;}/* MKPQuote quotation text *//* .mkquote {                        color: #0000ff;        } *//* MKPGallery module ecard */.ecardtitle {        font-size: 10pt;        font-weight: bold;        text-align: center;}/* MKPGallery slideshow caption text (modules/gallery/index.php function slide_update) *//* .mkslidecap {                font-family: Verdana, Arial, Helvetica, sans-serif;        font-size: 12pt;        font-weight: bold;        color: #ffffff;} *//*=============================MK BBcode quote stylesP=============================*/.mkquoteball {        font-size: 9px;        color: #666666;        font-family: Verdana, Arial, Helvetica, sans-serif;        font-weight: normal;        background-color: #ffffff;                padding: 0;        }.mkquotetext {        font-size: 10px;        color: #666666;        font-family: Verdana, Arial, Helvetica, sans-serif;        font-weight: normal;        background-color: #ffffff;        margin: 0;        padding: 0;        }table .mkquotetable{                                        width: auto; /* IE */                text-align: left;}
The only way I could get rid of it was to thank the post again!
Latest Fix today corrects this. Great job and great product Abe1.

D.Ilyin 02-14-2006 10:44 AM
3.2 BUG:
When use option "Delete Own Thanks" all thank's for post will be delete, when some of user clicked "Remove Your Thanks". But count of post thanks decrease only 1.
Just disable that future for a little, i think Abe1 updated it.

Abe1 02-14-2006 11:57 AM
Version 3.3 (2/14/06):
  • [FIXED] Fixed bug with removing own thanks.

I recommend everyone run the "Update Post Thanks Post Amount" counter. You can find it in you ACP under "Maintenance -> Update Counters -> Update Post Thanks Post Amount". This bug was resetting the count to zero when a user removed his own thanks.

The Realist 02-14-2006 01:11 PM
Yes just installed 3.3 version.

When I try and remove a thanks, I get this DB error:

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
DELETE FROM reputation WHERE postid = 2192 AND AND whoadded = 1 reason='Thanked Post';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND whoadded = 1 reason='Thanked Post'' at line 1
Error Number : 1064
Date        : Tuesday, February 14th 2006 @ 03:09:48 PM
Script      : http://www.tech-tronix.com/showthread.php?do=post_thanks_remove_user&p=2192
Referrer    : http://www.tech-tronix.com/signature-post-test-forum/test-1799.html
IP Address  : xx.xx.xx.xxx
Username    : Realist
Classname    : xxxxxx
At the top of the error page I get this as well:
Code:
Warning: implode(): Bad arguments. in /showthread.php on line 235
Line 235 reads:
Code:
$set_user_got = "post_thanks_thanked_times = post_thanks_thanked_times - $nb, post_thanks_thanked_posts = post_thanks_thanked_posts - 1";
Any ideas?


Quote:
Originally Posted by Abe1
Do you have the latest version installed?

Abe1 02-14-2006 01:16 PM
Quote:
Originally Posted by The Realist
Yes just installed 3.3 version.

When I try and remove a thanks, I get this DB error:

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
DELETE FROM reputation WHERE postid = 2192 AND AND whoadded = 1 reason='Thanked Post';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND whoadded = 1 reason='Thanked Post'' at line 1
Error Number : 1064
Date        : Tuesday, February 14th 2006 @ 03:09:48 PM
Script      : http://www.tech-tronix.com/showthread.php?do=post_thanks_remove_user&p=2192
Referrer    : http://www.tech-tronix.com/signature-post-test-forum/test-1799.html
IP Address  : xx.xx.xx.xxx
Username    : Realist
Classname    : xxxxxx
At the top of the error page I get this as well:
Code:
Warning: implode(): Bad arguments. in /showthread.php on line 235
Line 235 reads:
Code:
$set_user_got = "post_thanks_thanked_times = post_thanks_thanked_times - $nb, post_thanks_thanked_posts = post_thanks_thanked_posts - 1";
Any ideas?
It looks like you dont have the latest version. The query was fixed. I just checked again.

The Realist 02-14-2006 01:18 PM
I just downloaded post thanks 3 3.zip and ran the product-post_thanks.xml file?

So I presume this is the latest version?

The Realist 02-14-2006 01:25 PM
I removed the product from my forum and re installed it, looks like its working now, not getting any DB errors but:

Im getting this error:

Could not find phrase 'post_thanks'.

C_P 02-14-2006 05:45 PM
Well, I just added this latest 3.3 version fix and now this error is back when you try to delete your own thanks:
Quote:
Database error in vBulletin 3.5.2:

Invalid SQL:

UPDATE post
SET post_thanks_amount - 1
WHERE postid = 12796;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '- 1
WHERE postid = 12796' at line 2 Error Number : 1064
Date : Tuesday, February 14th 2006 @ 07:43:37 PM
Script : http://www.cpfools.com/forum/showthr...e_user&p=12796
Referrer : http://www.cpfools.com/forum/showthr...2796#post12796
IP Address : 71.104.209.88
Username : CP
Classname : vb_database

and this at top of page:

Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 131

Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 141

Abe1 02-14-2006 05:51 PM
Quote:
Originally Posted by C_P
Well, I just added this latest 3.3 version fix and now this error is back when you try to delete your own thanks:
I just updated the zip to fix the bug.

C_P 02-14-2006 05:57 PM
Quote:
Originally Posted by Abe1
I just updated the zip to fix the bug.
Awesome! Works like a charm Abe1


All times are GMT. The time now is 09:26 PM.
Page 51 of 100 « First 414950 51 525361 Last »
Show 40 post(s) from this thread on one page

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.01863 seconds
  • Memory Usage 1,810KB
  • 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
  • (8)bbcode_code_printable
  • (6)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
  • (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