MySQL Error in General Settings --> Background Tasks
6 posts by 3 authors in: Forums > CMS Builder
Last Post: September 24, 2013 (RSS)
Hi
I am using CMSB v2.53 Build 1040. In the General Settings --> Background Tasks under Status, I see the following error:
mysql_count() MySQL Error: Table 'rcl618_website.rcl__cron_log' doesn't exist (at general.php line 620 in function mysql_count)
Does anyone know what the issue is and how I can correct it?
northernpenguin
Northern Penguin Technologies
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
Have you changed your DB prefix? The table is usually cms__cron_log
Peace and Long Life
By Jason - September 24, 2013
Hi,
There shouldn't be any issue with having a different table prefix. Is this a new install, or something that has just started happening? Have there been any recent changes to this installation? If you look in the data/schema folder, is there a "_cron_log.ini.php" file?
Let me know and we can look into this further.
Thanks
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason: This was an upgrade to 2.53, and there is no "_cron_log.ini.php" file. Is there an easy fix?
northernpenguin
Northern Penguin Technologies
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
By Jason - September 24, 2013
Hi,
Okay, no problem. It sounds like the schema file just didn't get uploaded. Take a look at the version 2.53 upgrade that you downloaded. There should be a _cron_log.ini.php file in the schema folder. Upload this to the schema folder on your server. Log back into the CMS and go to Admin -> Section Editors. This will make sure that the CMS has picked up the new schema file and create the section. To make sure it works, go the cron log section like this:
www.example.com/cmsAdmin/admin.php?menu=_cron_log
Hope this helps
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Thanks Jason! That did it.
northernpenguin
Northern Penguin Technologies
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke