Text only | Text with Images

AbanteCart Community

eCommerce construction => General Discussion => Topic started by: Trendslink on April 28, 2016, 09:44:57 AM

Title: Error when send newsletter
Post by: Trendslink 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

(http://i.imgur.com/pOYSjTp.jpg)
Title: Re: Error when send newsletter
Post by: Basara on April 29, 2016, 09:36:14 AM
Hello.

Can you check for last few errors in your AbanteCart error log (http://forum.abantecart.com/index.php/topic,834.msg3085.html#msg3085)?
Title: Re: Error when send newsletter
Post by: Trendslink on April 29, 2016, 10:57:41 AM
Error log

Quote2016-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

Quoteforeach($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);
Title: Re: Error when send newsletter
Post by: abolabo 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?
Title: Re: Error when send newsletter
Post by: Trendslink on May 04, 2016, 12:28:04 PM
Quote from: abolabo 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?


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>
- <!--
Title: Re: Error when send newsletter
Post by: abolabo 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.
Title: Re: Error when send newsletter
Post by: Trendslink on May 05, 2016, 12:38:18 AM
Quote from: abolabo 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.

PM sent
Title: Re: Error when send newsletter
Post by: abolabo 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
Text only | Text with Images