search

chuushi / CoreProtect-Lookup-Web-Interface

A flexible lookup web interface for CoreProtect 2
MIT License
50 stars 14 forks source link

Seach Functions dont work? [MySQL] #26

Open ablac opened 4 years ago

ablac commented 4 years ago

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.

thunderlight411 commented 4 years ago

same behavior as in https://www.spigotmc.org/threads/coreprotect-lookup-web-interface.173574/#post-3811046

ablac commented 4 years ago

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

chuushi commented 4 years ago

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 4 years ago

@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.

ikuria commented 3 years ago

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

fahlur commented 3 years ago

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

tomas-kucera commented 3 years ago

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!