MySQL bug?!

[GTX]

Hello, I found problem/bug on my script, which I can't fix... I think this is MySQL bug. I have latest MySQL version.

Debug:

Error executing the query: (1103) Incorrect table name '[DM]Ffgg -Vol3- The enc '

My script looks like this:

result = mysql_query(connect_mysql, "CREATE TABLE IF NOT EXISTS `"..mapname.."` (name VARCHAR(70),time TEXT,date TEXT,serial VARCHAR(100),tag VARCHAR(100))") 

[SAbJaN]

What GameMode?

[GTX]

Race. (DD/DM)

[SAbJaN]

Have a look at this first.

viewtopic.php?f=148&t=39069

If that don't work, let us know.

[GTX]

Hmmm? That's not my problem. That topic you posted is talking on how to make SQL scripts work. I have this problem:

Error executing the query: (1103) Incorrect table name '[DM]Ffgg -Vol3- The enc '

[SAbJaN]

Yeah well executing the query has things to do with the SQL, are you sure you've set it up correctly, Have you set it up in settings.xml in the deathmatch folder?

[GTX]

No. My MySQL handler looks like this:

  
connect_mysql = mysql_connect(host, user, password, database, 3306, "/var/run/mysqld/mysqld.sock") 
  

And yes, MySQL seems to be setted up correctly.

[SAbJaN]

Try putting this is settings.xml in the deathmatch folder

<settings> 
<!-- MySQL Configuration --> 
        <setting name="@sql.user" value="SQL USER"/> 
        <setting name="@sql.password" value="PASSWORD"/> 
        <setting name="@sql.database" value="DATABASE NAME"/> 
        <setting name="@sql.hostname" value="HOST (Usually localhost if you're using XAMPP)"/> 
        <setting name="@sql.port" value="PORT (Default is 3306"/> 
        <!-- Only use this on Linux if the normal connection does fail even though using the correct username & password. --> 
        <setting name="@sql.socket" value="/var/run/mysqld/mysqld.sock"/> 
</settings> 

[GTX]

Tried. Still doesn't work. By the way, script is working fine on other maps but doesn't work on that one.