/ Register

Want to subscribe to topics you're interested in?
Become a Member

PHP-FPM Multibyte PHP String extension

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

Tags:
Previous Thread Next Thread
Loading...
  1. Sep 19, 2017 #1
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:28 PM
    Nginx-1.29.x
    MariaDB 10.6.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. Sep 19, 2017 #2
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:28 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    But isn't that means that is already there?

    Code:
    --enable-mbstring
     
  3. Sep 19, 2017 #3
    eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:28 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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
     
  4. Sep 19, 2017 #4
    Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    9:28 AM
    I didn't have any problem upgrading v3 to v4 using Utf8mb4. All my tables are utf8mb4_unicode_ci.
     
  5. Sep 19, 2017 #5
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:28 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Ok i think i found the issue.....I will check to be sure .....
     
    Last edited: Sep 19, 2017
  6. Sep 19, 2017 #6
    Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    9:28 AM
    I used the utility built into the upgrade software, not the conversion utility in the marketplace.
     
  7. Sep 19, 2017 #7
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:28 PM
    Nginx-1.29.x
    MariaDB 10.6.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. Sep 19, 2017 #8
    Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    9:28 AM
    The browser based one will give you the necessary command line statements to run.
     
  9. Sep 19, 2017 #9
    Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    9:28 AM
  10. Sep 19, 2017 #10
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:28 PM
    Nginx-1.29.x
    MariaDB 10.6.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. Sep 19, 2017 #11
    Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    9:28 AM
    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. Sep 19, 2017 #12
    Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    9:28 AM
    Are you using this?

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

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:28 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    yes :)
     
Previous Thread Next Thread
Loading...

.