upgrading problem

[farina]

Hi, I upgraded to the latest version 2.7.8
Everything is working fine but in control panel when I try to see categories an error comes out:
"Warning: Invalid argument supplied for foreach() in /web/htdocs/www.YOURSITE.COM/home/administrator/com ... lerycs.php on line 126"

this is the line involved:
"foreach ($data as $key) {
$show_text = $text . $key->title;"

should I correct anything in the database tables?

thanks in advance

[Jan]

Hi, you should enable debug mode to see what is wrong in the database.

https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan

[farina]

could this help?

500 - •Si è verificato un errore.•

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_c SQL=SELECT a.*, cc.title AS parentname, u.name AS editor, g.name AS groupname, v.average AS ratingavg, ua.username AS usercatname, c.countid AS countid FROM jos_phocagallery_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.parent_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS c GROUP BY c.parent_id ) AS c ON a.parent_id = c.parent_id ORDER BY a.ordering

[Jan]

Hi, try to update your database, mostly the mysql 4 databases with some specific settings have problems with composite queries, try to search this forum, there are some guides for this.

Jan

[farina]

thanks, but actually mysql is already version 4.0.30-standard-log... maybe I could post the table structure?

[Jan]

Hi, I think you need to upgrade e.g. to 5

Jan

[farina]

SOLVED. I upgraded my DB and now it works. Thanks

[Jan]

OK