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
|
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?
|
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.
|
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 |
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)
|
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 |
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.
|
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.
|
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 |
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 |
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
|