my site is hosted at strato.de. They use mysql 5.6.39. When I try to install jdownloads, I got an error: „Index column size too large. The maximum column size is 767 bytes.“ Like in the manual stated, I tried an install from directory. I got the same error.
Stackoverflow says this is because mysql uses character set utf8 with 3 bytes per character, utf8mb4 is 4 bytes per character. There were several ways listet to solve this problem.
I changed in com_jdownloads\admin\sql\install.mysql.utf8.sql all lines
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; to
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
This solved the error but there was no box „Details of jdownload installation progress“ and no button „Start jdownloads now“ after the install. I did a second install, no box but the startbutton was there.
Jdownloads works but the installation process didn’t install some data (text) to the database: the standard layouts are listet like:
COM_JDOWNLOADS_BACKEND_SETTINGS_TEMPLATES_FILES_D EFAULT_NAME and not as expected: Alternatives Dateien Layout v3.2.
The same happens in a lot of textboxes in the configuration section, e.g. frontend | hints for guests, plugins | standard layout.
I don’t know, whether it was a good idea to change the install.mysql.utf8.sql file, but jdownload now works on my site.