[TYPO3-german] WEC Map und NN Address

Stefan Wobbe stefan.wobbe at versanet.de
Fri Oct 17 12:41:15 CEST 2014


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


More information about the TYPO3-german mailing list