Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-15386

ezmbpaex doesn't work in oracle (/userpaex/password)

    XMLWordPrintable

Details

    Description

      HI

      ezmpbaex doesn't seem to work with oracle.
      After installing the extension and trying to login with a user which has an expired password (for instance 'admin' of not running ( extension/ezmbpaex/install/scripts/setpasswordlastupdated.php ) you'll get this error:

      Error (1400): ORA-01400: kan ikke sette inn NULL i ("EZP"."EZX_MBPAEX"."PASSWORDVALIDATIONREGEXP")
      Failed query at offset 189:
      INSERT INTO ezx_mbpaex (contentobject_id, passwordvalidationregexp, passwordlifetime, expirationnotification, password_last_updated, updatechildren,
       expirationnotification_sent) VALUES(14, '', 1, 172800, 1251734345, -1, 0)
      
      Start of error:
      '', 1, 172800, 1251734345, -1, 0)
      

      English ora error:

      ORA-01400 cannot insert NULL into ("USER"."TABLE"."COLUMN")
      

      Tested with version 1.1 of the extension

      Attachments

        Activity

          People

            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: