Mysql Issue - Printable Version

Mysql Issue - 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: Mysql Issue (/showthread.php?tid=601848)

Mysql Issue - alexanderjb918 - 27.02.2016

Код:

    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

Re: Mysql Issue - K0P - 27.02.2016

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,"","");

Re: Mysql Issue - alexanderjb918 - 27.02.2016

Issues fixed thanks, what was wrong for future reference?