Fix SQL syntax error

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1651 91ce42f0-d328-0410-95d8-f526ca767f89

diff --git a/bacula/src/cats/sql_create.c b/bacula/src/cats/sql_create.c
index 61c9a6e2f1aad1e39e475d19f290493980d3a397..03c7d9f81a20600c046b985ec4462a2cb1a0f82d 100644 (file)
--- a/bacula/src/cats/sql_create.c
+++ b/bacula/src/cats/sql_create.c
@@ -243,7 +243,7 @@ db_create_media_record(JCR *jcr, B_DB *mdb, MEDIA_DBR *mr)
 "INSERT INTO Media (VolumeName,MediaType,PoolId,MaxVolBytes,VolCapacityBytes," 
 "Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,"
 "VolStatus,Slot,VolBytes,InChanger,VolReadTime,VolWriteTime," 
-"EndFile,EndBlock "
+"EndFile,EndBlock) "
 "VALUES ('%s','%s',%u,%s,%s,%d,%s,%s,%u,%u,'%s',%d,%s,%d,%s,%s,0,0)", 
                  mr->VolumeName,
                  mr->MediaType, mr->PoolId,