Open2300 - Bug Report 2006x 07x 20x 011218

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

BugReportForm edit

TopicTitle mysql2300 reporting the rel pressure as 999.9 every time.
BugStatus Resolved
AssignedBugTo
SubmittedBy DaveJohns
Topic revision: r3 - 19 Nov 2006, OschenLars
Copyright © 1999-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
This website only use harmless session cookies. See Cookie Policy for details. By using this website you accept the use of these cookies.