search

NomisCZ / hlstatsx-community-edition

HLstatsX Community Edition - PHP 7 and GeoIP2 supported
GNU General Public License v2.0
83 stars 48 forks source link

Error importing install.sql in database #13

Closed Anton-Beresansky closed 5 years ago

Anton-Beresansky commented 5 years ago 
Import successfully completed, completed 119 requests.
Notice in ./vendor/phpmyadmin/sql-parser/src/Components/OptionsArray.php#217
 Trying to get property 'expr' of non-object

Backtrace

./vendor/phpmyadmin/sql-parser/src/Components/CreateDefinition.php#251: PhpMyAdmin\SqlParser\Components\OptionsArray::parse(
,
,
array,
)
./vendor/phpmyadmin/sql-parser/src/Statements/CreateStatement.php#432: PhpMyAdmin\SqlParser\Components\CreateDefinition::parse(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Statement.php#90: PhpMyAdmin\SqlParser\Statements\CreateStatement->parse(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Parser.php#500: PhpMyAdmin\SqlParser\Statement->__construct(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Parser.php#376: PhpMyAdmin\SqlParser\Parser->parse()
./libraries/classes/Tracker.php#655: PhpMyAdmin\SqlParser\Parser->__construct(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ')
./libraries/classes/Tracker.php#807: PhpMyAdmin\Tracker::parseQuery(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ')
./libraries/classes/DatabaseInterface.php#350: PhpMyAdmin\Tracker::handleQuery(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ')
./libraries/classes/Import.php#96: PhpMyAdmin\DatabaseInterface->tryQuery(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8')
./libraries/classes/Import.php#256: PhpMyAdmin\Import::executeQuery(
string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
array,
)
./libraries/classes/Plugins/Import/ImportSql.php#158: PhpMyAdmin\Import::runQuery(
string '-- -------------------------------------------------------- -- -- Table structure for table `hlstats_Players_Awards` -- CREATE TABLE IF NOT EXISTS `hlstats_Players_Awards` ( `awardTime` date NOT NULL, `awardId` int(11) unsigned NOT NULL default \'0\', `playerId` int(11) unsigned NOT NULL default \'0\', `count` int(11) unsigned NOT NULL default \'0\', `game` varchar(32) NOT NULL, PRIMARY KEY (`awardTime`,`awardId`,`playerId`,`game`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
string '-- -------------------------------------------------------- -- -- Table structure for table `hlstats_Players_Awards` -- CREATE TABLE IF NOT EXISTS `hlstats_Players_Awards` ( `awardTime` date NOT NULL, `awardId` int(11) unsigned NOT NULL default \'0\', `playerId` int(11) unsigned NOT NULL default \'0\', `count` int(11) unsigned NOT NULL default \'0\', `game` varchar(32) NOT NULL, PRIMARY KEY (`awardTime`,`awardId`,`playerId`,`game`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
array,
)
./import.php#554: PhpMyAdmin\Plugins\Import\ImportSql->doImport(array)
Anton-Beresansky commented 5 years ago 
nginx/1.14.0
client db version: libmysql - mysqlnd 5.0.12-dev - 20150407
PHP extension: mysqli curl mbstring
PHP version: 7.2.17-0
ubuntu: 18.04.1
phpMyAdmin version: 4.8.5
NomisCZ commented 5 years ago

Hi, looks like you're having problems with your phpMyAdmin, but the SQL is successfully imported (first line). So it's not related to HLStatsX.

You can try to import database using command line: mysql -u<db_user> -p<db_user_password> <database_name> < install.sql

Anton-Beresansky commented 5 years ago 
mysql -umyuser -pmypassword mydatabase < install.sql
Table   Op  Msg_type    Msg_text
test.hlstats_Ranks  optimize    status  OK