SQL data not working - RESOLVED

[Hugh]

My ISP experienced a DDoS attack two weeks ago. Since that time the sections of my Meteotemplate site that use MySQL have not worked correctly. It worked perfectly until March 16, 2018.

I was on vacation when the problem started and just returned yesterday. I have been trying to fix the problem since then.

My website is www.flowers-cove.ca

I thought this might be a problem with data that was corrupted during the DDoS attack so I uploaded and replaced all of the March data. I visually inspected today's data and some random days of the month and everything looks OK.

There are some strange things here. The current condition block works fine (I realize that this does not come directly from the MySQL database).

I have run the Error Checker and it shows no problems.

Here are the problems with the blocks

The graphcombined block mostly shows nothing at all but sometimes shows the various areas completely blocked in. A visual check of the MySQL database shows the data for these variables are correct.

The wind block shows bad data. Wind always from the north and averages of 3kmh and max of 997 kmh. However, the wind run data appears to be correct. A visual check of the MySQL database shows the data for these variables are correct.

The wind rose shows no data and the rain block shows no data. A visual check of the MySQL database shows the data for these variables are correct.

The stationdata block exhibits weird behaviour. When the page first loads everything is 0 (i.e. for today). If I click on month data, the monthly data appears correctly. If I then click back on today, it appears correctly. However, one hour data is wrong. Again, a visual check of the MySQL database shows the data for these variables are correct for the last hour, the last day, the last 24 hours etc.

The stationaveraged block shows no data at all. The history block shows everything as 0.

I am at a loss as to the cause of the problem. Should I reinstall everything?

Hugh

[Hugh]

It seems that the error was a corrupted database. I removed all data from the alldata and alldataExtra tables.

I then uploaded and imported all my data from 2008 to today.

Now everything works properly

Hugh

[LOBWX]

Nice work Hugh, that would have been the **its to lose ten years of data. Glad you were able to figure it out.