Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
MySQL error Details »»
MySQL error
Version: , by mathforum mathforum is offline
Developer Last Online: May 2020 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 08-14-2006 Last Update: Never Installs: 0
 
No support by the author.

I've installed everything and re-uploaded to make sure I didn't miss anything, but I keep getting this MySQL error:

mySQL query error: SELECT g.gid, g.active, count(*) nb, g.bestscore, g.bestmid AS champ_mid, u.username AS champ_name FROM games_list AS g INNER JOIN user AS u ON u.userid=g.bestmid WHERE active=1 GROUP BY bestmid ORDER BY 3 DESC LIMIT 1

mySQL error: Unknown column 'g.bestscore' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:31:47 PM

when I try to access arcade.php on my main site and

mySQL query error: SELECT usergroupid, title, arcade_access, p_require, max_play, ppd_require, ibpa_cats, tourney FROM usergroup

mySQL error: Unknown column 'tourney' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:34:01 PM

when I access Group Permissions from my AdminCP

I uploaded version 2.5.6 but in my product manager it says I have version 2.5.3.

Please help

Fixed! No help needed. Thank you MrZeroPage!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 08-18-2006, 01:33 PM
Wolf_Hook Wolf_Hook is offline
 
Join Date: Jun 2006
Location: England
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Kind of the on the same lines.

mySQL query error: INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('13', 'Dundon's W.G.P', 'Your Highscore got beaten', 'This is an automatically generated message

Hello futix76

your Highscore in the game Pacman got beaten.

Click here to check the Highscores or here to play the game and claim back the Highscore !

Enjoy the Arcade

', '6', 0, 1155867338, 0, 0)

mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's W.G.P', 'Your Highscore got beaten', '[size=1][i]This is an a
mySQL error code:
Date: Thursday 17th of August 2006 07:15:38 PM

Fella on my forum has beaten a Pacman score twice in succession but receives this error after submitting a score.

Now that is to do with the auto PM sent but this is the first time a user has posted this error.

Occasionally members complain about not being able to register a high score as well. I am not sure if it is connected at all.
Reply With Quote
  #3  
Old 08-18-2006, 03:57 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the username has special characters in it

This is fixed for v2.5.7+


you should do the following to quick-fix it:

open /arcade.php

search for
Code:
$DB->query("INSERT INTO ibf_pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('".$senderid."', '".$sendername."', '".$title."', '" . addslashes($message) . "',  '" . $recipient . "', 0, " . TIMENOW . ", 0, 0)");
and replace it with
Code:
$DB->query("INSERT INTO ibf_pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('".$senderid."', '".addslashes($sendername)."', '".$title."', '" . addslashes($message) . "',  '" . $recipient . "', 0, " . TIMENOW . ", 0, 0)");
Reply With Quote
  #4  
Old 08-18-2006, 04:15 PM
Wolf_Hook Wolf_Hook is offline
 
Join Date: Jun 2006
Location: England
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

WOW, I got a response!

Thanks for that. My members love this arcade so thanks for coding it.
Reply With Quote
  #5  
Old 08-18-2006, 05:58 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Wolf_Hook
WOW, I got a response!
Why should you not ?
Reply With Quote
  #6  
Old 08-18-2006, 09:36 PM
Wolf_Hook Wolf_Hook is offline
 
Join Date: Jun 2006
Location: England
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have had some problems recently with another mod and it seems that if you have a problem then you try and fix it yourself. No one was supporting it.
Reply With Quote
  #7  
Old 08-19-2006, 08:02 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well... welcome to ibProArcade
Reply With Quote
  #8  
Old 08-20-2006, 06:16 AM
Neo_obs Neo_obs is offline
 
Join Date: Mar 2006
Location: Disneyland, CA
Posts: 363
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Zeropage is very good on support and I believe he should be getting alot of credit all over for his excellent support on his work. He works and helps us and helps the forums I believe he deserves a round of applause.

/me applauds
Reply With Quote
  #9  
Old 10-17-2006, 02:45 AM
Wheels's Avatar
Wheels Wheels is offline
 
Join Date: Dec 2005
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mathforum
I've installed everything and re-uploaded to make sure I didn't miss anything, but I keep getting this MySQL error:

mySQL query error: SELECT g.gid, g.active, count(*) nb, g.bestscore, g.bestmid AS champ_mid, u.username AS champ_name FROM games_list AS g INNER JOIN user AS u ON u.userid=g.bestmid WHERE active=1 GROUP BY bestmid ORDER BY 3 DESC LIMIT 1

mySQL error: Unknown column 'g.bestscore' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:31:47 PM

when I try to access arcade.php on my main site and

mySQL query error: SELECT usergroupid, title, arcade_access, p_require, max_play, ppd_require, ibpa_cats, tourney FROM usergroup

mySQL error: Unknown column 'tourney' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:34:01 PM

when I access Group Permissions from my AdminCP

I uploaded version 2.5.6 but in my product manager it says I have version 2.5.3.

Please help

Fixed! No help needed. Thank you MrZeroPage!

How did you fix it? I've been having that error on a friend's forum for about a week.

Edit: My cousin fixed it. Was an issue with the game_list table, which was corrupted. Simply uploading a back-up fixed it.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 01:02 AM.


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.04975 seconds
  • Memory Usage 2,285KB
  • Queries Executed 24 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete