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

  • Registered: 2020-04-11
  • Posts: 2

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?

Quote Post 1

  • Registered: 2020-04-11
  • Posts: 2

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

Quote Post 2

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

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

Quote Post 3