Unhandled exception executing command 'f accept' in f: SQLite3::query(): near "*": syntax error

[teracube]

Hi,

Error : Unhandled exception executing command 'f accept' in f: SQLite3::query(): near "*": syntax error

PocketMine-MP 1.7dev-71
FactionsPro 1.3.11-2.alpha8 =)  FactionsPro_dev-17.phar

2017-09-24 [09:42:46] �[Server thread/CRITICAL]: Unhandled exception executing command 'f accept' in f: SQLite3::query(): near "*": syntax error�
2017-09-24 [09:42:46] �[Server thread/CRITICAL]: ErrorException: "SQLite3::query(): near "*": syntax error" (EXCEPTION) in "FactionsPro_dev-17.phar/src/FactionsPro/FactionCommands" at line 621�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #0 (): pocketmine\{closure}(integer 2, string SQLite3::query(): near "*": syntax error, string phar:///home/gsp_1485/g3.hmserv.eu-19144/plugins/FactionsPro_dev-17.phar/src/FactionsPro/FactionCommands.php, integer 621, array Array())�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #1 FactionsPro_dev-17.phar/src/FactionsPro/FactionCommands(621): SQLite3->query(string DELETE * FROM confirm WHERE player='lisa06500';)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #2 FactionsPro_dev-17.phar/src/FactionsPro/FactionMain(106): FactionsPro\FactionCommands->onCommand(pocketmine\Player object, pocketmine\command\PluginCommand object, string f, array Array())�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #3 src/pocketmine/command/PluginCommand(58): FactionsPro\FactionMain->onCommand(pocketmine\Player object, pocketmine\command\PluginCommand object, string f, array Array())�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #4 src/pocketmine/command/SimpleCommandMap(241): pocketmine\command\PluginCommand->execute(pocketmine\Player object, string f, array Array())�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #5 src/pocketmine/Server(1952): pocketmine\command\SimpleCommandMap->dispatch(pocketmine\Player object, string f accept)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #6 src/pocketmine/Player(2093): pocketmine\Server->dispatchCommand(pocketmine\Player object, string f accept)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #7 src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(219): pocketmine\Player->chat(string /f accept)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #8 src/pocketmine/network/mcpe/protocol/CommandRequestPacket(47): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleCommandRequest(pocketmine\network\mcpe\protocol\CommandRequestPacket object)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #9 src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(91): pocketmine\network\mcpe\protocol\CommandRequestPacket->handle(pocketmine\network\mcpe\PlayerNetworkSessionAdapter object)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #10 src/pocketmine/network/mcpe/protocol/BatchPacket(115): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleDataPacket(pocketmine\network\mcpe\protocol\CommandRequestPacket object)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #11 src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(91): pocketmine\network\mcpe\protocol\BatchPacket->handle(pocketmine\network\mcpe\PlayerNetworkSessionAdapter object)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #12 src/pocketmine/Player(3097): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleDataPacket(pocketmine\network\mcpe\protocol\BatchPacket object)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #13 src/pocketmine/network/mcpe/RakLibInterface(143): pocketmine\Player->handleDataPacket(pocketmine\network\mcpe\protocol\BatchPacket object)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #14 src/raklib/server/ServerHandler(97): pocketmine\network\mcpe\RakLibInterface->handleEncapsulated(string 88.187.126.16:57881, raklib\protocol\EncapsulatedPacket object, integer 0)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #15 src/pocketmine/network/mcpe/RakLibInterface(82): raklib\server\ServerHandler->handlePacket()�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #16 src/pocketmine/network/Network(89): pocketmine\network\mcpe\RakLibInterface->process()�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #17 src/pocketmine/Server(2485): pocketmine\network\Network->processInterfaces()�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #18 src/pocketmine/Server(2238): pocketmine\Server->tick()�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #19 src/pocketmine/Server(2117): pocketmine\Server->tickProcessor()�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #20 src/pocketmine/Server(1699): pocketmine\Server->start()�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #21 src/pocketmine/PocketMine(553): pocketmine\Server->__construct(BaseClassLoader object, pocketmine\utils\MainLogger object, string phar:///home/gsp_1485/g3.hmserv.eu-19144/PocketMine-MP.phar/, string /home/gsp_1485/g3.hmserv.eu-19144/, string /home/gsp_1485/g3.hmserv.eu-19144/plugins/)�
2017-09-24 [09:42:46] �[Server thread/DEBUG]: #22 /home/gsp_1485/g3.hmserv.eu-19144/PocketMine-MP.phar(1): require(string phar:///home/gsp_1485/g3.hmserv.eu-19144/PocketMine-MP.phar/src/pocketmine/PocketMine.php)�

---------------------------------------------------------------------------------------------------------------
PocketMine-MP 1.7dev-71: AlwaysSpawn 2.2.3-1.alpha8; ChatToDiscord 1.1.0; AllSigns 1.0.3; VPNGuard 1.0.6; ItemCasePE 1.2.0-alpha8; EconomyAPI 5.7.1-1.alpha8; PiggyCustomEnchants 1.0.2; KillMoney 1.1.3; SimpleAuth 2.1.0-map.5; essentialsTP 1.2.0-1.alpha8; iProtector 4.0.3#3.1b; Parkour 1.5.6-1.alpha8; PurePerms 1.4.1-1.alpha8; Slapper 1.3.6; BanItem 2.3.2-1.alpha8; xyz 1.0.3; EconomyShop 2.0.8-1.alpha8; SimpleAuthHelper 2.0.6-1.alpha8; PureChat 1.4.10-2.alpha8; FactionsPro 1.3.11-2.alpha8

[Awzaw]

Please try the latest build

[teracube]

i had this issue with this build

https://poggit.pmmp.io/r/11966/FactionsPro_dev-17.phar

it's the latest build no ?
thanks

[Awzaw]

Well spotted, that bug has been there since Tethered's very first release over 2 years ago! Should be fixed now.

[teracube]

@Awzaw

sorry to post here, because i have no open issue button on FactionsPro_1.4_dev

issue : Unhandled exception executing command 'f home' in f:
FactionsPro_1.4_dev
PocketMine-MP_1.7dev-132

Version :
https://poggit.pmmp.io/r/12888/FactionsPro_1.4_dev-19.phar
https://jenkins.pmmp.io/job/PocketMine-MP/lastSuccessfulBuild/artifact/PocketMine-MP_1.7dev-132_b54f256f_API-3.0.0-ALPHA9.phar

2017-10-02 [16:58:33] �[Server thread/CRITICAL]: Unhandled exception executing command 'f home' in f: Argument 1 passed to pocketmine\Server::getLevelByName() must be of the type string, null given, called in phar:///home/gsp_1589/g9.hmserv.eu-19199/plugins/FactionsPro_1.4_dev-19.phar/src/FactionsPro/FactionCommands.php on line 541� 2017-10-02 [16:58:33] �[Server thread/CRITICAL]: TypeError: "Argument 1 passed to pocketmine\Server::getLevelByName() must be of the type string, null given, called in phar:///home/gsp_1589/g9.hmserv.eu-19199/plugins/FactionsPro_1.4_dev-19.phar/src/FactionsPro/FactionCommands.php on line 541" (EXCEPTION) in "src/pocketmine/Server" at line 963� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #0 FactionsPro_1.4_dev-19.phar/src/FactionsPro/FactionCommands(541): pocketmine\Server->getLevelByName(NULL )� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #1 FactionsPro_1.4_dev-19.phar/src/FactionsPro/FactionMain(93): FactionsPro\FactionCommands->onCommand(pocketmine\Player object, pocketmine\command\PluginCommand object, string f, array Array())� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #2 src/pocketmine/command/PluginCommand(58): FactionsPro\FactionMain->onCommand(pocketmine\Player object, pocketmine\command\PluginCommand object, string f, array Array())� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #3 src/pocketmine/command/SimpleCommandMap(241): pocketmine\command\PluginCommand->execute(pocketmine\Player object, string f, array Array())� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #4 src/pocketmine/Server(1971): pocketmine\command\SimpleCommandMap->dispatch(pocketmine\Player object, string f home)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #5 src/pocketmine/Player(2161): pocketmine\Server->dispatchCommand(pocketmine\Player object, string f home)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #6 src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(219): pocketmine\Player->chat(string /f home)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #7 src/pocketmine/network/mcpe/protocol/CommandRequestPacket(47): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleCommandRequest(pocketmine\network\mcpe\protocol\CommandRequestPacket object)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #8 src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(91): pocketmine\network\mcpe\protocol\CommandRequestPacket->handle(pocketmine\network\mcpe\PlayerNetworkSessionAdapter object)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #9 src/pocketmine/network/mcpe/protocol/BatchPacket(115): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleDataPacket(pocketmine\network\mcpe\protocol\CommandRequestPacket object)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #10 src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(91): pocketmine\network\mcpe\protocol\BatchPacket->handle(pocketmine\network\mcpe\PlayerNetworkSessionAdapter object)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #11 src/pocketmine/Player(3033): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleDataPacket(pocketmine\network\mcpe\protocol\BatchPacket object)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #12 src/pocketmine/network/mcpe/RakLibInterface(143): pocketmine\Player->handleDataPacket(pocketmine\network\mcpe\protocol\BatchPacket object)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #13 src/raklib/server/ServerHandler(97): pocketmine\network\mcpe\RakLibInterface->handleEncapsulated(string 77.213.159.89:48732, raklib\protocol\EncapsulatedPacket object, integer 0)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #14 src/pocketmine/network/mcpe/RakLibInterface(82): raklib\server\ServerHandler->handlePacket()� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #15 src/pocketmine/network/Network(89): pocketmine\network\mcpe\RakLibInterface->process()� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #16 src/pocketmine/Server(2503): pocketmine\network\Network->processInterfaces()� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #17 src/pocketmine/Server(2257): pocketmine\Server->tick()� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #18 src/pocketmine/Server(2136): pocketmine\Server->tickProcessor()� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #19 src/pocketmine/Server(1718): pocketmine\Server->start()� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #20 src/pocketmine/PocketMine(556): pocketmine\Server->__construct(BaseClassLoader object, pocketmine\utils\MainLogger object, string phar:///home/gsp_1589/g9.hmserv.eu-19199/PocketMine-MP.phar/, string /home/gsp_1589/g9.hmserv.eu-19199/, string /home/gsp_1589/g9.hmserv.eu-19199/plugins/)� 2017-10-02 [16:58:33] �[Server thread/DEBUG]: #21 /home/gsp_1589/g9.hmserv.eu-19199/PocketMine-MP.phar(1): require(string phar:///home/gsp_1589/g9.hmserv.eu-19199/PocketMine-MP.phar/src/pocketmine/PocketMine.php)�

thanks

[Awzaw]

I've turned on Issues - but can't reproduce this error. Was the database previously used with Factions 1.3.x? When you open the database, is there a home table with a world column?

[teracube]

@Awzaw
yes database was previously used with Factions 1.3x.
does it mean that i can not use it with Factions 1.4 ?
i was unable to open the db file with Excel
see attach file. I rename it FactionsPro.db(.txt)

FactionsPro.db.txt

thanks

[Awzaw]

I'm not sure why, but most of your home entries have no world specified. Get yourself a sqlite editor (e.g LITA) and you should be able to fill in the missing data - but I'm not 100% sure that databases from one version of factions are compatible with the other...

[teracube]

@Awzaw
i completed world on each line
no problem for the moment