Thread: Major Additions - vBExperience 4
View Single Post
  #2450  
Old 06-25-2012, 07:32 PM
DevOne5555 DevOne5555 is offline
 
Join Date: Feb 2011
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Upgrading to vBExperience 4.1.1 under vBulletin 4.1.5 PL1, I get the following error when doing Recoung > Update Experience Points:
Code:
Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE xperience_stats 
		SET
		points_xperience=22764,points_threads=1053,points_thread_votes=175,points_thread_replycount=2323,points_thread_views=3672,points_thread_stickies=200,points_posts=3198,points_post_avg=6,points_post_attachment=274,points_misc_events=0,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=376,points_user_law=1536,points_user_infractions=0,points_user_reputation=6243,points_user_reputation_use=376,points_user_online=496,points_user_referrals=60,points_misc_custom=0,points_user_socialgroup=0,points_thread_tags=88,points_thread_rate=1,points_user_friends=0,points_user_visitormessages=7,points_user_albumpictures=0,points_misc_ldm=0,points_misc_dl2=0,points_misc_vbblog=0,points_misc_vbcms=0,points_misc_ppd=0,points_misc=0,points_thread=7512,points_post=6532,points_user=8719,points_xperience=22764,points_shop=0,points_post_likes=3060,points_user_activity=0,points_user_activity30=0,points_user_activity7=0,points_level=36,promoted=0,
	dateline=1340656014	
	WHERE userid=1;

MySQL Error   : Unknown column 'points_post_likes' in 'field list'
Error Number  : 1054
Request Date  : Monday, June 25th 2012 @ 04:26:53 PM
Error Date    : Monday, June 25th 2012 @ 04:26:54 PM
Script        : http://www.demo.com/forums/admincp/xperience_admin.php?do=xperience_admin_recount_xp
I'm assuming points_post_likes relates to the Point Market System mod we had installed? It was causing us problems, which is why we removed it. Is there some around these recount errors in Xperience mod that doesn't involve reinstalling Point Market?
Quote:
Originally Posted by K!nG View Post
Hello everyone,

i am running 4.1.12 and recently updated to latest version and after that day "overall activity" of all users and admins is "0%" Can anyone help me with that one ??? Thanks
Same thing is happening to me: user levels display correctly, but activity levels show 0%. Can anyone confirm how to fix this?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01130 seconds
  • Memory Usage 1,769KB
  • 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_code
  • (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