Five For A Change

  • 1136
A Not-For-Profit looking to help change the world.
Members
Empty
Profile Feed
Five For A Change
added a discussion

I have no idea why all the sudden this is happening?

Database error in Five For A Change

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='7§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Database error in Five For A Change

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='6§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='1§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='8§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='5§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='4§ion[]=bx_snipcart' LIMIT 0, 4

Mysql error:
Unknown column 'bx_snipcart_entries.cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='12§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_events_data`.`event_cat` ='3§ion[]=bx_events' LIMIT 0, 4

Mysql error:
Unknown column 'bx_events_data.event_cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='6§ion[]=bx_snipcart' LIMIT 0, 4

Mysql error:
Unknown column 'bx_snipcart_entries.cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Next one:

Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='6§ion[]=bx_snipcart' LIMIT 0, 4

Mysql error:
Unknown column 'bx_snipcart_entries.cat' in 'where clause'

Location:
The error was found in getAll function in the file /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Debug Backtrace:

Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolDb.php
            [line] => 1080
            [function] => execute
            [class] => PDOStatement
            [type] => ->
            [args] => Array
                (
                    [0] =>
                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolDb.php
            [line] => 1068
            [function] => executeStatementException
            [class] => BxDolDb
            [type] => ->
            [args] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_persons_data`  ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='6§ion[]=bx_snipcart' LIMIT 0, 4
                        )

                    [1] => Array
                        (
                        )

                    [2] =>
                )

        )

    [2] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolDb.php
            [line] => 486
            [function] => executeStatement
            [class] => BxDolDb
            [type] => ->
            [args] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_persons_data`  ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='6§ion[]=bx_snipcart' LIMIT 0, 4
                        )

                    [1] => Array
                        (
                        )

                    [2] =>
                )

        )

    [3] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolDb.php
            [line] => 364
            [function] => res
            [class] => BxDolDb
            [type] => ->
            [args] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_persons_data`  ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='6§ion[]=bx_snipcart' LIMIT 0, 4
                        )

                    [1] => Array
                        (
                        )

                )

        )

    [4] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php
            [line] => 764
            [function] => getAll
            [class] => BxDolDb
            [type] => ->
            [args] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_persons_data`  ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' AND `bx_snipcart_entries`.`cat` ='6§ion[]=bx_snipcart' LIMIT 0, 4
                        )

                )

        )

    [5] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php
            [line] => 748
            [function] => getNum
            [class] => BxDolSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [6] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php
            [line] => 582
            [function] => setConditionParams
            [class] => BxDolSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [7] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/template/scripts/BxBaseSearchResult.php
            [line] => 52
            [function] => getSearchData
            [class] => BxDolSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [8] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/modules/base/general/classes/BxBaseModGeneralSearchResult.php
            [line] => 117
            [function] => displayResultBlock
            [class] => BxBaseSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [9] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/modules/base/profile/classes/BxBaseModProfileSearchResult.php
            [line] => 169
            [function] => displayResultBlock
            [class] => BxBaseModGeneralSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [10] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php
            [line] => 430
            [function] => displayResultBlock
            [class] => BxBaseModProfileSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [11] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/inc/classes/BxDolSearch.php
            [line] => 112
            [function] => processing
            [class] => BxDolSearchResult
            [type] => ->
            [args] => Array
                (
                )

        )

    [12] => Array
        (
            [file] => /var/www/vhosts/fiveforchange.org/httpdocs/searchKeyword.php
            [line] => 31
            [function] => response
            [class] => BxDolSearch
            [type] => ->
            [args] => Array
                (
                )

Five For A Change
added a discussion

So I have 2 sites now running UNA and both sites, since the last updates are experiencing issues.

(I've done everything to make sure that it's not on my end including cleaning cache on the server and computer and updating all the apps in the app market.)

Site One: fiveforchange . org

  • Some of the site is running fine and then other parts are loading Super, Super slow.
    • I've done all the upgrades/delete cache (on server and personal computer)
    • The main problem page seems to be Groups. Either going to or coming from takes forever to do.
  • Albums also takes forever to load the pictures.
  • Anything with a group of pictures takes a very very long time to load.

Site Two: contributors . local360places . com

  • The whole site is now blank after the auto update.
    • I can't get into any of it now, not even studio or the login page.

Apparently auto update is on this one and every time it auto updates I have issues...

So, I'm need help getting these back up and running as both are being promoted more now and I need people to be able to use them!

Five For A Change
added a discussion

Well, the update is now making it to where I can see my front page, my login page and then after login, just a blank page. This is happening on both my sites now after the update.

These are the error logs and a screenshot of the blank page that I get on both my sites.

fiveforchange . org

and 

contributors.local360places . com 

Five For A Change
added a discussion

So I just got a charge for $100 for a module I had bought a while back.

The problem I have with this, is that I never got a notice about the charge coming...so it also put me in the hole, as I don't keep a lot of money in it. Then my bank charged me another $30 on top of that...

So it would be nice to get a heads up email about a charge that's coming...so I can prepare for it and I don't have to end up paying for it twice...

Five For A Change
added a discussion

So my Polls Module has been broken for awhile now and nobody seems to know why...

So since it's still broke, it also now breaks the new Create Post Box...

Clicking on "Update" also breaks the box...

See attached Video...

Five For A Change
added a discussion

I bought Froala, so that I could have a better writing experience for my users.

$50 bucks

Then this last update breaks the icons in Froala and now I have to buy Font Awesome Pro to fix it?

That's some BS if that's the case...

Also, you guys didn't fix the whole "when I use the image as a "cover image" it disappears as an attachment" either...

Five For A Change
added a discussion

So I updated and now I have icons that are missing in Decorous...see attachments...since I still can't post links 😠 

Please advise...I do like this layout look (what is it?) but still hate the horizontal menus...

Also, thank you for finally changing the upload section!

Five For A Change
added a discussion

I would share the link here but can't...

I can't even put a picture here now? Seriously guys...this does us no good if we can't even put a picture in the discussion...

Anyways, if I put the link in, which I can't post here, it comes up with this...aka multiple links for one link...

Five For A Change
added a discussion

Since we can't put links/pictures in our posts here now...

I created a video to show you what happens.

  • If you add an attachment
    • Then select it as a cover pic
    • Then hit save
      • Attachment Disappears
  • If you then deselect it as a cover pic
    • Hit save
    • It reappears as an attachment

See attached Video

... or jump to: 2018, 2017
My Discussions
Hi everyone!AlexT "catch" this trouble and fix it. See details here https://github.com/unaio/una/iss…
by LeonidS
5
for the minimal cloud4 server we use 4 GB RAM, 2 CPU, 80 GB SSD and it works very well including roc…
by Alex T⚜️
12
Excellent! You're welcome :)
by Chris
7
So I just got a charge for $100 for a module I had bought a while back.The problem I have with this,…
by Five For A Change
1
Thank you for the report:https://github.com/unaio/una/issues/1477
by Alex T⚜️
13
Yes, I had put it two places...
by Five For A Change
3
Info
Organization Name:
Five For A Change
Category:
Membership

Premium