Can you add that CP login to the review site as well?

Comment has been marked private.

I think I may have found the issue with the drafts, just need to update a file on your preview site to verify.

I think this issue, and #4 from your email (the translation statuses) are fixed on the preview site. I can send a new full build if you like.

Regarding the slow query issue, the category query that is taking several seconds to run I believe is from line 3376 of the mod.channel.php file. Its the only place in EE and in Publisher where I see “DISTINCT (c.cat_id)”, and if you read the code after that line you can see where its assembling this full query. So, I’m not really sure if/how this is a Publisher issue and if I can fix it. Maybe Robin at EL has some insight? I’d be happy to make a change if I can to fix the issue, but seeing that the query is from a core EE file not sure there is much I can do at this point.

SELECT DISTINCT (c.cat_id), c.group_id, c.cat_name, c.cat_url_title, c.cat_description, c.cat_image, c.parent_id, c.cat_order FROM (exp_categories AS c, exp_category_posts ) WHERE c.group_id IN ('3') AND c.cat_id IN (‘15','12','37','38','39','35','36','40','41','13','14') AND c.parent_id = 0 ORDER BY c.group_id, c.parent_id, c.cat_order;

I’m not very good at reading EXPLAIN query results, but maybe EL can make something of it?

EXPLAIN SELECT DISTINCT (c.cat_id), c.group_id, c.cat_name, c.cat_url_title, c.cat_description, c.cat_image, c.parent_id, c.cat_order FROM (exp_categories AS c, exp_category_posts ) WHERE c.group_id IN ('3') AND c.cat_id IN ('15','12','37','38','39','35','36','40','41','13','14') AND c.parent_id = 0 ORDER BY c.group_id, c.parent_id, c.cat_order

id  select_type  table  type  possible_keys  key  key_len  ref  rows  Extra 
1 SIMPLE c index_merge PRIMARY,group_id group_id,PRIMARY 4,4  1 Using intersect(group_id,PRIMARY); Using where; Using temporary; Using filesort
1 SIMPLE exp_category_posts index  PRIMARY 8  64864 Using index; Distinct; Using join buffer (flat, BNL join)

That table only has 2 columns each set as an index. I’m wondering what would happen if you created a composite index to see if it speeds up the query.

ALTER TABLE `exp_category_posts` ADD UNIQUE `entry_cat` (`entry_id`, `cat_id`)

And maybe the same thing on the categories table?

ALTER TABLE `exp_categories` ADD UNIQUE `group_cat` (`group_id`, `cat_id`)

Greg, did you confirm in the draft issue was fixed? We were emailing back and forth but I don’t recall getting a confirmation on the draft issue. This ticket kind of diverged into a slow query issue 😊

Confirmed fixed. Closing!

Double check the author_id column value in that entry that isn’t displaying right. See if the value is different in the exp_channel_titles and exp_publisher_titles tables.

Comment has been marked private.

The delete draft button may not be showing b/c the query could be failing, so it doesn’t think it has a draft. You may need to delete the rows manually from the db.

Have you tried creating a bare bones template with only the entries tag in it to load entry 9833 to see if it displays all the content correctly?

Comment has been marked private.

Are you using anything like DataGrab or any other method of inserting content?

Usually when I hear a bug report I have an idea of what could be causing it, but this one is very odd and I’m not sure where to start other than to run this query to see if other mismatches exist:

select t.entry_id, t.title from exp_publisher_titles as t
join exp_publisher_data as d on t.entry_id = d.entry_id
where t.lang_id = d.lang_id
and t.status = d.status
and t.channel_id != d.channel_id;

Yeah, double check the channel_id values for each of those. Also, see if there may be a pattern, e.g. do they have the same author_id/edit_by values or anything else in common that may lead to a possible cause.