Index column size too large. The maximum column size is 767 bytes

Question

Index column size too large. The maximum column size is 767 bytes

binarweb opened this issue 4 years ago · 0 comments

Affected Symphony version(s) : 3.0.0
PHP version(s) : 7.2.2
MySQL version(s): Ver 15.1 Distrib 10.1.30-MariaDB
OS(es) : Win 7 x64 / XAMPP

While trying to install, I got this error:

A severe error occurred whilst trying to handle an exception, check the Symphony log for more details
Undefined index: user on 355 of file 
/var/www/example.com/public_html/install/lib/class.installerpage.php

I found the issue #2911 and I fixed the variables manually, because the solution regexp was replacing too much. After replacement, I got the installation form with no errors. After submitting the form, I got this error:

============================================
Log Created: 2020-05-02T11:03:46+02:00
============================================
Symphony Log
Opened:  2020-05-02T11:03:46+02:00
Version: 3.0.0
Domain:  localhost/symphonycms
--------------------------------------------
2020-05-02T11:03:46+02:00 5ead37 > Fatal Error: Installer - Missing requirements.
2020-05-02T11:03:46+02:00 5ead37 > Fatal Error: Requirement - XSLT extension not present
2020-05-02T11:05:06+02:00 5ead37 > Notice: ErrorHandler 8: Undefined index: user on line 355 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:05:06+02:00 5ead37 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:11:55+02:00 5ead39 > Fatal Error: ParseError 0 - syntax error, unexpected '$fields' (T_VARIABLE), expecting '(' on line 355 of F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:11:55+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:08+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 355 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:08+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:28+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 362 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:28+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:29+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 362 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:29+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:29+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 362 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:29+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:29+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 362 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:29+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:40+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 363 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:40+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:40+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 363 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:40+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:41+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 363 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:41+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:52+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 375 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:52+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:53+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 375 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:53+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:54+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 375 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:54+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:12:54+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 375 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:12:54+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php
2020-05-02T11:13:09+02:00 5ead39 > Notice: ErrorHandler 8: Undefined index: user on line 382 of file F:\xampp\htdocs\symphonycms\install\lib\class.installerpage.php
2020-05-02T11:13:09+02:00 5ead39 > Warning: ErrorHandler 2: Use of undefined constant SYMPHONY_URL - assumed 'SYMPHONY_URL' (this will throw an Error in a future version of PHP) on line 193 of file F:\xampp\htdocs\symphonycms\symphony\lib\core\class.exceptionrenderer.php

============================================
INSTALLATION PROCESS STARTED (2020-05-02T11:14:54+02:00)
============================================
2020-05-02T11:14:54+02:00 5ead3a > Notice: MYSQL: Establishing Connection
2020-05-02T11:14:54+02:00 5ead3a > Notice: MYSQL: Importing Table Schema
2020-05-02T11:14:55+02:00 5ead3a > Fatal Error: There was an error while trying to import data to the database. MySQL returned: 0: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. in query 
CREATE TABLE `sym_fields` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `element_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_section` int(11) unsigned NOT NULL DEFAULT '0',
  `required` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  `sortorder` int(11) signed NOT NULL DEFAULT '1',
  `location` enum('main','sidebar') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'main',
  `show_column` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`),
  KEY `index` (`element_name`,`type`,`parent_section`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
============================================
INSTALLATION ABORTED: Execution Time - 1 sec (02.05.20 11:14:55)
============================================

Notes:

the database was partially installed (with 5 tables)
XAMPP was installed 2 weeks ago