vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - gXboxLive - Xbox Live Leaderboard (https://vborg.vbsupport.ru/showthread.php?t=139958)

Butcher 01-26-2008 03:01 PM

just updated and it all seems to work fine except i keep getting sent DB error's. Which is strange as it does look too work fine.

*EDIT*

Sorry missed that you updated the mod again, so i've uploaded the php file and product again and all is fine, my bad :(

TCE Killa 01-26-2008 03:25 PM

^That is exactly what I get after upgrading.

HellBoy 01-26-2008 04:33 PM

Updated to 2.1.3, works just fine. :)

TCE Killa 01-26-2008 07:58 PM

Quote:

Originally Posted by Queball_Beast (Post 1429056)
I got this error after the the upgrade. Product disable for the time being.

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reputation) AS `reputation`,
SUM(gxboxlive.gold) AS `gold`
FROM
`gpuser` AS user
LEFT JOIN
`gpuserfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gpgxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN(8)

AND
field0 != ''
AND
user.posts >= '10'
AND
user.lastvisit >= '0'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

MySQL Error : Unknown column 'field0' in 'where clause'
Error Number : 1054
Date : Friday, January 25th 2008 @ 10:10:32 PM
Script : http://www.gamerspride.com/phpBB2/online.php
Referrer : http://www.gamerspride.com/phpBB2/online.php
IP Address : **********
Username : ********
Classname : vb_database


Nope sorry, this is the exact error I get when updating.

I have disabled for the time being too.

How do you fix it? Thanks.

Butcher 01-26-2008 08:01 PM

the fix for yours was already given in the post afterwards :)

see here https://vborg.vbsupport.ru/showpost....&postcount=474
just update your field id number

Gryphon 01-26-2008 10:45 PM

Thank you Butcher, that is correct.

Deadly Assassin 01-27-2008 04:17 AM

Ace update, thanks alot.

Lovin this Mod/Hack :up:

Just one thing, because i am using the postbit_legacy, i assume thats why the showthreads part doesn't work for me?

face311 01-27-2008 04:33 AM

Fatal error: Call to undefined function gxbl_has_access() in /usr/home/****/***/forum/global.php(360) : eval()'d code on line 6

Does anyone know what this could be ?

Gryphon 01-27-2008 05:23 AM

Quote:

Originally Posted by Deadly Assassin (Post 1429798)
Ace update, thanks alot.

Lovin this Mod/Hack :up:

Just one thing, because i am using the postbit_legacy, i assume thats why the showthreads part doesn't work for me?

It should work fine as long at the hooks are in place within the template.

Quote:

Originally Posted by face311 (Post 1429807)
Fatal error: Call to undefined function gxbl_has_access() in /usr/home/****/***/forum/global.php(360) : eval()'d code on line 6


Does anyone know what this could be ?

That commonly means that the functions file has not been updated or is missing. Double check that all files have been uploaded to the proper locations.

face311 01-27-2008 05:36 AM

Quote:

Originally Posted by Gryphon (Post 1429828)
It should work fine as long at the hooks are in place within the template.



That commonly means that the functions file has not been updated or is missing. Double check that all files have been uploaded to the proper locations.

yea I figured Im new at this hopefully Ill find it


All times are GMT. The time now is 05:28 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.02025 seconds
  • Memory Usage 1,741KB
  • 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