Error importing meetings

kdun · 5 June 2015 10:40

Hi all,

I’ve just recently started using SugarCRM CE (6.5.18) and am trying to migrate to SuiteCRM (7.2.2). I tried to do the upgrade but that didn’t work, so i decided to do a fresh install of SuiteCRM (soooo much better than SugarCRM). I’ve ade the same customizations (B2C) and already imported all the Leads, Contacts, Tasks, Notes and Calls. This went mostly without problems. But I am now stuck on importing Meetings. This is the last data, once it is imported we can switch to SuiteCRM. Upon importing the meetings csv file exported from SugarCRM it will give an error at the last step, “Import Errors Occured”. No other information is given. I tried the import with only 8 records (the original import csv has abbout 750 records), but got the same error. I chcked and cleaned up the file where i thought it might be causing problems but still get the same error message. After each failed/errored import there will be a few records imported.
What makes it even stranger (for me) is that i can keep importing the same file without changing anything in it and each time it will import 1-3 records. I hve not changed anything in the file between imports.

any help would be appreciated.

urdhvatech · 5 June 2015 12:09

Hello,

Keep your eyes on sugarcrm.log & apache error log while importing test file. You can identify the issue.

kdun · 5 June 2015 13:43

i get quite a lot of error messages in the suitecrm.log, even when not importing. below a snippet of the error logs when i try to import the file. it doesn’t mean much to me, perhaps someone can point me in the right direction on getting the import working?

httpd log

[Fri Jun 05 15:29:57 2015] [error] [client 192.168.55.1] FastCGI: server "/php-fpm-handler" stderr: PHP message: PHP Fatal error:  Class 'Link' not found in /volume1/web/crm/data/Link2.php on line 672, referer: https://myserver/crm/index.php

suitecrm log

Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Accessing static property ImportFieldSanitize::$createdBeans as non static
Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Declaration of SugarFieldEnum::displayFromFunc() should be compatible with SugarFieldBase::displayFromFunc($displayType, $parentFieldArray, $vardef, $displayParams, $tabindex = 0)
Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Declaration of SugarFieldDatetimecombo::save() should be compatible with SugarFieldBase::save($bean, $params, $field, $properties, $prefix = '')
Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Declaration of Contact::save_relationship_changes() should be compatible with SugarBean::save_relationship_changes($is_update, $exclude = Array)
Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Declaration of Contact::create_new_list_query() should be compatible with SugarBean::create_new_list_query($order_by, $where, $filter = Array, $params = Array, $show_deleted = 0, $join_type = '', $return_array = false, $parentbean = NULL, $singleSelect = false, $ifListForExport = false)
Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Accessing static property ImportFieldSanitize::$createdBeans as non static
Fri Jun  5 15:29:55 2015 [8339][1][FATAL] Caught error: Declaration of SugarFieldText::getDetailViewSmarty() should be compatible with SugarFieldBase::getDetailViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex)
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::assign_default_groups() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::retrieveDefaultGroups() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit_assigned() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit_parent() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit_creator() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method ACLController::requireOwner() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method ACLController::requireSecurityGroup() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][ERROR] Index doesn't exists in the specified directory.
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method vCal::cache_sugar_vcal() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method vCal::cache_sugar_vcal_freebusy() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method CalendarActivity::get_activities() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method ACLController::checkAccess() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method ACLController::checkAccess() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Declaration of Call::save_relationship_changes() should be compatible with SugarBean::save_relationship_changes($is_update, $exclude = Array)
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Declaration of Call::ACLAccess() should be compatible with SugarBean::ACLAccess($view, $is_owner = 'not_set', $in_group = 'not_set')
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Declaration of Call::create_export_query() should be compatible with SugarBean::create_export_query($order_by, $where)
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method CalendarActivity::get_occurs_within_where_clause() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::assign_default_groups() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit_assigned() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit_parent() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method SecurityGroup::inherit_creator() should not be called statically, assuming $this from incompatible context
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method LogicHook::initialize() should not be called statically
Fri Jun  5 15:29:57 2015 [8339][1][FATAL] Caught error: Non-static method Tracker::logPage() should not be called statically

urdhvatech · 5 June 2015 14:23

Hello,

I am not quite sure about exact solution, because it could be possible that your row file may have some issue.
But you can try error reporting off for a while importation is going on. some times I too faced the issue that warning fails the ajax running and it results to ajax error.

kdun · 5 June 2015 14:59

alas, that wasn’t it. thanks for the suggestion though.

i think i will just try to export the data from the sugarcrm db and import it back into the suitecrm db. see if that works.

any other suggestions are welcome

kdun · 7 June 2015 21:27

so i exported the data from the meetings and meetings_* tables from the sugarcrm installation and imported them into the same tables of the suitecrm database and all imports were fine. i got an error on importing into the meetings table:

SQL query:
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
MySQL said: Documentation
#1231 - Variable 'collation_connection' can't be set to the value of 'NULL'

all data seems to be there though. all the contacts have their planned meetings linked to them. just one thing (one of the most important) is not working and that is none of the planned meetings show up in the calendar.

does anyone know if there is another table that needs to be imported to have all the scheduled meetings show up in the calendar?

kdun · 10 June 2015 21:36

nothing showed up in the calendars because the records read directly into the database had different user id records than the users (which were created new in the SuiteCRM install, but had the same names as in the SugarCRM). so by deleting all the users and exporting them directly from the sugar db, then importing them into the suite db fixed it.
users can be exported in the crm, butu not imported.

kdun · 17 June 2015 15:29

solved the meetings problem, but a new problem arrose. may not have anything to do with the meetings. nut i think it may have been caused by me truncating some tables in the database.

securitysuite assign to grouppanel now only shows on the list view of contacts. when trying to assign, it will end up in an empty page. menubar to the left still visible.

the edit contact and other views the securitygroup panel isn’t even there