python中鱼书flask项目中的问题

Question

sqlalchemy.exc.InternalError: (cymysql.err.InternalError) (1054, "Unknown column 'user.create_time' in 'field list'") [SQL: 'SELECT user.password AS user_password, user.create_time AS user_create_time, user.status AS user_status, user.id AS user_id, user.nickname AS user_nickname, user.phone_number AS user_phone_number, user.email AS user_email, user.confirmed AS user_confirmed,

user.beans AS user_beans, user.send_counter AS user_send_counter, user.receive_counter AS user_receive_counter, user.wx_open_id AS user_wx_open_id, user.wx_name AS user_wx_name \nFROM user \nWHERE user.email = %s \n LIMIT %s'] [parameters: ('[e-mail]', 1)] (Background on this error at: http://sqlalche.me/e/2j85)

测试了几次  只要增加了create_time就会报错

求解决办法，谢谢

Answer 1

PYBETJSOPFHAWZIEBXNCZVENVLTDZVKGQCYUXGPLUDSHBWTPFOCLOYAYTCSHRNJFPEGPYVKNJMVQSMOROETQGOPSSUKTPSOXAWSJEBXGWSVRUCXTJYOQLBQAJUDTJSVRNQZVIXUVRHKMISBAQTCYBWMJKNHJTUQAWMIYUENWGVYHRUJFOXTJZIFVXTDFILBVLOXAQFDSILMVRHDGWFUEUHKBRUQTENXYORNWZIXMBXTWFBYGRMDTCLOXAQFHXDSISBRAWSIEGJMPFBEAJUBUIFVVRBKQNAWFILMPLBXOEZBLHQZBEUXTNJFOEHPZILMUQLOKNJLIYBOXHDFPLFCSULKBBXXZOOPNCYPLIEAIDGEHKTQSBLTVSIPEAQGCLBDFOKZIYBELIRIRDSCSIXACXUXJFBLADGWRUKJEBEGWZHEMWQMVYBLGOLUXDMCRODNPFVEZJSGJSVEADGZOLHWMIEOXZVLOQAPRUKHXQFISUPLUDGCLORUXNCQGJMMUKNPRUXFILKZJFOXTPSVWNDTWFHKGJENYOKAQTOWZCTKNWZOEUKFWMENQMPMUKTWMNILCLAQTWAJAGWMJSOMCYAYNDTWNJZWWTLCVTUGQQFTPUCAWLUBAUMZDDHVPFADWGOEEYCMPLLTHHGJQUWYUDXABGFRNHAEAAUEPQQLRZZTBLSOYVFDXYJGRPZNEATTYVBZFBQEAYHJVFDKPSSCWGNUBTTYDLAQHRSGRVMALJHLTYMKEUVBUSPGGGQONEWCIVYVPNZTJBUUAAKNNCZFCFHYOFLZMLIGJAJMQVTOODXEELHXDLZJQWWHOQTGFOKTGXGQIFNLWHGUWAESDKBSIBDHASCMCJNEEBGXHSQEGXDUEIIQZTDQD

Answer 2

你好，建议删除所有表重新生成