EduSoho主系统1.1.6升级时数据库出错怎么办?
edusoho吧
全部回复
仅看楼主
level 3
zjedu5184 楼主
An exception occurred while executing ' SELECT clm.id AS id, clm.classroomId AS classroomId, clm.userId AS userId, cm.learnedCompulsoryTaskNum AS learnedCompulsoryTaskNum, cm.learnedElectiveTaskNum AS learnedElectiveTaskNum FROM classroom_member clm INNER JOIN ( SELECT classroomId, userId, SUM(learnedCompulsoryTaskNum) AS learnedCompulsoryTaskNum, SUM(learnedElectiveTaskNum) AS learnedElectiveTaskNum FROM course_member WHERE classroomId IN (?) AND userId IN (?) GROUP BY classroomId, userId ) cm ON clm.classroomId = cm.classroomId AND clm.userId = cm.userId AND clm.id IN (?); ' with params ["1", "3", "1"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'learnedElectiveTaskNum' in 'field list'
2021年06月20日 02点06分 1
level 8
'learnedElectiveTaskNum' in 'field list'
是数据库缺少该字段导致,手动创建好即可
learnedElectiveTaskNum int(11) default 0
2021年06月24日 08点06分 2
1