0
Undo
Votes
Hi there,
first, I'd like to thank you for the possibility to use your calendar as free. I'm providing an website with my own money but can't spend it for all extensions I like to use.
Now to the problem.
Every year it is frustrating to import entries to the calendar, because there are everytime new problems to solve. I use the import function at 4th time and tried it in the same way like 2014, 2013 and 2012. The txt-file looks like this (I used the file from last year with updated dates):
I tried to create a new calendar with this file an get this error:
After that error I had a look at the entries "which are made".
Only the first entry in the txt-file is displayed at the backend.
I deleted it and want to delete the calendar too, but it is not possible, because it gives me the feedback that there will be some lost entries when it would be deleted.
But I can't find any entries in the calendar, so I can't delete them first.
There is also no way to save a new txt-file or update the old in the existing calendar.
I am not an specialist and do not know where the problem is. At my webserver or in any installation of Joomla/JEvents.
I hope you can help me solve the problem(s).
In this way I have a feature request for you.
I also use ACYMailing. There you can import new users with comma separatet fields in a simple text area by copy and paste. Additional it is not needed to ad " at every data field.
See this example:
It would be so much easier for non professional useres whith this feature in JEvents...
But more: I didn't know any other system who uses the date-format yyyymmddThhmmss. It's a lot of work for non-specialists to convert the ordinary human-written dd.mm.yyyy to this. This could be much more comfortable.
--------------------------------------------------------------------
Support information
--------------------------------------------------------------------
first, I'd like to thank you for the possibility to use your calendar as free. I'm providing an website with my own money but can't spend it for all extensions I like to use.
Now to the problem.
Every year it is frustrating to import entries to the calendar, because there are everytime new problems to solve. I use the import function at 4th time and tried it in the same way like 2014, 2013 and 2012. The txt-file looks like this (I used the file from last year with updated dates):
CATEGORIES,DESCRIPTION,LOCATION,SUMMARY,CONTACT,X-EXTRAINFO,DTSTART,DTEND,TIMEZONE,RRULE,
"CVJM","","Eibach ","hohes c Gottesdienst","","",20160716T193000,,"Europe/Berlin","",
"Schützenverein","","Schützenhaus ","Königsschießen","","",20160717T110000,,"Europe/Berlin","",
"OGV","","Vereinsheim ","Sommerschnittkurs","","",20160806T100000,,"Europe/Berlin","",I tried to create a new calendar with this file an get this error:
Warning: curl_setopt() [function.curl-setopt (function.curl-setopt)]: CURLOPT_FOLLOWLOCATION cannot be activated when
safe_mode is enabled or an open_basedir is set in /.../.../.../.../.../components/com_jevents/libraries
/iCalImport.php on line 89
create temp CSV conversion file in /.../.../.../.../.../tmp
icaldate = 20160716T193000 imported date=2016-07-16 19:30:00
icaldate = 20160717T110000 imported date=2016-07-17 11:00:00
icaldate = 20160806T100000 imported date=2016-08-06 10:00:00
icaldate = 20160813T000000 imported date=2016-08-13 00:00:00
icaldate = 20160831T170000 imported date=2016-08-31 17:00:00
icaldate = 20160903T140000 imported date=2016-09-03 14:00:00
icaldate = 20160903T000000 imported date=2016-09-03 00:00:00
icaldate = 20160904T000000 imported date=2016-09-04 00:00:00
icaldate = 20160904T103000 imported date=2016-09-04 10:30:00
icaldate = 20160907T190000 imported date=2016-09-07 19:00:00
icaldate = 19700101T010000 imported date=1970-01-01 01:00:00
icaldate = 20160909T190000 imported date=2016-09-09 19:00:00
icaldate = 20160911T180000 imported date=2016-09-11 18:00:00
icaldate = 20160915T150000 imported date=2016-09-15 15:00:00
icaldate = 20160916T000000 imported date=2016-09-16 00:00:00
icaldate = 20160918T000000 imported date=2016-09-18 00:00:00
icaldate = 20160924T193000 imported date=2016-09-24 19:30:00
icaldate = 20160924T163000 imported date=2016-09-24 16:30:00
icaldate = 20161001T113000 imported date=2016-10-01 11:30:00
icaldate = 20161002T100000 imported date=2016-10-02 10:00:00
icaldate = 20161007T190000 imported date=2016-10-07 19:00:00
icaldate = 20161007T000000 imported date=2016-10-07 00:00:00
icaldate = 20161008T130000 imported date=2016-10-08 13:00:00
icaldate = 20161013T193000 imported date=2016-10-13 19:30:00
icaldate = 20161014T193000 imported date=2016-10-14 19:30:00
icaldate = 20161015T200000 imported date=2016-10-15 20:00:00
icaldate = 20161016T000000 imported date=2016-10-16 00:00:00
icaldate = 20161023T000000 imported date=2016-10-23 00:00:00
icaldate = 20161022T000000 imported date=2016-10-22 00:00:00
icaldate = 20161111T180000 imported date=2016-11-11 18:00:00
icaldate = 20161112T113000 imported date=2016-11-12 11:30:00
icaldate = 20161113T103000 imported date=2016-11-13 10:30:00
icaldate = 20161119T130000 imported date=2016-11-19 13:00:00
icaldate = 20161125T130000 imported date=2016-11-25 13:00:00
icaldate = 20161126T140000 imported date=2016-11-26 14:00:00
icaldate = 20161126T193000 imported date=2016-11-26 19:30:00
icaldate = 20161127T180000 imported date=2016-11-27 18:00:00
icaldate = 20161203T150000 imported date=2016-12-03 15:00:00
icaldate = 20161204T103000 imported date=2016-12-04 10:30:00
icaldate = 20161204T180000 imported date=2016-12-04 18:00:00
icaldate = 20161206T170000 imported date=2016-12-06 17:00:00
icaldate = 20161210T150000 imported date=2016-12-10 15:00:00
icaldate = 20161211T180000 imported date=2016-12-11 18:00:00
icaldate = 20161218T163000 imported date=2016-12-18 16:30:00
icaldate = 20161218T180000 imported date=2016-12-18 18:00:00
icaldate = 20161229T130000 imported date=2016-12-29 13:00:00
icaldate = 20161230T143000 imported date=2016-12-30 14:30:00
icaldate = 20161231T110000 imported date=2016-12-31 11:00:00
icaldate = 20161231T173000 imported date=2016-12-31 17:30:00
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
syntax to use near ')' at line 1 SQL=DELETE FROM jos_jevents_catmap where evid = 343 AND catid NOT IN ()After that error I had a look at the entries "which are made".
Only the first entry in the txt-file is displayed at the backend.
I deleted it and want to delete the calendar too, but it is not possible, because it gives me the feedback that there will be some lost entries when it would be deleted.
But I can't find any entries in the calendar, so I can't delete them first.
There is also no way to save a new txt-file or update the old in the existing calendar.
I am not an specialist and do not know where the problem is. At my webserver or in any installation of Joomla/JEvents.
I hope you can help me solve the problem(s).
In this way I have a feature request for you.
I also use ACYMailing. There you can import new users with comma separatet fields in a simple text area by copy and paste. Additional it is not needed to ad " at every data field.
See this example:
It would be so much easier for non professional useres whith this feature in JEvents...
But more: I didn't know any other system who uses the date-format yyyymmddThhmmss. It's a lot of work for non-specialists to convert the ordinary human-written dd.mm.yyyy to this. This could be much more comfortable.
--------------------------------------------------------------------
Support information
--------------------------------------------------------------------
PHP Version : 5.3.28-1~dotdeb.0
MySQL Version : 5.1.73-1+deb6u1
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Load JEvents Bootstrap JS? : Yes
Max Input Vars ? : 1000
Club code set? : No
Joomla : 3.4.5
component_com_jevents : 3.2.20
component_com_jce : 2.5.11
module_mod_jevents_cal : 3.2.20
module_mod_jevents_custom : 3.2.20
module_mod_jevents_filter : 3.2.20
module_mod_jevents_latest : 3.2.20
module_mod_jevents_legend : 3.2.20
module_mod_jevents_switchview : 3.2.20
plugin_content_jevents : 3.2.20
plugin_finder_jevents : 3.2.20 (not enabled)
plugin_search_eventsearch : 3.2.20
the warning can be ignored - if you set Joomla error reporting to 'none' is will not appear.
You can use any date format that strtotime (a php function) recognises. e.g. YYYY-MM-DD or YYYY/MM/DD etc.
You may need to put "" in the DTEND column as opposed to a blank entry.
You can use any date format that strtotime (a php function) recognises. e.g. YYYY-MM-DD or YYYY/MM/DD etc.
You may need to put "" in the DTEND column as opposed to a blank entry.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
Hi Geraint,
thanks for your answer.
I turned off error reporting in Joomla! and I putted "" wherever there is no entry in the events . It looks like this:
Important: The txt-file has to be UTF8-fomatted for German letters like ä,ö,ü,ß
JEvents has problems creating or match categories with these letters when it is no UTF8-format.
I did an import and it works.
Now there es a new Problem which causes in this:
I tried to delete the one old calendar, created with wrong txt-file.
I got this message:
I only found one event but can't delete it in the Joomla backend in different ways.
Everytime I tried, the message was, that i have no permissions to delete it.
While it was not possible to delete it in the backend, I tried to find the entry in MySQl database.
I found it in the table "jevents_vevent" and deleted it there (of cours without a backup of the database....
)
Now i had a look in the backend and the entry wasn't listed anymore. But the calendar still can't be deleted.
So I had a look at the categories and found one named "orphans" (I never createt this)
I tried to delete it and it said there where events in it which has to be deleted first.
O.K. - gone to "Manage Events" i filtered to category "orphans".
I now get this error message:
I get this message also when I try to view "Manage Events" with "Hide past events - NO"
I have to logout and login in Joomla backend to get e new access in "manage Events" with default view-settings.
At the frontend, there is no event listed in the year-overvies, filtered to the category orphans.
There is also no error message in the frontend.
Courious at this point: The event I deleted in MySQL wasn't in the past. It took place on 17.07.2016
Did i destroy my JEvents installation? In Frontenend it works fine
Is there any way to repair it and delet the calendar with the category "orphans"
I don't want to have waste or orphan events in my system.
Kind regards
Wolfgang
thanks for your answer.
I turned off error reporting in Joomla! and I putted "" wherever there is no entry in the events . It looks like this:
"CATEGORIES","DESCRIPTION","LOCATION","SUMMARY","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
"OGV","","Kirche ","Wanderung zum Jahresbeginn","","","20160102T150000","","Europe/Berlin",""
"Feuerwehr","","im Dorf ","Abhängen Weihnachtsbeleuchtung","","","20160108T130000","","Europe/Berlin",""Important: The txt-file has to be UTF8-fomatted for German letters like ä,ö,ü,ß
JEvents has problems creating or match categories with these letters when it is no UTF8-format.
I did an import and it works.
Now there es a new Problem which causes in this:
I tried to delete the one old calendar, created with wrong txt-file.
I got this message:
Deleting this will create orphan events - delete the events first
I only found one event but can't delete it in the Joomla backend in different ways.
Everytime I tried, the message was, that i have no permissions to delete it.
While it was not possible to delete it in the backend, I tried to find the entry in MySQl database.
I found it in the table "jevents_vevent" and deleted it there (of cours without a backup of the database....
)Now i had a look in the backend and the entry wasn't listed anymore. But the calendar still can't be deleted.
So I had a look at the categories and found one named "orphans" (I never createt this)
I tried to delete it and it said there where events in it which has to be deleted first.
O.K. - gone to "Manage Events" i filtered to category "orphans".
I now get this error message:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT language FROM jos_jevents_translation where evdet_id=
I get this message also when I try to view "Manage Events" with "Hide past events - NO"
I have to logout and login in Joomla backend to get e new access in "manage Events" with default view-settings.
At the frontend, there is no event listed in the year-overvies, filtered to the category orphans.
There is also no error message in the frontend.
Courious at this point: The event I deleted in MySQL wasn't in the past. It took place on 17.07.2016
Did i destroy my JEvents installation? In Frontenend it works fine
Is there any way to repair it and delet the calendar with the category "orphans"
I don't want to have waste or orphan events in my system.
Kind regards
Wolfgang
Hello Wolfgang,
Can you open:
/component/com_jevents/libraries/dbmodel.php
look for:
At around line 2261 and replace it with:
You can see this change on GitHub:
https://github.com/xtech86/JEvents/comm ... c1e452a6f4
Then once done, go to JEvents -> Configuration and save.
Now, go to: JEvents -> Categories and publish the orphaned events category.
Then view the manage events screen and try viewing past events to trash them, then empty the trash.
Many thanks
Tony
Can you open:
/component/com_jevents/libraries/dbmodel.php
look for:
$translationids[] = $icalrows[$i]->_evdet_id;
At around line 2261 and replace it with:
if (!$icalrows[$i]->_evdet_id) {continue;}
$translationids[] = $icalrows[$i]->_evdet_id;
You can see this change on GitHub:
https://github.com/xtech86/JEvents/comm ... c1e452a6f4
Then once done, go to JEvents -> Configuration and save.
Now, go to: JEvents -> Categories and publish the orphaned events category.
Then view the manage events screen and try viewing past events to trash them, then empty the trash.
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hi Tonyp,
i tried your way step by step but it doesn't take effect.
The code in dbmodel.php looks like
When i try to show past events, this message is shown:
The same as before.
Any other ideas to solve the problem?
Thanks for your help
Wolfgang
i tried your way step by step but it doesn't take effect.
The code in dbmodel.php looks like
2261 if (!$icalrows[$i]->_evdet_id) {continue;}
2262 $translationids[] = $icalrows[$i]->_evdet_id;When i try to show past events, this message is shown:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT language FROM jos_jevents_translation where evdet_id= The same as before.
Any other ideas to solve the problem?
Thanks for your help
Wolfgang
Please send me super user login details and how to recreate the error.
Many thanks
Tony
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
I would recommend you upgrade to JEvents 3.4.5 - this may well resolve your issue.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
I'm sorry, but trust in automatic update service at Joomla! backend.
This has updated this morning to JEvents 3.2.21 Stable and I thought it is the latest version.
Is 3.4.5 an all new component or is it possible to install it over the existing 3.2.21?
I've made some changes in layouts and hope they wouldn't be deletet with an update.
Thanks
Wolfgang
This has updated this morning to JEvents 3.2.21 Stable and I thought it is the latest version.
Is 3.4.5 an all new component or is it possible to install it over the existing 3.2.21?
I've made some changes in layouts and hope they wouldn't be deletet with an update.
Thanks
Wolfgang
Hello Wolfgang,
You need to download 3.4 manually as this contains jQuery changes and could cause unforseen issues.
If you find any we are here to help.
Thanks
Tony
You need to download 3.4 manually as this contains jQuery changes and could cause unforseen issues.
If you find any we are here to help.
Thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hi,
i updated now to 3.4.3 but the problem with orphans and past events is still there.
Tony, you already got the login with an PM. Hope you can help.
Kind regards
Wolfgang
i updated now to 3.4.3 but the problem with orphans and past events is still there.
Tony, you already got the login with an PM. Hope you can help.
Kind regards
Wolfgang
PHP Version : 5.3.28-1~dotdeb.0
MySQL Version : 5.1.73-1+deb6u1
Server Information : Linux srv8.schwarzkuenstler.info 2.6.32-042stab108.6 #1 SMP Thu Jul 9 13:40:24 MSK 2015 x86_64
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Load JEvents Bootstrap JS? : Yes
Max Input Vars ? : 1000
Club code set? : No
User Agent : Mozilla/5.0 (Windows NT 6.3; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0
Joomla : 3.4.5
component_com_jevents : 3.4.3
component_com_jce : 2.5.11
module_mod_jevents_cal : 3.4.3
module_mod_jevents_custom : 3.4.3
module_mod_jevents_filter : 3.4.3
module_mod_jevents_latest : 3.4.3
module_mod_jevents_legend : 3.4.3
module_mod_jevents_switchview : 3.4.3
plugin_content_jevents : 3.4.3
plugin_finder_jevents : 3.4.3 (not enabled)
plugin_search_eventsearch : 3.4.3
plugin_system_gwejson : 3.4.3
Hello,
I have fixed this on your site and was caused by a very rare scenario where no evdet_id was not set. Due to an error with one of your events.
You can view past events now.
Thanks
Tony
I have fixed this on your site and was caused by a very rare scenario where no evdet_id was not set. Due to an error with one of your events.
You can view past events now.
Thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hi Tony,
thank you. The first problem is solved.
I found an event in category orphans from 1970-01-01.
I tried to delete it. but it doesn't work. I only get this message:
Master event published state successfully changed.
I also can't change the publish-status or title of the event. Nothing take effect.
In cause this event exists, the category "Orphans" and the calender "delete" can't be deletet finally.
Would you mind to have al look again, how to solve this?
Kind regards
Wolfgang
thank you. The first problem is solved.
I found an event in category orphans from 1970-01-01.
I tried to delete it. but it doesn't work. I only get this message:
Master event published state successfully changed.
I also can't change the publish-status or title of the event. Nothing take effect.
In cause this event exists, the category "Orphans" and the calender "delete" can't be deletet finally.
Would you mind to have al look again, how to solve this?
Kind regards
Wolfgang
Hello Wolfgang,
Can you send me phpMyAdmin details and I will remove them for you.
Thanks
Tony
Can you send me phpMyAdmin details and I will remove them for you.
Thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.
Members Area
Show your support
Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons
Your membership will ensure that JEvents continues to be the best events calendar for Joomla.