[Server] MYSQL R41-4

[Kwarde]

Thanks to everyone, I had already solved the problem but I ended up not commenting here, it was a simple syntax error

There was indeed a syntax error in the logs. However:

[04/28/21 14:36:15] [INFO] Connection handle with id '1' successfully created.

A connection with id 1 was created (as literally stated in the logs). But then there's this log:

[04/28/21 11:14:16] [ERROR] mysql_format: invalid connection handle '0'

That has nothing to do with a syntax error. When you create a variable without a value, it's initial value will be 0. It is quite possible you used a wrong variable or created a new one (or the value of the variable with the MySQL connection ID was set to 0) for the connection handle:

Code:

//Global variable:

new MySQL:dbHandle;



//In your script initialisation:

dbHandle = mysql_connect(...);



//In the script that says "invalid connection handle '0'"

new MySQL:somethingElse;

mysql_format(somethingElse, ...);

//Correct: mysql_format(dbHandle, ...);