v3.28.1 bulid 3278

[griffo42]

My SQL database (monthly) has not been done since today (18/01/2024 at 08:55:00) and the SQL database (realtime) since today (18/01/2024 at 08:10:02).

A zip of my MXdiags file is attached to enable advice to be provided as to what I need to do to fix the problem.

See also this thread:
Re: Now available: AJAX/PHP multilingual website templates

Thanks,

[mcrossley]

The log file shows they are still working ...

e.g. Monthly...

Code: Select all

2024-01-18 15:20:01.936 DoLogFile: MySQL executing - INSERT IGNORE INTO monthlycumx (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Windgust,Windbearing,RainRate,TodayRainSoFar,Pressure,Raincounter,InsideTemp,InsideHumidity,LatestWindGust,WindChill,HeatIndex,UVindex,SolarRad,Evapotrans,AnnualEvapTran,ApparentTemp,MaxSolarRad,HrsSunShine,CurrWindBearing,RG11rain,RainSinceMidnight,WindbearingSym,CurrWindBearingSym,FeelsLike,Humidex) Values('2024-01-18 15:20',32.2,69,25.8,2,6,50,0.0,1.6,1002.7,160.6,31.9,64,0,32.2,40.7,0.0,0,0.00,0.00,38.8,703,0.0,0,0.0,1.6,'NE','-',37.2,45.1)
2024-01-18 15:20:02.173 DoLogFile: MySQL 1 rows were affected.

Realtime...

Code: Select all

2024-01-18 15:20:09.913 Realtime[9]: MySQL executing - INSERT IGNORE INTO realtimecumx (LogDateTime,temp,hum,dew,wspeed,wlatest,bearing,rrate,rfall,press,currentwdir,beaufortnumber,windunit,tempunitnodeg,pressunit,rainunit,windrun,presstrendval,rmonth,ryear,rfallY,intemp,inhum,wchill,temptrend,tempTH,TtempTH,tempTL,TtempTL,windTM,TwindTM,wgustTM,TwgustTM,pressTH,TpressTH,pressTL,TpressTL,version,build,wgust,heatindex,humidex,UV,ET,SolarRad,avgbearing,rhour,forecastnumber,isdaylight,SensorContactLost,wdir,cloudbasevalue,cloudbaseunit,apptemp,SunshineHours,CurrentSolarMax,IsSunny,FeelsLike) Values('2024-01-18 15:20:09',32.2,69,25.8,2,2,116,0.0,1.6,1002.7,'ESE','1','km/h','C','hPa','mm',13.8,'-0.7',160.6,160.6,0.6,31.9,64,32.2,-0.2,34.1,'14:02',24.6,'05:04',3,'12:08',14,'10:52',1007.2,'00:01',1002.7,'15:14','3.28.1','3278',6,40.5,45.0,0.0,0.00,0,50,0.0,24,'1','0','NE',799,'m',38.7,0.0,703,'0',37.1)
2024-01-18 15:20:10.148 Realtime[9]: MySQL 1 rows were affected.

[griffo42]

Some late night work here seems to have fixed it up. Thanks for your work.

best wishes,