Publisher does not support the Fluid field type. 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: Diff settings PHP errors

Status	Resolved
Add-on / Version	Publisher Lite 2.7.3
Severity
EE Version	4.0.3

Rob Allen

Jan 03, 2018

Just installed Publisher Lite and got errors when accessing Diff settings page

Addons installed
———-
EE4.0.3
Publisher 2.7.3
Structure 4.3.1
Calendar 3.0.1

The errors
———-

Exception Caught
Unknown field ChannelField.group_id

ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php:709
Stack Trace: Please include when reporting this error

#0 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(520): EllisLab\ExpressionEngine\Service\Model\Query\Select->translateProperty(‘group_id’)
#1 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(134): EllisLab\ExpressionEngine\Service\Model\Query\Select->applyOrders(Object(EllisLab\ExpressionEngine\Service\Database\Query), Array)
#2 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(46): EllisLab\ExpressionEngine\Service\Model\Query\Select->buildQuery()
#3 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select->run()
#4 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Select’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#5 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#6 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(62): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch()
#7 user/addons/publisher/Controllers/General/Diff.php(232): EllisLab\ExpressionEngine\Service\Model\Query\Builder->all()
#8 user/addons/publisher/Controllers/General/Diff.php(162): BoldMinded\Publisher\Controllers\General\Diff->getGridRow()
#9 user/addons/publisher/Controllers/General/Diff.php(58): BoldMinded\Publisher\Controllers\General\Diff->getFieldSettings()
#10 user/addons/publisher/mcp.publisher.php(141): BoldMinded\Publisher\Controllers\General\Diff->render(‘general/diff’)
#11 user/addons/publisher/mcp.publisher.php(84): Publisher_mcp->runController()
#12 [internal function]: Publisher_mcp->general(‘diff’)
#13 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1600): call_user_func_array(Array, Array)
#14 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(884): EllisLab\ExpressionEngine\Controller\Addons\Addons->getModuleSettings(‘publisher’, ‘general’, Array)
#15 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->settings(‘publisher’, ‘general’, ‘diff’)
#16 ee/EllisLab/ExpressionEngine/Core/Core.php(229): call_user_func_array(Array, Array)
#17 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#18 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#19 index.php(151): require_once(’...’)
#19 index.php(151): require_once(’...’)

BoldMinded (Brian)

Thanks for the report. I’ll try to take a look at it this week.

Rob Allen

Thanks Brian, I had to uninstall Publisher for the time being as it was affecting the front end - we have a client meeting tomorrow so need EE working!

BoldMinded (Brian)

I can see the error happening in the CP Diff settings page, but I don’t see it happening on the front-end. How is it affecting your front-end? Can you provide more info on that? Error message maybe?

Rob Allen

Are you looking at our dev site or locally?

Rob Allen

Just reinstalled Publisher, front end errors I get

Exception Caught SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m.url’ in ‘field list’: SELECT ct.*, t.*, d.*, channel_title, c.channel_name, c.channel_url, c.comment_url, c.comment_moderate, c.channel_html_formatting, c.channel_allow_img_urls, c.channel_auto_link_urls, c.comment_system_enabled, username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, ct.url_title AS default_url_title, t.title AS title, t.site_id AS entry_site_id FROM (exp_publisher_titles AS t) JOIN exp_publisher_data AS d ON t.entry_id = d.entry_id AND t.lang_id = d.lang_id AND t.status = d.status JOIN exp_channel_titles AS ct ON ct.entry_id = t.entry_id JOIN exp_channels AS c ON c.channel_id = t.channel_id JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.status = ‘open’ AND t.lang_id = 1 AND t.entry_id IN (2)

ee/legacy/database/drivers/mysqli/mysqli_connection.php:116 Stack Trace: Please include when reporting this error

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT `ct`.*, ...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT `ct`.*, ...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT `ct`.*, ...')
#3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query('SELECT `ct`.*, ...')
#4 user/addons/publisher/Service/Entry/EntryResult.php(632): CI_DB_active_record->get()
#5 user/addons/publisher/Service/Entry/EntryResult.php(353): BoldMinded\Publisher\Service\Entry\EntryResult->getAllQuery(Array, Array)
#6 user/addons/publisher/ext.publisher.php(675): BoldMinded\Publisher\Service\Entry\EntryResult->getAll(Array, Array)
#7 ee/legacy/libraries/Extensions.php(227): Publisher_ext->channel_entries_query_result(Object(Channel), Array)
#8 ee/legacy/libraries/Extensions.php(122): EE_Extensions->call_class('Publisher_ext', 'channel_entries...', Array, Array)
#9 ee/EllisLab/Addons/channel/mod.channel.php(2545): EE_Extensions->call('channel_entries...', Object(Channel), Array)
#10 ee/EllisLab/Addons/channel/mod.channel.php(284): Channel->parse_channel_entries()
#11 ee/legacy/libraries/Template.php(1810): Channel->entries()
#12 ee/legacy/libraries/Template.php(1449): EE_Template->process_tags()
#13 ee/legacy/libraries/Template.php(545): EE_Template->tags()
#14 ee/legacy/libraries/Template.php(229): EE_Template->parse('&#123;!-- ra:0000000...', false, 1, false)
#15 ee/legacy/libraries/Template.php(162): EE_Template->fetch_and_parse('parish-life', Array, false)
#16 ee/legacy/libraries/Core.php(657): EE_Template->run_template_engine('parish-life', 'index')
#17 ee/legacy/controllers/ee.php(62): EE_Core->generate_page()
#18 [internal function]: EE->index()
#19 ee/EllisLab/ExpressionEngine/Core/Core.php(229): call_user_func_array(Array, Array)
#20 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#21 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#22 index.php(172): require_once('...')
#22 index.php(172): require_once('...')

BoldMinded (Brian)

Comment has been marked private.

Rob Allen

Sadly no, though we have a few new error messages when accessing a Structure page

Notice Undefined offset: 1 user/addons/publisher/Service/ChannelField.php, line 262

Warning Invalid argument supplied for foreach() user/addons/publisher/Service/ChannelField.php, line 180

Notice Undefined offset: 1 user/addons/publisher/Service/ChannelField.php, line 262

Warning Invalid argument supplied for foreach() user/addons/publisher/Service/ChannelField.php, line 180

Notice Undefined offset: 1 user/addons/publisher/Service/ChannelField.php, line 262

Warning Invalid argument supplied for foreach() user/addons/publisher/Service/ChannelField.php, line 180

Notice Undefined offset: 1 user/addons/publisher/Service/ChannelField.php, line 262

Warning Invalid argument supplied for foreach() user/addons/publisher/Service/ChannelField.php, line 180

Warning Cannot modify header information - headers already sent by (output started at ee/legacy/core/Exceptions.php:111) ee/EllisLab/ExpressionEngine/Boot/boot.common.php, line 487

Exception Caught SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘exp_channels.field_group’ in ‘field list’: SELECT exp_publisher_titles.title, exp_publisher_titles.url_title, exp_publisher_data.*, exp_channels.field_group, exp_channels.channel_title AS channel, exp_channels.channel_name AS channel_short_name FROM (exp_publisher_titles) JOIN exp_publisher_data ON exp_publisher_data.entry_id = exp_publisher_titles.entry_id JOIN exp_channels ON exp_channels.channel_id = exp_publisher_titles.channel_id WHERE exp_publisher_titles.entry_id IN (‘13’, ‘15’, ‘65’, ‘2’, ‘20’, ‘14’) AND exp_publisher_titles.lang_id = 1 AND exp_publisher_titles.status = ‘open’ AND exp_publisher_data.lang_id = 1 AND exp_publisher_data.status = ‘open’

ee/legacy/database/drivers/mysqli/mysqli_connection.php:116 Stack Trace: Please include when reporting this error

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT `exp_pub...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT `exp_pub...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT `exp_pub...')
#3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query('SELECT `exp_pub...')
#4 user/addons/publisher/legacy/libraries/hooks/Publisher_structure_hooks.php(451): CI_DB_active_record->get('publisher_title...')
#5 user/addons/publisher/ext.publisher.php(1368): Publisher_structure_hooks->structure_get_custom_variables(Array)
#6 ee/legacy/libraries/Extensions.php(227): Publisher_ext->structure_get_custom_variables(Array)
#7 ee/legacy/libraries/Extensions.php(122): EE_Extensions->call_class('Publisher_ext', 'structure_get_c...', Array, Array)
#8 user/addons/structure/libraries/Structure_nav_parser.php(208): EE_Extensions->call('structure_get_c...', Array)
#9 user/addons/structure/libraries/Structure_nav_parser.php(269): Structure_core_nav_parser->add_entry_vars_ee4()
#10 user/addons/structure/libraries/Structure_nav_parser.php(75): Structure_core_nav_parser->add_entry_vars_start()
#11 user/addons/structure/mod.structure.php(3228): Structure_core_nav_parser->get_variables(true)
#12 user/addons/structure/mod.structure.php(3241): Structure->nav_basic(true)
#13 ee/legacy/libraries/Template.php(1810): Structure->nav_advanced()
#14 ee/legacy/libraries/Template.php(1449): EE_Template->process_tags()
#15 ee/legacy/libraries/Template.php(545): EE_Template->tags()
#16 ee/legacy/libraries/Template.php(229): EE_Template->parse('&#123;!-- ra:0000000...', false, 1, true)
#17 ee/legacy/libraries/Template.php(968): EE_Template->fetch_and_parse('inc', '_layout-general', false, 1, true)
#18 ee/legacy/libraries/Template.php(592): EE_Template->process_layout_template('&#123;!-- ra:0000000...', Array)
#19 ee/legacy/libraries/Template.php(229): EE_Template->parse('&#123;!-- ra:0000000...', false, 1, false)
#20 ee/legacy/libraries/Template.php(162): EE_Template->fetch_and_parse('parish-life', Array, false)
#21 ee/legacy/libraries/Core.php(657): EE_Template->run_template_engine('parish-life', 'index')
#22 ee/legacy/controllers/ee.php(62): EE_Core->generate_page()
#23 [internal function]: EE->index()
#24 ee/EllisLab/ExpressionEngine/Core/Core.php(229): call_user_func_array(Array, Array)
#25 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#26 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#27 index.php(172): require_once('...')
#27 index.php(172): require_once('...')

BoldMinded (Brian)

Have you created any custom fields yet? Are there custom fields assigned to the entry/channel you’re viewing?

Rob Allen

Yes custom fields existed before Publisher was installed, and yes custom fields are assigned to all channels - some use EE4 Field groups, but we’re not using Fluid fields..

#10

BoldMinded (Brian)

In the legacy/libraries/hooks/Publisher_structure_hooks.php file at the very bottom is this function

public function structure_get_custom_variables($entryIds)
    {
        $db = ee('db');

        return $db->select('publisher_titles.title, publisher_titles.url_title')
            ->select('publisher_data.*')
            ->select('channels.field_group')
            ->select('channels.channel_title AS channel')
            ->select('channels.channel_name AS channel_short_name')
            ->where_in('publisher_titles.entry_id', $entryIds)
            ->where('publisher_titles.lang_id', $this->currentLanguageId)
            ->where('publisher_titles.status', $this->currentStatus)
            ->where('publisher_data.lang_id', $this->currentLanguageId)
            ->where('publisher_data.status', $this->currentStatus)
            ->join('publisher_data', 'publisher_data.entry_id = publisher_titles.entry_id')
            ->join('channels', 'channels.channel_id = publisher_titles.channel_id')
            ->get('publisher_titles');
    }

Remove the line ->select(‘channels.field_group’) and see if that fixes it.

#11

BoldMinded (Brian)

Actually, hold off on that change…

#12

BoldMinded (Brian)

Comment has been marked private.

#13

BoldMinded (Brian)

Comment has been marked private.

#14

BoldMinded (Brian)

Comment has been marked private.

#15

BoldMinded (Brian)

Comment has been marked private.

#16

Rob Allen

Comment has been marked private.

#17

Rob Allen

Comment has been marked private.

#18

BoldMinded (Brian)

Are you sure the previews are enabled? Do you see any JS errors in your console?

#19

Rob Allen

Comment has been marked private.

#20

BoldMinded (Brian)

Rob, it could be any number of things and I can’t speculate what it is without seeing the CP. I do know that the previews work in my local environment, so its most likely a configuration issue.

#21

BoldMinded (Brian)

I’m pretty sure this is fixed in the latest build (2.7.5). See next comment for the link. I’m going to close this ticket.

#22

BoldMinded (Brian)

Comment has been marked private.