MySQL Doesnt Add Table - Printable Version

MySQL Doesnt Add Table - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Doesnt Add Table (/showthread.php?tid=640186)

MySQL Doesnt Add Table - nrg700 - 29.08.2017

Hi, I Have a VPS which I've used it as SA:MP Server Since Today. I was testing the connection between the mysql server and the SA:MP Server. The Problem is The Server doesnt add Table.

I correctly typed the Host,User Name ,Etc to fill the mysql_connect function. I even tried localhost(127.0.0.1) and The External IP as the host but no sign of working at all. Unfortunately, Both Mysql Error.log and Warning.log are empty and The Plugin seems to be loaded correctly. I've Restarted the Mysql Server for a bunch of times also Downgrade the Plugin Version into R41-2

Mysql Plugin Version : pBlueG's Mysql R41-3
Mysql Server Version : 5.7.19-0ubuntu0.16.04.1
OS : Ubuntu 16.04.1 x86

Код:

#include <a_samp>
#include <a_mysql>

new MySQL:connection;

main(){}
public OnGameModeInit()
{
	new query[50];
	connection = mysql_connect(Host,User,Pass,Data);
	mysql_format(connection,query,sizeof(query),"CREATE TABLE IF NOT EXISTS `PlayerData`(`ID` INT(10) KEY NOT NULL AUTO_INCREMENT)");
	mysql_tquery(connection,query);
	return 0;
}

public OnGameModeExit()
{
	mysql_close(connection);
	return 0;
}

Re: [MYSQL] MySQL Doesnt Add Table - WarZ - 29.08.2017

test this one

PHP код:



new query[50];

    connection = mysql_connect(Host,User,Pass,Data);

mysql_tquery( connection,"CREATE TABLE IF NOT EXISTS PlayerData(ID int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 1", "", "");

Re: MySQL Doesnt Add Table - nrg700 - 29.08.2017

Quote:

Originally Posted by WarZ

test this one

PHP код:



new query[50];

    connection = mysql_connect(Host,User,Pass,Data);

mysql_tquery( connection,"CREATE TABLE IF NOT EXISTS PlayerData(ID int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 1", "", "");

It Doesn't Work.. There should be something wrong with my setting or maybe the version. Anyway , Thanks