search

aerni / statamic-snipcart

A Snipcart addon for Statamic
https://statamic.com/addons/aerni/snipcart
Other
4 stars 0 forks source link

could not find driver (SQL: create table "currencies" ... #2

Closed el-schneider closed 4 years ago

el-schneider commented 4 years ago

Bug Description

I’m getting this error in the front-end wherever {{ snipcart:head }} or {{ snipcart:body }} is embedded and in the back-end when trying to create an entry in the products collection, that has been created by php please snipcart:setup

Illuminate\Database\QueryException could not find driver (SQL: create table "currencies" ("id" integer not null primary key autoincrement, "code" varchar null, "name" varchar null, "symbol" varchar null)) http://statamic.playground/

Environment

Statamic 3.0.1 Pro Laravel 7.26.0 PHP 7.4.9 aerni/snipcart 1.0.0-beta.13

Install method (choose one):

aerni commented 4 years ago

Did you publish the addon's config and configure the sites array according to config/statamic/sites.php? See the documentation here.

el-schneider commented 4 years ago

Yep. I also received the The sites array of the Statamic and Snipcart config need to be in sync. and changed the snipcart config accordingly.

aerni commented 4 years ago

Please share both the snipcart.php and sites.php config.

el-schneider commented 4 years ago

sites.php

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | Sites
    |--------------------------------------------------------------------------
    |
    | Each site should have root URL that is either relative or absolute. Sites
    | are typically used for localization (eg. English/French) but may also
    | be used for related content (eg. different franchise locations).
    |
    */

    'sites' => [

        'en' => [
            'name' => 'English',
            'locale' => 'en_US',
            'url' => '/',
        ],
        'de' => [
            'name' => 'Deutsch',
            'locale' => 'de_DE',
            'url' => '/de/',
        ],

    ],
];

snipcart.php

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | Collections & Taxonomies
    |--------------------------------------------------------------------------
    |
    | Define the handles of the products collection and taxonomies.
    |
    | If you change a value, you need to run 'php please snipcart:setup' 
    | to re-generate the collection, taxonomies, and blueprints.
    |
    */

    'collections' => [
        'products' => 'products',
    ],

    'taxonomies' => [
        'categories' => 'categories',
        'taxes' => 'taxes',
    ],

    'sites' => [

        'en' => [
            'currency' => 'USD',
            'length' => 'cm',
            'weight' => 'kg',
        ],
        'de' => [
            'currency' => 'EUR',
            'length' => 'cm',
            'weight' => 'kg',
        ],

    ],

    /*
    |--------------------------------------------------------------------------
    | Snipcart API Keys
    |--------------------------------------------------------------------------
    |
    | Your Snipcart API Keys for the Live and Test Environment.
    |
    */

    'live_key' => env('SNIPCART_LIVE_KEY'),
    'test_key' => env('SNIPCART_TEST_KEY'),

    /*
    |--------------------------------------------------------------------------
    | Test Mode
    |--------------------------------------------------------------------------
    |
    | Set this to "false" to start processing real transactions.
    | You probably want to do this in production only.
    |
    */

    'test_mode' => env('SNIPCART_TEST_MODE', true),

    /*
    |--------------------------------------------------------------------------
    | Snipcart Version
    |--------------------------------------------------------------------------
    |
    | The Snipcart version you want to use.
    |
    */

    'version' => '3.0.19',

    /*
    |--------------------------------------------------------------------------
    | Currency
    |--------------------------------------------------------------------------
    |
    | Define the currency you want to use.
    |
    */

    'currency' => 'EUR',

    /*
    |--------------------------------------------------------------------------
    | Length Unit
    |--------------------------------------------------------------------------
    |
    | Define the length unit you want to use. 
    | You can choose between the following options: 'cm', 'm', 'in', 'ft'.
    |
    | If you change a value, you may run 'php please snipcart:migrate'
    | to convert your products' lengths to the new unit.
    |
    */

    'length' => 'cm',

    /*
    |--------------------------------------------------------------------------
    | Weight Unit
    |--------------------------------------------------------------------------
    |
    | Define the weight unit you want to use. 
    | You can choose between the following options: 'g', 'kg', 'oz', 'lb'.
    |
    | If you change a value, you may run 'php please snipcart:migrate'
    | to convert your products' lengths to the new unit.
    |
    */

    'weight' => 'g',

    /*
    |--------------------------------------------------------------------------
    | Cart Behaviour
    |--------------------------------------------------------------------------
    |
    | Set this to "none" to prevent the cart from opening every time
    | a product is added. Default is "null".
    |
    */

    'behaviour' => null,

    /*
    |--------------------------------------------------------------------------
    | Cart Image
    |--------------------------------------------------------------------------
    |
    | Define a Glide preset to be applied to the product image that shows 
    | in the cart. You may also turn the manipulation off (not recommended).
    |
    */

    'image' => [
        'manipulation' => true,
        'preset' => ['w' => 240, 'q' => 75],
    ]

];
aerni commented 4 years ago

You've got some old config keys in snipcart.php. Please publish a fresh copy of the config and try again.

el-schneider commented 4 years ago

Here’s the new snipcart.php but i’m still getting the same error:

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | Sites
    |--------------------------------------------------------------------------
    |
    | The site handles need to be in sync with your Statamic config.
    | Make sure to add a new key for each site set in `config/statamic/site.php`.
    |
    | Snipcart's default currency, length and weight unit will be the ones
    | defined within the key of Statamic's default site.
    |
    | If you add/remove a site or change a value, you need to run
    | 'php please snipcart:migrate' to update the products collection and entries.
    |
    */

    'sites' => [

        'en' => [
            'currency' => 'USD',
            'length' => 'in',
            'weight' => 'oz',
        ],
        'de' => [
            'currency' => 'EUR',
            'length' => 'cm',
            'weight' => 'kg',
        ],

    ],

    /*
    |--------------------------------------------------------------------------
    | Collections & Taxonomies
    |--------------------------------------------------------------------------
    |
    | Define the handles of the products collection and taxonomies.
    |
    | If you change a value, you need to run 'php please snipcart:setup'
    | to re-generate the collection, taxonomies, and blueprints.
    |
    */

    'collections' => [
        'products' => 'products',
    ],

    'taxonomies' => [
        'categories' => 'categories',
        'taxes' => 'taxes',
    ],

    /*
    |--------------------------------------------------------------------------
    | Snipcart API Keys
    |--------------------------------------------------------------------------
    |
    | Your Snipcart API Keys for the Live and Test Environment.
    |
    */

    'live_key' => env('SNIPCART_LIVE_KEY'),
    'live_secret' => env('SNIPCART_LIVE_SECRET'),

    'test_key' => env('SNIPCART_TEST_KEY'),
    'test_secret' => env('SNIPCART_TEST_SECRET'),

    /*
    |--------------------------------------------------------------------------
    | Test Mode
    |--------------------------------------------------------------------------
    |
    | Set this to "false" to start processing real transactions.
    | You probably want to do this in production only.
    |
    */

    'test_mode' => env('SNIPCART_TEST_MODE', true),

    /*
    |--------------------------------------------------------------------------
    | Snipcart Version
    |--------------------------------------------------------------------------
    |
    | The Snipcart version you want to use.
    |
    */

    'version' => '3.0.19',

    /*
    |--------------------------------------------------------------------------
    | Cart Behaviour
    |--------------------------------------------------------------------------
    |
    | Set this to "none" to prevent the cart from opening every time
    | a product is added. Default is "null".
    |
    */

    'behaviour' => null,

    /*
    |--------------------------------------------------------------------------
    | Cart Image
    |--------------------------------------------------------------------------
    |
    | Define a Glide preset to be applied to the product image that shows
    | in the cart. You may also turn the manipulation off (not recommended).
    |
    */

    'image' => [
        'manipulation' => true,
        'preset' => ['w' => 240, 'q' => 75],
    ]

];
aerni commented 4 years ago

Do you have more information about your setup? I can't reproduce the error on my end.

el-schneider commented 4 years ago

I’m using WSL on windows. Maybe that’s an issue? Apart from that I have set-up a very basic site for testing. Nothing fancy at all.

aerni commented 4 years ago

I just realized, that there's an addons dependency, that required SQLite. Do you have SQLite installed?

el-schneider commented 4 years ago

Yes, i had it installed. I don’t know if this is helpful, but anyway, here is my php-config:

PHP Version 7.4.9
System  Linux XXX #1 SMP Wed Feb 19 06:37:35 UTC 2020 x86_64
Build Date  Aug 7 2020 14:29:36
Server API  Apache 2.0 Handler
Virtual Directory Support   disabled
Configuration File (php.ini) Path   /etc/php/7.4/apache2
Loaded Configuration File   /etc/php/7.4/apache2/php.ini
Scan this dir for additional .ini files     /etc/php/7.4/apache2/conf.d
Additional .ini files parsed    /etc/php/7.4/apache2/conf.d/10-mysqlnd.ini, /etc/php/7.4/apache2/conf.d/10-opcache.ini, /etc/php/7.4/apache2/conf.d/10-pdo.ini, /etc/php/7.4/apache2/conf.d/15-xml.ini, /etc/php/7.4/apache2/conf.d/20-bcmath.ini, /etc/php/7.4/apache2/conf.d/20-bz2.ini, /etc/php/7.4/apache2/conf.d/20-calendar.ini, /etc/php/7.4/apache2/conf.d/20-ctype.ini, /etc/php/7.4/apache2/conf.d/20-dom.ini, /etc/php/7.4/apache2/conf.d/20-exif.ini, /etc/php/7.4/apache2/conf.d/20-ffi.ini, /etc/php/7.4/apache2/conf.d/20-fileinfo.ini, /etc/php/7.4/apache2/conf.d/20-ftp.ini, /etc/php/7.4/apache2/conf.d/20-gd.ini, /etc/php/7.4/apache2/conf.d/20-gettext.ini, /etc/php/7.4/apache2/conf.d/20-iconv.ini, /etc/php/7.4/apache2/conf.d/20-intl.ini, /etc/php/7.4/apache2/conf.d/20-json.ini, /etc/php/7.4/apache2/conf.d/20-mbstring.ini, /etc/php/7.4/apache2/conf.d/20-mysqli.ini, /etc/php/7.4/apache2/conf.d/20-pdo_mysql.ini, /etc/php/7.4/apache2/conf.d/20-phar.ini, /etc/php/7.4/apache2/conf.d/20-posix.ini, /etc/php/7.4/apache2/conf.d/20-readline.ini, /etc/php/7.4/apache2/conf.d/20-shmop.ini, /etc/php/7.4/apache2/conf.d/20-simplexml.ini, /etc/php/7.4/apache2/conf.d/20-sockets.ini, /etc/php/7.4/apache2/conf.d/20-sysvmsg.ini, /etc/php/7.4/apache2/conf.d/20-sysvsem.ini, /etc/php/7.4/apache2/conf.d/20-sysvshm.ini, /etc/php/7.4/apache2/conf.d/20-tokenizer.ini, /etc/php/7.4/apache2/conf.d/20-xmlreader.ini, /etc/php/7.4/apache2/conf.d/20-xmlwriter.ini, /etc/php/7.4/apache2/conf.d/20-xsl.ini, /etc/php/7.4/apache2/conf.d/20-zip.ini
PHP API     20190902
PHP Extension   20190902
Zend Extension  320190902
Zend Extension Build    API320190902,NTS
PHP Extension Build     API20190902,NTS
Debug Build     no
Thread Safety   disabled
Zend Signal Handling    enabled
Zend Memory Manager     enabled
Zend Multibyte Support  provided by mbstring
IPv6 Support    enabled
DTrace Support  available, disabled
Registered PHP Streams  https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, phar, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters   zlib.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, bzip2.*, convert.iconv.*
Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.9, Copyright (c), by Zend Technologies
Configuration
apache2handler
Apache Version  Apache/2.4.29 (Ubuntu)
Apache API Version  20120211
Server Administrator    webmaster@localhost
Hostname:Port   xxx.localdomain:80
User/Group  xxx(1000)/1000
Max Requests    Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts    Connection: 300 - Keep-Alive: 5
Virtual Server  Yes
Server Root     /etc/apache2
Loaded Modules  core mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_expires mod_filter mod_headers mod_mime prefork mod_negotiation mod_php7 mod_reqtimeout mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_status
Directive   Local Value Master Value
engine  1   1
last_modified   0   0
xbithack    0   0
Apache Environment
Variable    Value
HTTP_HOST   localhost
HTTP_USER_AGENT     Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:80.0) Gecko/20100101 Firefox/80.0
HTTP_ACCEPT     text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE    de,en-US;q=0.7,en;q=0.3
HTTP_ACCEPT_ENCODING    gzip, deflate
HTTP_DNT    1
HTTP_CONNECTION     keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS  1
PATH    /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE    <address>Apache/2.4.29 (Ubuntu) Server at localhost Port 80</address>
SERVER_SOFTWARE     Apache/2.4.29 (Ubuntu)
SERVER_NAME     localhost
SERVER_ADDR     ::1
SERVER_PORT     80
REMOTE_ADDR     ::1
DOCUMENT_ROOT   /home/xxx/www/
REQUEST_SCHEME  http
CONTEXT_PREFIX  no value
CONTEXT_DOCUMENT_ROOT   /home/xxx/www/
SERVER_ADMIN    webmaster@localhost
SCRIPT_FILENAME     /home/xxx/www/index.php
REMOTE_PORT     41764
GATEWAY_INTERFACE   CGI/1.1
SERVER_PROTOCOL     HTTP/1.1
REQUEST_METHOD  GET
QUERY_STRING    no value
REQUEST_URI     /
SCRIPT_NAME     /index.php
HTTP Headers Information
HTTP Request Headers
HTTP Request    GET / HTTP/1.1
Host    localhost
User-Agent  Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:80.0) Gecko/20100101 Firefox/80.0
Accept  text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Accept-Language     de,en-US;q=0.7,en;q=0.3
Accept-Encoding     gzip, deflate
DNT     1
Connection  keep-alive
Upgrade-Insecure-Requests   1
HTTP Response Headers
bcmath
BCMath support  enabled
Directive   Local Value Master Value
bcmath.scale    0   0
bz2
BZip2 Support   Enabled
Stream Wrapper support  compress.bzip2://
Stream Filter support   bzip2.decompress, bzip2.compress
BZip2 Version   1.0.6, 6-Sept-2010
calendar
Calendar support    enabled
Core
PHP Version     7.4.9
Directive   Local Value Master Value
allow_url_fopen On  On
allow_url_include   Off Off
arg_separator.input &   &
arg_separator.output    &   &
auto_append_file    no value    no value
auto_globals_jit    On  On
auto_prepend_file   no value    no value
browscap    no value    no value
default_charset UTF-8   UTF-8
default_mimetype    text/html   text/html
disable_classes no value    no value
disable_functions   pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,  pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
display_errors  Off Off
display_startup_errors  Off Off
doc_root    no value    no value
docref_ext  no value    no value
docref_root no value    no value
enable_dl   Off Off
enable_post_data_reading    On  On
error_append_string no value    no value
error_log   no value    no value
error_prepend_string    no value    no value
error_reporting 22527   22527
expose_php  Off Off
extension_dir   /usr/lib/php/20190902   /usr/lib/php/20190902
file_uploads    On  On
hard_timeout    2   2
highlight.comment   #FF8000 #FF8000
highlight.default   #0000BB #0000BB
highlight.html  #000000 #000000
highlight.keyword   #007700 #007700
highlight.string    #DD0000 #DD0000
html_errors On  On
ignore_repeated_errors  Off Off
ignore_repeated_source  Off Off
ignore_user_abort   Off Off
implicit_flush  Off Off
include_path    .:/usr/share/php    .:/usr/share/php
input_encoding  no value    no value
internal_encoding   no value    no value
log_errors  On  On
log_errors_max_len  1024    1024
mail.add_x_header   Off Off
mail.force_extra_parameters no value    no value
mail.log    no value    no value
max_execution_time  30  30
max_file_uploads    20  20
max_input_nesting_level 64  64
max_input_time  60  60
max_input_vars  1000    1000
memory_limit    128M    128M
open_basedir    no value    no value
output_buffering    4096    4096
output_encoding no value    no value
output_handler  no value    no value
post_max_size   8M  8M
precision   14  14
realpath_cache_size 4096K   4096K
realpath_cache_ttl  120 120
register_argc_argv  Off Off
report_memleaks On  On
report_zend_debug   On  On
request_order   GP  GP
sendmail_from   no value    no value
sendmail_path   /usr/sbin/sendmail -t -i    /usr/sbin/sendmail -t -i
serialize_precision -1  -1
short_open_tag  Off Off
SMTP    localhost   localhost
smtp_port   25  25
sys_temp_dir    no value    no value
syslog.facility LOG_USER    LOG_USER
syslog.filter   no-ctrl no-ctrl
syslog.ident    php php
track_errors    Off Off
unserialize_callback_func   no value    no value
upload_max_filesize 2M  2M
upload_tmp_dir  no value    no value
user_dir    no value    no value
user_ini.cache_ttl  300 300
user_ini.filename   .user.ini   .user.ini
variables_order GPCS    GPCS
xmlrpc_error_number 0   0
xmlrpc_errors   Off Off
zend.assertions -1  -1
zend.detect_unicode On  On
zend.enable_gc  On  On
zend.exception_ignore_args  On  On
zend.multibyte  Off Off
zend.script_encoding    no value    no value
zend.signal_check   Off Off
ctype
ctype functions     enabled
date
date/time support   enabled
timelib version     2018.03
"Olson" Timezone Database Version   0.system
Timezone Database   internal
Default timezone    Europe/Berlin
Directive   Local Value Master Value
date.default_latitude   31.7667 31.7667
date.default_longitude  35.2333 35.2333
date.sunrise_zenith 90.583333   90.583333
date.sunset_zenith  90.583333   90.583333
date.timezone   no value    no value
dom
DOM/XML     enabled
DOM/XML API Version     20031129
libxml Version  2.9.10
HTML Support    enabled
XPath Support   enabled
XPointer Support    enabled
Schema Support  enabled
RelaxNG Support     enabled
exif
EXIF Support    enabled
Supported EXIF Version  0220
Supported filetypes     JPEG, TIFF
Multibyte decoding support using mbstring   enabled
Extended EXIF tag formats   Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson
Directive   Local Value Master Value
exif.decode_jis_intel   JIS JIS
exif.decode_jis_motorola    JIS JIS
exif.decode_unicode_intel   UCS-2LE UCS-2LE
exif.decode_unicode_motorola    UCS-2BE UCS-2BE
exif.encode_jis no value    no value
exif.encode_unicode ISO-8859-15 ISO-8859-15
FFI
FFI support enabled
Directive   Local Value Master Value
ffi.enable  preload preload
ffi.preload no value    no value
fileinfo
fileinfo support    enabled
libmagic    537
filter
Input Validation and Filtering  enabled
Directive   Local Value Master Value
filter.default  unsafe_raw  unsafe_raw
filter.default_flags    no value    no value
ftp
FTP support     enabled
FTPS support    enabled
gd
GD Support  enabled
GD headers Version  2.3.0
GD library Version  2.2.5
FreeType Support    enabled
FreeType Linkage    with freetype
GIF Read Support    enabled
GIF Create Support  enabled
JPEG Support    enabled
PNG Support     enabled
WBMP Support    enabled
XPM Support     enabled
XBM Support     enabled
WebP Support    enabled
BMP Support     enabled
TGA Read Support    enabled
Directive   Local Value Master Value
gd.jpeg_ignore_warning  1   1
gettext
GetText Support     enabled
hash
hash support    enabled
Hashing Engines     md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
MHASH support   Enabled
MHASH API Version   Emulated Support
iconv
iconv support   enabled
iconv implementation    glibc
iconv library version   2.27
Directive   Local Value Master Value
iconv.input_encoding    no value    no value
iconv.internal_encoding no value    no value
iconv.output_encoding   no value    no value
intl
Internationalization support    enabled
ICU version     65.1
ICU Data version    65.1
ICU TZData version  2019c
ICU Unicode version     12.1
Directive   Local Value Master Value
intl.default_locale no value    no value
intl.error_level    0   0
intl.use_exceptions 0   0
json
json support    enabled
libxml
libXML support  active
libXML Compiled Version     2.9.10
libXML Loaded Version   20904
libXML streams  enabled
mbstring
Multibyte Support   enabled
Multibyte string engine     libmbfl
HTTP input encoding translation     disabled
libmbfl version     1.3.2
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) version     6.7.0
Directive   Local Value Master Value
mbstring.detect_order   no value    no value
mbstring.encoding_translation   Off Off
mbstring.func_overload  0   0
mbstring.http_input no value    no value
mbstring.http_output    no value    no value
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
mbstring.internal_encoding  no value    no value
mbstring.language   neutral neutral
mbstring.regex_retry_limit  1000000 1000000
mbstring.regex_stack_limit  100000  100000
mbstring.strict_detection   Off Off
mbstring.substitute_character   no value    no value
mysqli
MysqlI Support  enabled
Client API library version  mysqlnd 7.4.9
Active Persistent Links     0
Inactive Persistent Links   0
Active Links    0
Directive   Local Value Master Value
mysqli.allow_local_infile   Off Off
mysqli.allow_persistent On  On
mysqli.default_host no value    no value
mysqli.default_port 3306    3306
mysqli.default_pw   no value    no value
mysqli.default_socket   no value    no value
mysqli.default_user no value    no value
mysqli.max_links    Unlimited   Unlimited
mysqli.max_persistent   Unlimited   Unlimited
mysqli.reconnect    Off Off
mysqli.rollback_on_cached_plink Off Off
mysqlnd
mysqlnd enabled
Version     mysqlnd 7.4.9
Compression     supported
core SSL    supported
extended SSL    supported
Command buffer size     4096
Read buffer size    32768
Read timeout    86400
Collecting statistics   Yes
Collecting memory statistics    No
Tracing     n/a
Loaded plugins  mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions  mysqli,pdo_mysql
openssl
OpenSSL support     enabled
OpenSSL Library Version     OpenSSL 1.1.1 11 Sep 2018
OpenSSL Header Version  OpenSSL 1.1.1g 21 Apr 2020
Openssl default config  /usr/lib/ssl/openssl.cnf
Directive   Local Value Master Value
openssl.cafile  no value    no value
openssl.capath  no value    no value
pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled
PCRE Library Version    10.35 2020-05-09
PCRE Unicode Version    13.0.0
PCRE JIT Support    enabled
PCRE JIT Target     x86 64bit (little endian + unaligned)
Directive   Local Value Master Value
pcre.backtrack_limit    1000000 1000000
pcre.jit    1   1
pcre.recursion_limit    100000  100000
PDO
PDO support enabled
PDO drivers     mysql
pdo_mysql
PDO Driver for MySQL    enabled
Client API version  mysqlnd 7.4.9
Directive   Local Value Master Value
pdo_mysql.default_socket    /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
Phar
Phar: PHP Archive support   enabled
Phar API version    1.1.1
Phar-based phar archives    enabled
Tar-based phar archives     enabled
ZIP-based phar archives     enabled
gzip compression    enabled
bzip2 compression   enabled
Native OpenSSL support  enabled
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive   Local Value Master Value
phar.cache_list no value    no value
phar.readonly   On  On
phar.require_hash   On  On
posix
POSIX support   enabled
readline
Readline Support    enabled
Readline library    EditLine wrapper
Directive   Local Value Master Value
cli.pager   no value    no value
cli.prompt  \b \>   \b \> 
Reflection
Reflection  enabled
session
Session Support     enabled
Registered save handlers    files user
Registered serializer handlers  php_serialize php php_binary
Directive   Local Value Master Value
session.auto_start  Off Off
session.cache_expire    180 180
session.cache_limiter   nocache nocache
session.cookie_domain   no value    no value
session.cookie_httponly no value    no value
session.cookie_lifetime 0   0
session.cookie_path /   /
session.cookie_samesite no value    no value
session.cookie_secure   0   0
session.gc_divisor  1000    1000
session.gc_maxlifetime  1440    1440
session.gc_probability  0   0
session.lazy_write  On  On
session.name    PHPSESSID   PHPSESSID
session.referer_check   no value    no value
session.save_handler    files   files
session.save_path   /var/lib/php/sessions   /var/lib/php/sessions
session.serialize_handler   php php
session.sid_bits_per_character  5   5
session.sid_length  26  26
session.upload_progress.cleanup On  On
session.upload_progress.enabled On  On
session.upload_progress.freq    1%  1%
session.upload_progress.min_freq    1   1
session.upload_progress.name    PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix  upload_progress_    upload_progress_
session.use_cookies 1   1
session.use_only_cookies    1   1
session.use_strict_mode 0   0
session.use_trans_sid   0   0
shmop
shmop support   enabled
SimpleXML
SimpleXML support   enabled
Schema support  enabled
sockets
Sockets Support     enabled
sodium
sodium support  enabled
libsodium headers version   1.0.18
libsodium library version   1.0.16
SPL
SPL support enabled
Interfaces  OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes     AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException
standard
Dynamic Library Support     enabled
Path to sendmail    /usr/sbin/sendmail -t -i
Directive   Local Value Master Value
assert.active   1   1
assert.bail 0   0
assert.callback no value    no value
assert.exception    0   0
assert.quiet_eval   0   0
assert.warning  1   1
auto_detect_line_endings    0   0
default_socket_timeout  60  60
from    no value    no value
session.trans_sid_hosts no value    no value
session.trans_sid_tags  a=href,area=href,frame=src,form=    a=href,area=href,frame=src,form=
unserialize_max_depth   4096    4096
url_rewriter.hosts  no value    no value
url_rewriter.tags   form=   form=
user_agent  no value    no value
sysvmsg
sysvmsg support     enabled
sysvsem
sysvsem support     enabled
sysvshm
sysvshm support     enabled
tokenizer
Tokenizer Support   enabled
xml
XML Support     active
XML Namespace Support   active
libxml2 Version     2.9.10
xmlreader
XMLReader   enabled
xmlwriter
XMLWriter   enabled
xsl
XSL     enabled
libxslt Version     1.1.29
libxslt compiled against libxml Version     2.9.4
EXSLT   enabled
libexslt Version    1.1.29
Zend OPcache
Opcode Caching  Up and Running
Optimization    Enabled
SHM Cache   Enabled
File Cache  Disabled
Startup     OK
Shared memory model     mmap
Cache hits  2744528
Cache misses    7289
Used memory     58477024
Free memory     51484560
Wasted memory   24256144
Interned Strings Used memory    6290000
Interned Strings Free memory    1008
Cached scripts  4109
Cached keys     7841
Max keys    16229
OOM restarts    0
Hash keys restarts  0
Manual restarts     0
Directive   Local Value Master Value
opcache.blacklist_filename  no value    no value
opcache.consistency_checks  0   0
opcache.dups_fix    Off Off
opcache.enable  On  On
opcache.enable_cli  Off Off
opcache.enable_file_override    Off Off
opcache.error_log   no value    no value
opcache.file_cache  no value    no value
opcache.file_cache_consistency_checks   On  On
opcache.file_cache_only Off Off
opcache.file_update_protection  2   2
opcache.force_restart_timeout   180 180
opcache.huge_code_pages Off Off
opcache.interned_strings_buffer 8   8
opcache.lockfile_path   /tmp    /tmp
opcache.log_verbosity_level 1   1
opcache.max_accelerated_files   10000   10000
opcache.max_file_size   0   0
opcache.max_wasted_percentage   5   5
opcache.memory_consumption  128 128
opcache.opt_debug_level 0   0
opcache.optimization_level  0x7FFEBFFF  0x7FFEBFFF
opcache.preferred_memory_model  no value    no value
opcache.preload no value    no value
opcache.preload_user    no value    no value
opcache.protect_memory  Off Off
opcache.restrict_api    no value    no value
opcache.revalidate_freq 2   2
opcache.revalidate_path Off Off
opcache.save_comments   On  On
opcache.use_cwd On  On
opcache.validate_permission Off Off
opcache.validate_root   Off Off
opcache.validate_timestamps On  On
zip
Zip     enabled
Zip version     1.15.6
Libzip headers version  1.6.1
Libzip library version  1.6.1
zlib
ZLib Support    enabled
Stream Wrapper  compress.zlib://
Stream Filter   zlib.inflate, zlib.deflate
Compiled Version    1.2.11
Linked Version  1.2.11
Directive   Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level   -1  -1
zlib.output_handler no value    no value
Additional Modules
Module Name
Environment
Variable    Value
APACHE_RUN_DIR  /var/run/apache2
APACHE_PID_FILE     /var/run/apache2/apache2.pid
PATH    /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
APACHE_LOCK_DIR     /var/lock/apache2
LANG    C
APACHE_RUN_USER     xxx
APACHE_RUN_GROUP    xxx
APACHE_LOG_DIR  /var/log/apache2
PWD     /
PHP Variables
Variable    Value
$_SERVER['HTTP_HOST']   localhost
$_SERVER['HTTP_USER_AGENT'] Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:80.0) Gecko/20100101 Firefox/80.0
$_SERVER['HTTP_ACCEPT'] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
$_SERVER['HTTP_ACCEPT_LANGUAGE']    de,en-US;q=0.7,en;q=0.3
$_SERVER['HTTP_ACCEPT_ENCODING']    gzip, deflate
$_SERVER['HTTP_DNT']    1
$_SERVER['HTTP_CONNECTION'] keep-alive
$_SERVER['HTTP_UPGRADE_INSECURE_REQUESTS']  1
$_SERVER['PATH']    /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
$_SERVER['SERVER_SIGNATURE']    <address>Apache/2.4.29 (Ubuntu) Server at localhost Port 80</address>
$_SERVER['SERVER_SOFTWARE'] Apache/2.4.29 (Ubuntu)
$_SERVER['SERVER_NAME'] localhost
$_SERVER['SERVER_ADDR'] ::1
$_SERVER['SERVER_PORT'] 80
$_SERVER['REMOTE_ADDR'] ::1
$_SERVER['DOCUMENT_ROOT']   /home/xxx/www/
$_SERVER['REQUEST_SCHEME']  http
$_SERVER['CONTEXT_PREFIX']  no value
$_SERVER['CONTEXT_DOCUMENT_ROOT']   /home/xxx/www/
$_SERVER['SERVER_ADMIN']    webmaster@localhost
$_SERVER['SCRIPT_FILENAME'] /home/xxx/www/index.php
$_SERVER['REMOTE_PORT'] 41764
$_SERVER['GATEWAY_INTERFACE']   CGI/1.1
$_SERVER['SERVER_PROTOCOL'] HTTP/1.1
$_SERVER['REQUEST_METHOD']  GET
$_SERVER['QUERY_STRING']    no value
$_SERVER['REQUEST_URI'] /
$_SERVER['SCRIPT_NAME'] /index.php
$_SERVER['PHP_SELF']    /index.php
$_SERVER['REQUEST_TIME_FLOAT']  1598858994.3943
$_SERVER['REQUEST_TIME']    1598858994
PHP Credits
PHP Group
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski
Language Design & Concept
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger
PHP Authors
Contribution    Authors
Zend Scripting Language Engine  Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API    Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization   Stig Bakken, Sascha Schumann, Jani Taskinen, Peter Kokot
Windows Support     Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski, Kalle Sommer Nielsen
Server API (SAPI) Abstraction Layer     Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer   Wez Furlong, Sara Golemon
PHP Data Objects Layer  Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler  Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
Consistent 64 bit support   Anthony Ferrara, Anatol Belski
SAPI Modules
Contribution    Authors
Apache 2.0 Handler  Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
CGI / FastCGI   Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI     Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Embed   Edin Kadribasic
FastCGI Process Manager     Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
litespeed   George Wang
phpdbg  Felipe Pena, Joe Watkins, Bob Weinand
Module Authors
Module  Authors
BC Math     Andi Gutmans
Bzip2   Sterling Hughes
Calendar    Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net    Wez Furlong
ctype   Hartmut Holzgraefe
cURL    Sterling Hughes
Date/Time Support   Derick Rethans
DB-LIB (MS SQL, Sybase)     Wez Furlong, Frank M. Kromann, Adam Baratz
DBA     Sascha Schumann, Marcus Boerger
DOM     Christian Stocker, Rob Richards, Marcus Boerger
enchant     Pierre-Alain Joye, Ilia Alshanetsky
EXIF    Rasmus Lerdorf, Marcus Boerger
FFI     Dmitry Stogov
fileinfo    Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans, Anatol Belski
Firebird driver for PDO     Ard Biesheuvel
FTP     Stefan Esser, Andrew Skalski
GD imaging  Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText     Alex Plotnick
GNU GMP support     Stanislav Malyshev
Iconv   Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP    Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter    Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
Internationalization    Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON    Jakub Zelenka, Omar Kilani, Scott MacVicar
LDAP    Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML  Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
Multibyte String Functions  Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO    George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQLi  Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd     Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8    Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO     Wez Furlong
ODBC    Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
Opcache     Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Dmitry Stogov, Xinchen Hui
OpenSSL     Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO     Wez Furlong
pcntl   Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps     Andrei Zmievski
PHP Archive     Gregory Beaver, Marcus Boerger
PHP Data Objects    Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash    Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix   Kristian Koehntopp
PostgreSQL driver for PDO   Edin Kadribasic, Ilia Alshanetsky
PostgreSQL  Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell  Vlad Krupin
Readline    Thies C. Arntzen
Reflection  Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions    Sascha Schumann, Andrei Zmievski
Shared Memory Operations    Slava Poliakov, Ilia Alshanetsky
SimpleXML   Sterling Hughes, Marcus Boerger, Rob Richards
SNMP    Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP    Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets     Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
Sodium  Frank Denis
SPL     Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO   Wez Furlong
SQLite3     Scott MacVicar, Ilia Alshanetsky, Brad Dewar
System V Message based IPC  Wez Furlong
System V Semaphores     Tom May
System V Shared Memory  Christian Cartus
tidy    John Coggeshall, Ilia Alshanetsky
tokenizer   Andrei Zmievski, Johannes Schlueter
XML     Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader   Rob Richards
xmlrpc  Dan Libby
XMLWriter   Rob Richards, Pierre-Alain Joye
XSL     Christian Stocker, Rob Richards
Zip     Pierre-Alain Joye, Remi Collet
Zlib    Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner
PHP Documentation
Authors     Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Philip Olson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey
Editor  Peter Cowburn
User Note Maintainers   Daniel P. Brown, Thiago Henrique Pojda
Other Contributors  Previously active authors, editors and other contributors are listed in the manual.
PHP Quality Assurance Team
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs
Websites and Infrastructure team
PHP Websites Team   Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers   Damien Seguy, Daniel P. Brown
Network Infrastructure  Daniel P. Brown
Windows Infrastructure  Alex Schoenmaker
aerni commented 4 years ago

I just released v1.0.0-beta.14. Please update and try again.

el-schneider commented 4 years ago

Nice! That did the trick. It’s working now. Thanks a lot.

aerni commented 4 years ago

Perfect!