Hi ruppmar,

May I ask what version of concrete5 are you using and what PHP version is the website running?

Best regards,
Neil

Hello Neil,
thanks for replying so quickly.
PHP Version on Server is: 7.0.33


# concrete5 Version
Core Version - 8.5.2
Version Installed - 8.5.2
Database Version - 20190925072210

# Database Information
Version: 10.2.31-MariaDB
SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# concrete5 Packages
Cookies Notice (1.3.2), Cosmos Theme (1.3.6), Crimson (1.3.0)

# concrete5 Overrides
None

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
7.0.33

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imagick, imap, intl, ionCube Loader, json, ldap, libxml, mbstring, mcrypt, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, redis, Reflection, session, SimpleXML, soap, sockets, sodium, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 120
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 120
max_input_vars - 1800
memory_limit - 512M
post_max_size - 32M
sql.safe_mode - Off
upload_max_filesize - 32M
ldap.max_links - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Hi ruppmar,

Can you disable the ‘Strict Mode’ in MySQL on the server of your website? Let me know if this solves the installation issue of the Cosmos theme.

Best regards,
Neil

Hello Neil,

Thanks for responding so quickly. Tried to find a way to disable strict mode using phpmyadmin but haven't been able to do so far. If you would happen to have a tutorial to do so, I would appreciate it highly.
By the way, I have setup a new instance with of concrete 5 with cosmos theme, latest php version 7.3.15 but still no success.
As said, if you could provide a way to disable strict mode, it would be highly helpful.

thanks
Martin

Hello Neil,

Any update on this topic?

Thanks
Martin

Hi Martin,

Are you running your own MySQL server? If not, you may need to ask your ISP to do it for you.

The following gives a bit more information on doing it yourself.

https://www.linode.com/community/questions/17070/how-can-i-disable-m...

Let me know how you get on.

Kind regards

Rob

Hello Rob,

I just got word from my webhoster:
MySQL Strict Mode is a security feature of the MariaDB 10.2 and cannot be deactivated.

Please provide a solution for this situation,

Thanks
Martin

Hi Martin,

Your ISP may not want to disable strict mode, but it is possible in maria-db and the methodology is the same as that of MySQL.

https://forums.cpanel.net/threads/mariadb-10-2-disabling-strict-mode...

At the moment, we don't have a quick solution, but I have raised a support issue with our team to amend this in the next release. In the mean time, if you are unable to disable strict mode or find an ISP willing to support your C5 installation, we would be happy to refund you.

Please request the refund via link at the top of this page.

Kind regards

Rob

I had this same issue. Temporarily disabling strict mode worked. This should be fixed!

Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.