Jump to content

Help with SQL


ewxlyz

Recommended Posts

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
  • Moderators
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

 

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...