6 posts by 2 authors in: Forums > CMS Builder
Last Post: July 23, 2018   (RSS)

By rez - July 17, 2018 - edited: July 19, 2018

MySQL Error: Table './site_cmsb/cmsb__error_log' is marked as crashed and should be repaired

Has anyone seen this? Is this a hosting situation or CMSB? This is the error where the /cmsb login page should be. I read that there is a table repair in phpmyadmin but thought i better ask first.

What should i do about this? 

MySQL Error: Table error crash

By rez - July 17, 2018 - edited: July 17, 2018

My host ran a repair in phpmyadmin on the table and everything is looking good.

I used to have your plugin setup to back things up. It was easy. However, now I apparently need a cronjob and better look into that but the add-on doesnt show up in the plugin section anymore. I see that backup has it's own section. Is that in every CMSB now and the plugin is not needed?

MySQL Error: Table error crash

By rez - July 18, 2018 - edited: July 19, 2018

Had to update to php 5.6 and believe i have the path correct with help from my host.

I am not receiving anymore email errors and in CMSB > Background tasks says it ran 7 minutes ago. However, I still only have the 2 manually created sql files under the "Backup and restore" tab.

  • What am I missing? 
  • Also, what is the save button for in "Background Tasks" of CMSB? 
  • Your cron examples work fine when enabled in plug-ins. log entries and everything. I have disabled those to be less confusing. Do I have to look into how you did this as opposed to using cpanel to create my commands? I hope not. i like the cPanel UI

MySQL Error: Table error crash

By rez - July 19, 2018 - edited: July 19, 2018

It appears I have the add-on plugin working now. I am getting files labeled daily, hourly, monthly, weekly. :) That's all I need.

However, I would still like to understand the cronjob situation above. By setting up the command and correct path in cPanel mentioned above, shouldn't I be getting those sql files here in Back Up and Restore as well?

MySQL Error: Table error crash

By daniel - July 23, 2018

Hi rez,

Setting up the cron job in cPanel is necessary to tell CMSB to run its background tasks regularly, but it is generally add-ons such as Auto Backup that handle creating and running the tasks themselves. Once you sorted out the issues with the cron job in cPanel, it sounds like it still required the step of getting the Auto Backup add-on working before the backup tasks would start to run again.

I hope this answers your question. Let me know if there's anything else I can help with.

Thanks,

Daniel
PHP Programmer
interactivetools.com