was passing the full path into the update query when the record itself only holds the name of the file. the db should update properly now.