[SOLVED] CG Calendar crashed - front end and in Admin

[amhoffmaster]

My customer has been using CMSMS for almost 2 years with no problems. Today when he tried to enter a new event in the calendar, it crashed. There are no events listed in the admin for the calendar. Here's the error I see in the admin:

Code: Select all

FATAL ERROR:
QUERY = INSERT INTO cms_module_cgcalendar_events (event_id,event_title,event_summary,event_details ,event_date_start,event_date_end,event_parent_id ,event_recur_period, event_date_recur_end, event_created_by ,event_recur_nevents, event_recur_interval, event_recur_weekdays ,event_recur_monthdays, event_allows_overlap ,event_create_date, event_modified_date) VALUES (60,'test event','test event for the new year','test event','2011-12-30 19:45:00',NULL,-1,'none',NULL,-101,-1,1,'','',1,NOW(),NOW())
ERROR = Table './hfmadv_cms/cms_module_cgcalendar_events' is marked as crashed and should be repaired

.

A similar error appears on the front end on the calendar page, http://www.hfmadv.org/index.php?page=cg-calendar. This error has caused the template and style sheets not to work on this page as well. The list function for the calendar on the home page doesn't work; however, on this page it does not cause the templates or stylesheets to fail.

All other pages seem to functioning properly. There have been no changes done to this site other than content updates.

This site is using the following:

CMS Version
1.8.2

Installed Modules
CMSMailer
2.0
FileManager
1.0.2
MenuManager
1.6.5
ModuleManager
1.4
News
2.10.6
nuSOAP
1.0.2
Printing
1.1.0
Search
1.6.5
ThemeManager
1.1.1
TinyMCE
2.7.2
FormBuilder
0.6.3
Captcha
0.4
CGSimpleSmarty
1.4.5
CGExtensions
1.21.3
Banners
2.3.6
CGCalendar
1.5.5
Gallery
1.4
FrontEndUsers
1.12.6
JQueryTools
1.0.6
CustomContent
1.7.3
CompanyDirectory
1.7.2
AjaxMadeSimple
0.3.1
Polls
0.3.1
Statistics
1.0.1
HitCounter
1.1
SelfRegistration
1.6.7
FormBrowser
0.3.2
CGEcommerceBase
1.2.2
CGPaymentGatewayBase
1.0.9
PaypalGateway
2.2.1
Postcode
1.1.1

I don't know how to repair the table it mentions in the error message. Anyone have any ideas?

[staartmees]

your cmsms, CGCalendar and all of your modules are too old and are no longer supported. Likely are they incompatible with the current PHP-version.

[amhoffmaster]

Nothing has changed on the server. Just one day, the calendar decided to crash.

Has anyone else had this problem before? If you have, please share how you fixed it. Thanks.

[Dr.CSS]

Fixed by upgrading site to at least 1.9.4.3...

[amhoffmaster]

There must be a solution using the existing installation. Nothing has changed but the content on this site. I have had many problems upgrading CMSMS in the past and there was a lot of work done to one part of this site that I don't want to mess with.

Is the database corrupt? Nothing else seems to be affected but the Calendar. Any one have any ideas how I can fix this problem.

[staartmees]

I'll try for one last time: you can try to fix the database manually, but that won't solve your problems. Your cmsms is way too old and won't function correct. I rest my case.

[amhoffmaster]

Ok, I have taken the suggestion to upgrade to 1.9.4.3.
I also upgraded the CGcalendar to the latest version 1.8.5.

This did not fix the problem. So my conclusion is that this problem is NOT related to the version of CMSMS.

Any one with any helpful suggestions?

[amhoffmaster]

Ok, I found a way to solve this problem and it had nothing to do with upgrading CMSMS to the latest version. A table in the database needed repaired. I found this helpful article that explained how to repair at table in a mySql database, and in my case it was the cms_module_cgcalendar_events table. I've copied the instructions here and it fixed my problem.

From phMyAdmin:
1. Choose the database you want to work with from the left hand column.
2. Click the check box on the table line that shows "In Use" .
3. Below all table entries, there is a drop-down menu called "with selected", choose the "repair table" option.
4. Wait patiently as the MySQL server repairs the table. The operation may take a while to complete, depending on the size of the table.
5. Once done, you will see a results page appear, hopefully with the word" OK" next to your table's status.
6. ♪ Celebrate ♪

Here's the link to the article: http://wiki.mediatemple.net/w/(mt):Repa ... phpMyAdmin

Hope this helps anyone who is having a similar problem and not a database programmer.