Error when clicking "Recent activities ... "

[andy.hoyle]

Clicked on
Recent activities on workspace 'My Workspace'

and got error:

Error (DBQueryError)
Query failed with message 'Unknown column 'Array' in 'where clause''

Error params:

File:    /my/path/to/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php

Line:    386

Sql:    SELECT * FROM `og_application_logs` WHERE `is_private` <= '1' AND `is_silent` <= '1' AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ApplicationLogs' AND `workspace_id` IN (Array)) ORDER BY `created_on` DESC LIMIT 0, 50

Error number:    1054

Error message:    Unknown column 'Array' in 'where clause'

Backtrace:
#0 /my/path/to/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /my/path/to/opengoo/environment/library/database/DB.class.php(209): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /my/path/to/opengoo/environment/classes/dataaccess/DataManager.class.php(242): DB::executeAll('SELECT * FROM `...')
#3 /my/path/to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(114): DataManager->find(Array)
#4 /my/path/to/opengoo/environment/classes/dataaccess/DataManager.class.php(270): BaseApplicationLogs->find(Array)
#5 /my/path/to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(131): DataManager->findAll(Array)
#6 /my/path/to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(133): BaseApplicationLogs->findAll(Array)
#7 /my/path/to/opengoo/application/models/application_logs/ApplicationLogs.class.php(213): BaseApplicationLogs::findAll(Array)
#8 /my/path/to/opengoo/application/controllers/FeedController.class.php(92): ApplicationLogs::getOverallLogs(true, true, Array, 50)
#9 /my/path/to/opengoo/environment/classes/controller/Controller.class.php(76): FeedController->project_activities()
#10 /my/path/to/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('project_activit...')
#11 /my/path/to/opengoo/environment/classes/Env.class.php(173): PageController->execute('project_activit...')
#12 /my/path/to/opengoo/init.php(149): Env::executeAction('feed', 'project_activit...')
#13 /my/path/to/opengoo/index.php(9): require('/var/home/openg...')
#14 {main}

Autoglobal varibles:

$_GET:    Array (
  ['c'] => (string) 'feed'
  ['a'] => (string) 'project_activities'
  ['id'] => (string) '1'
  ['token'] => (string) 'c49649dccdb7e1379abe2b4f4e9e35d60ca22821'
  ['project'] => (string) '2'
)

$_POST:    

$_COOKIE:    Array (
  ['__utma'] => (string) '166054271.539558655037944960.1242903145.1248682865.1248697052.7'
  ['__utmz'] => (string) '166054271.1242903145.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)'
  ['PHPSESSID'] => (string) 'f26a35285a92cce365aff925a5bb7776'
  ['id'] => (string) '1'
  ['token'] => (string) 'c49649dccdb7e1379abe2b4f4e9e35d60ca22821'
)

$_SESSION:    
Execution time:
Total execution time: 0.11999702453613 seconds

[ignacio]

Hi Andy,

You have to add this line between lines 25 and 26 of file 'application/models/application_logs/ApplicationLogs.class.php':

Code: [Select]

if (is_array($ids)) $ids = implode(",", $ids);
Thanks.