Pkp pn plugin - 4 page - same issue id

zerof · August 13, 2023, 4:58am

Describe the issue or problem
We use the latest version of the PKP PN plugin. It has been almost 5 days since the plugin was installed and activated. Yesterday our journal was added in onix.csv in 2 lines. Also, Archival Status for 2023 has been added to the ISSN portal.
According to the attached image, the conditions of the plugin are in progress and have 4 similar pages with 91 iteam (It is not displayed). The deposit option has not been added yet. And I want to know, according to the conditions shown in the picture, is the process normal? .
Will it be possible to access the archive?

Url : https://jclr.rovedar.com
ISSN : 2980-8065

What application are you using?
OJS 3.3.0.14

jonasraoni · August 13, 2023, 7:57am

Hi @zerof!

Both the deposit with ID 0 and the paging are looking very suspect for me, and I’ve never seen this problem before… On our end I can confirm that we’ve received 4 deposits, but 3 of them are duplicated (volume 2/issue 2), this shouldn’t have happened either.

Can you run these queries against your database and show us the results?

show create table pln_deposits

show create table pln_deposit_objects

select * from pln_deposits

select * from pln_deposit_objects

Best,
Jonas Raoni

zerof · August 13, 2023, 8:06am

Thanks
output of 2 tables


CREATE TABLE `pln_deposits` (
  `deposit_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `uuid` varchar(36) DEFAULT NULL,
  `status` bigint(20) DEFAULT 0,
  `date_status` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `export_deposit_error` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `pln_deposits`
--

INSERT INTO `pln_deposits` (`deposit_id`, `journal_id`, `uuid`, `status`, `date_status`, `date_created`, `date_modified`, `export_deposit_error`) VALUES
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL),
(0, 1, '20D8B7AA-5A46-44F7-950A-9EF93C1FFDF3', 3, '2023-08-12 22:28:37', '2023-08-12 22:25:55', '2023-08-12 22:28:37', NULL);



CREATE TABLE `pln_deposit_objects` (
  `deposit_object_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `object_id` bigint(20) NOT NULL,
  `object_type` varchar(36) NOT NULL,
  `deposit_id` bigint(20) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;



INSERT INTO `pln_deposit_objects` (`deposit_object_id`, `journal_id`, `object_id`, `object_type`, `deposit_id`, `date_created`, `date_modified`) VALUES
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55'),
(0, 1, 4, 'Issue', 0, '2023-08-12 22:25:54', '2023-08-12 22:25:55');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

It should be noted that due to the limitations of the shared server, I uploaded and activated the plugin in the generic folder. But it didn’t create these 2 tables, that’s why I create these two tables manually

zerof · August 13, 2023, 8:28am

Yes, I understand, my tables did not have auto insert values, can I make the following corrections and empty 2 tables once so that the process is normal?


ALTER TABLE `pln_deposits`
  ADD PRIMARY KEY (`deposit_id`);
  
  ALTER TABLE `pln_deposit_objects`
  ADD PRIMARY KEY (`deposit_object_id`);

ALTER TABLE `pln_deposits`
  MODIFY `deposit_id` bigint(20) NOT NULL AUTO_INCREMENT;


ALTER TABLE `pln_deposit_objects`
  MODIFY `deposit_object_id` bigint(20) NOT NULL AUTO_INCREMENT;

jonasraoni · August 13, 2023, 9:16am

Thanks! I was going to ask how you’ve installed the plugin

The problem is that the columns pln_deposits.deposit_id and the pln_deposit_objects.deposit_object_id should have the auto increment flag, and that’s why things are not working properly.

In order to fix, you’ll have to delete both tables and recreate them properly, with the auto increment flag.
The existing records are broken, so you don’t need to backup them, it’s perfectly fine to redeposit the issues.

Next time you need to install a plugin, this is the preferred order to try:

Website > Plugins > Plugin gallery
Website > Plugins > Installed Plugins > Upload plugin
Upload the plugin manually to the right folder (like you did), then run the command php lib/pkp/tools/installPluginVersion.php plugins/generic/pln/version.xml, which would create the tables.

Best,
Jonas Raoni

jonasraoni · August 13, 2023, 10:36am

Yes! Now it’s working fine

Best,
Jonas Raoni