overextended / oxmysql

MySQL resource for FXServer.
https://overextended.dev/oxmysql
GNU Lesser General Public License v3.0
316 stars 194 forks source link

Oxmysql error in multichar resource prevents joining to server (onReady) #195

Closed SneakyAF closed 1 year ago

SneakyAF commented 1 year ago

Issue checklist

Please put x inside of the box that matches your issue.

Describe the bug Since the update to the latest release I cannot join my own server because of an error in a resource.

The error originates from the another resource, however, only since the update to the latest version it prevents me from joining the server. Before it just complained about not being able to alter certain database fields because of their length, but still allowed joining in. (Please check screenshots)

Screenshots 2.7.3 image 2.7.2 image

Code Sadly the resource is under escrow... So my only hope is to tackle this from the oxmysql side

Expected behavior Despite the fail to alter the table no additional errors are generated causing the prevention to join the server.

Additional context I do understand that this originates from another resource and I'm fine with downgrading the oxmysql version if there's nothing you can do about it. Thank you for at least reading about the issue.

Server details

Database details

N-fire commented 1 year ago

Not an issue with oxmysql, change your db setting for the column identifier, varchar 46 is too low change it to 50

SneakyAF commented 1 year ago

Unfortunately I need that field to be the length it is right now.

As I've stated above the error was always there and I'm fine with it as long as there aren't additional problems that prevent properly loading into the server which there are with the latest update.