• 437
  • More

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',
)




Replies (8)
    • Hello @Kyle !


      Have you upgraded all installed modules there? What is the status of those errors now? In what pages did you meet smth similar?

      •  Still dealing with the same errors and yes all modules have been upgraded. I feel they are coming up when people are going to pages or crawlers are going to pages. It is all the same as above just sometimes it may be a different group or profile links someone is loading. I can go around whole site clicking without any database errors. Every day though same time in morning and around same time at night these errors occur. Very strange, one thing I did do though is I enabled SEO links, so wondering if it is related to that. Part of me though thinks it is all related to charts. I have been doing different troubleshooting to see. I have been to busy with real work to get around disabling seo links again and testing. All the errors though, sometimes there will be specific profiles or group url's but same database errors. Quick update: Checked for heck of it quick and seen errors when someone was just looking at a profile. All errors are either charts or fans/friends of personal/organization profiles, groups, and probably the other context areas as well if I tested them.

        • UPDATE: the trouble with Unknown column 'bx_timeline_events.added' in 'where clause'
          

          has been fixed here https://github.com/unaio/una/issues/3788

          • The charts/event one seems to have gone away yes, just have been to busy to remove it from the rest :D I did put in red at top though that the charts one was fixed.

            • Hello @Kyle !

              Plz check if all tables in your UNA DB have one (utf8mb4_unicode_ci) encoding?

              • We already talked about this prior :D Yes everything is utf8mb4_unicode_ci. I told you the day I reimported my database dump, which I did on my own intuition being here before. Had the same issue after. You also have full access to my stuff with my credentials I emailed and messaged to you. Your Support email says to wait on B2 so we will wait for B2 and see if it fixes.

                • Well, your UNA database has 6 tables with another encoding. So it's better to fix it too ti be sure.

                  • The ones on utf8_general_ci, I can try to change them and see. When I searched the dump initially they did not show up. I changed those 6. **update: this did not do anything to fix issue. Same database errors overnight.

                    Not logged in users can't 'Comments Post'.
                    Kyle
                    •  ·  Premium
                    • 3 members
                    • J

                      19 followers
                    • 2299 views
                    • 2 votes
                    • More
                    I am horrible at updating this stuff 😜 My name is Kyle. I am originally from NY and now in Texas in the U.S. I have a passion for web development and …
                    5
                    4