Error Campaigns

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

My suitecrm keeps writing to log errors qhen io create an campaign

Mon Jul 2 17:13:57 2018 [2335][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:13:57 2018 [2335][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:08 2018 [2335][1][ERROR] Unable to find relationship surveys_campaigns
Mon Jul 2 17:14:08 2018 [2335][1][ERROR] Unable to find relationship surveys_campaigns
Mon Jul 2 17:14:08 2018 [2335][1][ERROR] Unsupported segments file format
Mon Jul 2 17:14:14 2018 [2310][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:14 2018 [2310][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:17 2018 [2284][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:17 2018 [2284][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:22 2018 [2310][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:22 2018 [2310][1][ERROR] Unable to get proper side for link assigned_user_link
Mon Jul 2 17:14:25 2018 [2284][1][ERROR] Unable to find relationship surveys_campaigns
Mon Jul 2 17:14:25 2018 [2284][1][ERROR] Unable to find relationship surveys_campaigns
Mon Jul 2 17:14:25 2018 [2284][1][ERROR] Unable to find relationship surveys_campaigns
Mon Jul 2 17:14:26 2018 [2335][1][ERROR] Unable to find relationship surveys_campaigns
Mon Jul 2 17:14:56 2018 [2310][1][ERROR] convert: Conversion of : 12:00am from m/d/Y h:ia to Y-m-d H:i:s failed
Mon Jul 2 17:15:19 2018 [2310][1][ERROR] Unable to find relationship surveys_campaigns

i cant find the origin
Any suggestions?
best regards

#2

Please always tell us version of SuiteCRM! And PHP.

Try a few Admin / Repairs

  • QR & R, scrolling down to the bottom to see if there is a “sync vardefs” button

  • Rebuild Relationships

Then check BOTH your logs for any errors during the Repairs, and during the Campaign creation.

suitecrm.log
php_errors.log

#3

Hi thanks for the reply.

This night i create an survey campaign for test and receive 500 emails and still counting, its the second time, first time for luck the campaign stuck in the test email.
I already do all the repairs. my logs this night are full with this error
Tue Jul 3 07:21:02 2018 [27369][1][FATAL] Job 25c2b38b-35c2-14a6-a83f-5b3b15bf0fbb (Executar à noite o envio massivo de emails de campanhas) failed in CRON run
Tue Jul 3 07:22:02 2018 [27394][1][ERROR] Unable to find relationship surveys_campaigns
Tue Jul 3 07:22:02 2018 [27394][1][FATAL] Error inserting into table: emails_text: Query Failed: INSERT INTO emails_text (email_id,from_addr,reply_to_addr,to_addrs,cc_addrs,bcc_addrs,desc$
VALUES (‘dd666a39-3794-94c9-accb-5b3a4bf93278’,‘InGolf® Tour Operator media@news-ingolf.pt’,’’,’’,’’,’’,’\r\n \r\n \r\n \r\n $
Tue Jul 3 07:22:02 2018 [27394][1][FATAL] Job a5ad071e-2097-a56d-56bb-5b3b1628bca5 (Executar à noite o envio massivo de emails de campanhas) failed in CRON run
Tue Jul 3 07:23:02 2018 [27419][1][ERROR] Unable to find relationship surveys_campaigns
Tue Jul 3 07:23:02 2018 [27419][1][FATAL] Error inserting into table: emails_text: Query Failed: INSERT INTO emails_text (email_id,from_addr,reply_to_addr,to_addrs,cc_addrs,bcc_addrs,desc$
VALUES (‘dd666a39-3794-94c9-accb-5b3a4bf93278’,‘InGolf® Tour Operator media@news-ingolf.pt’,’’,’’,’’,’’,’\r\n \r\n \r\n \r\n $
Tue Jul 3 07:23:02 2018 [27419][1][FATAL] Job ec1a6d5e-24ef-8180-387f-5b3b166fbedb (Executar à noite o envio massivo de emails de campanhas) failed in CRON run
Tue Jul 3 07:24:02 2018 [27444][1][ERROR] Unable to find relationship surveys_campaigns
Tue Jul 3 07:24:02 2018 [27444][1][FATAL] Error inserting into table: emails_text: Query Failed: INSERT INTO emails_text (email_id,from_addr,reply_to_addr,to_addrs,cc_addrs,bcc_addrs,desc$
VALUES (‘dd666a39-3794-94c9-accb-5b3a4bf93278’,‘InGolf® Tour Operator media@news-ingolf.pt’,’’,’’,’’,’’,’\r\n \r\n \r\n \r\n $
Tue Jul 3 07:24:02 2018 [27444][1][FATAL] Job d8200496-dd9c-b68d-7147-5b3b16219f7a (Executar à noite o envio massivo de emails de campanhas) failed in CRON run
Tue Jul 3 07:25:02 2018 [27469][1][ERROR] Unable to find relationship surveys_campaigns

#4

3 logs files full with that error. and for 1 of that error one mail sent

#5

When i do the quick-repair and rebuild something appear in the bottom of the page.
An script

/* Table : emails_text /
/COLUMNS/
/MISSING IN DATABASE - email_id - ROW/
/MISSING IN DATABASE - from_addr - ROW/
/MISSING IN DATABASE - reply_to_addr - ROW/
/MISSING IN DATABASE - to_addrs - ROW/
/MISSING IN DATABASE - cc_addrs - ROW/
/MISSING IN DATABASE - bcc_addrs - ROW/
/MISSING IN DATABASE - description - ROW/
/MISSING IN DATABASE - description_html - ROW/
/MISSING IN DATABASE - raw_source - ROW/
/MISSING IN DATABASE - deleted - ROW/
/ INDEXES */
/*MISSING INDEX IN DATABASE - emails_textfromaddr -index ROW */
ALTER TABLE emails_text add COLUMN email_id char(36) NULL , add COLUMN from_addr varchar(255) NULL , add COLUMN reply_to_addr varchar(255) NULL , add COLUMN to_addrs text NULL , add COLUMN cc_addrs text NULL , add COLUMN bcc_addrs text NULL , add COLUMN description longtext NULL , add COLUMN description_html longtext NULL , add COLUMN raw_source longtext NULL , add COLUMN deleted bool DEFAULT ‘0’ NULL , ADD INDEX emails_textfromaddr (from_addr);

Can i run this script?

#6

Can you get me a better version of the log messages? Those “$” breaking long lines indicate that you’re trying to copy-paste from a terminal. If you can get me the actual, complete, text, it would be helpful. Thanks.

#7

Yes you can run the script at the bottom of QR&R screen.

#8

when i runned the script jast froze the screen, nothing happens

#9

Tue Jul 3 10:57:01 2018 [1487][1][FATAL] Job ddde6aaf-24ae-5470-0330-5b3b485e0265 (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 10:58:02 2018 [1520][1][FATAL] Job 2e57a86f-3e77-10b9-882a-5b3b48d85316 (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 10:59:01 2018 [1547][1][FATAL] Job 76eaf9dc-7446-eac9-91c3-5b3b48b7261c (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 11:00:01 2018 [1571][1][FATAL] Job bb644ef8-d71f-a296-9dba-5b3b49135bd1 (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 11:01:02 2018 [1595][1][FATAL] Job 11a184e5-d2c9-64ea-09b7-5b3b491f9c3e (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 11:02:01 2018 [1619][1][FATAL] Job 4cde6f51-d0db-a240-40ac-5b3b49c3b710 (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 11:02:33 2018 [994][1][FATAL] Query Failed: DESCRIBE emails_text: MySQL error 145: Table ‘./bitnami_suitecrm/emails_text’ is marked as crashed and should be repaired
Tue Jul 3 11:02:33 2018 [994][1][FATAL] Query Failed: SHOW INDEX FROM emails_text: MySQL error 145: Table ‘./bitnami_suitecrm/emails_text’ is marked as crashed and should be repaired
Tue Jul 3 11:02:33 2018 [994][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.
Tue Jul 3 11:03:01 2018 [1643][1][FATAL] Job 9b7e6abf-fe22-0d88-f744-5b3b493cf6d2 (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 11:03:52 2018 [1320][1][FATAL] Executing repair query: Query Failed: ALTER TABLE emails_text add COLUMN email_id char(36) NULL , add COLUMN from_addr varchar(255) NULL , add COLUMN reply_to_addr varchar(255) NULL , add COLUMN to_addrs text NULL , add COLUMN cc_addrs text NULL , add COLUMN bcc_addrs text NULL , add COLUMN description longtext NULL , add COLUMN description_html longtext NULL , add COLUMN raw_source longtext NULL , add COLUMN deleted bool DEFAULT ‘0’ NULL , ADD INDEX emails_textfromaddr (from_addr): MySQL error 145: Table ‘./bitnami_suitecrm/emails_text’ is marked as crashed and should be repaired
Tue Jul 3 11:03:52 2018 [1320][1][FATAL] Exception handling in /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php:402
Tue Jul 3 11:03:52 2018 [1320][1][FATAL] Exception in Controller: Falha na base de dados. Por favor, consulte o ficheiro .log do SuiteCRM para mais detalhes.
Tue Jul 3 11:03:52 2018 [1320][1][FATAL] backtrace:
#0 /opt/bitnami/apps/suitecrm/htdocs/include/database/DBManager.php(353): sugar_die(‘Falha na base d…’)
#1 /opt/bitnami/apps/suitecrm/htdocs/include/database/DBManager.php(328): DBManager->registerError(‘Executing repai…’, ‘Executing repai…’, true)
#2 /opt/bitnami/apps/suitecrm/htdocs/include/database/MysqliManager.php(167): DBManager->checkError(‘Executing repai…’, true)
#3 /opt/bitnami/apps/suitecrm/htdocs/modules/Administration/repairDatabase.php(93): MysqliManager->query(‘ALTER TABLE ema…’, true, ‘Executing repai…’)
#4 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/View/SugarView.php(840): include_once(’/opt/bitnami/ap…’)
#5 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile(‘modules/Adminis…’)
#6 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/View/SugarView.php(207): ViewClassic->display()
#7 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php(432): SugarView->process()
#8 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/SugarApplication.php(109): SugarController->execute()
#10 /opt/bitnami/apps/suitecrm/htdocs/index.php(52): SugarApplication->execute()
#11 {main}
Tue Jul 3 11:04:01 2018 [1667][1][FATAL] Job e0e21be9-ef4e-7abc-1e1a-5b3b4af70375 (Executar tarefas agendadas de criação de relatórios) failed in CRON run
Tue Jul 3 11:05:02 2018 [1691][1][FATAL] Job 362d61ee-fda5-085a-bfb6-5b3b4a11ad4d (Executar tarefas agendadas de criação de relatórios) failed in CRON run

#10

Attention to this error:

 MySQL error 145: Table './bitnami_suitecrm/emails_text' is marked as crashed and should be repaired

You need to attempt table repairs from within phpMyAdmin. Then retry the QR&R script. But you should be worried - this is a sign of database corruption, it’s important to keep an eye on the database and hope there are no more problems, and that the repairs really work once and for all…

#11

I have some problems to connect to phpmyadmin, no other way to correct the database?

#12

Yes, phpMyAdmin is just a web interface to MySQL.

You can connect to mysql from the servers’s command-line and do the repairs in text mode. I don’t know the exact commands, but you’ll find answers online with your exact error, and what you need to do to repair.

#13

Database is workfine now thank to you =) thank you vary mutch

Now when i press new campaign newsletter write this erros on the log

Tue Jul 3 14:36:20 2018 [994][1][ERROR] Unable to get proper side for link assigned_user_link
Tue Jul 3 14:36:20 2018 [994][1][ERROR] Unable to get proper side for link assigned_user_link

#14

Tue Jul 3 14:38:21 2018 [1320][1][ERROR] Unable to find relationship surveys_campaigns
Tue Jul 3 14:38:21 2018 [1320][1][ERROR] Unable to find relationship surveys_campaigns
Tue Jul 3 14:38:21 2018 [1320][1][ERROR] Unable to find relationship surveys_campaigns
Tue Jul 3 14:38:22 2018 [1252][1][ERROR] Unable to find relationship surveys_campaigns

#15

Tue Jul 3 14:39:48 2018 [1320][1][ERROR] convert: Conversion of : 12:00am from m/d/Y h:ia to Y-m-d H:i:s failed

#16

Now that the database is ok, you need to try the Repairs:

  • QR&R, with scripts

  • rebuild relationships

#17

Did you ever find a solution to this error?

1 Like