something is dead wrong with cron and tracking..

i am having a major problem headache over here.

I am running version 7.1.4 not an upgrade.

It seems to be working very well with one major problem

the tracking for ads and every other tracking module crashes at midnight

i assume cron is doing something to those particular fields in the database.

with php amdinistration those tracking fields are in red.. meaning total errors

and this happens at midnight almost every night.

I can not use pohp administrator to repair these fields either.

I have to manually copy an old backup over them then run the repair from php administrator

does anyone know what cuases this? is seems sessions is marked in the database error reporting.

i need help for peace of mind. i can not take waking up to a non functional website when this happens.

Database error in RoaRinG.BiZ

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: Table 'sys_localization_languages' is marked as crashed and should be repaired

Found error in the file 'D:\WEBSITE\indigoampp\apache-2.2.11\htdocs\inc\classes\BxDolEmailTemplates.php' at line 23.
Called 'getOne' function with erroneous argument #0.


Debug backtrace:

------------------------------

Database error in RoaRinG.BiZ

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: Table 'sys_localization_languages' is marked as crashed and should be repaired

Found error in the file 'D:\WEBSITE\indigoampp\apache-2.2.11\htdocs\inc\classes\BxDolEmailTemplates.php' at line 23.
Called 'getOne' function with erroneous argument #0.

------------

Your table crashed and needs to be repaired (this happens sometimes). If you have phpMyAdmin, select the table and from the dropdown menu at the bottom of the table list, select the repair option. That should take care of it.