Oh Mann ist das eine schwere Geburt :-(
Den zusammenhang zwischen pid = 14 im TS und dem Fehler hatte ich natürlich
auch vermutet und diesen entfernt. Sorry, hatte ich nicht so klar gesagt. Anbei
noch mal mein gesamtes TS:
# WEC Map
plugin.tx_wecmap_pi3 {
output >
output = COA
output {
30 = TEXT
30.field = map
30.wrap = |
}
centerLat = 52
centerLong = 11
zoomLevel = 3
maxAutoZoom = 3
showRadiusSearch = 0
tables {
10 {
table = tx_nnaddress_domain_model_address
select =
tx_nnaddress_domain_model_address.*,tx_nnaddress_person_group_mm.*,tx_nnaddress_domain_model_person.*
join = JOIN tx_nnaddress_person_group_mm ON
tx_nnaddress_domain_model_address.person =
tx_nnaddress_person_group_mm.uid_local JOIN tx_nnaddress_domain_model_person ON
tx_nnaddress_domain_model_address.person = tx_nnaddress_domain_model_person.uid
where = tx_nnaddress_person_group_mm.uid_foreign = 1
# LEWA Headquater Marker
icon {
iconID = lewa
imagepath = fileadmin/templates/lewa/Public/Images/lewa_marker.png
#shadowpath = fileadmin/template/worldwide/images/shadow.png
width = 21
height = 31
shadowWidth = 21
shadowHeight = 31
anchorX = 6
anchorY = 20
infoAnchorX = 5
infoAnchorY = 1
}
# config for title
title = COA
title {
10 = TEXT
10.field = person
10.wrap = <h1 style="padding:0;margin:0 0 4px 0;">|</h1>
}
# config for description
description = COA
description {
10 = COA
10 {
10 = TEXT
10.field = street
10.wrap = |�
10.if.isTrue.field = street
15 = TEXT
15.field = street_nr
15.wrap = |<br />
20 = TEXT
20.field = zip
20.wrap = |�
30 = TEXT
30.field = city
30.wrap = |<br />
30.if.isTrue.field = city
40 = TEXT
40.field = country
40.wrap = |
40.if.isTrue.field = country
#50 = TEXT
#50.value = Phone: {field:phone}
#50.wrap = <br />|
#50.if.isTrue.field = phone
#50.insertData = true
#55 = TEXT
#55.field = email
#55.wrap = <br /><a href="mailto:|">eMail</a>�
#55.if.isTrue.field = email
#56 = TEXT
#56.field = website
#56.wrap = - <a href="http://|">Website</a>
#56.if.isTrue.field = website
}
10.wrap = <div class="description">|</div>
}
}
}
Ich hatte auch schon versucht aus der adress und person Tabelle die Spalten
einzeln auszuwählen aber ohne Erfolg.
Die gesamte SQL Abfrage aus dem Typo3 Debug lautet:
SELECT
tx_nnaddress_domain_model_address.*,tx_nnaddress_person_group_mm.*,tx_nnaddress_domain_model_person.uid
FROM tx_nnaddress_domain_model_address JOIN tx_nnaddress_person_group_mm ON
tx_nnaddress_domain_model_address.person = tx_nnaddress_person_group_mm.uid_local JOIN
tx_nnaddress_domain_model_person ON tx_nnaddress_domain_model_address.person =
tx_nnaddress_domain_model_person.uid WHERE tx_nnaddress_person_group_mm.uid_foreign = 1 AND
pid IN (14) AND tx_nnaddress_domain_model_address.deleted=0 AND
tx_nnaddress_domain_model_address.t3ver_state<=0 AND
tx_nnaddress_domain_model_address.pid<>-1 AND tx_nnaddress_domain_model_address.hidden=0
AND tx_nnaddress_domain_model_address.starttime<=1413541320 AND
(tx_nnaddress_domain_model_address.endtime=0 OR
tx_nnaddress_domain_model_address.endtime>1413541320)
Ab AND pid IN (14) ist wohl von WEC Map hinzugefügt auffällig hier eventl. AND pid IN
(14) und AND tx_nnaddress_domain_model_address.pid<>-1
Sorry das ich die so quäle!
Gruß
Stefan
_______________________________________________
TYPO3-german mailing list
TYPO3-german@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-german
