matcracker / BedcoreProtect

BedcoreProtect is a fast, efficient, data logging and anti-griefing tool for PocketMine servers. Rollback and restore any amount of damage.
https://poggit.pmmp.io/p/BedcoreProtect/
GNU General Public License v3.0
43 stars 8 forks source link

sql Communication error #69

Closed cherrychip8293 closed 1 year ago

cherrychip8293 commented 1 year ago

Issue description

Steps to reproduce the issue

  1. Set the data storage method with mysql
  2. Afterwards, try to do any action using the rollback function, and you'll get an error

OS and versions

Plugins

BedcoreProtect v1.1.0, BossPlugin v1.0.3, BuilderTools v2.0.0-dev, CaveGenerator v1.0.0, CustomItemLoader v3.2.0, EquipmentManager v1.0.2, Mine v1.0.0, MonsterPlugin v1.0.15, RPGCore v1.1.4, Slapper v3.0.0, UpgradeTool v1.0.0, WarpCore v2.0.0, WorldManager v1.2.3-Adam, libItemRegistrar v1.0.0

Crashdump, backtrace or other files

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM log_history INNER JOIN blocks_log ON log_history.log_id = history_id ' at line 8 in phar:///root/pm/plugins/BedcoreProtect-pm5.phar/src/_8a2a3e91c4e22a1e8c9apoggit/libasynql/mysqli/MysqliThread.php:140 Stack trace:

0 phar:///root/pm/plugins/BedcoreProtect-pm5.phar/src/_8a2a3e91c4e22a1e8c9apoggit/libasynql/mysqli/MysqliThread.php(140): mysqli->prepare('SELECT log_id, ...')

1 phar:///root/pm/plugins/BedcoreProtect-pm5.phar/src/_8a2a3e91c4e22a1e8c9apoggit/libasynql/base/SqlSlaveThread.php(89): _8a2a3e91c4e22a1e8c9apoggit\libasynql\mysqli\MysqliThread->executeQuery(Object(mysqli), 3, 'SELECT log_id, ...', Array)

2 phar:///root/pm/PocketMine-MP.phar/src/thread/CommonThreadPartsTrait.php(96): _8a2a3e91c4e22a1e8c9apoggit\libasynql\base\SqlSlaveThread->onRun()

3 [internal function]: pocketmine\thread\Thread->run()

4 {main}

thrown in phar:///root/pm/plugins/BedcoreProtect-pm5.phar/src/_8a2a3e91c4e22a1e8c9apoggit/libasynql/mysqli/MysqliThread.php on line 140

matcracker commented 1 year ago

Thanks for report, issue fixed by e1cb4f746209f3ba68f7ddb82ed203e6002ca7c8