unable to upload employee documents

[aMozejko1]

Hi,

I am able to create new employees but am unable to upload documents for them.

Uploading files through the 'Expenses / Receipts' section works so I don't think it a PHP / permissions issue.

When a user clicks through "Self Service > My Details > Documents" they see "No data found." as per the attached.

Has this been seen before? Is there something that I need to enable or something?

[aMozejko1]

turns out that the "main_employeedocuments" table was not created. i'm not sure whether this was meant to be created during installation or whether it is only created when someone first tries to upload a document?

to create:

CREATE TABLE `main_employeedocuments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `attachments` text,
  `createdby` bigint(20) DEFAULT NULL,
  `modifiedby` bigint(20) DEFAULT NULL,
  `createddate` datetime DEFAULT NULL,
  `modifieddate` datetime DEFAULT NULL,
  `isactive` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;