Community

  • More
Posts
Polls

I personally think that the version number of apps, should not be isolated to the app store within the studio. I think developers should add or UNA.IO developers add fields to the apps within...

Products by hashtag: Community
Groups
Discussions
·
Added a discussion to , Community

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




  • 282
    • 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

          Not logged in users can't 'Comments Post'.
          ·
          Added a product to , Community

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


          • 17
          ·
          Added a discussion to , Community

          Hi,

          Is there any prediction of an UNA 13 Patch for PHP 8.1?

          • 34
            Not logged in users can't 'Comments Post'.
            ·
            Added a discussion to , Community

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

            **This was due to Msolutions 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.


            image_transcoder.php?o=sys_images_editor&h=6&dpx=1&t=1638615643


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

            image_transcoder.php?o=sys_images_editor&h=7&dpx=1&t=1638615779


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


            image_transcoder.php?o=sys_images_editor&h=8&dpx=1&t=1638615852


            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;


            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⚜️

            • 636
            ·
            Added a discussion to , Community

            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

            • 105
              Not logged in users can't 'Comments Post'.
              Followers
              Empty
              Add new...