[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