[TYPO3] TYPO3 direct subscription error

[Rocky Ou]

Rocky Ou wrote:
> Hey List,
> 
> I'm using TYPO3 4.0.4, direct_mail_subscription 1.1.0 and direct_mail 
> 2.2.0. I add the direct_mail_subscription in the page content. The front 
> end shows the newsletter subscription form without any problem. But 
> after I filled in the form and hit subscribe button I got the error 
> message:
> -------------------------Error message begins------------------
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL 
> result resource in 
> /home/angnews/public_html/typo3_src/t3lib/class.t3lib_db.php on line 802
> 
> Warning: Cannot modify header information - headers already sent by 
> (output started at 
> /home/angnews/public_html/typo3_src/t3lib/class.t3lib_db.php:802) in 
> /home/angnews/public_html/typo3_src/typo3/sysext/cms/tslib/class.tslib_fe.php 
> on line 2853
> ----------------------Error message end--------------------------
> The page content says:
>       
> Newsletter subscription
> Subscription recieved.
> 
> You're now subscribed to our newsletter. An email has been sent to your 
> email address, ###FIELD_email###, with a link to the administration of 
> your profile.
> Please notice that your subscription is not active until you've clicked 
> a link in that email!
> 
> But I never received the confirm email and the back-end of the 
> subscription page does not have address records in list module as well.
> 
>  From backend Tools-->DB check-->Manage Reference Index-->Update Now! 
> gave me the following error.
> 
> Warning: Invalid argument supplied for foreach() in 
> /home/angnews/public_html/typo3_src/t3lib/class.t3lib_refindex.php on 
> line 656
> 
> Plus from backend Web-->list-->any page the system gave me the error 
> read as:
> 
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result 
> resource in /home/angnews/public_html/typo3_src/t3lib/class.t3lib_db.php 
> on line 790
> 
> Warning: Cannot modify header information - headers already sent by 
> (output started at 
> /home/angnews/public_html/typo3_src/t3lib/class.t3lib_db.php:790) in 
> /home/angnews/public_html/typo3_src/typo3/template.php on line 613
> 
> 
> Can any of you give me some help on how to make the newsletter 
> subscription work please?
> 
> Thanks a lot in advance!
> 
> Blessings,
> Rocky
Hey all,

It turns out the TYPO3 installation is bad. For some reason, It seems 
Fantastico does not work well with TYPO3.

Blessings,
Rocky