Andersmmg
Andersmmg
PostsComments
DTDrizzle Team
Created by Andersmmg on 4/28/2025 in #help
Drizzle-kit push not creating new column
I have a basic schema for a user, which I set up the database for using drizzle-kit push. I added a new avatar field to the users, and tried to use push to update the schema, but instead got this: LibsqlError: SQLITE_ERROR: no such column: avatar Looking at the generated SQL it's trying to copy over the new column, and doesn't try to create it. 
INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;
INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;
I'm not sure what I'm doing wrong, this seems very simple yet doesn't work.
1 replies