vb.org Archive - Add-On Releases - gXboxLive

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
vb_user.*,
vb_userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`vb_userfield`
INNER JOIN
vb_usergroup AS usergroup ON(usergroup.usergroupid = vb_user.usergroupid)
LEFT JOIN
`vb_user` ON vb_userfield.userid = vb_user.userid
WHERE
vb_user.posts >= '0'
AND
vb_userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'vb_user.usergroupid' in 'on clause'
Error Number : 1054
Date : Monday, March 5th 2007 @ 02:58:43 AM
Script : http://www.premiumbattles.com/forums...cron&cronid=18
Referrer : http://www.premiumbattles.com/forums....php?do=modify
IP Address : 83.100.162.12
Username : Matt
Classname : vB_Database

Spinball

03-05-2007 09:41 AM

Hello,
nice hack. We have used one of our userfields for the XBL gamertag for some time and have 2,300 members with a gamertag entered.
I have reduced the frequency of the scheduled task to every hour but still only have the details of 275 members in the gxboxlive table.
I have just changed it to update once a day.
Do you have an idea of how long it takes to retrieve the data for 2,300 members?
Will it cause excess load on the server?
http://www.avforums.com/forums/gxboxlive.php

[edit : having looked through the scheduled task log, there are no entries for the gxboxlive task]

PabloAM

03-05-2007 11:20 AM

Quote:

Originally Posted by Blackjack (Post 1195050)

Neoka21, sorry this product is for vBulletin 3.6, there are plugin changes that aren't available in 3.5. However, I can look into making it 3.5 compatible.

Sorry, I got sidetracked on about 4 other modifications I'm working on. I will look into correcting this database error soon. v1.21 should work in the meantime until I can release v1.32.

Thanks Jack ;)

Gryphon

03-05-2007 03:53 PM

Quote:

Originally Posted by Spinball (Post 1196080)

Do you have an idea of how long it takes to retrieve the data for 2,300 members?

Spinball, I'm afraid that vBulletin's cron may not be powerful enough to handle large gamertag processes. I will have to work on splitting up the processes into smaller chunks in order to make this more efficient, until then, there may be no fix other than to run the tak manually occasionally. I've been monitoring some boards with thousands of users and they appear to work ok, though server setup can play a large roll in how well they will do.

Improving this is on top of my list of things to do.

Canis Firebrand

03-05-2007 04:03 PM

Nice :)

Uploaded the xboxlive.php, miner.gxboxlive.php files from the 1.32 zip file. Imported product with Overwrite enabled.

Manually ran the cron job. No errors and everything works beautifully now. Thanks for a fast update and fix for the issue. It was odd that some people had it and others didn't.

Awesome job with this product.

Gryphon

03-05-2007 04:35 PM

Thanks. I most likely didn't follow coding standards in creating my mySQL statement and people with less strict settings/older software/different permissions on their servers let it slip by while others error. I will have to learn what it is I did wrong in order to eliminate banned users from the listing.

Spinball

03-06-2007 05:51 PM

Quote:

Originally Posted by Blackjack (Post 1196354)

Thanks for the reply.

Inferno Dragon

03-07-2007 12:25 PM

brilliant addon I will use it in the future :) keep up the good work Blackjack!

*Voted for MOTM" :)

All times are GMT. The time now is 01:29 PM.

Page 8 of 127

« First

108

Last »

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

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