vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - vBExperience 4 (https://vborg.vbsupport.ru/showthread.php?t=245023)

everydayforums 06-26-2012 03:31 PM

Installed on 4.2 first time, no problems, looks great.

tpearl5 06-30-2012 01:26 PM

Anyone else having a problem with GAP? It seems that only the link to GAP in the member pull down doesn't appear all the time and when it does, the is no way to fill out the form. There is no data for "Description" & "You have" and no field for "Give Away".

looker2010 07-01-2012 10:57 PM

When I go to try to limit the Admin from not being included in the stats it has a database error. Please advise.

This is the error I get:

PHP Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT 
                       u
.userid
                       
points_threads+points_thread_votes+points_thread_replycount+points_thread_views+points_thread_stickies+points_thread_tags+points_posts+points_post_attachment 
                       
AS get_count 
                       FROM xperience_stats 
as 
                       INNER JOIN user 
as u ON u.userid s.userid 
                       WHERE 1 
1  AND u.userid NOT IN(1,) AND NOT (1=2  OR u.usergroupid '6' OR FIND_IN_SET(6u.membergroupids)) 
                       
ORDER BY get_count DESCpoints_xperience DESC 
                       LIMIT 0
,1;

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ') AND NOT (1=2  OR u.usergroupid = '6' OR FIND_IN_SET(6, u.membergroupids)) 
  ' 
at line 7
Error Number  
1064
Request Date  
SundayJuly 1st 2012 07:54:04 PM
Error Date    
SundayJuly 1st 2012 07:54:04 PM 


trackpads 07-02-2012 06:52 PM

1 Attachment(s)
Hey, great mod, I am having a problem though.

The mod installed perfectly and everything was going ok until my computer went to sleep while the admincp was recounting the achievements. Now all I get is a 500 Internal Server error when I try to recount achievements, regardless of how low I set the number to process. I even tried 1 :)

zombieshack 07-20-2012 07:31 AM

Only the admin postbit bars for the sidebar under the avatars show up, for the users the bars wont show up? How do i fix this? Thank you :)

slinky 07-30-2012 03:09 PM

First of all, I want to thank Phalynx for this crazy amazing free modification. It has been great but I needed to strip some forums down back towards the core. I have been unable to remove this completely and it is driving me crazy. For example:

script '/home/mysite/public_html/forum/xperience.php' not found or unable to stat

I have numerous messages like this one in my Apache error logs, frequently SE crawls. I can't locate anywhere an instance of xperience.php being called in any template. It's hidden somewhere.

In addition, I'm suspecting that this cron job error might be related too.

Invalid SQL:

SELECT post.postid, post.threadid, post.visible, post.title, post.userid, post.dateline,
thread.forumid, thread.title AS thread_title, thread.postuserid, thread.visible AS thread_visible,
thread.firstpostid,
user.usergroupid, user.displaygroupid, user.membergroupids, user.posts, usertextfield.rank # for rank updates
FROM post AS post
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN user AS user ON (post.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
WHERE postid =;

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 '' at line 9
Error Number : 1064

Postid is empty so that obviously is the problem. But this only began to occur when I removed Xperience and I wonder whether it's because this query isn't being fed a variable.

JonUrban 07-30-2012 07:21 PM

Quote:

Originally Posted by killerford (Post 2342347)
Is this working for 4.2?

I just got around to upgrading to 4.2, and the experience seems to still be there, however the EXPERIENCE button on the forum toolbar is gone, however in the User Control Panel, it's there along with all of the information.

Do I have to do something to get that back?

Thanks

Stonerspot.net 08-07-2012 02:52 AM

Awesome. Cheers :D

Fakher 08-10-2012 07:11 AM

installed smoothly... But when i install plugin for DBTech Post thanks and likes after that i tried to rebuilt point it says
Database error in vBulletin 4.2.0:

Quote:

Invalid SQL:
SELECT
dbtech_thanks_likes,
dbtech_thanks_liked,
dbtech_thanks_thanks,
dbtech_thanks_thanked
FROM user
WHERE userid = 1;

MySQL Error : Unknown column 'dbtech_thanks_likes' in 'field list'
Error Number : 1054
Request Date : Friday, August 10th 2012 @ 01:08:31 PM
Error Date : Friday, August 10th 2012 @ 01:08:31 PM
Script : http://hostingdreams.net/forums/admi...min_recount_xp
Referrer : http://hostingdreams.net/forums/admi...php?do=recount
IP Address : 39.45.78.224
Username : Fakher
Classname : vB_Database
MySQL Version : 5.1.63-cll
What did i miss ?

Anygma 08-10-2012 04:07 PM

im planning to upgrade vb3 to vb4.. How can I upgrade the vB Experience plugin?

Thanks


All times are GMT. The time now is 05:05 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.02846 seconds
  • Memory Usage 1,756KB
  • 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
  • (1)bbcode_php_printable
  • (2)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