vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - vBExperience (https://vborg.vbsupport.ru/showthread.php?t=171014)

Julrou 05-12-2008 07:02 AM

Hey There !


I updated my forum in vb 3.7 last version 2 days ago, and then i tried to update vbExperience... but it doesn't work, and give me a nice database error. Here it is :

Code:

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE xperience_awards SET awardlimit=0;

MySQL Error  : Unknown column 'awardlimit' in 'field list'
Error Number  : 1054
Request Date  : Monday, May 12th 2008 @ 09:55:56 AM
Error Date    : Monday, May 12th 2008 @ 09:55:57 AM
Script        : http://www.informatiquefacile.eu/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.informatiquefacile.eu/forums/admincp/plugin.php?do=productadd
IP Address    : 82.XXX.XXX.XXX
Username      : Julien
Classname    : vb_database
MySQL Version : 4.1.20-log

Moreover, it gives me database errors when the cron tries to update the data for vbexperience, for example after a post... :confused:

I've just uploaded PHP files to my server, and import the xml file "vbexperience_level_2_average".
The product (product_vbexperience3712) is the only source of the problem...


How can i fix this ? Or can i downgrade to vbexprience 3.10 ?


Thanks for your answers ;)

Julrou 05-12-2008 07:05 AM

I've just received a new error (via mail) :


Code:

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE xperience_stats
                SET
                points_thread=2518.2,
                points_threads=150,
                points_thread_votes=0,
                points_thread_replycount=952,
                points_thread_views=1356.2,
                points_thread_stickies=60,
                points_post=1314,
                points_posts=1314,
                points_post_thanks=0,
                points_post_thanks_use=0,
                points_user=1631.7248726852,
                points_user_infractions=0,
                points_user_activity=100,
                points_user_reputation=1039.5,
                points_user_reputation_use=0,
                points_user_online=420.72487268519,
                points_user_socialgroup=0,
                points_user_friends=39,
                points_user_visitormessages=2,
                points_user_albumpictures=0.5,
                points_user_referrals=130,
                points_post_attachment=0,
                points_post_attachment_views=0,
                points_thread_tags=0,
                points_misc=0,
                points_misc_ldm=0,
                points_misc_dl2=0,
                points_misc_ppg=0,
                points_misc_ppd=0,
                points_misc_vbblog=0,
                points_misc_custom=0,
                promoted=0,
                dateline=1210579260       
                WHERE userid=2;

MySQL Error  : Unknown column 'points_post_thanks_use' in 'field list'
Error Number  : 1054
Request Date  : Monday, May 12th 2008 @ 10:01:49 AM
Error Date    : Monday, May 12th 2008 @ 10:01:50 AM
Script        : http://www.informatiquefacile.eu/forums/cron.php?rand=906638
Referrer      : http://www.informatiquefacile.eu/forums/showthread.php?p=14724
IP Address    : 81.XXX.XXX.XX
Username      : Non inscrit
Classname    : vb_database
MySQL Version :


Phalynx 05-12-2008 11:04 AM

Quote:

Originally Posted by mikeinjersey (Post 1516040)
Just when you thought every possible Mod was out there for vBulletin , this comes around... Wow, im blown away right now looking at the description and screenshots for this. Very nice and thought out Mod. Good stuff !

One question, are we able to disable certain ranking parameters ? Like for instance i'd like to disable the Infraction part... as sometimes members start out bad and then get good over time..it would suck if they had to see that stamped on their record forever.

Oops 2 questions.. And is there a Counter that has to be run that calculates all the previous members that have registered years ago ?

thanks much

No support for people who did not clicked Mark as Installed, sorry!

Quote:

Originally Posted by gamerfu (Post 1516441)
Can I request an implementation Attack system like iBProBattle? :cool:

Currently no time for such extensions.


Quote:

Originally Posted by EcoForumZ (Post 1516749)
Users are not able to stay logged into the forum. After loging in it says "Thank you for logging in" then when the page refreshes it shows nobody as being logged in.

That is for 100% not a problem of vBExperience.

Quote:

Originally Posted by morpheusXIIX (Post 1516751)
I want to be able to modify my welcome block so that it shows the users activity level and current experience level. So they can see this right when they look to see PMs or New Posts.

Nice idea, will be part of next version.

Quote:

Originally Posted by Julrou (Post 1516895)
I updated my forum in vb 3.7 last version 2 days ago, and then i tried to update vbExperience... but it doesn't work, and give me a nice database error.

Did you maybe mixed up content of ZIP/upload and XML? awardlimit is part of newer product XML (not level XML)

Quote:

Originally Posted by Julrou (Post 1516897)
I've just received a new error (via mail) :

Which version of vBExperience are you using?

Phalynx 05-12-2008 11:04 AM

Quote:

Originally Posted by ShadyMDUK (Post 1515354)
What was the answer as I only see two bars on mine and none of the cool graphics... :confused:

Check settings, enable Level Up Bar

Quote:

Originally Posted by DBs (Post 1515660)
Thanks for a great mod but I have stumbled across a problem. In the rankings page many users are being listed duplicate times. Is this normal?

You will have to delete stats and do a recount.

Julrou 05-12-2008 11:22 AM

Quote:

Originally Posted by Phalynx (Post 1517071)
Did you maybe mixed up content of ZIP/upload and XML? awardlimit is part of newer product XML (not level XML)


Which version of vBExperience are you using?


Thanks for your quick answer !

I just downloaded the zip from here, and re-uploaded the PHP files to my server.
Then, I tried to upload the xml file product, by the admin cp, and it made the database error... Then i've uploaded the level xml ("vbexperience_level_2_average"), and it worked.. but the product still didn't worked, and gave me errors...

I am still using vb experience 3.10, because i cannot update the product with the xml BUT the files on my server are 3.12 ones. :/

Jul.

Phalynx 05-12-2008 11:47 AM

Uninstall both XML, install 3.7.12 XML and after that the Level XML.

honken 05-12-2008 12:31 PM

and i will not losing all my experience points by uninstall and install?

IrPr 05-12-2008 01:42 PM

Quote:

Originally Posted by honken (Post 1517169)
and i will not losing all my experience points by uninstall and install?

Points will be re-calculated by cron jobs

Marius, unfortunately due to really high server load caused by this mod i've decided to uninstalling this mod:(
First disabled cron jobs and restarted webserver to stop cron jobs but still forum was with lag
disabled whole vBexperienve product still same issue
at least i've decided to uninstall vbXperience and problem solved

im lookin for an optimize method for this supermod! for example just calculating points for active users
any chance for supadupa crazy forums?

subnet_rx 05-12-2008 01:58 PM

Quote:

Originally Posted by subnet_rx (Post 1513976)
I've created a couple of new rewards based on posts and threads created. Problem is, even though I marked 0 for automatic calculation, the awards aren't being handed out. Is there something you have to do to the cron job or something?

Any suggestions here?

Quote:

Originally Posted by IrPr (Post 1517217)

im lookin for an optimize method for this supermod! for example just calculating points for active users
any chance for supadupa crazy forums?

I'm not having lag problems, but I'd like to see this as well. I'd love to see rewards given out based on what has happened over a specific time period like a week or month, instead of just handing it to the top in each category since the beginning of the board.

germinus 05-12-2008 02:09 PM

Is it me or is the only thing that works with this is the activity bar when useing 3.6.9


All times are GMT. The time now is 05:48 PM.

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.02149 seconds
  • Memory Usage 1,765KB
  • 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
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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