将更改迁移到模型时出现 South 错误
我已将用户的外键添加到模型中，但是当我尝试使用 South 迁移数据库时，出现以下错误：
_mysql_exceptions.OperationalError: (1067, "Invalid default value for 'user_id'")
South 告诉我，我可以通过运行 SQL 命令从错误中恢复：
! You *might* be able to recover with: =
ALTER TABLE `main_deal` DROP COLUMN `user_id` CASCADE; []
I尝试运行 SQL 命令，但出现以下错误：
#1091 - Can't DROP 'user_id'; check that column/key exists
我是否需要将“user_id”添加到我的模型并将默认值设置为 1？
编辑： 以下是我添加到模型中以导致发生这种情况的代码：
user = models.ForeignKey(User)
然后我使用 South 迁移了模型。
I have added a foreign key to a user to a model, but when I try to migrate the database using South, I get the following error:
_mysql_exceptions.OperationalError: (1067, "Invalid default value for 'user_id'")
South tells me that I may be able to recover from the error by running an SQL command:
! You *might* be able to recover with: =
ALTER TABLE `main_deal` DROP COLUMN `user_id` CASCADE; []
I tried to run the SQL command, but I get the following error:
#1091 - Can't DROP 'user_id'; check that column/key exists
Do I need to add 'user_id' to my model and set the default value to 1?
Edit:
Here is the code that I added to my model to cause this to occur:
user = models.ForeignKey(User)
Then I migrated the model using South.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
当您运行
schemamigration命令时，系统应该会询问您一些有关默认值的问题。如果您给出了错误的答案，则可能导致了您所描述的问题。如果您可以打开实际的迁移文件并获取顶部附近的
forward方法，并将其发布到此处，我应该能够找出问题所在。When you ran the
schemamigrationcommand, you should've been asked some questions about default values. If you gave the wrong answer it may have caused the problem you describe.If you could open up the actual migration file and grab the
forwardmethod near the top, and post it here, I should be able to figure out what went wrong.我猜你有问题，因为你指定了不可为空的用户字段而不提供默认值。您需要提供默认值，例如。
user = models.ForeignKey(User, default=foo)或允许用户字段为空user = models.ForeignKey(User, null=True)顺便说一句，我认为最新South 版本在创建迁移时要求默认值。您使用哪个版本？
I guess you have a problem because you specified not nullable user field without providing default value. You need to either provide default value eg.
user = models.ForeignKey(User, default=foo)or allow nulls for user fielduser = models.ForeignKey(User, null=True)Btw, I think that latest version of south asks for default values when migration is being created. Which version do you use?