@Mark Or who ever can help….how are you? Two things.. 1) I had google ads on my site before my update 12.0.0. I just started get paid for ads. It wasn’t much but it just started going. Now I can get approve from google, I have tried over 3 or five time to only say the same things, which they are not say directly the issue. Could you help me with this? 2) what happen to paid to join the website? I need to monetize my site. Now it says this (We couldn’t find the code on your site. This is because the code is either missing or incomplete, or because the URL of your site is incorrect. Learn more.)
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',
)
Hi,
Is there any prediction of an UNA 13 Patch for PHP 8.1?
-
Hello @Carlos Kolinski !
It's better to test before because it's possible some glitches like this one https://github.com/unaio/una/issues/3828
***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.
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.