[TYPO3] TYPO3 direct subscription error

[Rocky Ou]

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