PSS

Hi@posimyththemes

All of the other plugins on the site are WordPress plugins too.

Because we have never experienced anything like this before over many years of using WordPress, we have decided not to proceed with using this plugin.

Appreciate your reply.

Hi @bcworkz

Thanks for the reply. Maybe I didn’t explain myself clearly enough.

All comments are posted by logged-in users only. All comment-author fields are filled with the user’s display name, including this comment that is showing the user’s first name instead of the display name which is in the comment-author field.

I don’t know that the Blank Canvas theme would be doing this. Is there any easy way to change this with PHP?

Hi @tdgu

Thanks for your reply. I wanted to update that the issue has been fixed. I will mark this as resolved.

Regards.

“It appears that the custom code conflicts with the iThemes Security plugin.”

Obviously, or we would have needed to open this support thread. We were hoping you would have some sort of fix for this but looks like no.

Hi @uncannyautomator

As I have sent the System Report, I am attaching our convo from emails here as we prefer to keep all info in one place.

____________________

Hi Ryan,

There is no migrated site because we can’t or don’t want to use the remaining tables without the complete database. We don’t want to be messing around with the database on a live site. We want this to function properly from the get-go and this is the only issue we are facing which is prolonging the launch of our website.

So yes, the Automator System Report is from the localhost development site.

> It sounds too like this was an entire database migration and Automator views specifically are the only things that failed?
As you can see from the error, yes this is the case. Automator is the only plugin causing an issue with the database upload.

——- Original Message ——-
Uncanny Automator Support wrote:

The System Report you sent here seems like maybe it was the original site, or do you have cPanel and WHM running locally too? This instance doesn’t show obvious issues, so I wanted to confirm that this is the system report for the migrated site.

Then for the .org ticket comments, I wanted to confirm that your #1 means you did that post migration (since you mentioned “re-upload” I wasn’t sure). It sounds too like this was an entire database migration and Automator views specifically are the only things that failed?

Thanks

– Ryan @ Uncanny Owl

Here’s the full error message:

CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW wp_uap_action_logs_view  AS SELECT a.automator_action_id AS automator_action_id, a.date_time AS action_date, a.completed AS action_completed, a.error_message AS error_message, a.automator_recipe_id AS automator_recipe_id, a.ID AS action_log_id, a.automator_recipe_log_id AS recipe_log_id, r.date_time AS recipe_date_time, r.completed AS recipe_completed, r.run_number AS recipe_run_number, pa.post_title AS action_title, am.meta_value AS action_sentence, p.post_title AS recipe_title, u.ID AS user_id, u.user_email AS user_email, u.display_name AS display_name FROM (((((wp_uap_action_log a left join wp_uap_recipe_log r on(a.automator_recipe_log_id = r.ID)) left join wp_posts p on(p.ID = a.automator_recipe_id)) join wp_posts pa on(pa.ID = a.automator_action_id)) left join wp_uap_action_log_meta am on(a.automator_action_id = am.automator_action_id and am.automator_action_log_id = a.ID and am.user_id = a.user_id and am.meta_key = 'sentence_human_readable_html')) left join wp_users u on(a.user_id = u.ID)) GROUP BY a.IDID;

I have tried creating a view using Query but the error is still the same:
“#1054 - Unknown column 'a.ID`ID' in 'group statement'“