Topic: SQL ERROR
I received an email stating there was an error in a cronjob. The file listed is webcal/lcalcron.php. I am instructed to look at /logs/sql.log. There I find:
**start of log entry
2019.09.06 05:03:47 mycal:ERROR Script: - SQL query error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Query string: SELECT
e.`ID` AS eid,
e.`private` AS pri,
e.`title` AS tit,
e.`venue` AS ven,
e.`text1` AS des,
e.`text2` AS xf1,
e.`text3` AS xf2,
e.`attach` AS att,
e.`catID` AS cid,
e.`scatID` AS sid,
e.`userID` AS uid,
e.`editor` AS edr,
e.`approved` AS apd,
e.`notEml` AS nom,
e.`notSms` AS nos,
e.`sDate` AS sda,
e.`eDate` AS eda,
e.`sTime` AS sti,
e.`eTime` AS eti,
e.`rType` AS r_t,
e.`rInterval` AS r_i,
e.`rPeriod` AS r_p,
e.`rMonth` AS r_m,
e.`rUntil` AS r_u,
e.`aDateTime` AS adt,
e.`mDateTime` AS mdt,
e.`status` AS sts,
c.`name` AS cnm,
c.`sequence` AS seq,
c.`approve` AS app,
c.`dayColor` AS dbg,
c.`color` AS cco,
c.`bgColor` AS cbg,
c.`subName1` AS sn1,
c.`subColor1` AS sc1,
c.`subBgrnd1` AS sb1,
c.`subName2` AS sn2,
c.`subColor2` AS sc2,
c.`subBgrnd2` AS sb2,
c.`subName3` AS sn3,
c.`subColor3` AS sc3,
c.`subBgrnd3` AS sb3,
c.`subName4` AS sn4,
c.`subColor4` AS sc4,
c.`subBgrnd4` AS sb4,
u.`name` AS una,
g.`color` AS uco
FROM `mycal_events` AS e
INNER JOIN `mycal_categories` AS c ON c.`ID` = e.`catID`
INNER JOIN `mycal_users` AS u ON u.`ID` = e.`userID`
INNER JOIN `mycal_groups` AS g ON g.`ID` = u.`groupID`
WHERE ((e.`aDateTime` NOT LIKE '9%' AND SUBSTR(e.`aDateTime`,1,10) >= '2019-09-05') OR (e.`mDateTime` NOT LIKE '9%' AND SUBSTR(e.`mDateTime`,1,10) >= '2019-09-05'))
**end of log entry
Any suggestions? I am a novice when it comes to both php and sql.
Thanks for your help.
Bill
