Problem when upgrading onlinejudge

[hit-moodle]

Problem when upgrading onlinejudge

[sunner]

Ah, it is terriable.

You must not use MySQL, do you? If no, please tell me which db engine are you using. (postgres? I guess)

In recent updates, I change the fields related with users' program output and testcase data from text type to binary type. This leads to two benefits:

1. Ability to process more charsets
2. Ability to judge programs input/output binary data

It seems that your db engine does not support this kind of alerting. Tell me what it is and perhaps we can find the solution.

[lchorbadjiev]

Yes, you are right: I'm using PostgreSQL 8.4.9. Hopes this helps.

[sunner]

I am sure that this is a problem under postgresql. There is also other people met the same problem, like http://bytes.com/topic/postgresql/answers/174532-cast-text-bytea . PostgreSQL does not support cast a column from text to bytea

I have no idea on how to solve this. Perhaps a totally new installation will work. If you want to reserve current data, you can try edit db/upgrade.php, remove two code blocks begin with "if ($oldversion < 2011092200) {" and "if ($oldversion < 2011102401) {", then upgrade as usual. This will keep the fields in text type.

[lchorbadjiev]

If I want to make fresh install of onlinejudge, which tables I should remove?

[sunner]

You can uninstall it in moodle by accessing http://yoursite.domain/admin/localplugins.php.

If the reinstallation works, please let me know. Thank you.