Hi

I’ve been having a couple of issues while installing the Publisher Lite addon. This is with a site that has just over 93,000 entries and 244 fields. The install takes quite a long time to install and migrate. Though I will say it works fine on our smaller/test sites.

The issue seem to be when either it the session times out or the user is logged out during the installation or migration.

The first issue is is when the the user is logged out, then at the end of the initial installation, a login loop occurs. I traced it down to where it has:

if ($this->request->isAdminRequest()) {

in ext.publisher.php

I created a work around for my situation where I replaced it with

if ($this->request->isAdminRequest() && ee()->session->userdata('member_id')) {

which enabled me to log back in to continue with the install.

Another situation is where if the migration is interrupted by a timeout, when stating it up again, it starts the migration from the beginning. I then get an error similar to this:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘54-1-open’ for key ‘exp_publisher_data_field_120.pub_key’: INSERT INTO `exp_publisher_data_field_120` (entry_id, lang_id, status, field_id_120) VALUES (54, 1, ‘open’, ‘0’);

I found changing SQL with wherever it is has “INSERT INTO ...” to “INSERT IGNORE INTO ...” in Migration.php gets the migration started again without errors (probably not a great solution as it goes through all the entries again which takes time in itself, but it works for me to get it completed).

Kind regards
Simon