vb.org Archive - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features)

Page 134 of 181

« First

134

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features) (https://vborg.vbsupport.ru/showthread.php?t=204117)

Ted S

02-06-2010 12:55 AM

Version 1.9.5 has been released which fixes an SQL query error for some users when viewing the most helpful answers page.

jGas	02-06-2010 07:54 AM

thank you very much ted s, but i wasn't able to make it works! i've tried disabling all the mods but there is still the database error.

if it's too hard to find the problem, don't you worry ;)

thanks again for your efforts

Ted S

02-06-2010 05:42 PM

Can you repost the error message so I can take a second look? Fixing errors isn't hard, just have to find it. Thanks

jGas	02-07-2010 10:54 AM

sure ted ;)

Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalran k,helpfulpost.lastvote,
thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle ,helpfulpost.goodrank as avgrank

FROM vb_helpfulpost as helpfulpost
INNER JOIN vb_post AS post ON(helpfulpost.postid = post.postid)
INNER JOIN vb_thread AS thread ON(post.threadid = thread.threadid)
INNER JOIN vb_forum AS forum ON(thread.forumid = forum.forumid)
WHERE goodrank > 0

ORDER BY avgrank desc
LIMIT 0, 25;

MySQL Error : Column 'goodrank' in where clause is ambiguous
Error Number : 1052
Request Date : Sunday, February 7th 2010 @ 06:53:15 AM
Error Date : Sunday, February 7th 2010 @ 06:53:15 AM
Script : http://www.musicadigitale.net/forum/helpfulanswers.php
Referrer :
IP Address : xxxxxxxxxxxx
Username : Mr Gas
Classname : vB_Database_MySQLi
MySQL Version : 5.0.89-community

thanks to you

Ted S

02-07-2010 10:20 PM

1 Attachment(s)

Quote:

Originally Posted by jGas (Post 1976559)

sure ted ;)

thanks to you

Use this version of the helpfulanswers.php file

jGas	02-08-2010 07:12 AM

you are great man!
now everything is working fine ;)

steve71

02-10-2010 12:28 PM

helpfulanswers.php

How can I get this to display the usernames instead of the post ID's?

Ted S

02-10-2010 03:22 PM

Quote:

Originally Posted by steve71 (Post 1979054)

helpfulanswers.php

How can I get this to display the usernames instead of the post ID's?

You would need to edit the php file to register this variable then call it in the template. It's pretty simple if you just look at the code for the page.

steve71

02-10-2010 09:00 PM

Quote:

$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."helpfulpost` (
`postid` INT(10) NOT NULL DEFAULT '0',
`threadid` INT(10) NULL,
`goodrank` INT(7) UNSIGNED NOT NULL DEFAULT '0',
`totalrank` INT(7) UNSIGNED NOT NULL DEFAULT '0',
`lastvote` INT UNSIGNED NOT NULL DEFAULT '0',
`userid` INT(7) unsigned NULL,
KEY `postid` (`postid`),
KEY `goodrank` (`goodrank`),
KEY `totalrank` (`totalrank`))

Am I close?

Ted S

02-10-2010 09:12 PM

Quote:

Originally Posted by steve71 (Post 1979480)

Am I close?

What are you trying to do?

All times are GMT. The time now is 05:01 PM.

Page 134 of 181

134

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03382 seconds Memory Usage 1,740KB 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 (5)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
Messages: