+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Development Area (/forum-1.html)
+--- Forum: Tickets / Roadmap / Timeline (/forum-50.html)
+--- Thread: Ticket #1913 -> SQL Error in sql_user_add.php (/thread-7388.html)
Ticket #1913 -> SQL Error in sql_user_add.php - BeNe - 08-04-2009 04:16 PM
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 1RatS 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
RE: Ticket #1913 -> SQL Error in sql_user_add.php - joximu - 08-04-2009 05:09 PM
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.
RE: Ticket #1913 -> SQL Error in sql_user_add.php - BeNe - 08-04-2009 05:23 PM
Thanks a lot - it works!
So i can go on...
Greez BeNe
RE: Ticket #1913 -> SQL Error in sql_user_add.php - RatS - 08-04-2009 06:43 PM
Commit r1879: I fixed it and reduces amount of code used in r1880.