IMPORT ERRORS on

[petersmith]

Hi John,

i've spent hours with our server administrator who has changed the appropriate setting, however it made absolutely no difference.

I don't understand as the file I tried to import as a second test was exactly the same file I succesfully imported 6 weeks ago when we were evaluating Sugar CRM CE. 6 weeks ago it imported like a dream and was perfect, now everything I do seems to be warnings and errors. (OK I have turned on error reporting as before there were just blank screens and nothing happened)

I log on to sugar is fine - then when i go to admin and press the Import Wizard button, immediately I get this -
Warning: Invalid argument supplied for foreach() occured in /home/phuket/public_html/sugar/include/externalAPI/ExternalAPIFactory.php on line 106 [2012-11-08 09:42:07] display_stack_trace caller, file: /home/phuket/public_html/sugar/include/utils.php line#: 3116
/home/phuket/public_html/sugar/include/externalAPI/ExternalAPIFactory.php[L:106](:StackTraceErrorHandler)
/home/phuket/public_html/sugar/include/externalAPI/ExternalAPIFactory.php[L:235](ExternalAPIFactory:loadFullAPIList)
/home/phuket/public_html/sugar/include/externalAPI/ExternalAPIFactory.php[L:274](ExternalAPIFactory:listAPI)
/home/phuket/public_html/sugar/modules/Import/views/view.step1.php[L:158](ExternalAPIFactory:getModuleDropDown)
/home/phuket/public_html/sugar/modules/Import/views/view.step1.php[L:121](ImportViewStep1:getAllImportableExternalEAPMs)
/home/phuket/public_html/sugar/include/MVC/View/SugarView.php[L:139](ImportViewStep1:display)
/home/phuket/public_html/sugar/include/MVC/Controller/SugarController.php[L:345](SugarViewrocess)
/home/phuket/public_html/sugar/include/MVC/Controller/SugarController.php[L:292](SugarControllerrocessView)
/home/phuket/public_html/sugar/include/MVC/SugarApplication.php[L:89](SugarController:execute)
/home/phuket/public_html/sugar/index.php[L:46](SugarApplication:execute)
Import»Step 1: Select Data Source

Create


This is only a warning, but when i load the same file as 6 weeks ago which imported like magic, I get -

Warning: DateTimeZone::__construct() [datetimezone.--construct]: Unknown or bad timezone (US/Pacific-New) occured in/home/phuket/public_html/sugar/include/TimeDate.php on line 1459 [2012-11-08 09:52:28] display_stack_trace caller, file: /home/phuket/public_html/sugar/include/utils.php line#: 3116
[L:](:StackTraceErrorHandler)
/home/phuket/public_html/sugar/include/TimeDate.php[L:1459](DateTimeZone:__construct)
/home/phuket/public_html/sugar/modules/Import/views/view.confirm.php[L:389](TimeDate:getTimezoneList)
/home/phuket/public_html/sugar/modules/Import/views/view.confirm.php[L:205](ImportViewConfirm:setDateTimeProperties)
/home/phuket/public_html/sugar/include/MVC/View/SugarView.php[L:139](ImportViewConfirm:display)
/home/phuket/public_html/sugar/include/MVC/Controller/SugarController.php[L:345](SugarViewrocess)
/home/phuket/public_html/sugar/include/MVC/Controller/SugarController.php[L:292](SugarControllerrocessView)
/home/phuket/public_html/sugar/include/MVC/SugarApplication.php[L:89](SugarController:execute)
/home/phuket/public_html/sugar/index.php[L:46](SugarApplication:execute)


The debug file is attached to my previous thread but after tearing my hair out I am no nearer a solution other than deleting Sugar completely from our server in US and completely re-installing and re-adding the new fields. If this happens now what happens if Sugar does this again when all our data is inside - I shudder to think! My initial super confidence is shattered!

Your kind assistance will be much appreciated.

Kind regards,debug on 8th Nov.txt

Peter Phuket Thailand. GMT+7

[jmertic]

First off, please add a bug for this at http://bugs.sugarcrm.com if you haven't already, and let me know the bug number.

Second, can you get access to the display_errors setting for your PHP install, and turn it to 'Off' to hide these errors from the user?