vb.org Archive

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 04-07-2009 05:19 PM

Quote:

Originally Posted by Quantnet.org (Post 1785525)
Good stuff, Ted
I have been using 1.5.4 for a while and only get to play with the latest version until now.
When I tried to use ha_import to import the thanks mod to this, it ran halfway and got this error

Invalid SQL:
UPDATE post SET totalrank=totalrank + 1,
goodrank=goodrank + 1 WHERE postid = 548;

MySQL Error : Unknown column 'totalrank' in 'field list'
Error Number : 1054

I think you're using the wrong utility script.

Quantnet 04-07-2009 09:39 PM

No, I only downloaded and used ha_import.php and run it as instructed.

nascartr 04-08-2009 03:01 AM

I received that error in one of the first importers Ted uploaded, it was eventually fixed in a new attached ha_import in a later post.

Ted S 04-08-2009 01:21 PM

Quote:

Originally Posted by nascartr (Post 1786282)
I received that error in one of the first importers Ted uploaded, it was eventually fixed in a new attached ha_import in a later post.

Good point. Be sure and use the version in the first post... I will remove any others out there

Quantnet 04-08-2009 08:29 PM

Download ha_import.php again from the second post. Ran and the same issue

Added record for post 35309 to log.
Added record for post 35219 to log.
Added record for post 35356 to log.
Added record for post 35375 to log.
Added record for post 34935 to log.

Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE post SET totalrank=totalrank + 1,
goodrank=goodrank + 1 WHERE postid = 548;

MySQL Error : Unknown column 'totalrank' in 'field list'
Error Number : 1054
Request Date : Wednesday, April 8th 2009 @ 05:25:17 PM
Error Date : Wednesday, April 8th 2009 @ 05:25:18 PM
Script : http://www.xxx.xxx/forum/admincp/ha_import.php
Updating post rating counters:

Ted S 04-09-2009 01:09 AM

As noted in https://vborg.vbsupport.ru/showpost....65&postcount=2 ha_import.php is designed to import data from the thank you addon. To update you can run ha_revote.php. This is only needed if you have errors with the script.

hilfe-forum 04-09-2009 09:30 AM

Buttons only show in first post... please help

Quantnet 04-09-2009 12:53 PM

I edited the template to show the rating in Digg style
It does not show the Yes|No part, only the number.

For example, if a post has 10 helpful votes, then it simply shows +10. It should show +10 YES|NO
If a post has 0 helpful vote and 1 unhelpful vote, then it shows +0. It should show -1 YES|NO

Ted S 04-10-2009 03:10 AM

Quote:

Originally Posted by Quantnet.org (Post 1787319)
I edited the template to show the rating in Digg style
It does not show the Yes|No part, only the number.

For example, if a post has 10 helpful votes, then it simply shows +10. It should show +10 YES|NO
If a post has 0 helpful vote and 1 unhelpful vote, then it shows +0. It should show -1 YES|NO

Sounds like your edits removed the links. You'll want to get a fresh copy of the template and add those back in.

Ted S 04-10-2009 03:11 AM

Quote:

Originally Posted by hilfe-forum (Post 1787234)
Buttons only show in first post... please help

What options do you have enabled?


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

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.02256 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
  • (4)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