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