Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Error when send newsletter  (Read 7774 times)

Offline Trendslink

  • Newbie
  • *
  • Posts: 21
  • Karma: +1/-0
    • View Profile
Error when send newsletter
« on: April 28, 2016, 09:44:57 AM »
Can somebody help me about this error? i'm newbie here. I trying to send newsletter to subscriber and other users


Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5791
  • Karma: +274/-2
    • View Profile
Re: Error when send newsletter
« Reply #1 on: April 29, 2016, 09:36:14 AM »
Hello.

Can you check for last few errors in your AbanteCart error log?

Offline Trendslink

  • Newbie
  • *
  • Posts: 21
  • Karma: +1/-0
    • View Profile
Re: Error when send newsletter
« Reply #2 on: April 29, 2016, 10:57:41 AM »
Error log

Quote
2016-04-28 13:51:46 - App Error: AbanteCart core v.1.2.6 Cannot run task step #69. Unknown settings for it. in /home/trendsli/public_html/admin/controller/task/sale/contact.php on line 161

2016-04-28 13:51:46 - warning: AbanteCart core v.1.2.6 Invalid argument supplied for foreach() in <b>/home/trendsli/public_html/admin/controller/task/sale/contact.php</b> on line <b>119</b>


What i found at line 119 public_html/admin/controller/task/sale/contact.php

Quote
         foreach($step_info['settings']['to'] as $to){


What i found at line 161 public_html/admin/controller/task/sale/contact.php

Quote
   $error = new AError($error_text);
« Last Edit: April 30, 2016, 12:13:55 PM by Trendslink »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Error when send newsletter
« Reply #3 on: May 04, 2016, 11:32:38 AM »
Looks like your scheduled tasks steps cannot be finished..

can you post data from database tables "tasks" and "task_steps" here?
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Trendslink

  • Newbie
  • *
  • Posts: 21
  • Karma: +1/-0
    • View Profile
Re: Error when send newsletter
« Reply #4 on: May 04, 2016, 12:28:04 PM »
Looks like your scheduled tasks steps cannot be finished..

can you post data from database tables "tasks" and "task_steps" here?


Is it this one?

Quote
-->
- <pma:structure_schemas>
- <pma:database name="trendsli_xxxx" collation="latin1_swedish_ci" charset="latin1">
  <pma:table name="abpc_tasks">CREATE TABLE `abpc_tasks` ( `task_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `starter` int(11) DEFAULT NULL, `status` int(11) DEFAULT '0', `start_time` datetime DEFAULT NULL, `last_time_run` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `progress` int(11) NOT NULL DEFAULT '0', `last_result` int(11) NOT NULL DEFAULT '0', `run_interval` int(11) NOT NULL DEFAULT '0', `max_execution_time` int(11) DEFAULT '0', `date_added` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`task_id`), UNIQUE KEY `task_name_idx` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;</pma:table>
  </pma:database>
  </pma:structure_schemas>
- <!--
« Last Edit: May 05, 2016, 12:11:59 AM by Trendslink »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Error when send newsletter
« Reply #5 on: May 04, 2016, 02:28:18 PM »
no.. we need data (content) of tables. not structure.
P.S. you can send me it as  private message.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Trendslink

  • Newbie
  • *
  • Posts: 21
  • Karma: +1/-0
    • View Profile
Re: Error when send newsletter
« Reply #6 on: May 05, 2016, 12:38:18 AM »
no.. we need data (content) of tables. not structure.
P.S. you can send me it as  private message.

PM sent

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Error when send newsletter
« Reply #7 on: May 20, 2016, 01:33:27 PM »
bug related to database column type limitation.
To solve it just run this query via phpMyAdmin

Code: [Select]
ALTER TABLE ac_task_details
CHANGE COLUMN `settings` `settings` MEDIUMTEXT NULL DEFAULT NULL ;

ALTER TABLE ac_task_steps
CHANGE COLUMN `settings` `settings` MEDIUMTEXT NULL DEFAULT NULL ;

where ac_ - your table name prefix
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod