Welcome to Centmin Mod Community
Register Now

PHP-FPM Multibyte PHP String extension

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Sep 19, 2017.

  1. pamamolf

    pamamolf Well-Known Member

    2,778
    245
    63
    May 31, 2014
    Ratings:
    +437
    Local Time:
    10:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hello :)

    On latest Centminmod i am using for IPB forum the php version 7.1.9 and i try to do the convert from v3 to v4 using a tool that IPB provide to get my database as Utf8mb4 but i got instead utf8_unicode :(

    Then i open a support ticket and they told me that:

    I think also other users that will use the upgrade converter to latest version and use Centminmod may have that issue :(

    Can we add it as default or optional?

    Thank you
     
  2. pamamolf

    pamamolf Well-Known Member

    2,778
    245
    63
    May 31, 2014
    Ratings:
    +437
    Local Time:
    10:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    But isn't that means that is already there?

    Code:
    --enable-mbstring
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,626
    6,862
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,306
    Local Time:
    6:58 PM
    Nginx 1.13.x
    MariaDB 5.5
    Centmin Mod PHP-FPM installs have mbstring extension enabled by default. Maybe Invision isn't looking for the extension in the right place ? Not first time Invision was looking for something which they didn't need to IP.Board - You do not have the cURL PHP extension loaded or it is running a version less than 7.36
    Code (Text):
    php --ri mbstring
    
    mbstring
    
    Multibyte Support => enabled
    Multibyte string engine => libmbfl
    HTTP input encoding translation => disabled
    libmbfl version => 1.3.2
    oniguruma version => 6.3.0
    
    mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
    
    Multibyte (japanese) regex support => enabled
    Multibyte regex (oniguruma) backtrack check => On
    Multibyte regex (oniguruma) version => 6.3.0
    
    Directive => Local Value => Master Value
    mbstring.language => neutral => neutral
    mbstring.detect_order => no value => no value
    mbstring.http_input => no value => no value
    mbstring.http_output => no value => no value
    mbstring.internal_encoding => no value => no value
    mbstring.substitute_character => no value => no value
    mbstring.func_overload => 0 => 0
    mbstring.encoding_translation => Off => Off
    mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml\+xml) => ^(text/|application/xhtml\+xml)
    mbstring.strict_detection => Off => Off
    
     
    • Agree Agree x 1
  4. Jimmy

    Jimmy Premium Member Premium Member

    1,146
    253
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +615
    Local Time:
    3:58 AM
    1.13.x
    MariaDB 10.1.x
    I didn't have any problem upgrading v3 to v4 using Utf8mb4. All my tables are utf8mb4_unicode_ci.
     
  5. pamamolf

    pamamolf Well-Known Member

    2,778
    245
    63
    May 31, 2014
    Ratings:
    +437
    Local Time:
    10:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Ok i think i found the issue.....I will check to be sure .....
     
    Last edited: Sep 19, 2017
  6. Jimmy

    Jimmy Premium Member Premium Member

    1,146
    253
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +615
    Local Time:
    3:58 AM
    1.13.x
    MariaDB 10.1.x
    I used the utility built into the upgrade software, not the conversion utility in the marketplace.
     
  7. pamamolf

    pamamolf Well-Known Member

    2,778
    245
    63
    May 31, 2014
    Ratings:
    +437
    Local Time:
    10:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    I think the included one at the upgrade software is based on browser and not for use at cli and as the database is big and i will get for sure some time outs i prefer always to use the cli versions.....
     
  8. Jimmy

    Jimmy Premium Member Premium Member

    1,146
    253
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +615
    Local Time:
    3:58 AM
    1.13.x
    MariaDB 10.1.x
    The browser based one will give you the necessary command line statements to run.
     
  9. Jimmy

    Jimmy Premium Member Premium Member

    1,146
    253
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +615
    Local Time:
    3:58 AM
    1.13.x
    MariaDB 10.1.x
  10. pamamolf

    pamamolf Well-Known Member

    2,778
    245
    63
    May 31, 2014
    Ratings:
    +437
    Local Time:
    10:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Yes i know but i must left open the browser at that point for 8 hours that takes to convert my big database....but it seems that it does the same thing with cli commands...

    *Yes i notice that about the script but it seems that the upgrade from software seems to do the same thing and then you must use the Admin panel option to convert it to mb4.
     
  11. Jimmy

    Jimmy Premium Member Premium Member

    1,146
    253
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +615
    Local Time:
    3:58 AM
    1.13.x
    MariaDB 10.1.x
    I thought there was an option in the browser based converter to run the commands via the command line. I could be wrong. I did the conversion awhile ago.
     
  12. Jimmy

    Jimmy Premium Member Premium Member

    1,146
    253
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +615
    Local Time:
    3:58 AM
    1.13.x
    MariaDB 10.1.x
    Are you using this?

    Code:
    Convert Database to utf-8mb4 via commandline
    # php /home/nginx/domains/xxx/public/admin/convertutf8mb4/cli.php
     
  13. pamamolf

    pamamolf Well-Known Member

    2,778
    245
    63
    May 31, 2014
    Ratings:
    +437
    Local Time:
    10:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    yes :)
     
    • Like Like x 1