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

Deprecated/Removed mysql-function is used in database-class

    Details

    • Type: Bug Bug
    • Status: Confirmed
    • Priority: Blocker Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      When ezmysqli is configured eZ correctly uses ezmysqlidb.php, however in ezpublish_legacy/lib/ezdb/classes/ezmysqlidb.php within function escapeString the MySQL-function mysql_escape_string is used.

      mysql_escape_string is deprecated in PHP 4.3 and removed in PHP 7, so eZ Publish won't work with PHP 7.

      ezpublish_legacy/lib/ezdb/classes/ezmysqlidb.php:
      eZDebug::writeDebug( 'escapeString called before connection is made', _METHOD_ );
      return mysql_escape_string( $str );

        Activity

        Alex Yes created issue -
        Sylvain Guittard made changes -
        Field Original Value New Value
        Project Community Platforms [ 10801 ] eZ Publish / Platform [ 10401 ]
        Key COM-19905 EZP-26247
        Workflow Community Workflow [ 100254 ] EZ* Development Workflow [ 100255 ]
        Component/s Database related [ 10791 ]
        Component/s Legacy stack [ 13341 ]
        Component/s Community [ 10713 ]
        Tomasz Madeyski (Inactive) made changes -
        Assignee Tomasz Madeyski [ tomasz.madeyski@ez.no ]
        Tomasz Madeyski (Inactive) made changes -
        Status Open [ 1 ] Confirmed [ 10037 ]
        Hide
        Tomasz Madeyski (Inactive) added a comment - - edited

        Dear Alex Yes

        Is there a chance you have a stacktrace hitting this part of code (else part of escapeString method) or you just noticed it "manually" ?

        Show
        Tomasz Madeyski (Inactive) added a comment - - edited Dear Alex Yes Is there a chance you have a stacktrace hitting this part of code ( else part of escapeString method ) or you just noticed it "manually" ?
        Hide
        Alex Yes added a comment -

        I do not remember what happened 9 month before, but I do not think that I noticed it manually first.
        However, I am not able to reproduce thitting the else-part when testing now.

        Show
        Alex Yes added a comment - I do not remember what happened 9 month before, but I do not think that I noticed it manually first. However, I am not able to reproduce thitting the else-part when testing now.
        Alex Schuster made changes -
        Workflow EZ* Development Workflow [ 100255 ] EZEE Development Workflow [ 108731 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Confirmed Confirmed
        277d 20h 9m 1 tomasz.madeyski@ez.no 07/Jun/17 1:29 PM

          People

          • Assignee:
            Tomasz Madeyski (Inactive)
            Reporter:
            Alex Yes
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: