Open2300 - Bug Report 2008x 09x 03x 220037

BUG: A small bug in mysql2300.sql (svn version).

You need to change line:

UNIQUE KEY `timestamp` (`timestamp`)


UNIQUE KEY `datetime` (`datetime`)

or by

UNIQUE KEY `timestamp` (`datetime`)

in mysql2300.sql file

Column: timestamp do not exist any more and need to be replaced by datetime

> Diff made with kdesvn:
> -------------------------------------------------------------------------
> Index: mysql2300.sql
> ===================================================================
> --- mysql2300.sql (révision 12)
> +++ mysql2300.sql (copie de travail)
> @@ -19,5 +19,5 @@
> `rel_pressure` decimal(5,1) NOT NULL default '0.0',
> `tendency` varchar(7) NOT NULL default '',
> `forecast` varchar(6) NOT NULL default '',
> - UNIQUE KEY `timestamp` (`timestamp`)
> + UNIQUE KEY `datetime` (`datetime`)
> -------------------------------------------------------------------------

Smilar to bug : Bug Report 2007x 06x 03x 114621 which is classified as closed.

Test case

Drop weather table in mysql database: drop tables weather; run mysql2300.sql under mysql and check that weather table is created.


Open2300 version: svn
Shared libraries: mysql
Server OS: Mandriva 2008

-- KiwiHC16 - 03 Sep 2008

Follow up

Fix record

BugReportForm edit

TopicTitle A small bug in mysql2300.sql (svn version).
BugStatus New
SubmittedBy KiwiHC16
I Attachment Action Size Date Who Comment
mysql2300.sqlsql mysql2300.sql manage 927 bytes 03 Sep 2008 - 22:31 UnknownUser File with proposed correction
Topic revision: r1 - 03 Sep 2008, KiwiHC16
Copyright © 1999-2024 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.