[TYPO3-english] Unsubscribe link problem

[Tomiţă MILITARU]

Ok, here are some errors:
When clicking on Recipient List:
caller t3lib_DB::exec_SELECTquery
 ERROR Unknown column 'tt_address.uid' in 'field list'
 lastBuiltQuery SELECT DISTINCT tt_address.uid
FROM tt_address
WHERE
tt_address.pid IN(30) AND tt_address.email !='' AND tt_address.hidden=0 AND
tt_address.deleted=0
 debug_backtrace tx_directmail_recipient_list->main#54 //
tx_directmail_recipient_list->moduleContent#245 //
tx_directmail_recipient_list->mailModule_main#308 //
tx_directmail_recipient_list->cmd_recip#342 //
tx_directmail_recipient_list->cmd_compileMailGroup#376 //
tx_directmail_static->getIdList#475 // t3lib_DB->exec_SELECTquery#278 //
t3lib_DB->debug#234
This error appears everywhere where Direct Mail / Subscription is used, even
when choosing the List view for the sysfolder. Also when seeing a list of
recipients or creating a list of subscribers. Hope this helps.

On Mon, Oct 5, 2009 at 9:44 AM, Bernhard Kraft <kraftb at kraftb.at> wrote:

> Tomiţă MILITARU schrieb:
> > Thank you Bernhard,
> > I'm out of ideas ... something I forgot to mention in my email was that
> > everywhere in the backend where its about Direct Mail I get PHP errors
> when
> > fetching from the database, like this:
> > *Warning*: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> > result resource in */srv/
> > domain.ro/prerelease/htdocs/tomita/typo/t3lib/class.t3lib_db.php* on
> line *
> > 809
> >
> > *This error appears when I want to see the recipient list or what to make
> a
> > new reciepient list from a page. I guess there might be missing some
> columns
> > in the databases of tt_address or something like that, do you think I
> should
> > reinstall typo or the extension related to the newsletter ?
>
> Usually you do not need to reinstall any extensions. First try to set
> enable/set the options
>
> "sqlDebug"
> "devIPmask"
>
> in the install Tool. This should give you more detailed output what went
> wrong. Post the results here.
>
>
> greets,
> Bernhard
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>



-- 
Tomiţă MILITARU
AIESEC Sibiu Member
Board Member SbLUG
Junior Java Developer
Tel. +40741064681