search

DOMjudge / domjudge

DOMjudge programming contest jury system
https://www.domjudge.org
GNU General Public License v2.0
709 stars 248 forks source link

ERROR 1050 (42S01) at line 12: Table 'auditlog' already exists #178

Closed wmacevoy closed 8 years ago

wmacevoy commented 8 years ago

I dropped the database domjudge before running the command

domserver/bin/dj-setup-database -u root -p "$password" install

And I get the above error but it looks like the tables are made:

show tables; +-----------------------+ | Tables_in_domjudge | +-----------------------+ | auditlog | | balloon | | clarification | | configuration | | contest | | contestproblem | | contestteam | | event | | executable | | judgehost | | judgehost_restriction | | judging | | judging_run | | language | | problem | | rankcache_jury | | rankcache_public | | rejudging | | role | | scorecache_jury | | scorecache_public | | submission | | submission_file | | team | | team_affiliation | | team_category | | team_unread | | testcase | | user | | userrole | +-----------------------+

meisterT commented 8 years ago

Which domjudge version are you using? 5.0.1? current git HEAD?

wmacevoy commented 8 years ago

5.0.1 ubuntu 14.04 we used 4.0.3 last year and I am running upgrades (this is a fresh install in /usr/local/domjudge after moving the old folder to a backup location)

meisterT commented 8 years ago

I cannot reproduce the error with the 5.0.1 tarball. Can you reproduce it (after dropping the database again)?

My assumption is that dropping the domjudge database failed somehow.

thijskh commented 8 years ago

I'm closing this issue. Let us know if you can provide more information on how to reproduce it.