vortex roleplay 2 query error help :(
#1

Your query is causing a database error;

[12:07:46] errorid: 1364 | error: Field 'playerEmail' doesn't have a default value | resultid: -1 | extraid: -1 | callback: NULL | query: INSERT INTO playeraccounts (playerName, playerPassword) VALUES('Adit_Iyan', 'CFD0CD43E8DD6061E1FB50592DC2DDD678DEFC7C00DF455C6 C44D83E347AD007E17137C34B072C998DF3043D09E78B73EB4 DF457118D78EFB8EEF446B116D9A4')
[12:07:52] [part] Adit_Iyan has left the server (0:2)

You either need to specify a default value for all the fields in the table, or to insert in to all the fields that do not have a set default value




the host of my server say that, can anyone help?
Reply
#2

Execute this query:

pawn Код:
ALTER TABLE `playeraccounts` CHANGE `playerEmail` `playerEmail` VARCHAR(256) DEFAULT 0
Reply
#3

Quote:
Originally Posted by Emmet_
Посмотреть сообщение
Execute this query:

pawn Код:
ALTER TABLE `playeraccounts` CHANGE `playerEmail` `playerEmail` VARCHAR(256) DEFAULT 0
check your PM,
btw
i have sent you a rep
Reply
#4

Go to phpMyAdmin, press the 'SQL' tab like in this picture (it's near the top):



and type in the query in the box and press Execute.
Reply
#5

Quote:
Originally Posted by Emmet_
Посмотреть сообщение
Go to phpMyAdmin, press the 'SQL' tab like in this picture (it's near the top):



and type in the query in the box and press Execute.
my server still error you can try at 95.211.180.224:7831 ,
btw thanks for help
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)