Help with SQL

[ewxlyz]

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.

[ewxlyz]

Also, this SQL works on localhost, but on buyed (rented) host it doesn't.

[IIYAMA]

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!

[ewxlyz]

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.