Help please..my server crashes cause of mysql error - 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: Help please..my server crashes cause of mysql error (/showthread.php?tid=633574)

---

Help please..my server crashes cause of mysql error - tharvin - 03.05.2017

When i start the my script..the server starts....but when i join the game..my samp crashes..and the server log shows
AdmCmd: A MySQL error occurred (error 1054). Details written to mysql_error.txt.

when i open mysql error it shows

[2017-05-03 23:49]
Error ID: 1054
Callback:
Query: UPDATE users SET toggleradio = 0, togglemusic = 0, togglefaction = 0, togglenews = 0, toggleglobal = 1, togglecam = 0, togglehud = 1, weedtime = 0, weedgrams = 0, showturfs = 0, showlands = 0, watchon = 0, gpson = 0, couriercooldown = 0, pizzacooldown = 0, detectivecooldown = 0, duty = 0, bandana = 0 WHERE uid = 1
Error: Unknown column 'detectivecooldown' in 'field list'

What should i do to fix this error?..help me plsss

---

Re: Help please..my server crashes cause of mysql error - Banditul18 - 03.05.2017

Go to phpmyadmin > select your databse > select users table and go and create a new column called "detectivecooldown"

---