Bug 2037 – metainformation wrong in mysql/dbcreate.sql in 6.1.x

Bug 2037 - metainformation wrong in mysql/dbcreate.sql in 6.1.x

Summary:

metainformation wrong in mysql/dbcreate.sql in 6.1.x

Status:	RESOLVED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Database
Version:	6.1.1
Platform:	PC All

Importance:	P2 normal (vote)
Target Milestone:	---
Assigned To:	Dan Sully

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2005-08-29 13:22 UTC by Joel
Modified:	2008-09-15 14:37 UTC (History)
CC List:	0 users

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Joel 2005-08-29 13:22:30 UTC

The Database is deleted and rescanned every time slimserver is started,
when using mysql for your database.

This is because the version is wrong in the metainformation of dbcreate.sql
It should be 9 NOT 8 to match the sql.version file

Solution
modify mysql/dbcreate.sql to read
INSERT INTO metainformation VALUES (9, 0, 0);

Comment 1 Dan Sully 2005-08-29 13:25:19 UTC

Already fixed in 6.2 nightlies.

Comment 2 Chris Owens 2006-06-16 14:41:25 UTC

There are 536 bugs in the database with targets of '---' that were fixed prior to new year 2006.  I am setting them to targets of 6.2.1 to keep them from showing up in my queries.