Member
|
07-05-2019
, 04:53
Re: GeoIP2 in HLXCE
|
#15
|
i added that code to the top where you said .. still blank page.
i noticed that when i import the db i get this errors :
Code:
Notice in ./vendor/phpmyadmin/sql-parser/src/Components/OptionsArray.php#217
Trying to get property 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#435: 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#477: PhpMyAdmin\SqlParser\Statement->__construct(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Parser.php#353: 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; ')
./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=utf8mb4 COLLATE=utf8mb4_unicode_ci; ')
./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=utf8mb4 COLLATE=utf8mb4_unicode_ci')
./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=utf8mb4 COLLATE=utf8mb4_unicode_ci')
./libraries/classes/Import.php#257: 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=utf8mb4 COLLATE=utf8mb4_unicode_ci',
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=utf8mb4 COLLATE=utf8mb4_unicode_ci',
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=utf8mb4 COLLATE=utf8mb4_unicode_ci',
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=utf8mb4 COLLATE=utf8mb4_unicode_ci',
array,
)
./import.php#554: PhpMyAdmin\Plugins\Import\ImportSql->doImport(array)
what can cause that ?
mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper
PHP 5.6.40-1+ubuntu18.04.1+deb.sury.org+1 (cli)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
with Xdebug v2.5.5, Copyright (c) 2002-2017, by Derick Rethans
curl 7.58.0 (x86_64-pc-linux-gnu) libcurl/7.58.0 OpenSSL/1.1.1a zlib/1.2.11 libidn2/2.0.4 libpsl/0.19.1 (+libidn2/2.0.4) nghttp2/1.30.0 librtmp/2.3
This is perl 5, version 26, subversion 1 (v5.26.1) built for x86_64-linux-gnu-thread-multi
(with 67 registered patches, see perl -V for more detail)
Last edited by vn_lind; 07-05-2019 at 05:00.
|
|