Current time: 11-22-2024, 10:18 AM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Ticket #1913 -> SQL Error in sql_user_add.php
Author Message
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #1
Ticket #1913 -> SQL Error in sql_user_add.php
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
08-04-2009 04:16 PM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #2
RE: Ticket #1913 -> SQL Error in sql_user_add.php
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.
(This post was last modified: 08-04-2009 05:12 PM by joximu.)
08-04-2009 05:09 PM
Visit this user's website Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #3
RE: Ticket #1913 -> SQL Error in sql_user_add.php
Thanks a lot - it works!
So i can go on...

Greez BeNe
08-04-2009 05:23 PM
Visit this user's website Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #4
RE: Ticket #1913 -> SQL Error in sql_user_add.php
Commit r1879: I fixed it and reduces amount of code used in r1880.
(This post was last modified: 08-05-2009 12:19 AM by RatS.)
08-04-2009 06:43 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)