Multiple database errors still in UNA 13 B1

B1 Further update: Errors are still there. The Charts ones are gone, but the ones when going to peoples profiles with SEO links on are still there and can be seen below.

I was wrong the errors came back while I was sleeping last night. So the main thing found when using SEO links alone or with SEO link redirects the urls showing, are not the ones that are actually pulling and showing on the website are fine, but the database error is showing the link with a number at end like if you were to create a new profile example with the same name it adds a number to end. This is with all context areas and profile types.

B1 Update: I will watch these like a hawk, not really I will check in morning and see if they return overnight. Other then that no issues so far since update and usually have at least one by the afternoon.

B1 Further update: Errors are still there. The Charts ones are gone, but the ones when going to peoples profiles with SEO links on are still there and can be seen below.

Just wanted to mention some database errors I have been getting with UNA 13 A3, they may be known, this is also after trying to change version back to A2 and re-upgrading. I was being flooded with the,m, but after the re upgrade they slowed down to maybe 6 a day instead of 100 :D. This is also with all modules, especially Msolutions disabled. I disabled them all before re-upgrading to be on safe side. This is just for bug reporting purposes for most part. This is same with two UNA installations being I host someone who is having the same errors, his being freshly installed since UNA 13 A2. Alot of these areas duplicate when you go into events ofcourse and groups. I see you have one on charts and events in Github reports and a good chance the other context areas may be the same thing.

Query:
SELECT COUNT(*) FROM `sys_profiles` AS `p` INNER JOIN `sys_accounts` AS `a` ON (`a`.`id` = `p`.`account_id`) {join_connections} WHERE 1
Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{join_connections} WHERE 1' at line 1
collation_connection:
utf8mb4_unicode_ci

----
Called script:
/page.php

Request parameters:


array (
  'i' => 'persons-profile-friends',
  'id' => '4',
)

Query:
INSERT INTO `bx_charts_most_active_profiles` (`object_id`, `profile_module`, `content_module`, `create_count`) SELECT `sys_profiles`.`content_id`, `sys_profiles`.`type`, 'bx_timeline' , COUNT(`bx_timeline_events`.`id`) FROM `bx_timeline_events` INNER JOIN `sys_profiles` ON `sys_profiles`.`id` = `bx_timeline_events`.`object_owner_id` WHERE sys_profiles.type='bx_organizations' AND `bx_timeline_events`.`added` > 1651107604 GROUP BY `sys_profiles`.`content_id`, `sys_profiles`.`type` ORDER BY COUNT(`bx_timeline_events`.`id`) DESC LIMIT 0,4

Mysql error:
Unknown column 'bx_timeline_events.added' in 'where clause'

collation_connection:
utf8mb4_unicode_ci

---

Called script:
/var/www/vhosts/---/httpdocs/periodic/cron.php

Query:
SELECT COUNT(*) FROM `sys_profiles` AS `p` INNER JOIN `sys_accounts` AS `a` ON (`a`.`id` = `p`.`account_id`) {join_connections} WHERE 1

Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{join_connections} WHERE 1' at line 1

collation_connection:
utf8mb4_unicode_ci

Debug backtrace:

---

Called script:
/page.php

Request parameters:


array (
  'i' => 'organization-profile-friends',
  'id' => '3',
)

Some more since I sent this:

Query:
SELECT COUNT(*) FROM `sys_profiles` AS `p` INNER JOIN `sys_accounts` AS `a` ON (`a`.`id` = `p`.`account_id`) {join_connections} WHERE 1

Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{join_connections} WHERE 1' at line 1

collation_connection:
utf8mb4_unicode_ci

---
Called script:
/page.php

Request parameters:


array (
  'i' => 'persons-profile-friends',
  'id' => '3',
)

Query:
SELECT COUNT(*) FROM `sys_profiles` AS `p` INNER JOIN `sys_accounts` AS `a` ON (`a`.`id` = `p`.`account_id`) {join_connections} WHERE 1

Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{join_connections} WHERE 1' at line 1

collation_connection:
utf8mb4_unicode_ci

---
Called script:
/page.php

Request parameters:


array (
  'i' => 'organization-profile-fans',
  'id' => '1',
)

Query:
SELECT COUNT(*) FROM `sys_profiles` AS `p` INNER JOIN `sys_accounts` AS `a` ON (`a`.`id` = `p`.`account_id`) {join_connections} WHERE 1

Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{join_connections} WHERE 1' at line 1

collation_connection:
utf8mb4_unicode_ci

---

Called script:
/page.php

Request parameters:


array (
  'i' => 'organization-profile-friends',
  'id' => '1',
)