Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 09 Feb 2008, 19:13
nickypoooo's Avatar
nickypoooo nickypoooo is offline
 
Join Date: Aug 2007
mySQL query error -- Highscores

Hello, this is a great mod and my members are lovin it..

I was hoping someone can help me with this SQL error I'm getting

My member complained that the scores are not updated for all games so I got in to the 'Arcade - Management' and ran 'Update Highscores' with no luck and got this SQL error:

mySQL query error: SELECT champ_gid, champ_mid, champ_score, champ_time FROM games_champs WHERE champ_gid IN (Array)

mySQL error: Unknown column 'Array' in 'where clause'
mySQL error code:
Date: Friday 08th of February 2008 09:36:30 PM




I am running vb 3.6.8 with ibProArcade v2.6.6+


Thank you for your time.
Comments
  #2  
Old 09 Feb 2008, 20:29
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
you selected some games before ?
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 148.000 downloads!):
ibProArcade 2.7.6+ download here | Click here to enter the ibProArcade-Support-Section
Don't miss the new Google Analytics Integration (GDPR/DSGVO) for vB4.x
  #3  
Old 10 Feb 2008, 02:17
nickypoooo's Avatar
nickypoooo nickypoooo is offline
 
Join Date: Aug 2007
Originally Posted by MrZeropage View Post
you selected some games before ?
Thank you for your reply, I'm not sure what you mean.. I did install some games but it was long time ago and did not have any problem.

This problem came up only a few days ago, I'm getting this error when running Arcade - Management Score Pruning

mySQL query error: SELECT * FROM games_scores WHERE gid IN (Array) ORDER BY name ASC

mySQL error: Unknown column 'Array' in 'where clause'
mySQL error code:
Date: Saturday 09th of February 2008 05:13:21 PM
and I get this error when running Update Highscores

mySQL query error: SELECT gid, highscore_type, gtitle FROM games_list WHERE gid IN (Array) ORDER by gid

mySQL error: Unknown column 'Array' in 'where clause'
mySQL error code:
Date: Saturday 09th of February 2008 05:14:26 PM

Thank you for your time.
  #4  
Old 11 Feb 2008, 15:31
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
in the score-pruning, you first have to select the games that should be pruned - you've done this ?
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 148.000 downloads!):
ibProArcade 2.7.6+ download here | Click here to enter the ibProArcade-Support-Section
Don't miss the new Google Analytics Integration (GDPR/DSGVO) for vB4.x
 



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 03:18.

Layout Options | Width: Wide Color: