MySQL Error in General Settings --> Background Tasks

6 posts by 3 authors in: Forums > CMS Builder
Last Post: September 24, 2013   (RSS)

By northernpenguin - September 22, 2013

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

By jenolan - September 22, 2013

Have you changed your DB prefix? The table is usually cms__cron_log

---
<?= "Jenolan(Larry) :: Coding Since 1973" ?>
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/

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/

By northernpenguin - September 24, 2013

Thanks Jason!  That did it.

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke