- Added birthday counters to the monthly view.
- Added a daily birthday overlay trigger for the monthly view.
- Added the ability to filter the agenda view with a search query.
- Added button link to clear the RSVP filter on the agenda view.
- Added holidays to the weekly view (in addition to the monthly).
- Date numbers on the monthly and weekly views now link to that day's daily view.
THE FOLLOWING ERROR OCCURRED:
Mysqli statement execute error : Data too long for column 'event_repeat' at row 1
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
XenForo_DataWriter->save() in EWRatendo2/Model/Events.php at line 87
EWRatendo2_Model_Events->updateEvent() in EWRatendo2/ControllerPublic/Calendar.php at line 135
EWRatendo2_ControllerPublic_Calendar->actionCreate() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in G:/xampp/htdocs/cozworld/index.php at line 13
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'event_repeat' at row 1 - library\Zend\Db\Statement\Mysqli.php:214
Generated By: CoZmicShReddeR, 4 minutes ago
Stack Trace
#0 G:\xampp\htdocs\cozworld\library\Zend\Db\Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 G:\xampp\htdocs\cozworld\library\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 G:\xampp\htdocs\cozworld\library\Zend\Db\Adapter\Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `EW...', Array)
#3 G:\xampp\htdocs\cozworld\library\XenForo\DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('EWRatendo2_even...', Array)
#4 G:\xampp\htdocs\cozworld\library\XenForo\DataWriter.php(1613): XenForo_DataWriter->_insert()
#5 G:\xampp\htdocs\cozworld\library\XenForo\DataWriter.php(1405): XenForo_DataWriter->_save()
#6 G:\xampp\htdocs\cozworld\library\EWRatendo2\Model\Events.php(87): XenForo_DataWriter->save()
#7 G:\xampp\htdocs\cozworld\library\EWRatendo2\ControllerPublic\Calendar.php(135): EWRatendo2_Model_Events->updateEvent(Array)
#8 G:\xampp\htdocs\cozworld\library\XenForo\FrontController.php(347): EWRatendo2_ControllerPublic_Calendar->actionCreate()
#9 G:\xampp\htdocs\cozworld\library\XenForo\FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 G:\xampp\htdocs\cozworld\index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(39) "http://www.cozworld.com/calendar/create"
["_GET"] => array(0) {
}
["_POST"] => array(16) {
["event_title"] => string(36) "First Tuesday of the Month Check in!"
["event_description_html"] => string(628) "<p style="text-align: center;"><b><font size="6"><img src="http://vignette2.wikia.nocookie.net/tjs-survivor-series/images/d/dd/Hartman_Icon.jpg" alt="[IMG]" unselectable="on"> <br></font></b></p><p style="text-align: center;"><b><font size="7">Sound off if you got a pair! </font></b></p><p style="text-align: center;"><b><font size="7"><br></font></b></p><p style="text-align: center;"><b><font size="7">First Tuesday of the Month Check in!</font></b></p><p style="text-align: center;"><b><font size="7"><br></font></b></p><p style="text-align: center;"><b><font size="7">Anyone is welcome to check in!</font></b></p>"
["_xfRelativeResolver"] => string(39) "http://www.cozworld.com/calendar/create"
["event_location"] => string(12) "This website"
["event_address"] => string(0) ""
["occur_start"] => array(4) {
["date"] => string(10) "2015-09-22"
["hour"] => string(2) "12"
["mins"] => string(1) "0"
["meri"] => string(2) "AM"
}
["occur_end"] => array(4) {
["date"] => string(10) "2015-09-22"
["hour"] => string(2) "12"
["mins"] => string(1) "0"
["meri"] => string(2) "PM"
}
["occur_timezone"] => string(16) "America/New_York"
["event_recur"] => string(1) "2"
["event_repeat"] => array(3) {
["ordinal"] => string(5) "first"
["dayname"] => string(3) "tue"
["limit"] => string(2) "10"
}
["create_thread"] => string(1) "1"
["event_node"] => string(3) "218"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(16) "/calendar/create"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Tried setting an Event for Tuesdays got this error
Code:THE FOLLOWING ERROR OCCURRED: Mysqli statement execute error : Data too long for column 'event_repeat' at row 1 Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574 Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624 XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613 XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405 XenForo_DataWriter->save() in EWRatendo2/Model/Events.php at line 87 EWRatendo2_Model_Events->updateEvent() in EWRatendo2/ControllerPublic/Calendar.php at line 135 EWRatendo2_ControllerPublic_Calendar->actionCreate() in XenForo/FrontController.php at line 347 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in G:/xampp/htdocs/cozworld/index.php at line 13
When I get "zend" errors that typically means that something went wrong and that there was an interference, well... that is usually my case, maybe try to redo your entire process.
Hmm... I will do some research, if I find a solution I will get back to you.It's repeatable
Can you run this code on your DB and see if that fixes it?Tried setting an Event for Tuesdays got this error
Code:THE FOLLOWING ERROR OCCURRED: Mysqli statement execute error : Data too long for column 'event_repeat' at row 1 Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574 Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624 XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613 XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405 XenForo_DataWriter->save() in EWRatendo2/Model/Events.php at line 87 EWRatendo2_Model_Events->updateEvent() in EWRatendo2/ControllerPublic/Calendar.php at line 135 EWRatendo2_ControllerPublic_Calendar->actionCreate() in XenForo/FrontController.php at line 347 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in G:/xampp/htdocs/cozworld/index.php at line 13
I checked error logs this is what it said
Code:Server Error Log Error Info Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'event_repeat' at row 1 - library\Zend\Db\Statement\Mysqli.php:214 Generated By: CoZmicShReddeR, 4 minutes ago Stack Trace #0 G:\xampp\htdocs\cozworld\library\Zend\Db\Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array) #1 G:\xampp\htdocs\cozworld\library\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement->execute(Array) #2 G:\xampp\htdocs\cozworld\library\Zend\Db\Adapter\Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `EW...', Array) #3 G:\xampp\htdocs\cozworld\library\XenForo\DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('EWRatendo2_even...', Array) #4 G:\xampp\htdocs\cozworld\library\XenForo\DataWriter.php(1613): XenForo_DataWriter->_insert() #5 G:\xampp\htdocs\cozworld\library\XenForo\DataWriter.php(1405): XenForo_DataWriter->_save() #6 G:\xampp\htdocs\cozworld\library\EWRatendo2\Model\Events.php(87): XenForo_DataWriter->save() #7 G:\xampp\htdocs\cozworld\library\EWRatendo2\ControllerPublic\Calendar.php(135): EWRatendo2_Model_Events->updateEvent(Array) #8 G:\xampp\htdocs\cozworld\library\XenForo\FrontController.php(347): EWRatendo2_ControllerPublic_Calendar->actionCreate() #9 G:\xampp\htdocs\cozworld\library\XenForo\FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #10 G:\xampp\htdocs\cozworld\index.php(13): XenForo_FrontController->run() #11 {main} Request State array(3) { ["url"] => string(39) "http://www.cozworld.com/calendar/create" ["_GET"] => array(0) { } ["_POST"] => array(16) { ["event_title"] => string(36) "First Tuesday of the Month Check in!" ["event_description_html"] => string(628) "<p style="text-align: center;"><b><font size="6"><img src="http://vignette2.wikia.nocookie.net/tjs-survivor-series/images/d/dd/Hartman_Icon.jpg" alt="[IMG]" unselectable="on"> <br></font></b></p><p style="text-align: center;"><b><font size="7">Sound off if you got a pair! </font></b></p><p style="text-align: center;"><b><font size="7"><br></font></b></p><p style="text-align: center;"><b><font size="7">First Tuesday of the Month Check in!</font></b></p><p style="text-align: center;"><b><font size="7"><br></font></b></p><p style="text-align: center;"><b><font size="7">Anyone is welcome to check in!</font></b></p>" ["_xfRelativeResolver"] => string(39) "http://www.cozworld.com/calendar/create" ["event_location"] => string(12) "This website" ["event_address"] => string(0) "" ["occur_start"] => array(4) { ["date"] => string(10) "2015-09-22" ["hour"] => string(2) "12" ["mins"] => string(1) "0" ["meri"] => string(2) "AM" } ["occur_end"] => array(4) { ["date"] => string(10) "2015-09-22" ["hour"] => string(2) "12" ["mins"] => string(1) "0" ["meri"] => string(2) "PM" } ["occur_timezone"] => string(16) "America/New_York" ["event_recur"] => string(1) "2" ["event_repeat"] => array(3) { ["ordinal"] => string(5) "first" ["dayname"] => string(3) "tue" ["limit"] => string(2) "10" } ["create_thread"] => string(1) "1" ["event_node"] => string(3) "218" ["_xfToken"] => string(8) "********" ["_xfRequestUri"] => string(16) "/calendar/create" ["_xfNoRedirect"] => string(1) "1" ["_xfResponseType"] => string(4) "json" } }
ALTER TABLE `EWRatendo2_events` CHANGE `event_repeat` `event_repeat` VARCHAR(50) NOT NULL
Can you run this code on your DB and see if that fixes it?
Code:ALTER TABLE `EWRatendo2_events` CHANGE `event_repeat` `event_repeat` VARCHAR(50) NOT NULL
+1Meaning that I could create a public google calendar, subscribe to my sites ical (from this add-on) and all existing (future dated) and newly created events will be automatically synchronised to this google calendar?
This update fixes a fundamental error when using keyword filtering that makes duplicates to events when they have more than one non-excluded keyword. In addition, it slightly alters a single function which will be required for the XenPorta2 widget I will be releasing later today.
Export to Google Calendar only works with single occurrences... not the entire event...a possible bug: on Event Tools there's no Export to Google Calendar
another thing:
where can I test the Export (sync?) to ICS o Google Calendar of the whole calendar (or only of some categories)?
Check your spam folders.I did not get the update email. I got the XenPorta2 email 8 times though.
- You can now use view->template based bbcodes in your event descriptions (such as the [spoiler] tag)
- The event description bbcode now places an "Edit Event Description" button below the embedded text. Some users just didnt seem to understand that you had to edit the event information to edit the text in the first post of a thread; so this new button will make it easier for them.
- You can now export the ENTIRE calendar (technically only the next 50 events) to...
Thank you Jaxel for the export of the entire calendar!Jaxel updated [8wayRun.Com] XenAtendo 2 (Events) PRO with a new update entry:
Version 1.0.5 CHANGELOG
Read the rest of this update entry...
The ICS file is recreated every time... however, its a single query... so its even smaller and more lightweight than actually viewing a page on your website. You can increase the event number by editing the action in the PHP file... but past events are not currently a possibility.Thank you Jaxel for the export of the entire calendar!
I own a Jeremy's Events license but I think that I will choose XenAtendo 2 as it has some basic feature that Events has not and I don't know if it will in the future (for example the upcoming event list).
A question about the ics/google calendar export:
The ics file is recreated every time? Or is there a cronjob that create/update static ics files (whole calendar and categories)?
I'm asking this because If many people export the entire calendar than all the ics clients will start to ask updates asking the addon to recreate every time. Having static files updated by a cronjob I think is a better idea.
Is it possible to configure the export make it export more events and past events too?
What do you think about it?
We use essential cookies to make this site work, and optional cookies to enhance your experience.