Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#46 DB Error

all
open
nobody
Db error (1)
1
2013-04-23
2012-09-26
tomek
No

Hi, i installed daloradius succesfuly. But when i want add attributes per user or per user profile I can not do it. I have got mysql error message like this:

Database error
Error Message: DB Error: syntax error
Debug info: SELECT Attribute FROM WHERE UserName='QRUZxXP5' AND Attribute='3GPP2-Security-Level' AND id=0 nativecode=1064 ** 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 'WHERE UserName='QRUZxXP5' AND Attribute='3GPP2-Security-Level' AND id=0' at line 1

I think there is a problem with table name in query. When i change in mng-edit.php $sql = "UPDATE $table SET Value=$value WHERE UserName='". to $sql = "UPDATE radcheck SET Value=$value WHERE UserName='". it works great. But problem is with attributes in profiles too.
Please help me it is very important for me. This same problem i fave with your vm template daloRadius version.

Discussion


  • Anonymous
    2013-04-23

    i got the same :(

     


Anonymous


Cancel   Add attachments