Yup, i managed to hose my own database ....
from : http://svn.mythtv.org/trac/browser/trun ... bcheck.cpp
this is the code that must have run for my schema version to have reached 1135 ....
Quote: if (dbver == "1128")
2067 {
2068
2069 MSqlQuery query(MSqlQuery::InitCon());
2070 query.prepare("SELECT chanid, starttime, cutlist FROM recorded"
2071 " WHERE LENGTH(cutlist) > 1;");
2072 if (query.exec() && query.isActive() && query.size() > 0)
2073 {
2074 MSqlQuery insert(MSqlQuery::InitCon());
2075 while (query.next())
2076 {
2077 QString cutlist = query.value(2).toString();
2078
2079 QStringList strlist = QStringList::split("\n", cutlist);
2080 QStringList::Iterator i;
2081 for (i = strlist.begin(); i != strlist.end(); ++i)
2082 {
2083 long long start = 0, end = 0;
2084 if (sscanf((*i).ascii(), "%lld - %lld", &start, &end) == 2)
2085 {
2086 insert.prepare(
2087 "INSERT INTO recordedmarkup (chanid, starttime,"
2088 " type, mark) "
2089 "VALUES (:CHANID, :STARTTIME, :TYPE, :MARK);");
2090 insert.bindValue(":CHANID", query.value(0).toString());
2091 insert.bindValue(":STARTTIME",
2092 query.value(1).toDateTime());
2093
2094 insert.bindValue(":TYPE", 1);
2095 insert.bindValue(":MARK", start);
2096 insert.exec();
2097
2098 insert.bindValue(":TYPE", 0);
2099 insert.bindValue(":MARK", end);
2100 insert.exec();
2101 }
2102 }
2103 }
2104 }
2105
2106 const QString updates[] = {
2107 "INSERT INTO recordedmarkup (chanid, starttime, type, mark) SELECT"
2108 " chanid, starttime, '2', bookmark FROM recorded WHERE bookmark <> 0;",
2109 "ALTER TABLE recorded CHANGE cutlist cutlist TINYINT(1) NOT NULL DEFAULT 0",
2110 "ALTER TABLE recorded CHANGE bookmark bookmark TINYINT(1) NOT NULL DEFAULT 0",
2111 ""
2112 };
2113 if (!performActualUpdate(updates, "1129", dbver))
2114 return false;
2115 }
"ALTER TABLE recorded CHANGE cutlist cutlist TINYINT(1) NOT NULL DEFAULT 0" almost certainly means the cutlist field is now just a pointer as to whether one exists, rather than the actual cutlist itself.
So my 0.19 program is trying to save another type(a string, I would guess)) to a tinyint field and fails (silently).
Or something like that, anyway.
I'll probably have to tweak it back to what it was before to get cutlists working again...
Apologies for the noise, thanks for the replies,
and the moral is to be a bit careful if you put a later build of myth on your network. I think mine picked up on an earlier config and tried (succesfully) to quietly update the master backend DB.
Which is what it should do, in most instances, I guess.
|
