ewxlyz Posted August 19, 2023 Share Posted August 19, 2023 Hello, can you help me fix this SQL error:https://imgur.com/a/bz5UepD . I tried it to fix, this is the full table of errors: https://imgur.com/a/NtvKJ12 , i deleted this, and it worked: https://imgur.com/a/UYslEZx.The problem is that the characters table: https://imgur.com/a/iUE1Phs, also has error and when i delte the DEFAULT '[ [ 1584.9250488281, -2311.2719726563, 13.546875, 0,0, 70 ] ] '. Players tried to join and they could not spawn because i deleted the position, also there was other 20 errrors and i dont know how to fix them. I hope somebody could help me with this because i tried everything and asked everybody. Thanks. Link to comment
ewxlyz Posted August 19, 2023 Author Share Posted August 19, 2023 Also, this SQL works on localhost, but on buyed (rented) host it doesn't. Link to comment
Moderators IIYAMA Posted August 19, 2023 Moderators Share Posted August 19, 2023 3 hours ago, ewxlyz said: can you help me fix this SQ It is intended behaviour, your query is doing something that is not allowed: Quote BLOB and TEXT columns cannot have DEFAULT values. https://dev.mysql.com/doc/refman/8.0/en/blob.html#idm140312903326336 The correct way to solve this (making sure it will always work) is to insert those default values when you insert a new row inside of the database. INSERT INTO accounts ( name, email, ... etc, usedEmails /* the column */ ) VALUES ( ?, ?, ... etc, '[ [ ] ]' /* the intial value */ ) Note: I do not expect that you will be able to fix this in one go. Make sure to make a backup! Link to comment
ewxlyz Posted August 21, 2023 Author Share Posted August 21, 2023 Hello, thanks for trying to help, but i fixed this. The problem was because i was using MySQL version instead of MariaDB. Thank you for trying to help. 1 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now