[alexanderjb918]

Код:

    dbHandle = mysql_connect(DB_SERVER,DB_USER,DB_DB,DB_PASS);
	mysql_function_query(dbHandle,"CREATE TABLE IF NOT EXISTS textlabel(t_id_ int,t_text varchar(228),t_color_ varchar(23),t_x float,t_y float,t_z float",false,"","");

This is on my ongamemodeinit to create the table if it does not exist but it does not work..

Код:

5:02:27] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[15:02:27] [ERROR] CMySQLQuery::Execute[_loadTextLabel] - (error #1146) Table 'dylang1-2.textlabel' doesn't exist

[K0P]

try this

Код:

dbHandle = mysql_connect(DB_SERVER,DB_USER,DB_DB,DB_PASS);
mysql_function_query(dbHandle,"CREATE TABLE IF NOT EXISTS textlabel(t_id_ int,t_text varchar(228),t_color_ varchar(23),t_x float,t_y float,t_z float)",false,"","");

[alexanderjb918]

Issues fixed thanks, what was wrong for future reference?