search

UniTime / unitime

Comprehensive University Timetabling System
http://www.unitime.org
Apache License 2.0
274 stars 162 forks source link

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'timetable.task_execution' doesn't exist #86

Closed webdbase closed 3 years ago

webdbase commented 3 years ago

Just downloaded unitime-4.5_bld164.zip There is no table task_execution in mysql/blank-data.sql or mysql/schema.sql or mysql/woebegon-data.sql

tomas-muller commented 3 years ago

When you install UniTime, the database is initially created with the schema.sql and populated with blank-data.sql or wobegon-data.sql. The database gets automatically updated to the most recent version the first time the UniTime application is deployed. In the case of MySQL the initial version is 123 and the task_execution table is created by the update to version 207.

So, once you have completed all the installation steps, starting UniTime for the first time, you should see something like this in the log:

[05/26/21 04:01:43] INFO   <init> -> Reading file:/Applications/apache-tomcat-9.0.13/webapps/UniTime/WEB-INF/lib/timetable.jar!/dbupdate.xml ...
[05/26/21 04:01:43] INFO   DatabaseUpdate -> Current UniTime database version: 123
[05/26/21 04:01:43] INFO   DatabaseUpdate ->   Performing UniTime update to version 124 (Instructor Note)
[05/26/21 04:01:43] INFO   DatabaseUpdate ->     UniTime Database version increased to: 124
[05/26/21 04:01:44] INFO   DatabaseUpdate ->   Performing UniTime update to version 125 (Solution Export XML)
[05/26/21 04:01:44] INFO   DatabaseUpdate ->     UniTime Database version increased to: 125
...
[05/26/21 04:02:00] INFO   DatabaseUpdate ->   Performing UniTime update to version 238 (Student Area Classification Major Unique Index)
[05/26/21 04:02:00] INFO   DatabaseUpdate ->     UniTime Database version increased to: 238
[05/26/21 04:02:00] INFO   DatabaseUpdate ->   Performing UniTime update to version 239 (Student Degree)
[05/26/21 04:02:00] INFO   DatabaseUpdate ->     UniTime Database version increased to: 239
[05/26/21 04:02:00] INFO   DatabaseUpdate -> New UniTime database version: 239

The final version depends on the UniTime version you are using, it is 239 for UniTime 4.5.164.

After that, the task_execution table will be present in the database. If the update failed for some reason, the individual update scripts are available at Documentation/Database/MySQL/Changes.