Hi @ilona,
Like Alec mentioned above both the php tools/upgrade.php upgrade
and the other command I mentioned should be run from the command line. This is the only native way you can add plugins with database tables to OJS at the moment, so it is really not a problem with the plugin itself. (I think Alec has mentioned before that this could change in the future?)
If you open the XAMPP Control Panel, you will see a button called “Shell”. Clicking that will open the command line tool. The default folder will probably be c:\xampp. You will have to move to the OJS folder probably under htdocs. There you can run the command mentioned above. Both of them should work. However, it could be that your XAMPP is not configured to support PHP on command line. You can find instructions on how to do that online Run PHP from command line with XAMPP on Windows 7 – Mark LaDoux
With actual webservers the PHP should work from the command line by default. I connect to our server using a program named PuTTY. But it is difficult to give instructions on how to do that with your server. This is something your service provider could probably answer better.
You could of course add the database tables with mysql commands. However, if you can not run the php tools/upgrade.php upgrade
command, then the plugin is maybe not registered properly. I am not sure if this will lead to other problems later on, @asmecher? But here are the needed mysql commands anyway.
CREATE TABLE `funders` (
`funder_id` bigint(20) NOT NULL AUTO_INCREMENT,
`funder_identification` varchar(255) NOT NULL,
`submission_id` bigint(20) NOT NULL,
`context_id` bigint(20) NOT NULL,
PRIMARY KEY (`funder_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `funder_awards` (
`funder_award_id` bigint(20) NOT NULL AUTO_INCREMENT,
`funder_id` bigint(20) NOT NULL,
`funder_award_number` varchar(255) NOT NULL,
PRIMARY KEY (`funder_award_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `funder_award_settings` (
`funder_award_id` bigint(20) NOT NULL,
`locale` varchar(5) NOT NULL DEFAULT '',
`setting_name` varchar(255) NOT NULL,
`setting_value` text,
`setting_type` varchar(6) NOT NULL,
UNIQUE KEY `funder_award_settings_pkey` (`funder_award_id`,`locale`,`setting_name`),
KEY `funder_award_settings_id` (`funder_award_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `funder_settings` (
`funder_id` bigint(20) NOT NULL,
`locale` varchar(5) NOT NULL DEFAULT '',
`setting_name` varchar(255) NOT NULL,
`setting_value` text,
`setting_type` varchar(6) NOT NULL,
UNIQUE KEY `funder_settings_pkey` (`funder_id`,`locale`,`setting_name`),
KEY `funder_settings_id` (`funder_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;