vb.org Archive
Page 7 of 127 « First 56 7 891757107 Last »
Show 40 post(s) from this thread on one page

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)

powerbook 02-28-2007 05:03 PM
I dropped the two tables manually and now the issue seems to be fixed... Thanks

Neoka21 03-03-2007 06:41 AM
hi!, i have this problem:

Database error in vBulletin 3.5.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vb_plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'gXBL Cache', 'cache_templates', '$globaltemplates[] = \'gxbl_vbnav_quicklink\';\r\n$globaltemplates[] = \'gxbl_vbnav_navbarlink\';', 'gXboxLive');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Saturday, March 3rd 2007 @ 02:24:20 AM
Script : http://www.gamersforce.com.mx/foro/admincp/plugin.php
Referrer : http://www.gamersforce.com.mx/foro/a...?do=productadd
IP Address : 189.135.237.220
Username : Neoka21
Classname : vb_database

josh_B 03-03-2007 11:20 AM
I installed this, very nice by the way, however, some have high scores etc.. but there are no icons for games played.. Rest have them.. Is there an icon set I need to update from time to time?

PabloAM 03-03-2007 06:03 PM
Quote:
Originally Posted by Canis Firebrand (Post 1192534)
I uploaded the files and overwrote the older version I had. When I view my list, the gamertag icons and games aren't there.
So, I tried to force the cron job to run. When I do so, I get a database error.

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error  : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date        : Wednesday, February 28th 2007 @ 04:48:56 AM
I looked at my phpadmin and the user table does have a field called usergroupid. So, I'm not sure why it is saying that it is an unknown column.

Also, in the Leaderboard Statistics section, the Top Avatar just reads "By 2 players By 2 players By 2 players By 1 player By 1 player"

That might be because the cron job won't run, however.
Same problem :(

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Saturday, March 3rd 2007 @ 08:57:58 PM
Script : http://www.xboxers360.net/admincp/cr...cron&cronid=25
Referrer : http://www.xboxers360.net/admincp/cr....php?do=modify
IP Address : 81.202.163.34
Username : PabloAM
Classname : vB_Database
One solution?

Gryphon 03-03-2007 07:30 PM
Quote:
Originally Posted by Neoka21 (Post 1194660)
hi!, i have this problem:

Database error in vBulletin 3.5.2:
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.

Quote:
Originally Posted by PabloAM (Post 1194997)
Same problem :(

One solution?
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.

ORACLE 03-04-2007 02:11 PM
Hi im getting this error on 3.6.4 does it have to be 3.6.5???
thanks
Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Sunday, March 4th 2007 @ 04:06:56 PM
Script : http://www.digital-community.co.uk/f...cron&cronid=25
Referrer : http://www.digital-community.co.uk/f...Dedit%26u%3D22
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database

ORACLE 03-04-2007 03:46 PM
im not using 3.6.5 and i get this i think its the same not checked properly:
Quote:
Database error in vBulletin 3.6.5:

Invalid SQL:

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

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Sunday, March 4th 2007 @ 05:45:34 PM
Script : http://www.digital-community.co.uk/f...cron&cronid=26
Referrer : http://www.digital-community.co.uk/f...incp/index.php
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database

Gryphon 03-04-2007 07:42 PM
Thank you, yes it is compatible with all 3.6.x, I have an error in my query statement as reported by two others already. I need a few more days to get some time to sort it out. This error will exist as long as v1.31 is the latest version.

WNxWakko 03-04-2007 07:45 PM
ONly problem for me is that I have an xbox mod to display them in profiles and such, however I dont use a custom field. I actually cloned the msn, icq etc. so my field is called xbox and your script doesnt acknoledge that?? How can I make this pull from my xbox titled field?

Gryphon 03-04-2007 07:50 PM
Hmm, that will require the query to be completely different. Is it a public mod available here? I can look into making it compatible.


All times are GMT. The time now is 09:52 PM.
Page 7 of 127 « First 56 7 891757107 Last »
Show 40 post(s) from this thread on one page

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.01632 seconds
  • Memory Usage 1,757KB
  • 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
  • (1)bbcode_code_printable
  • (6)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