Feng Forum

Support => Older versions => : Pet August 05, 2009, 05:31:03 PM

: Can't Upload again (1.5.1)
: Pet August 05, 2009, 05:31:03 PM
Not sure if it is related to this (http://forums.opengoo.org/index.php?topic=2314.0), but when I try to upload a file (I'm administrator), just as soon as I click on the Upload menu item this appears:

We are sorry, but OpenGoo is not currently able to execute your request. An Error Report has been sent to the administrator.

Query failed with message 'Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=''

Error params:
File:    D:\Domains\mydomain.com\wwwroot\clients\environment\library\database\adapters\AbstractDBAdapter.class.php
Line:    386
Sql:    SELECT DISTINCT `t`.`tag` AS `name`, count(`t`.`tag`) AS `count` FROM `og_tags` `t`, (SELECT 'ProjectMessages' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_messages` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectMessages' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMessages' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMessages' AND `xx_pu`.can_read_messages = true ) ) ) ) UNION SELECT 'ProjectEvents' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_events` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectEvents' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectEvents' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectEvents' AND `xx_pu`.can_read_events = true ) ) ) ) UNION SELECT 'ProjectFiles' AS `object_manager_value`, `id` as `oid`, `updated_on` AS `order_value` FROM `og_project_files` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectFiles' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectFiles' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectFiles' AND `xx_pu`.can_read_files = true ) ) ) ) UNION SELECT 'ProjectTasks' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_tasks` `co` WHERE `is_template` = false AND `completed_by_id` = 0 AND `trashed_by_id` = 0 AND `is_template` = false AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectTasks' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectTasks' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectTasks' AND `xx_pu`.can_read_tasks = true ) ) ) ) UNION SELECT 'ProjectMilestones' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_milestones` `co` WHERE `trashed_by_id` = 0 AND `is_template` = false AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectMilestones' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMilestones' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMilestones' AND `xx_pu`.can_read_milestones = true ) ) ) ) UNION SELECT 'ProjectWebPages' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_webpages` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectWebpages' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectWebpages' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectWebpages' AND `xx_pu`.can_read_weblinks = true ) ) ) ) UNION SELECT 'MailContents' AS `object_manager_value`, `id` AS `oid`, `sent_date` AS `order_value` FROM `og_mail_contents` `co` WHERE `trashed_by_id` = 0 AND `is_deleted` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'MailContents' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( ( ( `created_by_id` = 1) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 1 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'MailContents' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (1,10000000) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'MailContents' AND `xx_pu`.can_read_mails = true ) ) ) ) OR (`trashed_by_id` = 0 AND `is_deleted` = 0 AND `account_id` IN (1) ) UNION SELECT 'Companies' AS `object_manager_value`, `id` as `oid`, `updated_on` AS `order_value` FROM `og_companies` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'Companies' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND ( true) UNION SELECT 'Contacts' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_contacts` `co` WHERE `trashed_by_id` = 0 AND ( true)) `o` WHERE `t`.`rel_object_manager` = `o`.`object_manager_value` AND `t`.`rel_object_id` = `o`.`oid` GROUP BY `t`.`tag` ORDER BY `count` DESC, `t`.`tag`
Error number:    1267
Error message:    Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Backtrace:
#0 D:\Domains\mydomain.com\wwwroot\clients\environment\library\database\adapters\AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT DISTINCT...', NULL)
#1 D:\Domains\mydomain.com\wwwroot\clients\environment\library\database\DB.class.php(209): AbstractDBAdapter->executeAll('SELECT DISTINCT...', NULL)
#2 D:\Domains\mydomain.com\wwwroot\clients\application\models\tags\Tags.class.php(72): DB::executeAll('SELECT DISTINCT...')
#3 D:\Domains\mydomain.com\wwwroot\clients\application\controllers\FilesController.class.php(327): Tags->getTagNames()
#4 D:\Domains\mydomain.com\wwwroot\clients\environment\classes\controller\Controller.class.php(76): FilesController->add_file()
#5 D:\Domains\mydomain.com\wwwroot\clients\environment\classes\controller\PageController.class.php(62): Controller->execute('add_file')
#6 D:\Domains\mydomain.com\wwwroot\clients\environment\classes\Env.class.php(133): PageController->execute('add_file')
#7 D:\Domains\mydomain.com\wwwroot\clients\init.php(149): Env::executeAction('files', 'add_file')
#8 D:\Domains\mydomain.com\wwwroot\clients\index.php(9): require('D:\Domains\mydo...')
#9 {main}
Autoglobal varibles:
$_GET:    Array (
  ['active_project'] => (string) '5'
  ['ajax'] => (string) 'true'
  ['c'] => (string) 'files'
  ['a'] => (string) 'add_file'
  ['current'] => (string) 'documents-panel'
  ['_dc'] => (string) '1921024950315'
)
$_POST:    
$_COOKIE:    Array (
  ['id'] => (string) '1'
  ['token'] => (string) '8b94abba4fe6d32a4cacec6d5075e6b669aa7e40'
  ['remember'] => (string) '1'
  ['PHPSESSID'] => (string) 'hvb586bjvjp72fnfk237blh0p0'
)
$_SESSION:    
: Re: Can't Upload again (1.5.1)
: werner.wuerfel August 05, 2009, 05:53:47 PM
It is related to this: http://forums.opengoo.org/index.php?topic=2378.0

By upload a file we got the same error
: Re: Can't Upload again (1.5.1)
: Pet August 05, 2009, 05:55:12 PM
ah yes, thanks werner