View Issue Details

IDProjectCategoryView StatusLast Update
0013532Tine 2.0Addressbookpublic2017-12-07 17:40
ReporterpunitAssigned Topschuele 
Status closedResolutionno change required 
Product Version2017.08.6 Community Edition 
Target Version2017.08.10 Community EditionFixed in Version2017.08.10 Community Edition 
Summary0013532: Abnormal End error while adding contact on server

We tested Tine 2017.08.6 Community Edition in various servers and in one of our server while adding contact after filling up details it throws Abnormal end error :

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'soft_tine939.tin6n_path' doesn't exist, query was: SELECT `path`.* FROM `tin6n_path` AS `path` WHERE ((MATCH (`path`.`shadow_path`) AGAINST ('+Addressbook_Model_Contact*, +844679550eb763052ea445ae4f0580eb05485fd8*' IN BOOLEAN MODE)) AND ((`path`.`shadow_path` LIKE ('%/{Addressbook\\_Model\\_Contact}844679550eb763052ea445ae4f0580eb05485fd8%'))))

.../vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
.../Tinebase/Backend/Sql/Abstract.php(762): Zend_Db_Adapter_Pdo_Abstract->query()
.../Tinebase/Backend/Sql/Abstract.php(542): Tinebase_Backend_Sql_Abstract->_fetch()
.../Tinebase/Path/Backend/Sql.php(436): Tinebase_Backend_Sql_Abstract->search()
.../Tinebase/Record/Path.php(104): Tinebase_Path_Backend_Sql->search()
.../Tinebase/Record/Path.php(220): Tinebase_Record_Path->getPathsForRecord()
.../Tinebase/Controller/Record/Abstract.php(1127): Tinebase_Record_Path->rebuildPaths()
.../Tinebase/Controller/Record/Abstract.php(594): Tinebase_Controller_Record_Abstract->_setRelatedData()
[internal function]: Tinebase_Controller_Record_Abstract->create()
.../Tinebase/Frontend/Json/Abstract.php(266): call_user_func_array()
.../Addressbook/Frontend/Json.php(326): Tinebase_Frontend_Json_Abstract->_save()
[internal function]: Addressbook_Frontend_Json->saveContact()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(232): call_user_func_array()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(590): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(197): Zend_Json_Server->_handle()
.../Tinebase/Server/Json.php(336): Zend_Json_Server->handle()
.../Tinebase/Server/Json.php(171): Tinebase_Server_Json->_handle()
.../Tinebase/Core.php(237): Tinebase_Server_Json->handle()
.../index.php(18): Tinebase_Core::dispatchRequest()

Server info :
PHP Version 5.6.31
Apache/2.4.27 (cPanel)
Steps To ReproduceIn Address book tab -> Add Contact -> fill up contact details and press ok

Throws error.
TagsNo tags attached.




2017-10-09 13:12


Tineerror.png (108,557 bytes)
Tineerror.png (108,557 bytes)


2017-10-10 10:05

administrator   ~0020914

did you install from scratch or update an existing installation?
you might need to run the CLI command Tinebase.upgradeMysql564 if you have updated mysql after the installation of tine 2.0.


2017-10-10 11:02

reporter   ~0020916

Its fresh install.


2017-10-27 11:20

reporter   ~0021044

I did checked this with MySQL 5.6 and found that no such error occured on MySQL 5.6 because it uses FULLTEXT search indexes which is only supported on MySQL 5.6 and not with MySQL 5.5 Innodb engine.

As my database engine is innodb with MySQL server version 5.5 all FULLTEXT keys and table "path" were not generated. and hence I was getting above issue.

I just wanted to confirm is the requirement for MySQL has been changed to 5.6 ?


2017-10-30 13:03

reporter   ~0021052

Any update regarding above issue ?


2017-12-07 17:40

administrator   ~0021222

> I just wanted to confirm is the requirement for MySQL has been changed to 5.6 ?

it is recommended to run at least mySQL 5.6.4 because of the fulltext feature.

if you have a lower version, tine 2.0 should also work. but if you installed with a version < 5.6.4, you have to run the CLI command Tinebase.upgradeMysql564 (to add the missing indexes and tables) before tine 2.0 is working again.

Issue History

Date Modified Username Field Change
2017-10-09 13:12 punit New Issue
2017-10-09 13:12 punit File Added: Tineerror.png
2017-10-10 10:05 pschuele Assigned To => pschuele
2017-10-10 10:05 pschuele Status new => feedback
2017-10-10 10:05 pschuele Note Added: 0020914
2017-10-10 11:02 punit Note Added: 0020916
2017-10-10 11:02 punit Status feedback => assigned
2017-10-27 11:20 punit Note Added: 0021044
2017-10-30 13:03 punit Note Added: 0021052
2017-12-07 17:40 pschuele Note Added: 0021222
2017-12-07 17:40 pschuele Target Version => 2017.08.10 Community Edition
2017-12-07 17:40 pschuele Status assigned => closed
2017-12-07 17:40 pschuele Resolution open => no change required
2017-12-07 17:40 pschuele Fixed in Version => 2017.08.10 Community Edition