MySQL syntax error

[largbungus]

Hi, I am currently trying to set up a LAN server using a VM
I am using ubuntu 20.04.04 and managed to get the cowfc admin site working however, my inputted user doesnt seem to be valid as it keeps saying that username was not found.
additionally I have been attempting to use the add-acct.sh found in in the CoWFC folder however it seems to throw a syntax error

as seen here
do you know a solution?

[madisive]

#16

For this add-acct.sh issue, you might need to remove the 'Rank' field from the INSERT query in the code, as 'Rank' became a MySQL keyword in version 8.0 but executed fine in the past (possibly on old SQlite version). 'Rank' column name wasn't really thought through by me back then, and the feature was never finished anyway, so there's no harm in removing it.