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: Exception Caught: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION usr_p533910_1.1AND does not exist:

Status	Resolved
Add-on / Version	Publisher 3.0.0
Severity
EE Version	5.3.0

Matthias Ballmann

Nov 01, 2019

hi brian,

I installed the 3.0.0 of publisher, downloaded today from your site and it works well on the greater part of the website. but on some pages I get these errors as seen in the screenshots attached.

this is the complete text error:

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION usr_p533910_1.1AND does not exist:
SELECT `ct`.*, `t`.*, `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`.`screen_name`, `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`, `ct`.`url_title` AS default_url_title, `ct`.`status` AS status, `t`.`title` AS title, `t`.`site_id` AS entry_site_id, `exp_publisher_data_field_1`.`field_id_1` AS field_id_1, `exp_publisher_data_field_2`.`field_id_2` AS field_id_2, `exp_publisher_data_field_3`.`field_id_3` AS field_id_3, `exp_publisher_data_field_4`.`field_id_4` AS field_id_4, `exp_publisher_data_field_5`.`field_id_5` AS field_id_5, `exp_publisher_data_field_10`.`field_id_10` AS field_id_10, `exp_publisher_data_field_11`.`field_id_11` AS field_id_11, `exp_publisher_data_field_12`.`field_id_12` AS field_id_12, `exp_publisher_data_field_15`.`field_id_15` AS field_id_15, `exp_publisher_data_field_16`.`field_id_16` AS field_id_16, `exp_publisher_data_field_17`.`field_id_17` AS field_id_17, `exp_publisher_data_field_18`.`field_id_18` AS field_id_18, `exp_publisher_data_field_19`.`field_id_19` AS field_id_19, `exp_publisher_data_field_20`.`field_id_20` AS field_id_20, `exp_publisher_data_field_21`.`field_id_21` AS field_id_21, `exp_publisher_data_field_22`.`field_id_22` AS field_id_22, `exp_publisher_data_field_23`.`field_id_23` AS field_id_23, `exp_publisher_data_field_25`.`field_id_25` AS field_id_25, `exp_publisher_data_field_26`.`field_id_26` AS field_id_26, `exp_publisher_data_field_27`.`field_id_27` AS field_id_27, `exp_publisher_data_field_6`.`field_id_6` AS field_id_6, `exp_publisher_data_field_7`.`field_id_7` AS field_id_7, `exp_publisher_data_field_8`.`field_id_8` AS field_id_8, `exp_publisher_data_field_9`.`field_id_9` AS field_id_9, `exp_publisher_data_field_13`.`field_id_13` AS field_id_13, `exp_publisher_data_field_14`.`field_id_14` AS field_id_14 FROM (`exp_publisher_titles` AS t) 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` LEFT JOIN `exp_publisher_data_field_1` ON `t`.`entry_id` = `exp_publisher_data_field_1`.`entry_id` AND t.lang_id = exp_publisher_data_field_1.lang_id AND t.status = exp_publisher_data_field_1.status AND exp_publisher_data_field_1.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_2` ON `t`.`entry_id` = `exp_publisher_data_field_2`.`entry_id` AND t.lang_id = exp_publisher_data_field_2.lang_id AND t.status = exp_publisher_data_field_2.status AND exp_publisher_data_field_2.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_3` ON `t`.`entry_id` = `exp_publisher_data_field_3`.`entry_id` AND t.lang_id = exp_publisher_data_field_3.lang_id AND t.status = exp_publisher_data_field_3.status AND exp_publisher_data_field_3.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_4` ON `t`.`entry_id` = `exp_publisher_data_field_4`.`entry_id` AND t.lang_id = exp_publisher_data_field_4.lang_id AND t.status = exp_publisher_data_field_4.status AND exp_publisher_data_field_4.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_5` ON `t`.`entry_id` = `exp_publisher_data_field_5`.`entry_id` AND t.lang_id = exp_publisher_data_field_5.lang_id AND t.status = exp_publisher_data_field_5.status AND exp_publisher_data_field_5.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_10` ON `t`.`entry_id` = `exp_publisher_data_field_10`.`entry_id` AND t.lang_id = exp_publisher_data_field_10.lang_id AND t.status = exp_publisher_data_field_10.status AND exp_publisher_data_field_10.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_11` ON `t`.`entry_id` = `exp_publisher_data_field_11`.`entry_id` AND t.lang_id = exp_publisher_data_field_11.lang_id AND t.status = exp_publisher_data_field_11.status AND exp_publisher_data_field_11.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_12` ON `t`.`entry_id` = `exp_publisher_data_field_12`.`entry_id` AND t.lang_id = exp_publisher_data_field_12.lang_id AND t.status = exp_publisher_data_field_12.status AND exp_publisher_data_field_12.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_15` ON `t`.`entry_id` = `exp_publisher_data_field_15`.`entry_id` AND t.lang_id = exp_publisher_data_field_15.lang_id AND t.status = exp_publisher_data_field_15.status AND exp_publisher_data_field_15.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_16` ON `t`.`entry_id` = `exp_publisher_data_field_16`.`entry_id` AND t.lang_id = exp_publisher_data_field_16.lang_id AND t.status = exp_publisher_data_field_16.status AND exp_publisher_data_field_16.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_17` ON `t`.`entry_id` = `exp_publisher_data_field_17`.`entry_id` AND t.lang_id = exp_publisher_data_field_17.lang_id AND t.status = exp_publisher_data_field_17.status AND exp_publisher_data_field_17.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_18` ON `t`.`entry_id` = `exp_publisher_data_field_18`.`entry_id` AND t.lang_id = exp_publisher_data_field_18.lang_id AND t.status = exp_publisher_data_field_18.status AND exp_publisher_data_field_18.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_19` ON `t`.`entry_id` = `exp_publisher_data_field_19`.`entry_id` AND t.lang_id = exp_publisher_data_field_19.lang_id AND t.status = exp_publisher_data_field_19.status AND exp_publisher_data_field_19.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_20` ON `t`.`entry_id` = `exp_publisher_data_field_20`.`entry_id` AND t.lang_id = exp_publisher_data_field_20.lang_id AND t.status = exp_publisher_data_field_20.status AND exp_publisher_data_field_20.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_21` ON `t`.`entry_id` = `exp_publisher_data_field_21`.`entry_id` AND t.lang_id = exp_publisher_data_field_21.lang_id AND t.status = exp_publisher_data_field_21.status AND exp_publisher_data_field_21.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_22` ON `t`.`entry_id` = `exp_publisher_data_field_22`.`entry_id` AND t.lang_id = exp_publisher_data_field_22.lang_id AND t.status = exp_publisher_data_field_22.status AND exp_publisher_data_field_22.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_23` ON `t`.`entry_id` = `exp_publisher_data_field_23`.`entry_id` AND t.lang_id = exp_publisher_data_field_23.lang_id AND t.status = exp_publisher_data_field_23.status AND exp_publisher_data_field_23.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_25` ON `t`.`entry_id` = `exp_publisher_data_field_25`.`entry_id` AND t.lang_id = exp_publisher_data_field_25.lang_id AND t.status = exp_publisher_data_field_25.status AND exp_publisher_data_field_25.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_26` ON `t`.`entry_id` = `exp_publisher_data_field_26`.`entry_id` AND t.lang_id = exp_publisher_data_field_26.lang_id AND t.status = exp_publisher_data_field_26.status AND exp_publisher_data_field_26.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_27` ON `t`.`entry_id` = `exp_publisher_data_field_27`.`entry_id` AND t.lang_id = exp_publisher_data_field_27.lang_id AND t.status = exp_publisher_data_field_27.status AND exp_publisher_data_field_27.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_6` ON `t`.`entry_id` = `exp_publisher_data_field_6`.`entry_id` AND t.lang_id = exp_publisher_data_field_6.lang_id AND t.status = exp_publisher_data_field_6.status AND exp_publisher_data_field_6.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_7` ON `t`.`entry_id` = `exp_publisher_data_field_7`.`entry_id` AND t.lang_id = exp_publisher_data_field_7.lang_id AND t.status = exp_publisher_data_field_7.status AND exp_publisher_data_field_7.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_8` ON `t`.`entry_id` = `exp_publisher_data_field_8`.`entry_id` AND t.lang_id = exp_publisher_data_field_8.lang_id AND t.status = exp_publisher_data_field_8.status AND exp_publisher_data_field_8.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_9` ON `t`.`entry_id` = `exp_publisher_data_field_9`.`entry_id` AND t.lang_id = exp_publisher_data_field_9.lang_id AND t.status = exp_publisher_data_field_9.status AND exp_publisher_data_field_9.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_13` ON `t`.`entry_id` = `exp_publisher_data_field_13`.`entry_id` AND t.lang_id = exp_publisher_data_field_13.lang_id AND t.status = exp_publisher_data_field_13.status AND exp_publisher_data_field_13.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_14` ON `t`.`entry_id` = `exp_publisher_data_field_14`.`entry_id` AND t.lang_id = exp_publisher_data_field_14.lang_id AND t.status = exp_publisher_data_field_14.status AND exp_publisher_data_field_14.is_fluid = 0 JOIN `exp_members` AS m ON `m`.`member_id` = `t`.`author_id` WHERE `t`.`entry_id` IN (73, 14, 6, 2, 11) AND `t`.`status` = ‘open’ AND `t`.`lang_id` = 1AND ( (d.site_id=1 AND exp_channel_data_field_9.field_id_9!=”” AND d.site_id=1 AND exp_channel_data_field_9.field_id_9 IS NOT NULL) )

ee/legacy/database/drivers/mysqli/mysqli_connection.php:117

Stack Trace: Please include when reporting this error

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query(‘SELECT `ct`.*, ...’)
#1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute(‘SELECT `ct`.*, ...’)
#2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query(‘SELECT `ct`.*, ...’)
#3 user/addons/publisher/Service/Entry/EntryQuery.php(209): CI_DB_driver->query(‘SELECT `ct`.*, ...’)
#4 user/addons/publisher/Service/Entry/EntryResult.php(501): BoldMinded\Publisher\Service\Entry\EntryQuery->getResultArray()
#5 user/addons/publisher/Service/Entry/EntryResult.php(219): BoldMinded\Publisher\Service\Entry\EntryResult->getAllQuery(Array, Array)
#6 user/addons/publisher/ext.publisher.php(885): BoldMinded\Publisher\Service\Entry\EntryResult->getAll(Array, Array)
#7 ee/legacy/libraries/Extensions.php(222): Publisher_ext->channel_entries_query_result(Object(Channel), Array)
#8 ee/legacy/libraries/Extensions.php(117): EE_Extensions->call_class(‘Publisher_ext’, ‘channel_entries…’, Array, Array)
#9 ee/EllisLab/Addons/channel/mod.channel.php(2779): EE_Extensions->call(‘channel_entries…’, Object(Channel), Array)
#10 ee/EllisLab/Addons/channel/mod.channel.php(281): Channel->parse_channel_entries()
#11 ee/legacy/libraries/Template.php(1847): Channel->entries()
#12 ee/legacy/libraries/Template.php(1482): EE_Template->process_tags()
#13 ee/legacy/libraries/Template.php(578): EE_Template->tags()
#14 ee/legacy/libraries/Template.php(234): EE_Template->parse(’{!—ra:0000000…’, false, 1, false)
#15 ee/legacy/libraries/Template.php(165): EE_Template->fetch_and_parse(’‘, Array, false)
#16 ee/legacy/libraries/Core.php(661): EE_Template->run_template_engine(’‘, ‘’)
#17 ee/legacy/controllers/ee.php(63): EE_Core->generate_page()
#18 [internal function]: EE->index()
#19 ee/EllisLab/ExpressionEngine/Core/Core.php(241): call_user_func_array(Array, Array)
#20 ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#21 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#22 files/index.php(191): require_once(’...’)
#22 files/index.php(191): require_once(’...’)

{!-- Mastertemplate --}
{layout="index/master"}

{!-- Seitentitel --}
{layout:set name="title" value="{phrase:impressum}"}

{!-- Seiteninhalte --}
<a class="legal">
 {exp:channel:entries channel="profil" disable="categories|category_fields|member_data|pagination|relationships"}
  <h1>{phrase:impressum}</h1>
  {impressum}
 {/exp:channel:entries}
 {exp:channel:entries channel="projekte" search:bildnachweise="not IS_EMPTY" orderby="bildnachweise" sort="asc" disable="categories|category_fields|member_data|pagination|relationships"}
  {if count == 1}
    
   
   <strong>{phrase:bildnachweise}</strong>
   
   
  {/if}
  {bildnachweise}{if absolute_results >= 2 AND count != absolute_results}, {/if}
  {if count == absolute_results}
   
  {/if}
 {/exp:channel:entries}
</article>

BoldMinded (Brian)

I know what the fix is but I’m just not exactly sure where it is. I should have a new build for you by the end of the weekend.

BoldMinded (Brian)

Comment has been marked private.

Matthias Ballmann

Comment has been marked private.

#10

Matthias Ballmann

Comment has been marked private.

#11

Matthias Ballmann

Comment has been marked private.

#12

BoldMinded (Brian)

I wasn’t able to replicate the second query error, but I was able to replicate the first one you reported, which is how I fixed it.

Are you sure the exp_publisher_data_field_9 table exists and the field_id_9 column is in it? What is field #9? Is it the bildnachweise field?

#13

Matthias Ballmann

I just looked in the db and…

hi brain, It looks as if the error of the emptied fields has been corrected. However, it now seems as if there is an switching of the language versions in the mass edit mode, because after I inserted all English versions of the texts yesterday (via mass edit), now all German texts are English… and the English versions are still empty or missing.

But if you edit an entry individually, everything seems to be correct.

#24

BoldMinded (Brian)

When you do the mass edit, do you have the CP set to your default language or non-default language?

#25

BoldMinded (Brian)

Matthias, just to make sure I’m replicating this, you checked multiple entries and then selected Edit, not Bulk Edit, correct? screenshot: https://d.pr/i/gdB6sv

That conditional isn’t executing any queries, what is the entries tag that is around it?

#32

Matthias Ballmann

it’s this:

{exp:channel:entries channel="shop" search:art_des_shopartikels="Bücher und Kataloge" status="not vergriffen" orderby="random" dynamic="no" limit="10" disable="categories|category_fields|member_data"}

#33

BoldMinded (Brian)

That is what I needed, thanks. I’ll test it locally and see what happens. Could be a day or two before I get a new build to you.

#34

BoldMinded (Brian)

What is “not vergriffen” in English?

#35

Matthias Ballmann

Comment has been marked private.

#36

BoldMinded (Brian)

I just tried a similar tag locally, and it worked fine in default and non-default languages.

{exp:channel:entries channel="pages" search:heading="one" status="not closed" orderby="random" dynamic="no" limit="10" disable="categories|category_fields|member_data"}
 {title}
{/exp:channel:entries}

$this->customFields = $this->fieldSchema->getCustomFieldTables();

Add after that line:

var_dump($this->customFields);

Comment has been marked private.

#55

BoldMinded (Brian)

Ok, so test just the structure:nav tag in a template.

{exp:structure:nav_advanced}{root:children}{if child:active}{child:title} – {/if}{/root:children}{if root:active}{root:title}{/if}{/exp:structure:nav_advanced}

If there are multiple tags running on the page it makes it more difficult to debug. We need to narrow it down to a single tag that is causing the error, then I can look into it.

#56

Matthias Ballmann

Comment has been marked private.

#57

Matthias Ballmann

Comment has been marked private.

#58

Matthias Ballmann

Comment has been marked private.

#59

BoldMinded (Brian)

I’m not logged in and won’t be able to agin until tonight or tomorrow.

What do you mean by rollback? Will rolling back stop the error from occurring and remove those test templates? If so they’ll need to be added back so I can debug.

#60

Matthias Ballmann

Comment has been marked private.

#61

BoldMinded (Brian)

Matthias, just checking in on the status of this. Did the rollback fix it? If not were you able to re-create the test/debug template I made?