All add-ons currently require PHP 7.4 or greater.

On July 4th 2024 PHP 8.2 will be the new minimum requirement for all add-ons. Expect any add-on released after that date to require 8.2 or greater. Some releases may not immediately take advantage of 8.x specific features in PHP, which means you might, be able to continue using new releases in PHP 7.4, however, if you experience an error the first thing you should do is update to PHP 8.2 then create a support ticket if the error persists.

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: Database error when persistence entries=“no” and no entries in the second language

Status Resolved
Add-on / Version Publisher 1.6.12
Severity
EE Version v2.10.1 - Build Date: 20150501

Barbara Cinotti

Jun 07, 2016

Description:
I’ve updated to the last Publisher version 1.6.12
delete Publisher Cache directory
Settings persistence/preference - persistent entries=“no”
when I switch to the second language and there aren’t translated entries I get this error:

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY c.group_id, c.parent_id, c.cat_order' at line 7

SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id, p.cat_id, p.entry_id, c.group_id , cg.field_html_formatting, fd.* FROM (exp_categories AS c, exp_category_posts AS p) LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id WHERE c.cat_id = p.cat_id AND p.entry_id IN ) ORDER BY c.group_id, c.parent_id, c.cat_order

Filename: modules/channel/mod.channel.php

Line Number: 482

In my template I have:

{exp:channel:entries channel="news" status="open" limit="4"}
<h1>{title}</h1>
<p>{/exp:channel:entries}

It works only if I add parameter publisher_enable_persistence=“yes”

I know that this option is not priority and for me is not essential but just to let you know that with the previous version 1.6.11 all works fine.

Thanks

Barbara

 

#1

BoldMinded (Brian)

Did you try the entries tag without the limit parameter?

#2

Barbara Cinotti

Hi Brian,

I’ve tried the entries tag without the limit parameter and in this case it works, no errors.

Thanks

Barbara

#3

BoldMinded (Brian)

Barbara, I wasn’t able to replicate this locally. The error is occurring in an area that deals with categories. Are you using categories with these entries? Would you be able to setup a clean EE environment to replicate the issue that I could take a look at?

#4

Barbara Cinotti

Yes Brian, I’ve used categories.

I’m going to setup a clean EE enviroment as soon as possible for you,

thanks

Barbara

#5

BoldMinded (Brian)

Closing b/c of no response after a couple months.

Login to reply