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

Please DM me to get customization for your UNA websites and apps at the best price.

***Last update fixed the editor and time format issue for me.

**This was due to Msolutions #Emotions module. Just a heads up if anyone runs into same issues. 4 hours of rolling back and then I rolled forward and the minute I disabled that module everything went back to normal. I let them know, I am sure they will get it figured out and fixed :)** Will update once it is.

Thankfully I backup server up to two weeks at all times so am rolling back to 12 and re-updating. I will let everyone know the result.

UNA 13 A2 No editor on editing profiles, adding content, but does show for the main timeline from the homepage. I have changed between quill and Froala to make sure I am not losing my mind and different browsers and private windows. Editor is not showing like it is on here, it done show in the main post to context that shows with the add new.. and when adding content from the post to context, but not from profile timelines, not from the adding of content from their actual creation page, and not when editing profiles and content. I keep checking if I edited or changed something, but I have been so busy with work nothing has changed really. I thought it was there after the upgrade, but may have not been and just now noticing. Has anyone else ran into this? Also can not use the emoji button on the timeline feed post neither, but all other buttons work in respect to that timeline I have on the homepage. I tried change themes, etc, but no resolve. All worked fine when I did the first alpha build, only issue I notice at that time was the developer issue, but that was fixed in A2. I have checked for java errors anything I could think of and not getting anything that is leading me to a fix sadly. Anything I need to be checking in developer where I have not checked already? All UNA modules are on 13 by the way, I did them all after the upgrade in regards to fixing the 500 error after the upgrade.

From the Site Home Page (Add content form here shows editor, just not the content areas themselves when adding or editing, and Emoji button not working.

On Profiles the editor does not show and the buttons do not work:

Editor gone when editing Profile and also gone if you go to an actual add to context window instead of the main feed.

While looking into this issue I am noticing others, would be my luck :/ Looks like buttons on members sections in areas like organizations are not working. You click accept/set role and they do not work. I am using NGINX, did anything change that would require config changes. Please see my following config:

location / {

index index.html index.htm index.php;

rewrite "^/page/(.*)$" /page.php?i=$1 last;

rewrite "^/m/(.*)$" /modules/index.php?r=$1 last;

rewrite "^/s/([a-zA-Z0-9_]+)/([a-zA-Z0-9\.]+)" /storage.php?o=$1&f=$2 last;

if (!-e $request_filename ) {

rewrite ^/(.+)$ /r.php?_q=$1 last;

break;

}

}

# Cache Static Files

location ~* ^(/cache_public/|/plugins_public/|/modules/|/studio/|/template/).+\.(jpg|jpeg|gif|css|png|js|ico|svg|eot|ttf|woff|woff2|)$ {

expires 365d;

}

# PROXY SETTINGS

proxy_buffering on;

proxy_buffer_size 128k;

proxy_buffers 4 256k;

proxy_busy_buffers_size 256k;

# FASTCGI

fastcgi_buffers 16 16k;

fastcgi_buffer_size 32k;

#headers sesion time

proxy_connect_timeout 900;

proxy_send_timeout 900;

fastcgi_send_timeout 900;

fastcgi_read_timeout 900;

# GZIP COMPRESSION

gzip on;

gzip_proxied any;

gzip_types text/plain text/xml text/css application/x-javascript;

gzip_vary on;

gzip_disable “MSIE [1-6]\.(?!.*SV1)”;

brotli off;

I turned brotli off for now and went back to Gzip, because with PLESK could not tell if it was working or not a while ago. Artificer also has a lot of bugs on my end when I was trying it.

@Leonid S @Alex T⚜️

Can someone give me a general guidance on how to migrate the data that is on the DB of an existing UNA site (A3 updated from an older A2 version) to a new fresh UNA 13-A3 that has no data? (both UNA sites are very close in terms of modules available and settings). tnx