SQL Error: 1054

Hallo Forum,

ich habe Tellmatic frisch installiert und alles scheint soweit zu funktionieren, bis ich beim Versand eines NL eine große Fehlerseite erhalte mit der Überschrift

SQL Error: 1054 (Unknown column 'nl_q.nl_id' in 'on clause')

und desweiteren:

Invalid SQL:
            /* insert new adr_id for selected newsletter in newsletter history */
            /* adresses can refer to multiple groups adr_grp.id via adr_grp_ref.adr_id and adr_grp_ref.grp_id (inner join) */
            INSERT INTO
                nl_h
                (
                    q_id, #qeue id
                    #1 AS q_id,
                    host_id, #host id
                    #1 AS host_id,
                    nl_id, #newsletter id
                    #1 AS nl_id,
                    grp_id, #adress group id
                    adr_id, #adress id
                    status, #history status (1=new)
                    created, #creation date
                    sent, #send date
                    siteid #the siteid
                )
            SELECT
                /* we also could use prefined values from php array h, but we use matches */
                /* q_id, host_id from q, nl_id from nl.id, adr_id from adr.id, and grp_id from grp.id */
                /* status, created is taken from array, sent is empty (not sent yet) and siteid as defined in Tellmatic */
                nl_q.id AS q_id,
                nl_q.host_id AS host_id,
                nl.id AS nl_id,
                adr_grp.id AS grp_id,
                adr.id AS adr_id,
                1 AS status,
                '2009-02-02 03:44:07' AS created,
                '' as sent,
                'tellmatic' as siteid
            FROM adr
                /* join adresstable adr.id with groups references table adr_grp_ref.adr_id */
                INNER JOIN adr_grp_ref
                    ON adr.id = adr_grp_ref.adr_id
                /* join groupstable adr_grp.id with groups references table adr_grp_ref.grp_id  */
                INNER JOIN adr_grp
                    ON adr_grp_ref.grp_id = adr_grp.id
                /* join newsletter nl.id with queuetable nl_q.nl_id */
                INNER JOIN nl
                    ON nl_q.nl_id = nl.id
                /* join newsletterqueue nl_q.grp_id with groupstable adr_grp.id */
                INNER JOIN nl_q
                    ON adr_grp.id = nl_q.grp_id
                /* left join now adresstable adr.id with temporary historytable/recipientstable nl_h_tmp_tellmatic_1_1_1_603.adr_id */
                LEFT JOIN nl_h_tmp_tellmatic_1_1_1_603 ON adr.id = nl_h_tmp_tellmatic_1_1_1_603.adr_id
            WHERE
                /* Address is active */
                adr.aktiv=1
                /* for siteid */
                AND adr.siteid='tellmatic'
                AND (
                            /* less errors */
                            adr.errors<=5
                            /* or NULL */
                            OR adr.errors IS NULL
                        )
                AND (
                            /* filter adr with status */
                             adr.status=1
                            OR adr.status=2
                            OR adr.status=3
                            OR adr.status=4
                            OR adr.status=10
                            OR adr.status=12
                        )
                /* for selected group */
                AND adr_grp.id=1
                AND adr_grp_ref.grp_id=1
                AND nl_q.grp_id=1
                AND (
                        /* q status must be 1 new or 2 started */
                        nl_q.status=1
                        OR nl_q.status=2
                        )
                /* group must be active */
                AND adr_grp.aktiv=1
                /* for selected newsletter */
                AND nl.id=1
                AND nl_q.nl_id=1
                /* for siteid */
                AND adr_grp.siteid='tellmatic'
                AND adr_grp_ref.siteid='tellmatic'
                AND nl.siteid='tellmatic'
                AND nl_q.siteid='tellmatic'
                AND
                /* only addresses not included in temporary table */
                nl_h_tmp_tellmatic_1_1_1_603.adr_id IS NULL
               

Zur Zeit gibt es keine zu verarbeitenden Versandaufträge.
Die Seite wird in 300 Sekunden automatisch neu geladen.
Klicken Sie auf 'Neu laden' wenn Sie diese Seite erneut aufrufen wollen.
Neu laden

2009-02-02 03:44:07: Preparing 1 of 1 Qs
begin

2009-02-02 03:44:07: QID=1
2009-02-02 03:44:07: Status=1
2009-02-02 03:44:07: nl_id=1
2009-02-02 03:44:07: grp_id=1
2009-02-02 03:44:07: host_id=1
2009-02-02 03:44:07: send_at=2009-02-02 03:33:00
2009-02-02 03:44:07: autogen=1
2009-02-02 03:44:07: q status=1, q autogen =1, creating recipients list:
2009-02-02 03:44:07:     Error refreshing recipients list!
2009-02-02 03:44:07: q status =1, new status=2, sending mail to admin

Was ist hier falsch / was zu tun?

Viele Grüße -
christian