Opened 13 years ago

Closed 13 years ago

#396 closed defect (fixed)

correct type mismatch in data-db-xxx.sql scripts for table Settings

Reported by: mcr Owned by: geonetwork-devel@…
Priority: major Milestone: v2.6.3
Component: General Version: v2.6.1
Keywords: Cc:

Description

All but one script use integer values for filling the settings table.

INSERT INTO Settings VALUES (701,700,'mdmode',1); INSERT INTO Settings VALUES (702,700,'tokentimeout',3600); INSERT INTO Settings VALUES (703,700,'cachesize',60);

The type of the 4th param is a string type. The correct statements are

INSERT INTO Settings VALUES (701,700,'mdmode','1'); INSERT INTO Settings VALUES (702,700,'tokentimeout','3600'); INSERT INTO Settings VALUES (703,700,'cachesize','60');

Only the SQL Server script has the correct statements.

Attached is a patch (based on 2.6.x ) which makes the scripts consistent.

Attachments (1)

data-db-xxx.sql.patch (5.9 KB ) - added by mcr 13 years ago.

Download all attachments as: .zip

Change History (2)

by mcr, 13 years ago

Attachment: data-db-xxx.sql.patch added

comment:1 by josegar74, 13 years ago

Resolution: fixed
Status: newclosed

Commited in branch. Thanks for providing the patch

Note: See TracTickets for help on using tickets.