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)

sweetpotato 02-28-2012 03:07 PM

Quote:

Originally Posted by Phalynx (Post 2304260)
I did now an update to vBulletin 4.1.10 and tested vBExperience. Luckily (?) there are now errors. So if someone has SQL errors or other related to 4.1.10 can post them here to get them fixed before I release vBExperience 4.1.1

vBExperience no longer work for my site at all so please update it ASAP.
Thank Phalynx,

gsmlover4u 02-28-2012 03:50 PM

need update for vbulletin 4.1.10 and now coming soon vbulletin 4.1.11

Phalynx 02-28-2012 04:15 PM

What exactly is not working?

My Testsite is running smoothly with 4.1.10:
http://www.vbaddict.net/xperience.php

HHelp1 02-28-2012 08:13 PM

Quote:

Originally Posted by DS MrSinister (Post 2303893)
@HHelp1

Look into the folder it makes after unzipping the file. you will see a folder called extras in that folder you will see a folder call levels. choose one of those.

vBExperience410_20111216_GOLD ---> extras ---> levels.

Hope this helps.

Then i import that plug in right? So the overall active will decrease and go slower?

kisanjong 02-29-2012 10:24 AM

Just installed on 4.1.10 and from what i can see its working fine.

updating counts at the moment, but seems fine.

Thanks

gsmlover4u 02-29-2012 01:04 PM

Quote:

Originally Posted by Phalynx (Post 2304308)
What exactly is not working?

My Testsite is running smoothly with 4.1.10:
http://www.vbaddict.net/xperience.php

sir working fine on vbulletin 4.1.10
but after uninstall giving this error

Quote:

Originally Posted by gsmlover4u (Post 2289304)
after uninstall facing this error

Warning: require_once([path]/xperience/hooks/memberaction_dropdown.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php(3412) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required '/mounted-storage/home127/sub015/sc75274-IGMU/********.com/forum/xperience/hooks/memberaction_dropdown.php' (include_path='.:/usr/share/php5/') in /mounted-storage/home127/sub015/sc75274-IGMU/********.com/forum/includes/functions.php(3412) : eval()'d code on line 4


Phalynx 02-29-2012 01:30 PM

You will have to uninstall also the product.

Adamwingie 02-29-2012 04:45 PM

Isn't working properly with vBookie.

Phalynx 02-29-2012 04:48 PM

This is fixed in the upcoming 4.1.1

sweetpotato 03-04-2012 07:17 AM

Phalynx, Does 4.1.0 work with vb 4.1.11?

gsmlover4u 03-04-2012 11:18 AM

Quote:

Originally Posted by sweetpotato (Post 2305972)
Phalynx, Does 4.1.0 work with vb 4.1.11?

working fine for me on vbulletin 4.1.11

sweetpotato 03-04-2012 11:47 AM

I face this error when I try to update Experience points with vb 4.1.11
Quote:

Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT
COUNT(fid) AS iresult
FROM formresults
WHERE userid=1
AND formresults.dateline > 315532800;

MySQL Error : Unknown column 'formresults.dateline' in 'where clause'
Error Number : 1054
Request Date : Sunday, March 4th 2012 @ 05:45:16 AM
Error Date : Sunday, March 4th 2012 @ 05:45:16 AM

Phalynx 03-05-2012 09:33 AM

Quote:

Originally Posted by sweetpotato (Post 2305972)
Phalynx, Does 4.1.0 work with vb 4.1.11?

Yes.

Quote:

Originally Posted by sweetpotato (Post 2306025)
I face this error when I try to update Experience points with vb 4.1.11

This is related to EasyForms. Did you uninstalled it and leave the vBExperience Plugin for EasyForms?

sully02 03-06-2012 01:34 AM

Seems a few people have had this issue, but I'm not sure if any light has been shed. Everything seems to be working just fine. However, the awards tab (From xperience.php) does not show up, all you get is a blank or white page.

On my forum it's not exclusive to any one style. No database error, nothing else has a problem, and for that matter, the awards are being tabulated (from what I see on the admincp), just the awards page itself shows nothing.

Phalynx 03-06-2012 08:13 AM

Try to reinstall the XML, it seems the template is missing.

sweetpotato 03-06-2012 08:49 AM

Quote:

Originally Posted by Phalynx (Post 2306341)
Yes.


This is related to EasyForms. Did you uninstalled it and leave the vBExperience Plugin for EasyForms?

Thanks, Somehow vBExperience works for my site again when I disable Easyforms and Event Attendance plugins.

ssdevious 03-06-2012 01:22 PM

Hey there,

first of all, thanks for this amazing mod! It's really greatly appreciated, when someone dedicates that much work and is willing to provide free support and releases, so thanks a lot!

I've got one question.

I've noticed that your vBExperience 4 provides support for some 3rd party modifications, such as "IWT Time Spent Online (plugin)" - sadly this plugin is no longer supported for current release 4.1.11 and I'd like to know, what would be the best approach right now?

Install your vBExperience 4 and then seek someone, who might update the IWT or actually the dev team behind vBE 4 would be able to help here?

Please, let me know. I'd be very grateful, if someone could take a look at this, since it's supposed to work technically, just might be a little bugged, so the fixing would take just a couple of minutes, I guess.

Anyway, I will appreciate any help.

Best Regards,
~tEh'Pâr4d0x

sully02 03-06-2012 03:33 PM

Quote:

Originally Posted by Phalynx (Post 2306728)
Try to reinstall the XML, it seems the template is missing.

Just tried reinstalling the XML file and no change from before.

ssdevious 03-06-2012 03:41 PM

Quote:

Originally Posted by sully02 (Post 2306821)
Just tried reinstalling the XML file and no change from before.

You were installing @ 4.1.11? I'm just curious, because I'm about to get it by myself, I jsut don't want to blow up my forums.

Best Regards,
~tEh'P?r4d0x

sully02 03-06-2012 04:13 PM

Quote:

Originally Posted by ssdevious (Post 2306825)
You were installing @ 4.1.11? I'm just curious, because I'm about to get it by myself, I jsut don't want to blow up my forums.

Best Regards,
~tEh'P?r4d0x

4.1.1 for me. It won't blow anything up on your forums, and it works great. It's just that the tab for awards shows nothing but a blank page.

ssdevious 03-06-2012 06:54 PM

Quote:

Originally Posted by sully02 (Post 2306836)
4.1.1 for me. It won't blow anything up on your forums, and it works great. It's just that the tab for awards shows nothing but a blank page.

Cool, thanks!

Now, I'm just wondering, how should I get that IWT /plugin for counting spent time/ fixed, hehe. Curious about one thing, vBE 4 devs offering support for 3rd party mod, wondering whether they might or might not give me a hand with that one.

Anyway thanks,
~tEh'P?r4d0x

Phalynx 03-06-2012 08:19 PM

vBExperience 4.1.1 BETA has been released. This is primary a bugfix release. Download the Installation from the first post.

Please reinstall ALL plugins you are using from the ZIP\Plugins! Espacially if you get SQL Errors after reinstalling vBExperience.

Changes:
- Fixed Plugin for 8WR_Media_Library
- Fixed Plugin for Advanced_Forum_Points
- Fixed Plugin for Attachment_Consumes_Points
- Fixed Plugin for EasyForms
- Fixed Plugin for Post_Thanks_Abe1
- Fixed border around boxes
- Fixed not correctly saving award images
- Extended character length for manual award assignment
- Several smaller fixes

Phalynx 03-06-2012 08:21 PM

Quote:

Originally Posted by ssdevious (Post 2306785)
I've noticed that your vBExperience 4 provides support for some 3rd party modifications, such as "IWT Time Spent Online (plugin)" - sadly this plugin is no longer supported for current release 4.1.11 and I'd like to know, what would be the best approach right now?

There is a plugin for that one, it is included in the ZIP of vBExperience. You can find it in ZIP\Plugins\Time_Spent_Online.xml

ssdevious 03-06-2012 09:12 PM

Quote:

Originally Posted by Phalynx (Post 2306915)
There is a plugin for that one, it is included in the ZIP of vBExperience. You can find it in ZIP\Plugins\Time_Spent_Online.xml

So basically the functions of it are included? Does it count time spent online and shows some sort of ladder of people, who spent online the most time?

Thanks,
~tEh'P?r4d0x

Phalynx 03-06-2012 09:21 PM

I thought you asked for the "bridge" between Time Spent Online and vBExperience.

Nirjonadda 03-06-2012 09:27 PM

1 Attachment(s)
when install complete i get database error in admin panel


Attachment 136890

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT
u.userid,
u.usergroupid,
u.membergroupids,
u.username,
u.xperience_level,
u.xperience,
u.xperience_ppd,
u.xperience_awardt,
u.reputation,
SUM(s.points_user) AS points_user,
SUM(s.points_thread) AS points_thread,
SUM(s.points_post) AS points_post,
SUM(s.points_misc) AS points_misc
FROM vbxperience_stats AS s
INNER JOIN vbuser AS u ON u.userid=s.userid
WHERE 1=1
GROUP BY S.userid
ORDER BY u.xperience desc
LIMIT 0,30;

MySQL Error : Unknown column 'S.userid' in 'group statement'
Error Number : 1054
Request Date : Wednesday, March 7th 2012 @ 04:35:28 AM
Error Date : Wednesday, March 7th 2012 @ 04:35:28 AM
Script : http://www.*******/xperience.php?go=ranking
Referrer : http://www.******/xperience.php?go=groups
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.56

flighttalk 03-06-2012 09:59 PM

I found the same error after the update but when clicking on Ranking tab only:

Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT
u.userid,
u.usergroupid,
u.membergroupids,
u.username,
u.xperience_level,
u.xperience,
u.xperience_ppd,
u.xperience_awardt,
u.reputation,
SUM(s.points_user) AS points_user,
SUM(s.points_thread) AS points_thread,
SUM(s.points_post) AS points_post,
SUM(s.points_misc) AS points_misc
FROM xperience_stats AS s
INNER JOIN user AS u ON u.userid=s.userid
WHERE 1=1
GROUP BY S.userid
ORDER BY u.xperience desc
LIMIT 0,30;

MySQL Error : Unknown column 'S.userid' in 'group statement'
Error Number : 1054
Request Date : Tuesday, March 6th 2012 @ 10:55:01 PM
Error Date : Tuesday, March 6th 2012 @ 10:55:02 PM
Script : http://www.xxxxx.xxx/xperience.php?go=ranking
Referrer : http://www.xxxxx.xxx/xperience.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.95

otttto 03-07-2012 07:26 AM

Yes is the same Error my vbullettin 4.1.11

Phalynx 03-07-2012 08:51 AM

1 Attachment(s)
Please replace xperience.php in the root with the file attached.
Installation ZIP has been also replaced.

Nirjonadda 03-07-2012 09:28 AM

1 Attachment(s)
Its same condition...when install complete database error in admin panel

Attachment 136895

Phalynx 03-07-2012 10:27 AM

This is another error, I need that SQL Query that is crashing.

otttto 03-07-2012 04:53 PM

Quote:

Please replace xperience.php in the root with the file attached.
Installation ZIP has been also replaced.
Thank you for this xperience.php.
Is working good. :)

digicom 03-07-2012 10:58 PM

Hi Phalynx
After updating from vBExperience 4.1.0 to 4.1.1 BETA
Update Activity PPD, Assign Achievements, Recalculate Awards, Update Promotions.(All work fine)

But i recieve this error when i try to update experience points.
Any help would be apprciated :up:

Code:

Database error in vBulletin 4.1.11:
Invalid SQL:
UPDATE xperience_stats
        SET        points_xperience=136219,points_threads=9580,points_thread_votes=1340,points_thread_replycount=1135,points_thread_views=9245,points_thread_stickies=1850,points_posts=14060,points_post_avg=3,points_post_attachment=4317,points_misc_events=150,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=4783,points_user_law=96,points_user_infractions=0,points_user_reputation=2987,points_user_reputation_use=380,points_user_online=4622,points_user_referrals=10025,points_misc_custom=0,points_user_socialgroup=135,points_thread_tags=73408,points_thread_rate=38,points_user_friends=15,points_user_visitormessages=39,points_user_albumpictures=0,points_misc_ldm=0,points_misc_dl2=68,points_misc_vbblog=131,points_misc_vbcms=250,points_misc_ppd=0,points_misc=600,points_thread=96597,points_post=20301,points_user=18719,points_xperience=136219,points_shop=0,points_post_thanks_used=486,points_post_thanks_got_post=422,points_post_thanks_got_total=1016,points_user_tso=420,points_misc_dsl_vbexp=0,points_user_activity=100,points_user_activity30=40,points_user_activity7=70,points_level=100,promoted=0,
    dateline=1331164145   
    WHERE userid=1;
MySQL Error  : Unknown column 'points_misc_dsl_vbexp' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, March 7th 2012 @ 11:49:04 PM
Error Date    : Wednesday, March 7th 2012 @ 11:49:07 PM
Script        : /forums/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /forums/admincp/xperience_admin.php?do=recount
IP Address    : x.xxx.xxx.xxx
Username      : Admin
Classname    : vB_Database
MySQL Version : 5.1.56


tommyxv 03-07-2012 11:14 PM

Where do you add padding so the icons do not touch the box border??
See here: http://www.vbaddict.net/xperience.php?go=achievements

On a dark background it is way more noticeable. I don't want to mess with any stylevar that would change other areas of my site as I do not have a padding issue any where else.

Thanks!

sully02 03-08-2012 03:42 AM

Quote:

Originally Posted by Phalynx (Post 2307079)
Please replace xperience.php in the root with the file attached.
Installation ZIP has been also replaced.

A couple of notes on this one I've seen:

1] The award icons do not show up. The images simply go to the icons folder (./icons) but do not show an actual image
2] The awards page still shows blank for me
3] The rankings only show the first page of top XP posters. Before I could go beyond the first page.

ssdevious 03-08-2012 03:37 PM

I see, Phalynx, thanks for answering me anyway.

I don't mean to anyhow keep on hijacking this topic, since there's a dozen of people with more serious problems than mine, but...

Do you / does anybody think, that it would be anyhow possible to either integrate the 'time spent online' feature into vBE 4 or is there some guy, who would be willing to take a look at it and fix it?

This is my last post here and sorry for the intrusion once again.

Best Regards,
~tEh'Pâr4d0x

chrisngrod 03-10-2012 06:10 AM

Code:

Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT AVG(points_user_vppd) AS A FROM bundyhi1_MCFVB_xperience_stats WHERE points_user_vppd > 0;

MySQL Error  : Unknown column 'points_user_vppd' in 'field list'
Error Number  : 1054
Request Date  : Saturday, March 10th 2012 @ 01:09:17 AM
Error Date    : Saturday, March 10th 2012 @ 01:09:17 AM
Script        : http://www.cricketusers.com/xperience.php?go=earn
Referrer      : http://www.cricketusers.com/xperience.php
IP Address    : 70.114.141.237
Username      : admin
Classname    : vB_Database
MySQL Version : 5.0.95-community

This is when I try to visit xperience.php?go=earn.

Just letting you know... Thanks!

Toorak Times 03-10-2012 07:25 AM

Do I need to upgrade Phalynx?

Cheers

Mick

chrisngrod 03-10-2012 05:25 PM

I uninstalled and reinstalled. I'm going to give it 24 hours and see if everything is back up. I know it took time for everything to sort itself out before. I'm not going to run any of the scheduled tasks. Just going to let it do it's thing on it's own. Will report back.

raymondblog 03-11-2012 12:06 PM

May I know why are there 2 Points for Posts and also Points for Threads?
http://www.vbaddict.net/xperience.php?go=stats


All times are GMT. The time now is 09:34 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.03043 seconds
  • Memory Usage 1,847KB
  • 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
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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