The urls you provided are throwing a 403 forbidden error.

Comment has been marked private.

Comment has been marked private.

Comment has been marked private.

Have you tried disabling Diffs?

I don’t think the truncation error is b/c of Publisher. That appears to be more of an MySQL error, e.g. the column in the database has a max length on it. If field_id_356 is set to “text” then it shouldn’t have any problem accepting that amount of content.

I know what was changed in 2.7.6 that may cause the error, but the error shouldn’t happen if field_id_749 is set to the text type. Text db columns can hold a ton of data.

In the Service/Entry/Entry.php file line 489, add this writeToFile line

https://www.dropbox.com/s/8xj0cxdsssgd3vh/Screenshot 2018-03-08 13.24.08.png?dl=0

And in addon.setup.php at line 315, uncomment the writeToFile function. Save an entry, and see what is saved to the update.txt file in your cache folder.

Comment has been marked private.

Excellent! I still see a lot of these queries, so I’ll look into it more.

SELECT *
FROM (`exp_publisher_diff_settings`)

Well obviously. Publisher has to do a lot of work to make translations viable. What I’m concerned about now is those publisher_diff_settings queries. There is no way that many should still be executed. In your Service/Diff.php file, do you see the getSettings function and does it look exactly like this?

public function getSettings($fieldId)
    {
        $fieldId = preg_replace('/field_id_(\d+)/', '$1', $fieldId);

        $db = ee('db');
        $settings = [];

        if (!$this->requestCache->get('diffSettings')) {
            /** @var CI_DB_result $qry */
            $qry = $db->get('publisher_diff_settings');

            foreach ($qry->result() as $row) {
                $snippetContents = false;

                if ($row->snippet_id) {
                    $snippets = ee()->publisher_template->get_snippets(false);

                    if (array_key_exists($row->snippet_id, $snippets)) {
                        $snippetContents = ee()->publisher_template->get_snippet_contents($row->snippet_id);
                    }
                }

                $settings[$row->field_id] = [
                    'snippet'  => $row->snippet_id,
                    'template' => $row->template_custom,
                    'use_template' => ($snippetContents ? $snippetContents : $row->template_custom),
                    'style'    => $row->style
                ];
            }

            $this->requestCache->set('diffSettings', $settings);
        }

        $cacheResults = $this->requestCache->get('diffSettings');

        if ($cacheResults && isset($cacheResults[$fieldId])) {
            return $cacheResults[$fieldId];
        }

        return [
            'snippet' => '',
            'template' => '',
            'use_template' => '',
            'style' => ''
        ];
    }

Can your disable Diffs and then do the query logging when saving an entry?

In that same mysqli_driver.php file, line 277, add this writeToFile, then save one of those same entries you’ve been testing with.

function _list_columns($table = '')
 {
     writeToFile('show-columns', $table);
  return "SHOW COLUMNS FROM ".$this->_protect_identifiers($table, TRUE, NULL, FALSE);
 }

Ok, so the excessive queries to SHOW COLUMNS FROM exp_channel_grid_field_* don’t appear to be coming from Publisher, but from EE itself. At this point I don’t know what else I can do to make it faster.

There is no guarantee those queries are causing the issue. You’d have to stop those queries to see if it is them, but if you disable Publisher and it saves in 3 seconds then obviously there is something slow in Publisher but I’m not sure what it is, or when I’d be able to identify it, let alone fix it. Regardless having Publisher installed is going to make things a bit slower out of the fact of what it’s trying to do. I don’t even have an EE 2 site running anymore so I can’t compare.

Comment has been marked private.