vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   MySQL error (https://vborg.vbsupport.ru/showthread.php?t=123975)

mathforum 08-14-2006 09:27 PM

MySQL error
 
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!

Wolf_Hook 08-18-2006 01:33 PM

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.

MrZeropage 08-18-2006 03:57 PM

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)");

Wolf_Hook 08-18-2006 04:15 PM

WOW, I got a response!

Thanks for that. My members love this arcade so thanks for coding it.

MrZeropage 08-18-2006 05:58 PM

Quote:

Originally Posted by Wolf_Hook
WOW, I got a response!

Why should you not ?

Wolf_Hook 08-18-2006 09:36 PM

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.

MrZeropage 08-19-2006 08:02 AM

Well... welcome to ibProArcade :)

Neo_obs 08-20-2006 06:16 AM

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

Wheels 10-17-2006 02:45 AM

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.


All times are GMT. The time now is 10:22 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.02640 seconds
  • Memory Usage 1,737KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete