MantisBT - Issues

0003892: implement module panel (allow to save single row filters)

Sat, 04 Feb 2012 19:33:34 +0100

add module panel/selector to Timetracker/Sales that switches between datatypes (timeaccounts/timesheets) with the corresponding Favorites/Trees.

allow to save single row filters / filter save button is not shown if only one filter row is visible in filter toolbar.

0005500: do not allow to uninstall Addressbook in setup js frontend

Sat, 04 Feb 2012 19:29:39 +0100

do not allow to uninstall Addressbook in setup js frontend

0005540: High CPU usage with mysql

Sat, 04 Feb 2012 18:59:18 +0100

MySQL need a lot of CPU time and disk access with Felamimail. Sometimes messages are not shown, got a timeout while checking emails.

Some informations about the installation:

- Two user accounts
- select count(*) from tine20_felamimail_cache_message; => 50199
- select count(*) from tine20_felamimail_cache_message_cc; => 52044
- select count(*) from tine20_felamimail_cache_message_bcc; => 181
- tuning-primer.sh
Current max_heap_table_size = 256 M
Current tmp_table_size = 256 M
Of 898437 temp tables, 49% were created on disk

Informations from mysql-slow.log

# Query_time: 15 Lock_time: 0 Rows_sent: 1000 Rows_examined: 2042
SELECT `felamimail_cache_message`.`messageuid`, `felamimail_cache_message`.`id`, GROUP_CONCAT(DISTINCT `felamimail_cache_message_flag`.`flag`) AS `flags` FROM `tine20_felamimail_cache_message` AS `felamimail_cache_message`
.....

# Query_time: 36 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT COUNT(*) AS `count` FROM (SELECT `felamimail_cache_message`.*, GROUP_CONCAT(DISTINCT `felamimail_cache_message_to`.`email`) AS `to`, GROUP_CONCAT(DISTINCT `felamimail_cache_message_cc`.`email`) AS `cc`, GROUP_CONCAT(DISTINCT `felamimail_cache_message_bcc`.`email`) AS `bcc`, GROUP_CONCAT(DISTINCT `felamimail_cache_message_flag`.`flag`) AS `flags` FROM `tine20_felamimail_cache_message` AS `felamimail_cache_message`
LEFT JOIN `tine20_felamimail_cache_message_to` AS `felamimail_cache_message_to` ON `felamimail_cache_message`.`id` = `felamimail_cache_message_to`.`message_id`
LEFT JOIN `tine20_felamimail_cache_message_cc` AS `felamimail_cache_message_cc` ON `felamimail_cache_message`.`id` = `felamimail_cache_message_cc`.`message_id`
LEFT JOIN `tine20_felamimail_cache_message_bcc` AS `felamimail_cache_message_bcc` ON `felamimail_cache_message`.`id` = `felamimail_cache_message_bcc`.`message_id`
LEFT JOIN `tine20_felamimail_cache_message_flag` AS `felamimail_cache_message_flag` ON `felamimail_cache_message`.`id` = `felamimail_cache_message_flag`.`message_id`
LEFT JOIN `tine20_felamimail_folder` AS `37f78800f47b4901629010bdf7e17a527aaca815folder` ON `37f78800f47b4901629010bdf7e17a527aaca815folder`.`id` = felamimail_cache_message.folder_id WHERE (`felamimail_cache_message`.`folder_id` IN ('5ea0b7a35d10dd12593118ee59a119a43c595472')) AND (`37f78800f47b4901629010bdf7e17a527aaca815folder`.`account_id` IN ('4c67919e2fe91a00036142e07f5ab64d0c006bf4')) AND ((1=1/* empty query */)) GROUP BY `felamimail_cache_message`.`id`) AS `t`;

0005538: Confirmed terms&conditions doesn't saved

Sat, 04 Feb 2012 15:24:39 +0100

On every login to setup menu you've to confirm the terms&conditons again. The systems doesn't save the confirmation.

0005536: Forwarding EMail with Attachment from Felamimail to Tine Account with Android (4.0) ActiveSync Client broken

Sat, 04 Feb 2012 13:52:32 +0100

On Android (4.0.3) you can't open a email with attachment forwarded from Felamimail.
it is possible to open the forwarded .eml file, but then you cant open the attachment.

0005534: Programm Abbruch wegen SQLState

Sat, 04 Feb 2012 13:40:53 +0100

Fast jede Aktion erzeugt den Fehler:

NOTICE (5): Tinebase_Server_Json::_handleException::161 Zend_Db_Statement_Exception -> SQLSTATE[21000]: Cardinality violation: 1241 Operand sollte 1 Spalte(n) enthalten
NOTICE (5): Tinebase_Server_Json::_logExceptionTrace::228 #0 .../library/Zend/Db/Statement.php(284): Zend_Db_Statement_Pdo->_execute(Array)
#1 .../library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
0000002 .../library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#3 .../Tinebase/Backend/Sql/Abstract.php(590): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
0000004 .../Tinebase/Backend/Sql/Abstract.php(424): Tinebase_Backend_Sql_Abstract->_fetch(Object(Zend_Db_Select))
#5 .../Tinebase/Controller/Record/Abstract.php(149): Tinebase_Backend_Sql_Abstract->search(Object(Addressbook_Model_ContactFilter), NULL, true)
#6 .../Tinebase/Model/Filter/Relation.php(107): Tinebase_Controller_Record_Abstract->search(Object(Addressbook_Model_ContactFilter), NULL, false, true)
#7 .../Tinebase/Model/Filter/Relation.php(90): Tinebase_Model_Filter_Relation->_resolveForeignIds()
0000008 .../Tinebase/Backend/Sql/Filter/FilterGroup.php(45): Tinebase_Model_Filter_Relation->appendFilterSql(Object(Tinebase_Backend_Sql_Filter_GroupSelect), Object(Projects_Backend_Project))
#9 .../Tinebase/Backend/Sql/Filter/FilterGroup.php(47): Tinebase_Backend_Sql_Filter_FilterGroup::appendFilters(Object(Tinebase_Backend_Sql_Filter_GroupSelect), Object(Projects_Model_ProjectFilter), Object(Projects_Backend_Project))
0000010 .../Tinebase/Backend/Sql/Filter/FilterGroup.php(47): Tinebase_Backend_Sql_Filter_FilterGroup::appendFilters(Object(Tinebase_Backend_Sql_Filter_GroupSelect), Object(Projects_Model_ProjectFilter), Object(Projects_Backend_Project))
#11 .../Tinebase/Backend/Sql/Abstract.php(454): Tinebase_Backend_Sql_Filter_FilterGroup::appendFilters(Object(Zend_Db_Select), Object(Projects_Model_ProjectFilter), Object(Projects_Backend_Project))
0000012 .../Tinebase/Backend/Sql/Abstract.php(416): Tinebase_Backend_Sql_Abstract->_addFilter(Object(Zend_Db_Select), Object(Projects_Model_ProjectFilter))
#13 .../Tinebase/Controller/Record/Abstract.php(149): Tinebase_Backend_Sql_Abstract->search(Object(Projects_Model_ProjectFilter), Object(Tinebase_Model_Pagination), false)
0000014 .../Tinebase/Frontend/Json/Abstract.php(127): Tinebase_Controller_Record_Abstract->search(Object(Projects_Model_ProjectFilter), Object(Tinebase_Model_Pagination), true)
#15 .../Projects/Frontend/Json.php(56): Tinebase_Frontend_Json_Abstract->_search(Array, Array, Object(Projects_Controller_Project), 'Projects_Model_...', true)
0000016 [internal function]: Projects_Frontend_Json->searchProjects(Array, Array)
#17 .../library/Zend/Server/Abstract.php(232): call_user_func_array(Array, Array)
0000018 .../Zend/Json/Server.php(558): Zend_Server_Abstract->_dispatch(Object(Zend_Server_Method_Definition), Array)
#19 .../Zend/Json/Server.php(197): Zend_Json_Server->_handle()
0000020 .../Tinebase/Server/Json.php(140): Zend_Json_Server->handle(Object(Zend_Json_Server_Request))
#21 .../Tinebase/Server/Json.php(76): Tinebase_Server_Json->_handle(Object(Zend_Json_Server), Object(Zend_Json_Server_Request))
0000022 .../Tinebase/Core.php(235): Tinebase_Server_Json->handle()
#23 .../index.php(57): Tinebase_Core::dispatchRequest()
0000024 {main}

0005492: saving a group with "display in adb" and no container set should be invalid

Sat, 04 Feb 2012 13:07:47 +0100

saving a group with "display in adb" and no container set should be invalid and user should not be allowed to save that!

0005532: ordner baum aktualisiert sich nicht

Sat, 04 Feb 2012 13:00:53 +0100

nach dem löschen von mails bleib die anzahl der ungelesenen
mails gleich, hab gerade 8 neue mails gelöscht aber in der
verzechniss übersicht werden immer noch 8 ungelesene mails
angezeigt.

erst ein manueles "ordnerliste aktualisieren" biegt das wieder
gerade.

0005526: timeout when opening role edit dialog

Fri, 03 Feb 2012 15:08:11 +0100

timeout when opening role edit dialog

-> only happens with deactivated cache

0005530: createNode is called twice after upload

Fri, 03 Feb 2012 14:59:03 +0100

createNode is called twice after upload

0005522: Termine verschieben ; Fehler 'Nicht Gefunden'