1 (edited by dmitry_79 2020-04-11 12:11:13)

Topic: SQL query error: 1115 Unknown character set 'utf8'

When installing, the file gives an error:

mycal: ERROR Script: /install478.php - SQL query error: SQLSTATE [42000]: Syntax error or access violation: 1115 Unknown character set 'utf8' or collation 'utf8_unicode_ci;'
Query string: SET NAMES utf8 COLLATE utf8_unicode_ci; SET CHARACTER SET utf8;

Hosting: 000webhost.com
Database Client Version: libmysql - mysqlnd 5.0.12
PHP Version: 7.3.12
Server Encoding: UTF-8 Unicode (utf8)

Tell me how to solve the problem?

Re: SQL query error: 1115 Unknown character set 'utf8'

I answer myself: I need to comment out the line "SET NAMES utf8 COLLATE utf8_unicode_ci; SET CHARACTER SET utf8;" in the /install478.php file

Re: SQL query error: 1115 Unknown character set 'utf8'

This is the first time I hear that the utf8 character set is not available on the server.
Correct, comment out the mentioned line (line 369) should solve the problem.

Roel