[mythtv] Problems with mythfilldatabase
Flo
flokohlert at muenchen-mail.de
Sun Jun 27 09:46:46 EDT 2004
I recently updated to cvs, now i got a problem with mythfilldatabase (xmltv,
tv_grab_de_tvtoday)
I get a lot of these:
DB error: Insert into credits [snip] Duplicate entry [SNIP]
As far as i can see in filldata.cpp
if (personid < 0)
{
cerr << "Error inserting person\n";
continue;
}
querystr = QString("INSERT INTO credits (chanid,starttime,"
"role,person) VALUES "
"(%1, \"%2\", \"%3\", %4);")
.arg(chanid)
.arg((*i).start.toString("yyyyMMddhhmmss"))
.arg((*k).role)
.arg(personid);
if (!query.exec(querystr.utf8()))
{
// be careful of the startime/timestamp "feature"!
querystr = QString("UPDATE credits SET "
"role = concat(role,',%1'), "
"starttime = %2 "
"WHERE chanid = %3 AND "
"starttime = %4 and person = %5")
.arg((*k).role)
.arg((*i).start.toString("yyyyMMddhhmmss"))
.arg(chanid)
.arg((*i).start.toString("yyyyMMddhhmmss"))
.arg(personid);
if (!query.exec(querystr.utf8()))
MythContext::DBError("credits update", query);
}
There should be an update done if theres an error, but somehow this doesnt
seem to work.
No data at all is inserted in the db (no programinfo either), the .xml seems
to be fine.
Thx
flo
More information about the mythtv-dev
mailing list