BUG: mysql2300 reporting the rel pressure as 999.9 every time.

mysql2300 reporting the rel pressure as 999.9 every time. However, fetch2300 reports it correctly as the web page displays everything correctly. I never noticed this until the other day.

20060711073105 2006-07-11 07:31:05 23.7 19.6 14.0 54 70 1.6 99.9 NNW 18.9 0.0 0.0 0.4 999.9 Rising Sunny

1. 2006-07-11 07:31:14 23.7 19.6 14.0 54 70 2.0 99.9 WNW 19.6 0.0 0.0 0.4 999.9 Rising Sunny
2. 2006-07-11 07:31:20 23.7 19.6 14.0 54 70 2.0 99.9 WNW 19.6 0.0 0.0 0.4 999.9 Rising Sunny
3. 2006-07-11 07:31:24 23.7 19.6 14.0 54 70 2.0 99.9 WNW 19.6 0.0 0.0 0.4 999.9 Rising Sunny
4. 2006-07-11 07:40:07 24.1 20.0 13.9 55 68 2.9 99.9 NW 20.0 0.0 0.0 0.4 999.9

Test case

Environment

Open2300 version:	1.10
Shared libraries:	mysql
Server OS:	SuSE 10.1

-- DaveJohns - 20 Jul 2006

Follow up

Fix record

Problem is an error in the table definition of the mySQL init script. See also Bug reported in Error in defintion in the weather SQL table. wind_angle has this problem as well!!

Resolution is as follows:

1) Connect to your open2300 database using mysql -u -p N.B: Make sure user has the ALTER TABLE rights granted. 2) Enter in mysql shell: alter table change rel_pressure rel_pressure decimal(5,1); 2) Enter in mysql shell: alter table wind_angle wind_angle decimal(4,1);

The pressure field now can handle 4 digits plus 1 fraction digit and the wind angle field now can handle 4 digits plus 1 fraction digit. All stored data keeps untouched.

If you have backups in text files, you might upload them to the database because the mySQL stored values have been truncated.

I will provide a fixed SQL script asap.

Cheers, Lars

---

Here we go with patch.

-- OschenLars - 19 Nov 2006