Five For A Change Added a discussion

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

Comments

· Genesis

· 2018-11-16T21:10:35+0000
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.
· 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

Login or Join to comment.