[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 ?

[DRIFT_HUNTER]

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)

[kaisersouse]

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.