We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Error: SQL: UPDATE `db_name`.`modx_web_user_attributes` SET WHERE `internalkey`

    • 25979
    • 178 Posts
    salik Reply #1, 18 years, 4 months ago 
    MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 `internalkey` = '10'' at line 1 »
      SQL: UPDATE `db_name`.`modx_web_user_attributes` SET WHERE `internalkey` = '10'


    I got this error whenever I try to change data through form using WebLoginPE.

    Does anyone knows what it is about?

    Regards,

    Mike
      //Why use windows since there is a door?//
      • 24806
      • 43 Posts
      ReMaX Reply #2, 18 years, 4 months ago
      Hm, could it be, that you have to put something between SET and WHERE? You doesn’t change any values!
      UPDATE `db_name`.`modx_web_user_attributes` SET `fieldtoupdate` = 'new value' WHERE `internalkey` = '10'
        I love MODx
        • 25979
        • 178 Posts
        salik Reply #3, 18 years, 4 months ago
        that’s what I thought but it’s the first time I get this error, and in other places I got nothing like that.

        :(
          //Why use windows since there is a door?//