Thread: Add-On Releases - Radio and TV Player 3.8.x
View Single Post
  #540  
Old 03-27-2012, 04:49 PM
Black Tiger's Avatar
Black Tiger Black Tiger is offline
 
Join Date: Apr 2004
Location: Netherlands
Posts: 957
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Seems to work good.

Just don't delete ratings of deleted users when you don't have any deleted users who made ratings, because then you will encounter this database error:

Quote:
Invalid SQL:
SELECT *, s.name, u.username, !(BIT_OR(ug.radiotvpermissions) & 64) as candomagic
FROM radiostation_rating AS r
LEFT JOIN user AS u ON (u.userid = r.userid)
LEFT JOIN usergroup AS ug ON (find_in_set(ug.usergroupid, u.membergroupids) OR (ug.usergroupid = u.usergroupid))
LEFT JOIN radiostation AS s ON (s.stationid = r.stationid)
WHERE r.userid IN ()
GROUP BY r.ratingid
HAVING candomagic > 0;

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 ')
GROUP BY r.ratingid
HAVING candomagic > 0' at line 6
Error Number : 1064
Request Date : Tuesday, March 27th 2012 @ 07:39:59 PM
Error Date : Tuesday, March 27th 2012 @ 07:40:00 PM
Script : http://www.mydomain.com/forum/adminc...o=cleanratings
Referrer : http://www.mydomain.com/forum/adminc...php?do=cleanup
IP Address : 84.26.xx.xx
Username : Black Tiger
Classname : vB_Database
MySQL Version : 5.0.95-community
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01329 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete