EB CRASHED!!

More
11 years 8 months ago #46910 by Jeff
EB CRASHED!! was created by Jeff
One week before their event and EB crashed with this error:

Error: 145 - Table './mosea_jmln40/joom_eb_registrants' is marked as crashed and should be repaired SQL=SELECT tbl.*,DATEDIFF(tbl.early_bird_discount_date, NOW()) AS date_diff,c.name AS location_name,IFNULL(SUM(b.number_registrants), 0) AS total_registrants FROM joom_eb_events AS tbl LEFT JOIN joom_eb_registrants AS b ON (tbl.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" AND b.published != 2))) LEFT JOIN joom_eb_locations AS c ON tbl.location_id = c.id WHERE tbl.published=1 AND tbl.access IN (1,1,5) AND tbl.id IN (SELECT event_id FROM joom_eb_event_categories WHERE category_id=1) GROUP BY tbl.id ORDER BY tbl.ordering ASC LIMIT 0, 5

mosea.org/calendar/seminars

Joomla.3.3.0
EB is current

I need help!

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #46915 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic EB CRASHED!!
Hi Jeff

This is sometime happens on a mysql database tables (you can do a google search an see that many users get this issue), it is not something with the extension itself.

To fix this issue, we need to run a Repair command from mysql. Please submit a support ticket sending us super admin account of your site so that we can do that for you.

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc