Maplebit Problem

Results 1 to 10 of 10
  1. #1
    Registered Joey1202 is offline
    MemberRank
    Apr 2014 Join Date
    20Posts

    Maplebit Problem

    Maplebit Problem
    Anyone know how to fix this? I'm using a VPS on NFOServers. My operating system I am using is CentOS 6.



    This happens straight after 'Execute MySQL'


  2. #2
    Registered Omni is offline
    MemberRank
    Jul 2018 Join Date
    17Posts

    Re: Maplebit Problem

    You need to import the game server SQL files prior to the MapleBit installation.

    Check for SQL files in your MapleStory source directory.

  3. #3
    Registered Joey1202 is offline
    MemberRank
    Apr 2014 Join Date
    20Posts

    Re: Maplebit Problem

    I imported the game server SQL before, still didn't work...? I'm using MapleSolaxia.

  4. #4
    Registered Omni is offline
    MemberRank
    Jul 2018 Join Date
    17Posts

    Re: Maplebit Problem

    I ran into similar issues when performing tests in a few environments:
    * [FAILED] Ubuntu 18.04 - Apache 2.4.7 - PHP 7.2
    * [FAILED] Ubuntu 14.04 - Apache 2.4.7 - PHP 5.5.9-1ubuntu4.26
    * [SUCCESS] OSX 10.14.3 - Apache 2.4.34 - PHP 7.1.23

    All were connecting to a remote MySQL server:
    5.5.62 MySQL Community Server (GPL)

    Errors found in the Apache logs suggest the code is written poorly.

    Can you share your error logs? Execute the following command:
    cat /var/log/apache2/error.log

  5. #5
    Registered Joey1202 is offline
    MemberRank
    Apr 2014 Join Date
    20Posts

    Re: Maplebit Problem

    I fixed the problem, just had to find database.php in assets/config and set my database details.

    Now at the register page, this is what's happening:

  6. #6
    Registered Omni is offline
    MemberRank
    Jul 2018 Join Date
    17Posts

    Re: Maplebit Problem

    You will need to view the error logs or configure error display to discover why PHP is failing.

  7. #7
    Registered Joey1202 is offline
    MemberRank
    Apr 2014 Join Date
    20Posts

    Re: Maplebit Problem

    The error:
    PHP Parse error: syntax error, unexpected '[' in /var/www/html/sources/public/register.php on line 14

    The line of code:
    return $mysqli->query("SELECT COUNT(*) FROM accounts WHERE $param ='".$mysqli->real_escape_string($input[$field])."'")->fetch_row()[0] == 0;

    EDIT: The line of code had to be changed to this:
    return $mysqli->query("SELECT COUNT(*) FROM accounts WHERE $param ='".$mysqli->real_escape_string($input[$field])."'")->fetch_row(0) == 0;

  8. #8
    very green greenelfx is offline
    True MemberRank
    Jul 2011 Join Date
    1,322Posts

    Re: Maplebit Problem

    Quote Originally Posted by Joey1202 View Post
    The error:
    PHP Parse error: syntax error, unexpected '[' in /var/www/html/sources/public/register.php on line 14

    The line of code:
    return $mysqli->query("SELECT COUNT(*) FROM accounts WHERE $param ='".$mysqli->real_escape_string($input[$field])."'")->fetch_row()[0] == 0;

    EDIT: The line of code had to be changed to this:
    return $mysqli->query("SELECT COUNT(*) FROM accounts WHERE $param ='".$mysqli->real_escape_string($input[$field])."'")->fetch_row(0) == 0;
    Can you verify these queries are actually able to run from your webpage to your DB? Looks like something's messed up with your connection to MySQL, either on the web end of things or in your sql db server

  9. #9
    Registered muzukashii is offline
    MemberRank
    Feb 2019 Join Date
    6Posts

    Re: Maplebit Problem

    You have to check all the files, i'm currently using this CMS too and i have to correct php syntax to prevent from Fatal error when try to login and register.

    If you need my help, you can contact me via discord.
    MisterBT#6061

  10. #10
    Registered Hoxer is offline
    MemberRank
    Nov 2016 Join Date
    7Posts

    Re: Maplebit Problem

    go to your /site/assets/config folder
    # cd /assets/config
    chmod 777 database.php
    after you're done installing chmod the file back
    chmod 644 database.php
    Last edited by Hoxer; 22-03-20 at 10:51 AM.



Advertisement