commit 6f92d0af5a421e6331d7f1a94c3a051cd0523a7e Author: Hector Martin <hec...@marcansoft.com> Date: Tue Oct 20 04:04:34 2009 +0200
Better handle Locations.itdb Honestly it's 4am and I don't know if this is needed, but it's syncing properly now so I'm committing it. src/itdb_sqlite.c | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) --- diff --git a/src/itdb_sqlite.c b/src/itdb_sqlite.c index 24240b1..5f05b57 100644 --- a/src/itdb_sqlite.c +++ b/src/itdb_sqlite.c @@ -1075,7 +1075,7 @@ static void mk_Locations(Itdb_iTunesDB *itdb, const char *outpath, const char *u continue; } - if (SQLITE_OK != sqlite3_prepare_v2(db, "INSERT INTO \"location\" VALUES(?,?,?,?,:path,?,?,?,?,?,?,?,?);", -1, &stmt, &sqltail)) { + if (SQLITE_OK != sqlite3_prepare_v2(db, "INSERT INTO \"location\" (item_pid, sub_id, base_location_id, location_type, location, extension, kind_id, date_created, file_size) VALUES(?,?,?,?,?,?,?,?,?);", -1, &stmt, &sqltail)) { fprintf(stderr, "[%s] sqlite3_prepare error: %s\n", __func__, sqlite3_errmsg(db)); } else { char *ipod_path = strdup(track->ipod_path); @@ -1116,6 +1116,7 @@ static void mk_Locations(Itdb_iTunesDB *itdb, const char *outpath, const char *u sqlite3_bind_int(stmt, ++idx, timeconv(track->time_modified)); /* file_size */ sqlite3_bind_int(stmt, ++idx, track->size); +#if 0 /* file_creator */ /* TODO unknown, set to NULL */ sqlite3_bind_null(stmt, ++idx); @@ -1128,7 +1129,7 @@ static void mk_Locations(Itdb_iTunesDB *itdb, const char *outpath, const char *u /* num_dir_levels_lib */ /* TODO unknown, set to NULL */ sqlite3_bind_null(stmt, ++idx); - +#endif res = sqlite3_step(stmt); if (res == SQLITE_DONE) { /* expected result */ ------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev _______________________________________________ gtkpod-cvs2 mailing list gtkpod-cvs2@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gtkpod-cvs2