Website error after update 7.02

I updated to 7.02 and I am getting this error:


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

Error
Database query error

I did everything the last step said (clear cache, permissions etc).

Line 373 - 398, bold part is line 388:

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 )
{
if( is_string($argVal) and strcmp( $argVal, $query ) == 0 )
{
$aFoundError['file']     = $aCall['file'];
$aFoundError['line']     = $aCall['line'];
$aFoundError['function'] = $aCall['function'];
$aFoundError['arg']      = $argNum;
}
}
}

Thanks,

Ruud

Quote · 21 Jul 2010

Btw.

I had 7.01 before I updated so that was correct too.

Then after the update I tried the website again and everything was fine, but after I refreshed it (a sec or 2 later) it gave me this error.

I cleared the cache multiple times.

What shall I do?

Reinstall the update? / website?

Quote · 22 Jul 2010

Firstly show that error :)

just because watching at your screenshot nobody will understand error itself.

inc\classes\BxDolDb.php

change

define( 'DB_FULL_DEBUG_MODE', false );

to

define( 'DB_FULL_DEBUG_MODE', true );

and try to repeat this error.

you will got some defined SQL error.

Quote · 22 Jul 2010

Yes Andrew right we need more details regards your sql error

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 22 Jul 2010

Sorry forgot about that:

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

Error
Database query error
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`), '%d.%m.%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_news_entries` AS `te` WHERE 1 AND `te`.`status`='0' 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/modules/boonex/news/classes/BxNewsDb.php' at line 159.
Called 'getAll' function with erroneous argument #0.

Debug backtrace:
(and then it shows big part of the website + majority of the code from BxNewsDb.php I think)
Quote · 22 Jul 2010

According to your post, I would check the bx_news_entries table via PhpMyAdmin and see if there is a column called 'When'

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

Nothing to see here
Quote · 22 Jul 2010

No, there there is no column called "When" nor is there a column "te.when"

Edit:

I'm trying to find the mysql from the update and see if I can manually update my older sql tables.

They might have not updated correctly..

I will let you know how it goes,

Thanks for the help so far.

Quote · 22 Jul 2010

One more question, than I think i fixed the problem..

If a module is not installed (lets say "articles") does it have a sql table installed, or will it install its tables when you install the module?

Also do you know where the "bx_fdb_" tables are connected to? which module? (is this articles?)

Thank

Edit:

I think I will just reinstall the module, my sql tables are somehow quite messed up.

Lets hope this will solve the problems.

Quote · 22 Jul 2010

No. When a module is removed, it is suppose to remove it's tables and any fields it added to existing tables. When installed it puts the tables in.

bx_fdb_ is the feedback module i believe.

Also. do you have any third party modules installed? Some modules, esp those that add fields to existing dolphin tables can cause problems when upgrading dolphin if the upgrade requires changes to a table that was altered by a 3'rd party module.

https://www.deanbassett.com
Quote · 22 Jul 2010

The tables are created when the module is installed. So if you link there may be an issue regarding table to the "News" or "Articles", then reinstalling the module should resolve it.

Just a shot in the dark, I think the bx_fdb tables may be tied to the 'Feedback' module.

Nothing to see here
Quote · 22 Jul 2010

Thanks guys!

I think everything works fine now, but I think I will reinstall the website after 7.03 is released, just to make sure that everything is fine.

I back-uped all the tables, so I don't think I will loos any data (hopefully).

Anyway, thanks again.

Ruud

Quote · 22 Jul 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.