vortex roleplay 2 query error help :( - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: vortex roleplay 2 query error help :( (/showthread.php?tid=462861)

---

vortex roleplay 2 query error help :( - sotau - 09.09.2013

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?

---

Re: vortex roleplay 2 query error help :( - Emmet_ - 10.09.2013

Execute this query:

---

Re: vortex roleplay 2 query error help :( - sotau - 11.09.2013

check your PM,
btw
i have sent you a rep

---

Re: vortex roleplay 2 query error help :( - Emmet_ - 11.09.2013

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.

---

Re: vortex roleplay 2 query error help :( - sotau - 12.09.2013

my server still error you can try at 95.211.180.224:7831 ,
btw thanks for help

---