0013532: Abnormal End error while adding contact on server

[Gloirin]

Reported by punit on 9 Oct 2017 11:12

Version: 2017.08.6 Community Edition

Hi,

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
CGI/FastCGI
Apache/2.4.27 (cPanel)

Steps to reproduce: In Address book tab -> Add Contact -> fill up contact details and press ok

Throws error.

[Gloirin]

Comment posted by pschuele on 10 Oct 2017 08:05

hi,
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.

[Gloirin]

Comment posted by punit on 10 Oct 2017 09:02

Its fresh install.

[Gloirin]

Comment posted by punit on 27 Oct 2017 09:20

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 ?

[Gloirin]

Comment posted by punit on 30 Oct 2017 12:03

Any update regarding above issue ?

[Gloirin]

Comment posted by pschuele on 7 Dec 2017 16:40

> 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.