Jevents 2.x (Free Access)

Trouble Managing Events  Topic is solved

Discuss JEvents 2.x for Joomla 1.5-2.5 here - club members can use the special club forum for faster response times.
Forum rules
When requesting support please follow these steps:

1. Update all JEvents add on's first, via the Joomla! Updater
2. Copy and Paste the JEvents Support Information from the JEvents Control Panel.
3. If you get a 500 error OR white page, enable Maximum Error Reporting in Joomla! Global Config and visit the page again, this should give you a more detailed error and help us provide a prompt response.

Postby 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
spotter6284
 
Posts: 2
Joined: Sat Sep 29, 2012 6:28 pm

Postby 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
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23749
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby spotter6284 » Sat Oct 27, 2012 3:19 pm

Thanks for the fast response. Fixed with Acesql, simple enough for me!
spotter6284
 
Posts: 2
Joined: Sat Sep 29, 2012 6:28 pm


Return to Jevents 2.x (Free Access)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: No registered users