chuushi/CoreProtect-Lookup-Web-Interface

Seach Functions dont work? [MySQL]

ablac opened this issue · 7 comments

ablac commented

When using the web interface, If i select just an Action, it shows up with the information requested, but if I select a user it says "An Unknown Error Occurred" It does this for Coordinates, Radius, Worlds, Users, Materials, entities, Date/Time, and even Limit... So basically the entire website is useless unless i want just a massive flood of data in the map.

ablac commented

Yes same Behavior, Willing to allow testing with my site as well https://angel-gaming.com/bans

Secondly I'm running MariaDB 10.3.17-MariaDB MariaDB Server
Core Protect Versions 2.18.2

I'll start looking into it next week. I believe it has to do with the old versions of MySQL/MariaDB server not understanding the query.

Until then, if you can, try updating to the latest MySQL server version.

ablac commented

@chuushi Thats very interesting, So i downloaded the new MariaDB Repo, and Yum Updated to the newest version, and its working now, so your 100% correct it is the older version, 10.4 works perfectly.

pls fix that problem, because i cant update my mysql for that :(

I agree with ikuria. I cant update it either stuck with the one my host provides.
mysqlnd 5.0.12-dev

Can I suggest to change the subject of the issue to mysql: search functions do not work ?

This issue does not impact sqlite users.

Thanks!