error in BxDolDb.php

hi

i get this erorr when i try to log in to the site in member.php page.

it is start after i upload the old DB to the new D7.0.2 from D7.0.1

Warning: Invalid argument supplied for foreach() in /home/******/public_html/d87/inc/classes/BxDolDb.php on line 388

Did you ever figure out this problem?  I am getting the same error

What block on member page is not working ?

Same Exact Problem! I need help before she starts calling me asking me why her site is down again.  I love the Dolphin engine, but every upgrade/update is getting scarier.  Please help.

I used "Softaculous" in my cPanel to do the upgrade, and now when I go to my client's page:

http://puffinspresentations.com/gathering7/

I get the error:

Warning: Invalid argument supplied for foreach() in /home/*******/gathering7/inc/classes/BxDolDb.php on line 388

Hello you'll need set full debug for db errors in inc/classes/BxDolDb.php. We need full db error!

function genMySQLErr( $out, $query ='' )
{
global $site;

$aBackTrace = debug_backtrace();
unset( $aBackTrace[0] );

if( $query )
{
//try help to find error

$aFoundError = array();

foreach( $aBackTrace as $aCall )
{
foreach( $aCall['args'] as $argNum => $argVal )                     <<<<<<<<<<<<<<<<<<<<< line 388
{
if( is_string($argVal) and strcmp( $argVal, $query ) == 0 )
{
$aFoundError['file']     = $aCall['file'];
$aFoundError['line']     = $aCall['line'];
$aFoundError['function'] = $aCall['function'];
$aFoundError['arg']      = $argNum;
}
}
}

Useless i know.  So you will have to post the real database error you get in your email with the subject line <sitename>  database error or something like that.

Also to set to full debug mode look for this line around line number 28:

define( 'DB_FULL_DEBUG_MODE', false );  and change false to true.

make sure to set this back to false after your done with it.

no no, I need full db error description !

yes i know   i am not the one with the error  i was just showing the people what line 388 was to not even bother to go looking at it.

In the DATABASE ERROR emails, this is the first few lines.

I've posted the entire error report here if anyone can help, I'd appreciate it.

http://puffinspresentations.com/error/error.txt

Database error in

Query:

SELECT

`te`.`id` AS `id`,

`te`.`caption` AS `caption`,

`te`.`content` AS `content`,

`te`.`when` AS `when_uts`,

DATE_FORMAT(FROM_UNIXTIME(`te`.`when`), '%Y-%m-%d %H:%i:%S') AS `when`,

DATE_FORMAT(FROM_UNIXTIME(`te`.`when`), '%m.%d.%Y') AS `when_uf`,

`te`.`uri` AS `uri`,

`te`.`tags` AS `tags`,

`te`.`categories` AS `categories`,

`te`.`comment` AS `comment`,

`te`.`vote` AS `vote`,

`te`.`date` AS `date`,

`te`.`status` AS `status`,

`te`.`featured` AS `featured`,

`te`.`cmts_count` AS `cmts_count`

FROM `bx_arl_entries` AS `te`

WHERE 1  AND `te`.`status`='0' AND `te`.`featured`='1'

ORDER BY `te`.`when` DESC LIMIT 0, 10

Mysql error: Unknown column 'te.when' in 'field list'

Found error in the file '/home/****/public_html/gathering7/modules/boonex/articles/classes/BxArlDb.php' at line 159.

Called 'getAll' function with erroneous argument #0.

@dmick which version of dolphin do you use? It says that column "when" is missing from the table "bx_arl_entries" that is used for article entries.

@Sneha  I was running 7.0.1 successfully.  The error started after I used Softaculous to handle the upgrade from 7.0.1 to 7.0.2

this column is not added during migration then....

you can add it by going to phpmyadmin through your site's cpanel. and run below query

ALTER TABLE `bx_arl_entries` ADD COLUMN `when` int(11) NOT NULL default '0'

Maybe you can help me?
I fully matched situation. I tried to introduce PhpMyAdmin Cpanel through my site you recommended line ALTER TABLE `bx_arl_entries` ADD COLUMN `when` int (11) NOT NULL default 0

But the problem persists, the site has not earned. http://niido.ru/
Help me please!