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

Hello,

Thanks for the great addon. I have the same "duplicate post" (same post it - but displayed a few times) problem. There are some duplicate helpfulpost entries in the mysql table and i delete them manually to fix the problem. Is there a permanent solution for it?

NeutralizeR

04-10-2011 11:26 AM

Here's the query to find the duplicate helpfulpost votes:

Code:

SELECT postid, 

 COUNT(postid) AS NumOccurrences

FROM helpfulpost

GROUP BY postid

HAVING ( COUNT(postid) > 1 )

Since i deleted all of them, it doesn't return any results but i know it'll happen again :)

Ted S

04-13-2011 05:26 PM

Quote:

Originally Posted by NeutralizeR (Post 2182931)

Here's the query to find the duplicate helpfulpost votes:

Code:

SELECT postid, 

 COUNT(postid) AS NumOccurrences

FROM helpfulpost

GROUP BY postid

HAVING ( COUNT(postid) > 1 )

Since i deleted all of them, it doesn't return any results but i know it'll happen again :)

Thanks! The system checks for dup votes... twice in face but I'll review again to see why some are making it through.

regua

05-09-2011 08:52 PM

I have no idea how no one noticed this before, but there are mismatched parentheses in the file helpfulanswers.php, which result in the parse error that so many people have been talking about. Using an older version of helpfulanswers.php does seem to solve the problem, but also - as far as I've noticed - prevents the point counter from working (i.e. you can't display a user's total amount of points in the postbit).

Thanks for all the work, Ted, and I'm looking forward to a fix to this!

EDIT: I found the missing } at line 292. However, the points are being counted only when the notifications are turned on.

The Realist

05-13-2011 01:33 PM

Ummm installed ok but there is a missing } on the helpfull.php file, anyway.

Why does my forum say 0 out of 4294967295 members found this post helpful. Did you find this post helpful?

I dont have 4294967295 members wish I did.

Whats causing this and how can I correct it?

Regards

Ted S

05-13-2011 07:35 PM

Quote:

Originally Posted by regua (Post 2193796)

Very strange but really appreciate the report and you tracking this down! Update issued...

Ted S

05-13-2011 07:36 PM

Quote:

Originally Posted by The Realist (Post 2195098)

4294967295 is the max value for a 32-bit integer in mySQL. Sounds like your database didn't update properly... Uninstall and reinstall the mod.

Ted S

05-13-2011 07:39 PM

Released a minor update which fixes a parse error in helpfulanswers.php - no other files need to be updated.

All times are GMT. The time now is 01:44 AM.

Page 161 of 181

161

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02618 seconds Memory Usage 1,745KB 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_code_printable (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: