I had exactly the same problem after I added a new user. There must be something about the admin user that doesn’t create that row. The sql insert worked perfectly. (It must have something to do with the Admin being able to choose anyone at that author line. While authors will only see themsleves.
Anyway, thanks for the spot on comments.