diff options
Diffstat (limited to 'mg_db_gd_mysql.c')
| -rw-r--r-- | mg_db_gd_mysql.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mg_db_gd_mysql.c b/mg_db_gd_mysql.c index b93a449..c067a81 100644 --- a/mg_db_gd_mysql.c +++ b/mg_db_gd_mysql.c @@ -548,7 +548,7 @@ mgDbGd::AddToCollection( const string Name,const vector<mgItem*>&items, mgParts* // insert a unique trackid: string trackid = ltos(thread_id()+1000000); Execute("INSERT INTO playlistitem SELECT "+listid+"," - "MAX(tracknumber)+"+ltos(tracksize)+","+trackid+ + "CASE WHEN MAX(tracknumber) IS NULL THEN 0 ELSE MAX(tracknumber) END +"+ltos(tracksize)+","+trackid+ " FROM playlistitem WHERE playlist="+listid); // find tracknumber of the trackid we just inserted: |