SobiPro issueshttps://code.sigsiu.net/Sigsiu.NET/SobiPro/-/issues2018-05-11T11:05:10Zhttps://code.sigsiu.net/Sigsiu.NET/SobiPro/-/issues/96'Specified key was too long; max key length is 767 bytes' on SobiPro installa...2018-05-11T11:05:10ZSigrid Suski'Specified key was too long; max key length is 767 bytes' on SobiPro installation (some servers only)https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes
767 bytes is the stated prefix limitation for InnoDB tables in MySQL version 5.6 (and prior versions). It's 1,000 bytes long for MyISAM tables. In MySQL version 5.7 and upwards this limit has been increased to 3072 bytes.
The index limit is 767 bytes, not characters. And since Mysql's utf8mb4 character set (which the rest of the world calls utf8) needs (at most) 4 bytes per character you can only index up to VARCHAR(191)https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes
767 bytes is the stated prefix limitation for InnoDB tables in MySQL version 5.6 (and prior versions). It's 1,000 bytes long for MyISAM tables. In MySQL version 5.7 and upwards this limit has been increased to 3072 bytes.
The index limit is 767 bytes, not characters. And since Mysql's utf8mb4 character set (which the rest of the world calls utf8) needs (at most) 4 bytes per character you can only index up to VARCHAR(191)1.4.7.2Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/SobiPro/-/issues/95Error after every several tries of component update2018-05-11T11:05:10ZSÅ‚awek SikoraError after every several tries of component updateEvery few times when I update component, I see following error:
```
Warning
Unable to write archive
JFolder: :delete: Path is not a folder. Path: /home/sikorasobipro/test2.sikora.sobipro.eu/components/com_sobipro/media
Error
Error installing component
```
after this error I can again install update without problem. So let say, I install it once, is ok, 2nd time appear error, i try 3rd time and again update will install properly.Every few times when I update component, I see following error:
```
Warning
Unable to write archive
JFolder: :delete: Path is not a folder. Path: /home/sikorasobipro/test2.sikora.sobipro.eu/components/com_sobipro/media
Error
Error installing component
```
after this error I can again install update without problem. So let say, I install it once, is ok, 2nd time appear error, i try 3rd time and again update will install properly.1.4.7.2Sigrid SuskiSigrid Suski