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_ciNext 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_ciNext 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_ciNext 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_ciDebug 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 ( )
I am getting errors with the video module. This is the third thread that I have seen regarding similar errors and for me it all seems to be with BxDolSearch.php.
Here are the other threads:
una(dot)io/page/view-discussion?id=1733
una(dot)io/page/view-discussion?id=1510
BTW: fiveforchang(dot)org is a good concept and I hope it works out for you.
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
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...
Hi everyone!
AlexT "catch" this trouble and fix it. See details here https://github.com/unaio/una/issues/1804