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 Suskihttps://code.sigsiu.net/Sigsiu.NET/SobiPro/-/issues/92modal windows for adding repository are not closed properly2018-05-11T11:05:10ZSigrid Suskimodal windows for adding repository are not closed properlywhen adding a new repository window, the modal popups are not closed properly and the line `<div class="modal-backdrop in"></div>` remains.
As these are 2 popups not closed properly it ends up in a black screen if the repository isn't added successfully.
temporary solution for users: double click on the screenwhen adding a new repository window, the modal popups are not closed properly and the line `<div class="modal-backdrop in"></div>` remains.
As these are 2 popups not closed properly it ends up in a black screen if the repository isn't added successfully.
temporary solution for users: double click on the screen1.4.7.2Radek SuskiRadek Suskihttps://code.sigsiu.net/Sigsiu.NET/SobiPro/-/issues/91Part of the Collection application data is missed2018-05-11T11:05:10ZSławek SikoraPart of the Collection application data is missedLooks like part of the collection application data in the collection view is missed after 1.4.6 core update. This is data available with SobiPro 1.4.5:<br />
```
<collection allow_contact="true" allow-contact="true" allow_share="true" allow-share="true" label="Send Message" url="/index.php/business-directory/collection?ssid=5ae82336e8fc5">
<button>
<a class="ctrl-collection-list" href="/index.php/business-directory/collection?ssid=5ae82336e8e05"><i class="icon-star"></i> Favourites</a>
</button>
<lists>
<list prompt="New List Name" cid="new" label="Create New List"/>
<list cid="5ae821afec073" label="moja" public="false" url="/index.php/business-directory/collection?cid=5ae821afec073">
<entries>
<entry id="13876"/>
<entry id="13878"/>
<entry id="13884"/>
</entries>
</list>
</lists>
</collection>
```
and this is same view after update to 1.4.6
```
<collection>
<button>
<a class="ctrl-collection-list" href="/index.php/business-directory/collection?ssid=5ae821c3b933f"><i class="icon-star"></i> Favourites</a>
</button>
<lists>
<list prompt="New List Name" cid="new" label="Create New List"/>
<list cid="5ae821afec073" label="moja" public="false">
<entries>
<entry id="13876"/>
<entry id="13878"/>
<entry id="13884"/>
</entries>
</list>
</lists>
</collection>
```Looks like part of the collection application data in the collection view is missed after 1.4.6 core update. This is data available with SobiPro 1.4.5:<br />
```
<collection allow_contact="true" allow-contact="true" allow_share="true" allow-share="true" label="Send Message" url="/index.php/business-directory/collection?ssid=5ae82336e8fc5">
<button>
<a class="ctrl-collection-list" href="/index.php/business-directory/collection?ssid=5ae82336e8e05"><i class="icon-star"></i> Favourites</a>
</button>
<lists>
<list prompt="New List Name" cid="new" label="Create New List"/>
<list cid="5ae821afec073" label="moja" public="false" url="/index.php/business-directory/collection?cid=5ae821afec073">
<entries>
<entry id="13876"/>
<entry id="13878"/>
<entry id="13884"/>
</entries>
</list>
</lists>
</collection>
```
and this is same view after update to 1.4.6
```
<collection>
<button>
<a class="ctrl-collection-list" href="/index.php/business-directory/collection?ssid=5ae821c3b933f"><i class="icon-star"></i> Favourites</a>
</button>
<lists>
<list prompt="New List Name" cid="new" label="Create New List"/>
<list cid="5ae821afec073" label="moja" public="false">
<entries>
<entry id="13876"/>
<entry id="13878"/>
<entry id="13884"/>
</entries>
</list>
</lists>
</collection>
```1.4.7.2Radek SuskiRadek Suskihttps://code.sigsiu.net/Sigsiu.NET/SobiPro/-/issues/90calendar view stop working2018-05-11T11:05:10ZSławek Sikoracalendar view stop workingThere are no entries displayed in the calendar view, also navigation to other months generate 500 error:<br />
`Error: Call to undefined method Joomla\CMS\Document\RawDocument::addHeadLink(): Cannot load file at components/com_sobipro/opt/listing/view.php. File does not exist or is not readable.`There are no entries displayed in the calendar view, also navigation to other months generate 500 error:<br />
`Error: Call to undefined method Joomla\CMS\Document\RawDocument::addHeadLink(): Cannot load file at components/com_sobipro/opt/listing/view.php. File does not exist or is not readable.`1.4.7.2Radek SuskiRadek Suski