fbcyborg

Hello @wayneallen-1 I can confirm this is a conflict with UAM. What do you suggest? Actually, after disabling the plugin, the post was correctly imported.

Thanks in advance!

Hi!

I have some news since I could debug a bit the problem. I can provide you the full log file in case of need but please find the below considerations.

I have category having ID = 10 and tag with ID = 11.
For what I could see, every time I send an e-mail to the configured address,
the batch runs and it creates just one new row into the wp_term_relationships table.
This means that I have one new row with ID 11 only. If I make a comparison to the posts having the category and tag being associated, I see this for the correct posts:

{"object_id":"7174","term_taxonomy_id":"11","term_order":"0"},
{"object_id":"7174","term_taxonomy_id":"10","term_order":"0"},

While I only see this for the new post without the category:

{"object_id":"7182","term_taxonomy_id":"11","term_order":"0"},

I tried to manually insert a new entry into the wp_term_relationships table and could see the post correctly in the Admin panel (meaning that I can see both category and tag set as well as the author). This is equivalent to setting up the category in the admin panel.

Here’s what I could see in the debug logs:
[14-Jan-2023 14:52:06 Europe/Rome] Postie [debug]: Query: INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES (7182, 11)
Which is okay as reported above.

But I cannot see the other insert instruction for term_taxonomy_id = 10.

The below query raises me a suspect (why is it excluding 10 in the NOT IN clause?):

[14-Jan-2023 14:52:06 Europe/Rome] Postie [debug]: Query: 
			SELECT DISTINCT t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
			WHERE tt.taxonomy IN ('post_tag') AND t.term_id NOT IN (10,29,30) AND tr.object_id IN (7182)

I suspect it is something related to a missing database configuration for such category having id = 10 on the core of WordPress but can’t understand which one for now.

Do you have any idea?

Thanks!

• This reply was modified 3 years, 5 months ago by fbcyborg.

Hello,

thank you for replying. Regarding the user, it is linked to the post as expected.
I am definitely using a category, not a custom taxonomy. After the new article creation, I see just a “dash sign” (it’s like a minus) under the category column within the article list (which is different from “no category” as far as I know).

By saying okay I mean that it worked as expected (category is assigned) on manual run. But if I let the scheduled task run every “xx” minutes, I can’t see any category for the new article.

Sorry, I thought there’s no more people supporting this plugin and I was hoping some other user would have some hint. Apologizes, I understand.

Just let me know if I can put some debug log or do any specific test on the source code. Consider that this website is coming from a manual WordPress core upgrade from version 4.2 to 6.1.1.

Hi! anyone can help me please?

Let’s add some more information about the plug-ins I’m using:

• Aruba HiSpeed Cache
• Cookie Notice & Compliance for GDPR / CCPA
• Custom Login
• Embed Plus YouTube WordPress Plugin
• NextGEN Gallery
• Postie
• Simple Custom Post Order
• Simple Visitors Counter
• Social Gallery and Widget
• Subscribe2
• Team Showcase
• Theme My Login
• Ultimate Product Catalog
• User Access Manager
• WP Instant Feeds

I’ve read something about a compatibility issue with UAM but not sure it is because of this plugin, since Postie was working well on WordPress 5 and UAM.