What to do ? - Printable Version

What to do ? - 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: What to do ? (/showthread.php?tid=606072)

MySQL Query execute error - Help - HyperLink - 29.04.2016

Hello,

I am new to mysql and i get the following MySQL error in my server_log, so my server keeps crashing.

Код:

[06:26:44] [MySQL] Error (0): Could not execute query. Unknown column 'town' in 'field list'.

What to do ?

Re: What to do ? - DRIFT_HUNTER - 29.04.2016

You probably have something like these:

Код:

SELECT `something`, `town` FROM `somewhere`

That town column does not exists in mysql database (or it has similar but different name from that)
Please note that is just example of how it might look, i cant know your code so i gave you a simple example. My suggestion is to check mysql database for columns and search in pawn for `town` (including that quotes)

Re: MySQL Query execute error - Help - kaisersouse - 29.04.2016

Quote:

Originally Posted by HyperLink

Hello,

I am new to mysql and i get the following MySQL error in my server_log, so my server keeps crashing.

Код:

[06:26:44] [MySQL] Error (0): Could not execute query. Unknown column 'town' in 'field list'.

What to do ?

You typically have to create your DBs table structure before interfacing it with SA-MP. SOME filterscripts have code in there to populate the structure, but most dont because they assume you've done that already.