Strona 1 z 1

MYSQL error

: 27 gru 2018, 00:47:48
autor: gaminek_
Witam, przy instalacji IPB 3.4.6 wyskakuje mi error z bazą danych mysql:

Kod: Zaznacz cały

mySQL query error: CREATE TABLE  IPB_backup_vars (
  backup_var_key    VARCHAR(255) NOT NULL DEFAULT '',
  backup_var_value  TEXT,
  PRIMARY KEY (backup_var_key)
) ENGINE=MyISAM;

SQL error: Specified key was too long; max key length is 1000 bytes
SQL error code: 1071
Date: Wednesday 26th December 2018 11:43:57 PM


 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Wed, 26 Dec 2018 23:43:57 +0000
 Error: 1071 - Specified key was too long; max key length is 1000 bytes
 IP Address: 127.0.0.1 - /admin/install/index.php?app=install§ion=install&do=sql
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: CREATE TABLE  IPB_backup_vars (
  backup_var_key    VARCHAR(255) NOT NULL DEFAULT '',
  backup_var_value  TEXT,
  PRIMARY KEY (backup_var_key)
) ENGINE=MyISAM;
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/setup/applications/install/sections/install.php                      | [install_install].install_sql                                                 | 89                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/setup/sources/base/ipsController_setup.php                           | [install_install].doExecute                                                   | 258               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

MYSQL error

: 30 gru 2018, 13:28:28
autor: endriu888
witam

na jakiej domenie?

MYSQL error

: 30 gru 2018, 13:43:54
autor: endriu888
MyISAM ma tylko klucze 1000 bajtowe, a utf8mb4 zajmuje 4 bajty na znak, więc varchar(255) zajmuje 255 * 4. Na VPsie lub dedyku można zainstalować mysql z InnoDB. Wtedy nie będzie tego problemu