Fatal error: SQL #10

  • New
  • Defect
Open
Assigned to
View _ForgeUser7509252's Profile
_ForgeUser7509252
  • View _ForgeUser8603257's Profile
    _ForgeUser8603257 created this issue Jul 7, 2012

    What steps will reproduce the problem?
    1. Installing Minescore, and setting it completely up.
    2. Opening the browser, and go to mineland.co/minescore.
    3. Getting this error on every page: Fatal error: SQL in /home/mineland/public_html/minescore/mobhighscores.php on line 17

    What is the expected output? What do you see instead?
    My expected output is that it will show the highscores, but it doesn't.

    What version of the product are you using?
    I'm using v0.8.1

    Do you have an error log of what happened?
    Sorry, I don't.

    Please provide any additional information below.
    I use my SQL database for many others things, so my database works.
    I've put the correct information in the config.

  • View _ForgeUser8603257's Profile
    _ForgeUser8603257     added the tags New Defect Jul 7, 2012
  • View _ForgeUser7509252's Profile
    _ForgeUser7509252 posted a comment Jul 7, 2012

    did you run this query to create the correct tables properly? 

    CREATE DATABASE highscores;
USE highscores;
CREATE TABLE pvphighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL,
rating INT( 11 ) NOT NULL,
honor INT( 11 ) NOT NULL,
current INT( 11 ) NOT NULL,
killstreak INT( 11 ) NOT NULL);
CREATE TABLE mobhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
CREATE TABLE minehighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
coal INT( 11 ) NOT NULL DEFAULT 0,
iron INT( 11 ) NOT NULL DEFAULT 0,
redstone INT( 11 ) NOT NULL DEFAULT 0,
lapis INT( 11 ) NOT NULL DEFAULT 0,
gold INT( 11 ) NOT NULL DEFAULT 0,
obby INT( 11 ) NOT NULL DEFAULT 0,
diamond INT( 11 ) NOT NULL DEFAULT 0);
CREATE TABLE farmhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
wheat INT( 11 ) NOT NULL DEFAULT 0,
melon INT( 11 ) NOT NULL DEFAULT 0,
pumpkin INT( 11 ) NOT NULL DEFAULT 0,
pwheat INT( 11 ) NOT NULL DEFAULT 0,
pmelon INT( 11 ) NOT NULL DEFAULT 0,
ppumpkin INT( 11 ) NOT NULL DEFAULT 0);
CREATE TABLE blocks (location VARCHAR( 1000 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL);
    Edited Jul 7, 2012
  • View _ForgeUser8603257's Profile
    _ForgeUser8603257 posted a comment Jul 8, 2012

    @Kamisoyokaze: Go

    I'm sorry, I don't know what you mean. The only thing I did was put in my MySQL information in the file "config", located in the folder "website", then I uploaded it to my web host.

  • View _ForgeUser7509252's Profile
    _ForgeUser7509252 posted a comment Jul 8, 2012

    Ok in that case the plugin is trying to connect to a database that doesn't exist. In the instruction file it states you need to enter a query use the query I posted on the main page of the plugin (or the last post in this ticket) as the one i provided in the file is incorrect. Anyhow, you need to go into phpmyadmin or some where where you can type in a SQL query to your database and enter the query. Once you have done this it should work.

To post a comment, please login or register a new account.