Ticket #1913 -> SQL Error in sql_user_add.php

[BeNe]

Hello Dev´s!

There is an Error since Changeset 1874 in sql_user_add.php.

Code:

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 ''`2\\_kghj`' *.* TO '2_yaqwx'@'localhost' IDENTIFIED BY 'yaqwsx123'' at line 1

RatS changed the file this night but the Error still exists.
Maybe that´s the reason why the ticket was not closed.

Can somebody take a look at the Code ? I can´t test the new Version without a MySQL-DB and Users.

Thanks a lot!
Greez BeNe

[joximu]

Why not revert the changes on that file to before...

It seems that the changes came from the one who had problems with php 5.3 - but he's not an expert.

I think the moving of the db name from the query to the parameter list was not completed...

I'll revert bak to the original...

/Joxi

upd: 1879 should be ok.

[BeNe]

Thanks a lot - it works!
So i can go on...

Greez BeNe

[RatS]

Commit r1879: I fixed it and reduces amount of code used in r1880.