[mythtv] Problems to Update database

[Jochen Kühner]

If uptated the dbcheck.cpp of mythgame to the following  version:

At the Beginning I hav set the DB-Version to 1005.

 

….

};

        performActualUpdate(updates, "1003", dbver);

    }

 

    if (dbver == "1003")

    {

        const QString updates[] = {

QString("update mamemetadata set rom_path ='%1' WHERE rom_path
='';").arg(gConte

""

};

        performActualUpdate(updates, "1004", dbver);

    }

 

    if (dbver == "1004")

    {

        const QString updates[] = {

 

    "CREATE TABLE IF NOT EXISTS n64settings ("

    "romname VARCHAR(128) NOT NULL,"

    "usedefault BOLL NOT NULL,"

    "emulationmode VARCHAR(1) NOT NULL"

    "gfxplugin VARCHAR(1) NOT NULL"

    "audioplugin VARCHAR(1) NOT NULL"

    "inputplugin VARCHAR(1) NOT NULL"

    "rspplugin VARCHAR(1) NOT NULL"

    ");",

    "INSERT INTO n64settings (romname,usedefault,"

    "emulationmode,gfxplugin,audioplugin,"

    "inputplugin,rspplugin) VALUES"

    "(\"default\",1,\"1\",\"1\",\"1\",\"1\",\"1\");",

    ""

};

        performActualUpdate(updates, "1005", dbver);

 

    }

}

 

 

But If I run it. The Table fort he N64 Games is not beeing created!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20050521/ae33549d/attachment.htm