Can't Attach Files

[apatel0]

Hi, I'm getting errors when trying to attach files to either a ticket or a change or a workorder. In the case of workorders and changes, the first time I try to attach a file, it goes through the screen but I don't see any attachment on the change or workorder screens. If I try to attach another file, it gives a bunch of error messages.

----------------------
Table 'otrs.virtual_fs' doesn't exist, SQL: 'SELECT vfs.filename, vfsp.preferences_key, vfsp.preferences_value FROM virtual_fs vfs , virtual_fs_preferences vfsp WHERE vfs.id = vfsp.virtual_fs_id AND ((vfsp.preferences_key = ? AND vfsp.preferences_value = ?))'
----------------------
Table 'otrs.virtual_fs' doesn't exist, SQL: 'SELECT id, backend_key, backend FROM virtual_fs WHERE filename = ?'
----------------------
Table 'otrs.virtual_fs' doesn't exist, SQL: 'INSERT INTO virtual_fs (filename, backend_key, backend, create_time) VALUES ( ?, 'TMP', ?, current_timestamp)'
----------------------
Cannot add attachment for change 12
----------------------

When I just tried attaching a file to a note on a ticket, it didn't attach and the syslog stated:
Need Filename!

Any help would be greatly appreciated.

[jojo]

it seems that your datbase is not valid. Did you perform a an upgrade (if yes it is brokn)

[apatel0]

JoJo,
Yes I did perform an upgrade on this box from an earlier version of OTRS and ITSM. It was only one rev. back. Is there a way to repair the database?

[jojo]

you need to perform a new upgrade as not all upgrade scripts seemed to be run successfully

[apatel0]

Is that something I can do from the package manager? Are there additional steps besides going through the package manager install that I need to take into consideration?

[jojo]

your otrs upgrade failed. this can not be done via package manager