Wow - quick response thank you.
Here is the snippet code
<?php
$base_path = $modx->getOption('core_path').'/components/newsletter/';
$o = '';
$f = $base_path.'snippet.newsletter.php';
if (file_exists($f)) {
$o = include $f;
} else {
$modx->setLogTarget('ECHO');
$modx->log(modX::LOG_LEVEL_ERROR,'CA Newsletter not found at: '.$f);
}
return $o;
Here is the PHP code the snippet calls:
<?php
/**
* @package newsletter
*/
$base_path = !empty($base_path) ? $base_path : $modx->getOption('core_path').'components/newsletter/';
$modx->addPackage('newsletter',$base_path.'model/');
$email = $modx->newObject('nlEmail');
$email->fromArray(array(
'name' => 'Dave',
'email' => '[email protected]',
'sent' => '0',
'unsubscribe' => '0',
));
$email->save();
$emails = $modx->getCollection('nlEmail');
echo 'Total: '.count($emails);
Here is an error in the log that may pertain to the problem:
[2010-12-16 11:42:57] (ERROR @ /manager/index.php) Error preparing statement for query: SELECT `modActionDom`.`id` AS `modActionDom_id`, `modActionDom`.`action` AS `modActionDom_action`, `modActionDom`.`name` AS `modActionDom_name`, `modActionDom`.`description` AS `modActionDom_description`, `modActionDom`.`xtype` AS `modActionDom_xtype`, `modActionDom`.`container` AS `modActionDom_container`, `modActionDom`.`rule` AS `modActionDom_rule`, `modActionDom`.`value` AS `modActionDom_value`, `modActionDom`.`constraint` AS `modActionDom_constraint`, `modActionDom`.`constraint_field` AS `modActionDom_constraint_field`, `modActionDom`.`constraint_class` AS `modActionDom_constraint_class`, `modActionDom`.`active` AS `modActionDom_active`, `modActionDom`.`for_parent` AS `modActionDom_for_parent` FROM `modx_actiondom` AS `modActionDom` LEFT JOIN `modx_access_actiondom` `Access` ON `modActionDom`.`id` = `Access`.`target` WHERE ( `modActionDom`.`action` = ? AND `modActionDom`.`active` = ? AND `modActionDom`.`for_parent` = ? AND ( ( `Access`.`principal_class` = ? AND `Access`.`principal` IN (1) ) OR `Access`.`principal` IS ? ) ) - Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’? ) )’ at line 1
