Calendar Field issueshttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues2022-07-04T13:44:46Zhttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/30Ordering entries by calendar field in the back-end2022-07-04T13:44:46ZSławek SikoraOrdering entries by calendar field in the back-endSeems like ordering entries in the back-end by calendar field doesn't work, entries are always sorted by ID ascending.Seems like ordering entries in the back-end by calendar field doesn't work, entries are always sorted by ID ascending.3.0.1Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/29Entries in calendar listing are not shown for months which are between start ...2022-04-27T11:48:30ZSławek SikoraEntries in calendar listing are not shown for months which are between start and end monthWhen entry is set to be long for few months, for example from 20th may to 10 october, then in the calendar view it is marked only in the may and october, it isn't displayed in the full months.When entry is set to be long for few months, for example from 20th may to 10 october, then in the calendar view it is marked only in the may and october, it isn't displayed in the full months.3.0 BetaSigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/28Warnings in the calendar view iwth PHP82022-04-27T11:48:39ZSławek SikoraWarnings in the calendar view iwth PHP8There are warnings in the calendar view when entry need to be displayed in more than one month and used is PHP8.
`Warning: Undefined array key "attributes" in /home/sikorasobipro/test3.sikora.sobipro.eu/components/com_sobipro/lib/views/calendar.php on line 87`There are warnings in the calendar view when entry need to be displayed in more than one month and used is PHP8.
`Warning: Undefined array key "attributes" in /home/sikorasobipro/test3.sikora.sobipro.eu/components/com_sobipro/lib/views/calendar.php on line 87`3.0 BetaSigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/27Can't install calendar field2022-04-27T11:48:46ZSławek SikoraCan't install calendar fieldI can't install calendar field, got following error:
An error has occurred.
- 500 Cannot execute queries. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1.
-
- Call stack
- # Function Location
- 1 () JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:216
- 2 SPJoomlaMainFrame->runAway() JROOT/components/com_sobipro/lib/base/exception.php:232
- 3 SPExceptionHandler()
- 4 trigger_error() JROOT/components/com_sobipro/lib/sobi.php:107
- 5 Sobi::Error() JROOT/components/com_sobipro/lib/services/installers/sobiproapp.php:124
- 6 SPAppInstaller->install() JROOT/components/com_sobipro/lib/ctrl/adm/extensions.php:1400
- 7 SPExtensionsCtrl->install() JROOT/components/com_sobipro/lib/ctrl/adm/extensions.php:84
- 8 SPExtensionsCtrl->execute() JROOT/components/com_sobipro/lib/ctrl/adm/sobipro.php:458
- 9 SobiProAdmCtrl->execute() JROOT/administrator/components/com_sobipro/sobipro.php:57
- 10 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:69
- 11 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
- 12 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:389
- 13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
- 14 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
- 15 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:278
- 16 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:63
- 17 require_once() JROOT/administrator/index.php:32
Tested with SobiPro 2.0.0.42 RC and Calendar field 3.0.0.1 on both Joomla and PHP versionsI can't install calendar field, got following error:
An error has occurred.
- 500 Cannot execute queries. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1.
-
- Call stack
- # Function Location
- 1 () JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:216
- 2 SPJoomlaMainFrame->runAway() JROOT/components/com_sobipro/lib/base/exception.php:232
- 3 SPExceptionHandler()
- 4 trigger_error() JROOT/components/com_sobipro/lib/sobi.php:107
- 5 Sobi::Error() JROOT/components/com_sobipro/lib/services/installers/sobiproapp.php:124
- 6 SPAppInstaller->install() JROOT/components/com_sobipro/lib/ctrl/adm/extensions.php:1400
- 7 SPExtensionsCtrl->install() JROOT/components/com_sobipro/lib/ctrl/adm/extensions.php:84
- 8 SPExtensionsCtrl->execute() JROOT/components/com_sobipro/lib/ctrl/adm/sobipro.php:458
- 9 SobiProAdmCtrl->execute() JROOT/administrator/components/com_sobipro/sobipro.php:57
- 10 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:69
- 11 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
- 12 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:389
- 13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
- 14 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
- 15 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:278
- 16 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:63
- 17 require_once() JROOT/administrator/index.php:32
Tested with SobiPro 2.0.0.42 RC and Calendar field 3.0.0.1 on both Joomla and PHP versions3.0 BetaSigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/23Warning message at the search page2020-12-29T13:13:21ZSławek SikoraWarning message at the search pageWhen calendar field is set as searchable, following warning is generated at the search page:<br />
Warning: count(): Parameter must be an array or an object that implements Countable in .../components/com_sobipro/opt/fields/calendar.php on line 1038When calendar field is set as searchable, following warning is generated at the search page:<br />
Warning: count(): Parameter must be an array or an object that implements Countable in .../components/com_sobipro/opt/fields/calendar.php on line 10382.4Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/22Adding calendar field to meta data causes XML error2020-12-29T13:12:23ZSławek SikoraAdding calendar field to meta data causes XML errorWhen ~~calendar field is set to be a time period field and~~ we set it to add data to the meta description or keys, there appear following error at the front-end entry view:
```
0 Argument 1 passed to DOMNode::appendChild() must be an instance of DOMNode, null given
/home/srv17555/domains/srv17555.microhost.com.pl/public_html/components/com_sobipro/lib/mlo/template_xslt.php:308
Call stack
# Function Location
1 () JROOT/components/com_sobipro/lib/mlo/template_xslt.php:308
2 DOMNode->appendChild() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:308
3 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:242
4 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:295
5 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:242
6 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:242
7 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:295
8 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:173
9 SPTemplateXSLT->createXML() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:88
10 SPTemplateXSLT->display() JROOT/components/com_sobipro/lib/views/view.php:336
11 SPFrontView->display() JROOT/components/com_sobipro/lib/views/entry.php:44
12 SPEntryView->display() JROOT/components/com_sobipro/lib/ctrl/entry.php:737
13 SPEntryCtrl->details() JROOT/components/com_sobipro/lib/ctrl/entry.php:73
14 SPEntryCtrl->execute() JROOT/components/com_sobipro/lib/ctrl/sobipro.php:535
15 SobiProCtrl->execute() JROOT/components/com_sobipro/sobipro.php:47
16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
19 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
20 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
21 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
```When ~~calendar field is set to be a time period field and~~ we set it to add data to the meta description or keys, there appear following error at the front-end entry view:
```
0 Argument 1 passed to DOMNode::appendChild() must be an instance of DOMNode, null given
/home/srv17555/domains/srv17555.microhost.com.pl/public_html/components/com_sobipro/lib/mlo/template_xslt.php:308
Call stack
# Function Location
1 () JROOT/components/com_sobipro/lib/mlo/template_xslt.php:308
2 DOMNode->appendChild() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:308
3 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:242
4 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:295
5 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:242
6 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:242
7 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:295
8 SPTemplateXSLT->createNode() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:173
9 SPTemplateXSLT->createXML() JROOT/components/com_sobipro/lib/mlo/template_xslt.php:88
10 SPTemplateXSLT->display() JROOT/components/com_sobipro/lib/views/view.php:336
11 SPFrontView->display() JROOT/components/com_sobipro/lib/views/entry.php:44
12 SPEntryView->display() JROOT/components/com_sobipro/lib/ctrl/entry.php:737
13 SPEntryCtrl->details() JROOT/components/com_sobipro/lib/ctrl/entry.php:73
14 SPEntryCtrl->execute() JROOT/components/com_sobipro/lib/ctrl/sobipro.php:535
15 SobiProCtrl->execute() JROOT/components/com_sobipro/sobipro.php:47
16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
19 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
20 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
21 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
```2.4Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/21Datepickler shows wrong date in time period mode2020-12-29T13:13:00ZSławek SikoraDatepickler shows wrong date in time period modeThis happens when we enter first time data to the calendar field in the entry. Let say today is 16.11, in the 'date from' field we set for example 18.11, this will set date for this field and automatically change date of 'date to' field also to 18.11, but when we open datepicker for this field, there is still selected today (16.11).This happens when we enter first time data to the calendar field in the entry. Let say today is 16.11, in the 'date from' field we set for example 18.11, this will set date for this field and automatically change date of 'date to' field also to 18.11, but when we open datepicker for this field, there is still selected today (16.11).Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/20sorting by calendar field2020-12-29T13:13:48ZSławek Sikorasorting by calendar fieldSorting entries by calendar field in the front-end is no longer possible. There is no option in the template settings, also setting order by such field directly in the json file don't work.Sorting entries by calendar field in the front-end is no longer possible. There is no option in the template settings, also setting order by such field directly in the json file don't work.2.4Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/19Popover data in calendar view loading problem2020-12-29T13:12:35ZSławek SikoraPopover data in calendar view loading problemWhen in the calendar view we hover mouse over entries there appear popup where load entry data. However when we move cursor from the entry before ajax finish loading data, then when we try to show it one more time only entry name appear and spinner - rest of the data will be no longer loaded until page refresh.When in the calendar view we hover mouse over entries there appear popup where load entry data. However when we move cursor from the entry before ajax finish loading data, then when we try to show it one more time only entry name appear and spinner - rest of the data will be no longer loaded until page refresh.2.4Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/18Form refill with calendar field data generate error2020-12-29T13:12:41ZSławek SikoraForm refill with calendar field data generate errorWhen form is refilled after leaving it from payment summary page and calendar field contains any data there appear error:<br />
0 Unsupported operand typesWhen form is refilled after leaving it from payment summary page and calendar field contains any data there appear error:<br />
0 Unsupported operand types2.4Radek SuskiRadek Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/17calendar view stop working2018-04-26T15:56:39ZSł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.`https://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/16Time period which lasts less than 24h is displayed as one day date2020-12-29T13:12:46ZSławek SikoraTime period which lasts less than 24h is displayed as one day dateThis happens when we specify time period date which start in one day and end in 2nd but time between start and end is shorten (or equal) than 24h. For example, if we specify start as 24.04.2018 13:00 and end 25.04.2018 at 12:00 at the entry view will appear as 24.04.2018, if we change end time to 25.04.2018 13:01 then we will see at entry view both dates.<br />
This affect very much situation when only date (without time) is selected in entry edit form, then when we set 24th to 25th it set in most cases same time for bot dates and in the result in the entry we will see only first dateThis happens when we specify time period date which start in one day and end in 2nd but time between start and end is shorten (or equal) than 24h. For example, if we specify start as 24.04.2018 13:00 and end 25.04.2018 at 12:00 at the entry view will appear as 24.04.2018, if we change end time to 25.04.2018 13:01 then we will see at entry view both dates.<br />
This affect very much situation when only date (without time) is selected in entry edit form, then when we set 24th to 25th it set in most cases same time for bot dates and in the result in the entry we will see only first date2.4Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/15Field data will be duplicated in DB; as result the date cannot longer be changed2017-09-14T15:45:09ZSigrid SuskiField data will be duplicated in DB; as result the date cannot longer be changedcaused by setting the language in the DB added in the last version.
Solution:
Installation of Calendar Field 2.3
After that this query needs to be performed:
DELETE FROM `xxx_sobipro_field_data` WHERE `fid` = 'yy' and `lang` != ''
Replace xxx with your database prefix and yy with the id of your calendar fieldcaused by setting the language in the DB added in the last version.
Solution:
Installation of Calendar Field 2.3
After that this query needs to be performed:
DELETE FROM `xxx_sobipro_field_data` WHERE `fid` = 'yy' and `lang` != ''
Replace xxx with your database prefix and yy with the id of your calendar field2.3Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/24Ordering in back-end entries view by calendar field2020-12-29T13:12:53ZSławek SikoraOrdering in back-end entries view by calendar fieldOrdering in the admin view of entries in the back-end by calendar field ascending or descending doesn't sort entries by date.Ordering in the admin view of entries in the back-end by calendar field ascending or descending doesn't sort entries by date.2.4Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/13Wrong disaplying of 'text' dates in the back-end entries view2017-07-25T11:41:23ZSławek SikoraWrong disaplying of 'text' dates in the back-end entries viewWhen cache is enabled and build, and calendar field is set to be visible in the Admin List all text dates are displaying in the following way:
CFA_OUT_YEARLYWhen cache is enabled and build, and calendar field is set to be visible in the Admin List all text dates are displaying in the following way:
CFA_OUT_YEARLY2.2Radek SuskiRadek Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/12Lack of 'no date set' info2017-07-25T11:41:36ZSławek SikoraLack of 'no date set' infoI'm not sure if this is a bug, but when calendar field don't have set recurrent data or time period options, and entry is saved without data in this field, then such field don't show 'no date set' message in the entry view. Example XML data for three calendar fields:<br />
```
<field_standard_date id="5" itemprop="" type="calendar" suffix="" position="2" css_view="spClassViewCalendar" css-view="spClassViewCalendar" css_class="spClassCalendar" css-class="spClassCalendar">
<label lang="en-GB" show="1">Standard date</label>
<data></data>
</field_standard_date>
<field_recurrent_date id="6" itemprop="" type="calendar" suffix="" position="3" css_view="spClassViewCalendar" css-view="spClassViewCalendar" css_class="spClassCalendar" css-class="spClassCalendar">
<label lang="en-GB" show="1">Recurrent date</label>
<data lang="en-GB" class="spClassCalendar" timestamp="0" startdate="0" enddate="0" offset="0">no date set</data>
</field_recurrent_date>
<field_time_period id="7" itemprop="" type="calendar" suffix="" position="4" css_view="spClassViewCalendar" css-view="spClassViewCalendar" css_class="spClassCalendar" css-class="spClassCalendar">
<label lang="en-GB" show="1">Time period</label>
<data lang="en-GB" class="spClassCalendar" timestamp="0" startdate="0" enddate="0" offset="0">no date set</data>
</field_time_period>
```
Tested with ver. 2.2.0.10I'm not sure if this is a bug, but when calendar field don't have set recurrent data or time period options, and entry is saved without data in this field, then such field don't show 'no date set' message in the entry view. Example XML data for three calendar fields:<br />
```
<field_standard_date id="5" itemprop="" type="calendar" suffix="" position="2" css_view="spClassViewCalendar" css-view="spClassViewCalendar" css_class="spClassCalendar" css-class="spClassCalendar">
<label lang="en-GB" show="1">Standard date</label>
<data></data>
</field_standard_date>
<field_recurrent_date id="6" itemprop="" type="calendar" suffix="" position="3" css_view="spClassViewCalendar" css-view="spClassViewCalendar" css_class="spClassCalendar" css-class="spClassCalendar">
<label lang="en-GB" show="1">Recurrent date</label>
<data lang="en-GB" class="spClassCalendar" timestamp="0" startdate="0" enddate="0" offset="0">no date set</data>
</field_recurrent_date>
<field_time_period id="7" itemprop="" type="calendar" suffix="" position="4" css_view="spClassViewCalendar" css-view="spClassViewCalendar" css_class="spClassCalendar" css-class="spClassCalendar">
<label lang="en-GB" show="1">Time period</label>
<data lang="en-GB" class="spClassCalendar" timestamp="0" startdate="0" enddate="0" offset="0">no date set</data>
</field_time_period>
```
Tested with ver. 2.2.0.102.2Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/11Template files aren't copied to the section template2017-07-25T11:41:47ZSławek SikoraTemplate files aren't copied to the section templateEven on clean installation, when calendar field is added to the section, calendar template files aren't copied to the section template listing folder. They need to be copied manually in this moment.Even on clean installation, when calendar field is added to the section, calendar template files aren't copied to the section template listing folder. They need to be copied manually in this moment.2.2Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/10In Admin List visble is timestamp value2017-07-25T11:41:56ZSławek SikoraIn Admin List visble is timestamp valueAfter enabling Show in Admin List option, in the entries list is displayed timestamp value instead of the regular dateAfter enabling Show in Admin List option, in the entries list is displayed timestamp value instead of the regular date2.2Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/9Wrong dates displaying on the front-end2017-07-25T11:42:06ZSławek SikoraWrong dates displaying on the front-endIt looks like now when calendar field don't have set recurrent or time period option it doesn't display any data on the front-end, however in edit page date set in this field during creation is displayed properly.<br />
When field have enabled recurrent date option it is displayed as time period date with 'from to' text. For example, if I set 18.07.2017 recurrent weekly, on the front-end appear:<br />
> each week from Tuesday to ThursdayIt looks like now when calendar field don't have set recurrent or time period option it doesn't display any data on the front-end, however in edit page date set in this field during creation is displayed properly.<br />
When field have enabled recurrent date option it is displayed as time period date with 'from to' text. For example, if I set 18.07.2017 recurrent weekly, on the front-end appear:<br />
> each week from Tuesday to Thursday2.2Sigrid SuskiSigrid Suskihttps://code.sigsiu.net/Sigsiu.NET/CalendarField/-/issues/7Missed Ajax navigation for calendar view2017-07-25T11:42:38ZSławek SikoraMissed Ajax navigation for calendar viewLooks like in latest version stop working Ajax navigation for calendar view, now changing months reload whole page.Looks like in latest version stop working Ajax navigation for calendar view, now changing months reload whole page.2.2Sigrid SuskiSigrid Suski