AW: [mythtv] Problems...

[Jochen Kühner]

If have found my Problem…

I forgot the commas in my sql and haven’t seen it…

 

  _____  

Von: mythtv-dev-bounces at mythtv.org [mailto:mythtv-dev-bounces at mythtv.org] Im
Auftrag von Jochen Kühner
Gesendet: Montag, 23. Mai 2005 08:57
An: 'Development of mythtv'
Betreff: AW: [mythtv] Problems to Update database

 

I have checked this again, and mythtv updatest he dbversion to 1005 but the
tabels wern’t created! Why?? Any error in my code?

 

  _____  

Von: mythtv-dev-bounces at mythtv.org [mailto:mythtv-dev-bounces at mythtv.org] Im
Auftrag von Jochen Kühner
Gesendet: Samstag, 21. Mai 2005 21:58
An: 'Development of mythtv'
Betreff: [mythtv] Problems to Update database

 

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/20050524/eeaf6c30/attachment.htm