[Typo3] Direct Mail

[René Schade]

Sure,

Trying to install the three tables: sys_dmail, sys_dmail_maillog & sys_dmail_group

sys_dmail and sys_dmail_group had the same problem 

....snip from sql...
CREATE TABLE sys_dmail (
  uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
.................... 

I had to remove the DEFAULT '0'

....another snip from sql...
CREATE TABLE sys_dmail_maillog (
  ....
  KEY rid (rid,rtbl,mid,response_type,uid),
  KEY mid (mid,response_type,rtbl,rid)
............................

It did not like tie last key (mid) and said, there was problems with the sql syntax.

I simply dumped the table from my local dev env, and installed it from there:

CREATE TABLE `sys_dmail_maillog` (
  `uid` int(11) unsigned NOT NULL auto_increment,
  `mid` int(11) unsigned NOT NULL default '0',
  `rid` int(11) unsigned NOT NULL default '0',
  `rtbl` char(1) NOT NULL default '',
  `tstamp` int(11) unsigned NOT NULL default '0',
  `url` tinyblob NOT NULL,
  `size` int(11) unsigned NOT NULL default '0',
  `parsetime` int(11) unsigned NOT NULL default '0',
  `response_type` tinyint(4) NOT NULL default '0',
  `html_sent` tinyint(4) NOT NULL default '0',
  `url_id` tinyint(4) NOT NULL default '0',
  `return_content` mediumblob NOT NULL,
  `return_code` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `rid` (`rid`,`rtbl`,`mid`,`response_type`,`uid`),
  KEY `mid` (`mid`,`response_type`,`rtbl`,`rid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

I tried to follow the (rather confusing) tutorial, did you follow that tutorial in order to install Direct Mail?

Regards,
René

> -----Original Message-----
> From: typo3-english-bounces at lists.netfielders.de 
> [mailto:typo3-english-bounces at lists.netfielders.de] On Behalf 
> Of Kraft Bernhard
> Sent: 12. april 2005 14:03
> To: typo3-english at lists.netfielders.de
> Subject: Re: [Typo3] Direct Mail
> 
> René Schade wrote:
> 
> > Does anyone have any succes installing and using direct 
> mail? Am I using the wrong extension?
> 
> For me Direct Mail worked in 3.7 like a charm. I had some 
> glitches with 3.6 and 3.5 but now it seems most things are fixed ...
> 
> 
> Could you be more precise what exactyl didn't work and where 
> you had to hack to get the extensions installed ?
> 
> 
> greets,
> Bernhard
> --
> Kraft Bernhard
> MOKKA Medienagentur <http://www.mokka.at>
> T: +43 - 1 - 895 33 33 - 50
> _______________________________________________
> Typo3-english mailing list
> Typo3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> 
>