Five For A Change

A Not-For-Profit looking to help change the world.

Members

Empty

Friends

Mark Purser

Baloo

LeonidS

Will Monte

UNA Inc

Alex T⚜️

Add new...

Five For A Change

·

Added a discussion

Getting a ton of database errors with RC12

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
(
)

See older replies...
· Alex T⚜️

· 2018-11-19T08:54:43+0000
Five For A Change Could you please provide access to your site to investigate this problem (Studio, FTP/SSH, phpMyAdmin) ?
Also we need to know how to reproduce the problem
· Five For A Change

· In reply to

Alex T⚜️

· 2018-11-19T15:32:55+0000
Alex are you wanting access? You already have access to the site. fiveforchange . org - I can give you ftp access also but I'm not sure how to give it for SSH and phpMyAdmin unless I add you as a admin on the server...
· LeonidS

· 2018-11-20T11:45:29+0000
Hi everyone!
AlexT "catch" this trouble and fix it. See details here https://github.com/unaio/una/issues/1804

Not logged in users can't 'Comments Post'.

Five For A Change

·

Added a discussion

Multiple sites having issues now

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!

See older replies...
· Alex T⚜️

· 2018-10-31T10:58:35+0000
Which part would I have to change on the server to allow for the resizing?
It's better to check server logs before changing anything, it's better to ask hosting support about this.
· Five For A Change

· In reply to

Alex T⚜️

· 2018-10-31T14:28:59+0000
I am basically hosting support...the servers I have are run by me...the people I rent the servers from really don't help much. I used to use Zarconia which had awesome support but the servers I use now are basically just servers. They just offer the service and not much support unless it's hardware related.
I just need to know what settings I need in order to make UNA run on my servers.
· Alex T⚜️

· 2018-11-02T08:56:49+0000
for the minimal cloud4 server we use 4 GB RAM, 2 CPU, 80 GB SSD and it works very well including rocket.chat and jot servers

Not logged in users can't 'Comments Post'.

Five For A Change

·

Added a discussion

Site now blank after Login on RC10 update

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

See older replies...
· Five For A Change

· 2018-09-26T16:10:02+0000
Well, that did work. Thanks!
· Five For A Change

· 2018-09-26T16:15:58+0000
Ok, thanks Chris as I was able to go in and update everything after that and now it works.
· Chris

· 2018-09-26T16:16:59+0000
Excellent! You're welcome :)

Not logged in users can't 'Comments Post'.

Five For A Change

·

Added a discussion

Notices of Invoice for Module Payments

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

Polls Module Inop and Breaks Create Post Box

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...

See older replies...
· Baloo

· In reply to

LeonidS

· 2018-07-25T20:49:39+0000
Ok Leonid, okay, because I put "update" in first position, but originally he is on "discussion", I modified, now try again

I did not speak poll, it is "Update" that poses the problem. Once you click on "Update", it's over, you do not know anything open, poll or other.
· Baloo

· In reply to

Alex T⚜️

· 2018-07-25T20:52:46+0000
ReferenceError: BxTimelinePost is not defined
· Alex T⚜️

· In reply to

Baloo

· 2018-07-25T23:56:09+0000
Thank you for the report:
https://github.com/unaio/una/issues/1477

Not logged in users can't 'Comments Post'.

Five For A Change Discussions

	Getting a ton of database errors with RC12 Five For A Change 2018-11-16T17:10:21+0000 Replies (4)
	Multiple sites having issues now Five For A Change 2018-10-29T20:22:59+0000 Replies (11)
	Site now blank after Login on RC10 update Five For A Change 2018-09-26T05:37:35+0000 Replies (6)
	Notices of Invoice for Module Payments Five For A Change 2018-08-02T20:15:12+0000
	Polls Module Inop and Breaks Create Post Box Five For A Change 2018-07-21T04:45:07+0000 Replies (12)
	Font Awesome Pro - Only fix to Froala and it costs… Five For A Change 2018-07-20T13:13:23+0000 Replies (2)

Achievements

Apprentice

Total points: 1

100.1 point(s) to reach

Info

Organization Name:

Five For A Change

Category:

Friends count:

Followers count:

Membership

Premium