vb.org Archive - Major Additions

Cool, thanks man. I'll see if I can find out of my provider has SQL4.1 available.

Edit: Well, I checked, and I'm on MySQL Version : 5.0.83. Any other ideas as to why I may be getting these database errors? Here's the full DB Error message:

PHP Code:


		
			
Database error in vBulletin 4.0.3:

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

MySQL Error   : Unknown column 'u.xperience_awards' in 'field list'
Error Number  : 1054
Request Date  : Monday, October 4th 2010 @ 04:15:47 PM
Error Date    : Monday, October 4th 2010 @ 04:15:48 PM
Script        : http://www.project-abraham.com/forums/xperience.php?go=ranking
Referrer      : http://www.project-abraham.com/forums/xperience.php
IP Address    : 129.130.172.125
Username      : tha_con
Classname     : vB_Database
MySQL Version : 5.0.83-log

StonePilot

10-04-2010 07:36 PM

I upgraded from 3.8 to 4.0.7 and I'm not able to see anything added to the postbit template. I got a notice that I had some conflicts, so I uploaded the latest version of my custom template and it still did not work.

Any thoughts or suggestions?

http://www.gmtruckclub.com/forum/sho...ed.&styleid=10

StonePilot

10-04-2010 08:20 PM

Quote:

Originally Posted by StonePilot (Post 2106772)

I got it, it wasn't saving the option to show with description, but it did now.

Phalynx

10-05-2010 05:33 AM

Quote:

Originally Posted by jeremyricci (Post 2106759)

PHP Code:


		
			
Database error in vBulletin 4.0.3:



Invalid SQL:

SELECT 

        u.userid,

        u.usergroupid,

        u.membergroupids,

        u.username,

        u.xperience_level,

        u.xperience,

        u.xperience_ppd,

        u.xperience_awards,

        u.reputation,

        s.points_user,

        s.points_thread,

        s.points_post,

        s.points_misc

        FROM xperience_stats AS s

        INNER JOIN user AS u ON u.userid=s.userid

        WHERE 1=1 

        ORDER BY u.xperience desc

        LIMIT 0,30;



MySQL Error   : Unknown column 'u.xperience_awards' in 'field list'

Error Number  : 1054

Request Date  : Monday, October 4th 2010 @ 04:15:47 PM

Error Date    : Monday, October 4th 2010 @ 04:15:48 PM

Script        : http://www.project-abraham.com/forums/xperience.php?go=ranking

Referrer      : http://www.project-abraham.com/forums/xperience.php

IP Address    : 129.130.172.125

Username      : tha_con

Classname     : vB_Database

MySQL Version : 5.0.83-log

Your files on the server are old. Please copy all files from the ZIP - I mean ALL. After that, re-import that product.xml

Otherwise the database will not be upgraded correctly.

cad2go

10-06-2010 03:28 PM

Quote:

Originally Posted by Phalynx (Post 2106634)

As for the awards: If you have limited the awards to one per user, it must search for other users in the ranking who have no award. To test this just increase the number of awards up to 5.

Seems to work perfectly. Is there any way to allow the user pick which 5 awards they want to keep or a way to weight them as more valuable than one another. E.g. if I wanted referrals to be the most valuable award so if someone won ten but was only allowed hold 1 then that would be the one held. Kind of like a sort order?

Overall I'm very happy with this as a mod, it's just a matter or getting used to it's complexity.

Hall of Famer

10-07-2010 01:39 AM

Quote:

Originally Posted by Phalynx (Post 2106551)

Yes, check the user exclude setting.

Seems to be an issue with the path. Do you still have that problem?

Fixed in 4.0.4

Uhm, I have no idea. Can you point me via PM to you forum so I can look.

If you would read the readme file, and also the description of the mod than you would know that it has been replaced by the Point Market System.

You don't even have clicked "Mark as Installed", but you are asking here very often and also messaging me about this. This is really not fair.

Sorry I forgot to click on that, just did it.

So can you please add VBexperience shop back? I enjoyed it a lot back when I had vb3.8...

Phalynx

10-07-2010 05:50 AM

Quote:

Originally Posted by cad2go (Post 2107434)

Choosing achievements/awards for display is already on my todo list:
http://www.vbaddict.net/project.php?issueid=35

Quote:

Originally Posted by Hall of Famer (Post 2107579)

Sorry I forgot to click on that, just did it.

So can you please add VBexperience shop back? I enjoyed it a lot back when I had vb3.8...

The Shop has been replaced by the Market System, there is no way back. Sorry.

argothiusz

10-08-2010 01:42 AM

I have some question regarding managing Awards. Ok, here is what I did

Add New Awards - Set title, description, images - assign awards manually to user id (232,111,666) then save.

I don't want this award to give out automatically but rather only admin can give them out to specific user. However, after I added the award, recount the award, and even run scheduled task for vbexperience award, it's still not being updated. I check the award tab inside vbexperience but the award is not there. I also check the user postbit, and its still not there either.

Any idea? Apparently, its only work if I set the award to assign automatically with the value of 0. I also noticed one more thing, I dont see the "Test" link next to the award inside admin cpanel.

Thanks

All times are GMT. The time now is 04:36 AM.

Page 133 of 270

133

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02514 seconds Memory Usage 1,781KB 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_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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
Messages: