PHP-Code:
Fatal error: Uncaught exception Exception with message Query error: Unknown column 'm.source' in 'field list' ( SELECT t.*, t.outbox_email as email FROM ( SELECT IFNULL(r.email, m.email) as email, r.salutation as salutation, r.title as title, IFNULL(r.firstname, m.firstname) as firstname, IFNULL(r.lastname, m.lastname) as lastname, IFNULL(r.gender, m.gender) as gender, r.confirmed as confirmed, r.token as token, r.addedOn as addedOn, r.addedBy as addedBy, m.dateOfBirth as dateOfBirth, m.company as company, m.street as street, m.postal as postal, m.city as city, m.state as state, m.country as country, m.phone as phone, m.mobile as mobile, m.fax as fax, m.website as website, m.language as language, m.groups as groups, m.login as login, m.username as username, m.password as password, m.assignDir as assignDir, m.homeDir as homeDir, m.disable as disable, m.start as start, m.stop as stop, m.dateAdded as dateAdded, m.lastLogin as lastLogin, m.avisota_registration_lists as avisota_registration_lists, m.avatar as avatar, m.source as source, m.helpdesk_timezone as helpdesk_timezone, m.helpdesk_role as helpdesk_role, m.helpdesk_showrealname as helpdesk_showrealname, m.helpdesk_showlocation as helpdesk_showlocation, m.helpdesk_signature as helpdesk_signature, m.helpdesk_subscriptions as helpdesk_subscriptions, m.xt_datenschutz as xt_datenschutz, m.xt_tl_member_branche as xt_tl_member_branche, m.xt_tl_member_dialog as xt_tl_member_dialog, m.xt_tl_member_titel as xt_tl_member_titel, m.allowEmail as allowEmail, m.publicFields as publicFields, m.newsletter as newsletter, o.email as outbox_email, o.id as outbox, o.source as outbox_source, SUBSTRING(o.email, LOCATE('@', o.email)) as domain FROM tl_avisota_newsletter_outbox o LEFT JOIN tl_member m ON o.email=m.email AND m.disable='' LEFT JOIN tl_avisota_recipient r ON o.email=r.email AND r.pid = SUBSTRING(o.source, 6) WHERE o.pid='7' AND o.token='2269d5fb46f9c105ca077a3ddb094a0b' AND o.send=0) t GROUP BY domain LIMIT 0,100) thrown in /srv/www/htdocs/system/libraries/Database.php on line 642
#0 /srv/www/htdocs/system/libraries/Database.php(589): Database_Statement->query()
#1 /srv/www/htdocs/system/modules/Avisota/Avisota.php(861): Database_Statement->execute('7', '2269d5fb46f9c10...')
#2 /srv/www/htdocs/system/modules/Avisota/Avisota.php(107): Avisota->outbox()
#3 /srv/www/htdocs/system/modules/backend/Backend.php(186): Avisota->generate()
#4 /srv/www/htdocs/contao/main.php(101): Backend->getBackendModule('avisota_outbox')
#5 /srv/www/htdocs/contao/main.php(304): Main->run()
#6 {main}
Jemand eine Idee, woran das liegen könnte?
Lesezeichen