Trouble Managing Events 
Forum rules
When requesting support, please copy and paste the 'Version information for Support Forum' from the JEvents Control Panel into your post. If you cannot see this, please enable JEvents project news within it's configuration. Also, if you get a 500 Error, Enable Joomla! Maximum Error Reporting and view the page again, you should now have a more detailed error which will help us to resolve you issue quickly.
When requesting support, please copy and paste the 'Version information for Support Forum' from the JEvents Control Panel into your post. If you cannot see this, please enable JEvents project news within it's configuration. Also, if you get a 500 Error, Enable Joomla! Maximum Error Reporting and view the page again, you should now have a more detailed error which will help us to resolve you issue quickly.
3 posts
• Page 1 of 1
Trouble Managing Events
by spotter6284 » Sat Oct 27, 2012 4:21 am
When I try to open Manage Events in back end the following appears. Worked fine yesterday until I deleted a repeating event.
[size=50]Table './lidorace_data/lido_jevents_vevdetail' is marked as crashed and should be repaired SQL=SELECT count(distinct rpt.eventid) FROM lido_jevents_vevent AS ev LEFT JOIN lido_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN lido_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN lido_jevents_repetition as rpt ON rpt.eventid = ev.ev_id WHERE ev.catid IN(-1,116) AND rpt.endrepeat>'2012-10-25 23:18:17'
Warning: Invalid argument supplied for foreach() in /home/lidorace/public_html/administrator/components/com_jevents/controllers/icalevent.php on line 324
DB function failed with error number 145
Table './lidorace_data/lido_jevents_vevdetail' is marked as crashed and should be repaired SQL=SELECT ev.*, ev.state as evstate, detail.*, ev.created as created, max(detail.modified) as modified, a.title as _groupname , rr.rr_id, rr.freq,rr.rinterval ,MAX(rpt.endrepeat) as endrepeat ,MIN(rpt.startrepeat) as startrepeat , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM lido_jevents_vevent as ev LEFT JOIN lido_jevents_repetition as rpt ON rpt.eventid = ev.ev_id LEFT JOIN lido_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN lido_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN lido_viewlevels AS a ON a.id = ev.access WHERE ev.catid IN(-1,116) AND rpt.endrepeat>'2012-10-25 23:18:17' GROUP BY ev.ev_id ORDER BY rpt.startrepeat asc LIMIT 0, 10[/size]
Thank you
[size=50]Table './lidorace_data/lido_jevents_vevdetail' is marked as crashed and should be repaired SQL=SELECT count(distinct rpt.eventid) FROM lido_jevents_vevent AS ev LEFT JOIN lido_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN lido_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN lido_jevents_repetition as rpt ON rpt.eventid = ev.ev_id WHERE ev.catid IN(-1,116) AND rpt.endrepeat>'2012-10-25 23:18:17'
Warning: Invalid argument supplied for foreach() in /home/lidorace/public_html/administrator/components/com_jevents/controllers/icalevent.php on line 324
DB function failed with error number 145
Table './lidorace_data/lido_jevents_vevdetail' is marked as crashed and should be repaired SQL=SELECT ev.*, ev.state as evstate, detail.*, ev.created as created, max(detail.modified) as modified, a.title as _groupname , rr.rr_id, rr.freq,rr.rinterval ,MAX(rpt.endrepeat) as endrepeat ,MIN(rpt.startrepeat) as startrepeat , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM lido_jevents_vevent as ev LEFT JOIN lido_jevents_repetition as rpt ON rpt.eventid = ev.ev_id LEFT JOIN lido_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN lido_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN lido_viewlevels AS a ON a.id = ev.access WHERE ev.catid IN(-1,116) AND rpt.endrepeat>'2012-10-25 23:18:17' GROUP BY ev.ev_id ORDER BY rpt.startrepeat asc LIMIT 0, 10[/size]
Thank you
- spotter6284
- Posts: 2
Re: Trouble Managing Events
by Tonyp » Sat Oct 27, 2012 7:05 am
Hello,
Your database/server has crashed at some point and locked the database.
You need to run a repairs, information on this:
http://lmgtfy.com/?q=repairing+mysql+from+a+crash
Regards
Tony
Your database/server has crashed at some point and locked the database.
You need to run a repairs, information on this:
http://lmgtfy.com/?q=repairing+mysql+from+a+crash
Regards
Tony
---------------------------------------
Do not forget if you like JEvents, why not join the CLUB! for priority support and lots of excellent plugin's. JEvents Club
Do not forget if you like JEvents, why not join the CLUB! for priority support and lots of excellent plugin's. JEvents Club
-
Tonyp - Contributor
- Posts: 8709
- Location: Isle of Man
Re: Trouble Managing Events 
by spotter6284 » Sat Oct 27, 2012 3:19 pm
Thanks for the fast response. Fixed with Acesql, simple enough for me!
- spotter6284
- Posts: 2
3 posts
• Page 1 of 1
Return to Jevents 2.x (Free Access)
Who is online
Users browsing this forum: Google [Bot]
Main Menu
User Menu
Hosted By
