17 replies to this topic

[sbossu]

Hello,

I tried to export all my leads (about 1000) and I got a message saying a link would be emailed to me but I never received the email...  Perhaps there is something wrong in the super user email configuration?  Any help would be appreciated

Thank you

 

[speixoto]

Make sure you have your cron jobs running. Or at least go to index.php/jobsManager/default/list and run them manually. You need to run ate least this one: Export Job

[sbossu]

Make sure you have your cron jobs running. Or at least go to index.php/jobsManager/default/list and run them manually. You need to run ate least this one: Export Job

Thanks.  I ran the Export Job manually but after 1hr it is still running (whereas there was supposedly a timeout after 500 seconds...!)  Did the job get stuck?

[speixoto]

Run the Monitor Job maybe?

[Wiggert]

I had the same. Looking into the logs i came across this error

 

6/10/14 9:47 AM Europe/Amsterdam Starting job type: Export

PHP Error[8]: unserialize(): Error at offset 65528 of 65535 bytes

    in file /var/www/zurmo/app/protected/modules/export/jobs/ExportJob.php at line 141

#0 /var/www/zurmo/app/protected/modules/export/jobs/ExportJob.php(141): unserialize()

#1 /var/www/zurmo/app/protected/modules/export/jobs/ExportJob.php(107): ExportJob->processExportItem()

 

 

I expect because i have added custom fields, but i'm not sure. I used the SQL query generated from the report function and exported it to manually. 

[sbossu]

OK is this bug going to be fixed?

[speixoto]

To solve any issue we need to be able to know what is happening. What are the condition that make this happen? Have anyone tried to reproduce this in zurmo demo enviroments? If yes, can you provide details how to reproduce the bug?

[sbossu]

I also have custom fields maybe that's the lead

At any rate the fact that there is no error message sent to the user is an indication that the code needs revising

[speixoto]

I tryed locally with all the possible custom field and got no error. So are you sure its not an environment issue? Can you reproduce this in on demo.zurmo.com?

[sbossu]

I don't know I'm not a zurmo expert, we're using Ubuntu on an AWS EC2

Where do I find the relevant log files? The log for the Export Job is empty and last run is "Never" which clearly indicates that it never went through

[speixoto]

Log file is app\protected\runtime\application.log

[sbossu]

I didn' see anything in that log file which seemed related to the export job

I see a bunch of errors like this one:

2014/06/11 23:31:52 [error] [exception.PDOException] exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' in /var/www/zurmo/redbean/rb.php:613
Stack trace:
#0 /var/www/zurmo/redbean/rb.php(613): PDO->__construct('mysql:host=loca...', 'zurmo', 'zurmo', Array)
#1 /var/www/zurmo/redbean/rb.php(832): RedBean_Driver_PDO->connect()
#2 /var/www/zurmo/redbean/rb.php(7062): RedBean_Driver_PDO->setDebugMode(false, Object(RedBean_Logger))
#3 /var/www/zurmo/app/protected/core/models/RedBeanDatabase.php(87): RedBean_Facade::debug(false)
#4 /var/www/zurmo/app/protected/modules/zurmo/components/BeginRequestBehavior.php(444): RedBeanDatabase::setup('mysql:host=loca...', 'zurmo', 'zurmo')
#5 /var/www/zurmo/yii/framework/base/CComponent.php(558): BeginRequestBehavior->handleSetupDatabaseConnection(Object(CEvent))
#6 /var/www/zurmo/yii/framework/base/CApplication.php(196): CComponent->raiseEvent('onBeginRequest', Object(CEvent))
#7 /var/www/zurmo/yii/framework/base/CApplication.php(167): CApplication->onBeginRequest(Object(CEvent))
#8 /var/www/zurmo/app/protected/commands/bootstrap.php(64): CApplication->run()
#9 /var/www/zurmo/app/protected/commands/zurmoc.php(38): require_once('/var/www/zurmo/...')
#10 /var/www/zurmo/app/protected/commands/zurmoc(4): require_once('/var/www/zurmo/...')
#11 {main}
 

[sbossu]

... any idea?

[speixoto]

Can you try change "localhost" for "127.0.0.1" on your perInstance.php file on the $connectionString var?

[sbossu]

If I do that the login page displays:

 

"An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.

SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)"

[sbossu]

Where can I find the SQL query for the export job?  I want to export the data manually, and re-import it later

[Wiggert]

I tryed locally with all the possible custom field and got no error. So are you sure its not an environment issue? Can you reproduce this in on demo.zurmo.com?

 

Did not try it, But i also have custom fields (quite some) and it also breaks on line 141

 

$dataProviderOrIdsToExport = unserialize($exportItem->serializedData);

 

Let me know if you have some code that i can add to the export file that helps you debug it. 

 

I have two custom fields, 2 picklists. 

[bigfoot53]

Hello All,

I have a similar issue, I have an export job that is stuck it never shows any progress and i cant cancel it. the job log shows .

 

10/15/14 8:24 AM America/New_York Starting job type: Export
2014/10/15 08:24:01 Info  - Script will run at most for 300 seconds.
2014/10/15 08:24:01 Info  - Starting job type: Export
2014/10/15 08:24:01 Info  - Existing job detected
10/15/14 8:24 AM America/New_York Ending job type: Export

 

Is there a way to delete this job ?

 

 

Thanks

Bruce