Publisher is EE6 compatible, but it does not support the Fluid field. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Problems with installing Publisher Lite on large site

Status Resolved
Add-on / Version Publisher Lite 3.6.0
Severity
EE Version 6.3.4

Simon Andersohn

Jul 26, 2022

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

 

#1

BoldMinded (Brian)

Jul 26, 2022

I made some changes based on this feedback from the other ticket. New build is in the next comment. Try to re-install it using a DB backup so EE sees it as a new add-on, and not something stuck in the middle of an upgrade process right now.

#2

BoldMinded (Brian)

Jul 26, 2022

Comment has been marked private.

#3

Simon Andersohn

Jul 27, 2022

Thank you. So far so good though it me took around 3 hours to install and migrate it with a copy of the full site.

I’ll keep testing on this and another install to see if any errors do appear - I did see some critical SQL error with Structure trying to update a channel or other which went away after installing Publisher. I keep a look out

Thanks

#4

Simon Andersohn

Jul 30, 2022

I meant to say “uninstalling”

I did see some critical SQL error with Structure trying to update a channel or other which went away after uninstalling Publisher. I keep a look out

I’m working on another install to see how it goes, but I’ll close this ticket for now until I find any related issue.

Thanks

Login to reply