Zum Inhalt springen
Anbindung eines Gambio-Onlineshops an die VARIO 8
  • 0

Bestellungen werden nicht abgeholt

Rene

Gefragt von Rene,

 Teilen

Frage

Rene Rookie

Rene

Geschrieben
Geschrieben

Hallo Forum,

nun mit Hilfe habe ich es hinbekommen das der Gambio Shop GX3 3.10.1 mit der Vario verbunden wird. Ich kann Artikel hochladen und Kategorien erstellen, das Funktioniert.

Nun habe ich eine Testbestellung im Shop gemacht, diese wird von der Vario jedoch nicht importiert... Die Exportfiles werden auf dem Server unter /export/vario/files angelegt und sind mit 777 für alle erreichbar.

Hab ich etwas vergessen?

 

Link zu diesem Kommentar
Auf anderen Seiten teilen

10 Antworten auf diese Frage

Empfohlene Beiträge

  • 0
Rene Rookie

Rene

Geschrieben
  • Autor
Geschrieben
Zitat

29.08.2018 15:59:11 Datenbank Version 8.0.61.8
29.08.2018 15:59:12 Replikationsserver Version 8.0.61.3
29.08.2018 15:59:12 Repliziere Filiale 901 'GX3 Shop' (FIL_ID: 4) 
29.08.2018 15:59:12 Sperre Filiale 901 'GX3 Shop' (FIL_ID: 4) für exklusiven Zugriff
29.08.2018 15:59:12 Shop-Replikation xtc/Gambio
29.08.2018 15:59:12 Download aktiv.
29.08.2018 15:59:12 Prüfe lokale Download-Pfade
29.08.2018 15:59:12 Rufe 'https://dev-gx310.eshop-source.de/admin/vario_export7.php?' auf
29.08.2018 15:59:13 Upload aktiv.
29.08.2018 15:59:13 Prüfe lokale Upload-Pfade
29.08.2018 15:59:13 Erzeuge zu replizierende Daten ....
29.08.2018 15:59:13 Verdichte zu replizierende Daten
29.08.2018 15:59:13 Entsperre Filiale 901 'GX3 Shop' (FIL_ID: 4) vom exklusiven Zugriff
29.08.2018 15:59:13 Replikation beendet.
29.08.2018 15:59:13 Starte automatischen Import...

das ist das Log vom Replikationsserver.

Link zu diesem Kommentar
Auf anderen Seiten teilen
  • 0
Rene Rookie

Rene

Geschrieben
  • Autor
Geschrieben 
29.08.2018 16:48:48 [Replizieren.] Datenbank Version 8.0.61.8
29.08.2018 16:48:50 [RepliziereShop.] Replikationsserver Version 8.0.61.3
29.08.2018 16:48:50 [RepliziereShop.] Repliziere Filiale 901 'GX3 Shop' (FIL_ID: 4) 
29.08.2018 16:48:50 [RepliziereShop.] Sperre Filiale 901 'GX3 Shop' (FIL_ID: 4, 'RS.EXE') für exklusiven Zugriff
29.08.2018 16:48:50 [RepliziereShop.CreateTxtcShopReplikation] Shop-Replikation xtc/Gambio
29.08.2018 16:48:50 [RepliziereShop.aShop.Downloaden] Download aktiv.
29.08.2018 16:48:50 [CheckDownloadPaths.] Prüfe lokale Download-Pfade
29.08.2018 16:48:50 [HTTPDownload.] Rufe 'https://dev-gx310.eshop-source.de/admin/vario_export7.php?&Verbose' auf
29.08.2018 16:48:50 [HTTPDownload.] Ergebnis HTTP-Aufruf: <pre>START adr_export: 2-400210</pre><pre>--> START select_customers_data: 2</pre><pre>--> ENDE select_customers_data: Array
(
    [customers_id] => 2
    [customers_cid] => 2
    [customers_vat_id] => 
    [customers_status] => 1
    [customers_gender] => f
    [customers_firstname] => Susi
    [customers_lastname] => Sonnenschein
    [customers_email_address] => test@eshop-source.com
    [customers_telephone] => 0123456789
    [account_type] => 1
    [refferers_id] => 0
    [customers_date_added] => 2018-08-29 12:19:46
    [customers_last_modified] => 2018-08-29 16:48:39
    [entry_gender] => f
    [entry_company] => 
    [entry_firstname] => Susi
    [entry_lastname] => Sonnenschein
    [entry_street_address] => Magdaleenstr. 13 
    [entry_suburb] => 
    [entry_postcode] => 01458
    [entry_city] => Ottendorf-Okrilla
    [entry_state] => 
    [entry_country_id] => 81
    [address_date_added] => 2018-08-29 12:19:46
    [address_last_modified] => 2018-08-29 12:19:46
    [countries_iso_code_2] => DE
    [customers_status_name] => Gast
    [customers_status_show_price_tax] => 1
    [customers_status_add_tax_ot] => 1
    [banktransfer_owner] => 
    [banktransfer_number] => 
    [banktransfer_bankname] => 
    [banktransfer_blz] => 
    [cc_number] => 
    [cc_cvv] => 123
    [cc_start] => 
    [cc_expires] => 
    [cc_owner] => 
    [BELEG_KUNDE] => BELEG
    [BXX] => B01
    [DXX] => D01
    [PREISGRUPPE] => 1
    [vertreter1] => 
)
</pre><pre>--> START assign_field_values (id): 2</pre><pre>--> ENDE assign_field_values: Array
(
    [1] => Array
        (
            [WEB_ID] => 2
            [WEB_ADRESSNR] => 2
            [KUNDENNR] => 2
            [KUNDEJN] => J
            [ANREDE] => Frau
            [NAME1] => Sonnenschein, Susi
            [NAME2] => 
            [NAME3] => 
            [STRASSE] => Magdaleenstr. 13 
            [LKZ] => DE
            [PLZ] => 01458
            [ORT] => Ottendorf-Okrilla
            [TELEFON1] => 0123456789
            [EMAIL] => test@eshop-source.com
            [INTERNETJN] => N
            [TELEFAX1] => 
            [USTIDNR] => 
            [FAKTURIERUNGSART] => 1
            [OHNEMWST] => N
            [PREISGRUPPE] => 1
            [KONTOINHABER] => 
            [KONTONR] => 
            [BANK] => 
            [BLZ] => 
            [KK_NR] => 
            [KK_MOPS] => 123
            [KK_GUELTIG_VON] => 
            [KK_GUELTIG_BIS] => 
            [KK_INHABER] => 
            [KK_INSTITUT] => 
            [ERSTKONTAKTAM] => 29.08.2018
            [ERSTKONTAKTBEM] => 
            [B01] => N
            [D01] => 29.08.2018
            [WEB_KENNWORT_MD5] => 
            [ANG_AM] => 29.08.2018
            [ANG_VON] => VAE
            [GEA_AM] => 29.08.2018
            [GEA_VON] => VAE
            [VERTRETER1] => 
            [VERSION] => 8.0.000.000
            [VERSION_INFO] => GAMBIOGX2
        )

)
</pre><pre> ENDE adr_export: Array
(
    [export_view] => Array
        (
            [fields] => Array
                (
                    [0] => Array
                        (
                            [source] => customers_id
                            [destination] => WEB_ID
                            [default] => 
                            [function] => 
                        )

                    [1] => Array
                        (
                            [source] => customers_id
                            [destination] => WEB_ADRESSNR
                            [default] => 
                            [function] => 
                        )

                    [2] => Array
                        (
                            [source] => customers_cid
                            [destination] => KUNDENNR
                            [default] => 
                            [function] => get_kundennr($this->ds)
                        )

                    [3] => Array
                        (
                            [source] => 
                            [destination] => KUNDEJN
                            [default] => J
                            [function] => 
                        )

                    [4] => Array
                        (
                            [source] => entry_gender
                            [destination] => ANREDE
                            [default] => 
                            [function] => get_anrede($this->ds)
                        )

                    [5] => Array
                        (
                            [source] => entry_company
                            [destination] => NAME1
                            [default] => 
                            [function] => get_nameX(1, $this->ds)
                        )

                    [6] => Array
                        (
                            [source] => entry_firstname
                            [destination] => NAME2
                            [default] => 
                            [function] => get_nameX(2, $this->ds)
                        )

                    [7] => Array
                        (
                            [source] => entry_lastname
                            [destination] => NAME3
                            [default] => 
                            [function] => get_nameX(3, $this->ds)
                        )

                    [8] => Array
                        (
                            [source] => entry_street_address
                            [destination] => STRASSE
                            [default] => 
                            [function] => 
                        )

                    [9] => Array
                        (
                            [source] => countries_iso_code_2
                            [destination] => LKZ
                            [default] => 
                            [function] => 
                        )

                    [10] => Array
                        (
                            [source] => entry_postcode
                            [destination] => PLZ
                            [default] => 
                            [function] => 
                        )

                    [11] => Array
                        (
                            [source] => entry_city
                            [destination] => ORT
                            [default] => 
                            [function] => 
                        )

                    [12] => Array
                        (
                            [source] => customers_telephone
                            [destination] => TELEFON1
                            [default] => 
                            [function] => 
                        )

                    [13] => Array
                        (
                            [source] => customers_email_address
                            [destination] => EMAIL
                            [default] => 
                            [function] => 
                        )

                    [14] => Array
                        (
                            [source] => 
                            [destination] => INTERNETJN
                            [default] => J
                            [function] => check_kundenkonto($this->ds)
                        )

                    [15] => Array
                        (
                            [source] => customers_fax
                            [destination] => TELEFAX1
                            [default] => 
                            [function] => 
                        )

                    [16] => Array
                        (
                            [source] => customers_vat_id
                            [destination] => USTIDNR
                            [default] => 
                            [function] => 
                        )

                    [17] => Array
                        (
                            [source] => 
                            [destination] => FAKTURIERUNGSART
                            [default] => 
                            [function] => $this->getFakturierungsart()
                        )

                    [18] => Array
                        (
                            [source] => 
                            [destination] => OHNEMWST
                            [default] => 
                            [function] => $this->getOhneMwst()
                        )

                    [19] => Array
                        (
                            [source] => customers_vat_id
                            [destination] => USTIDNR
                            [default] => 
                            [function] => 
                        )

                    [20] => Array
                        (
                            [source] => PREISGRUPPE
                            [destination] => PREISGRUPPE
                            [default] => 
                            [function] => $this->GetVARIOPreisgruppe()
                        )

                    [21] => Array
                        (
                            [source] => banktransfer_owner
                            [destination] => KONTOINHABER
                            [default] => 
                            [function] => 
                        )

                    [22] => Array
                        (
                            [source] => banktransfer_number
                            [destination] => KONTONR
                            [default] => 
                            [function] => 
                        )

                    [23] => Array
                        (
                            [source] => banktransfer_bankname
                            [destination] => BANK
                            [default] => 
                            [function] => 
                        )

                    [24] => Array
                        (
                            [source] => banktransfer_blz
                            [destination] => BLZ
                            [default] => 
                            [function] => 
                        )

                    [25] => Array
                        (
                            [source] => cc_number
                            [destination] => KK_NR
                            [default] => 
                            [function] => 
                        )

                    [26] => Array
                        (
                            [source] => cc_cvv
                            [destination] => KK_MOPS
                            [default] => 
                            [function] => 
                        )

                    [27] => Array
                        (
                            [source] => cc_start
                            [destination] => KK_GUELTIG_VON
                            [default] => 
                            [function] => 
                        )

                    [28] => Array
                        (
                            [source] => cc_expires
                            [destination] => KK_GUELTIG_BIS
                            [default] => 
                            [function] => 
                        )

                    [29] => Array
                        (
                            [source] => cc_owner
                            [destination] => KK_INHABER
                            [default] => 
                            [function] => 
                        )

                    [30] => Array
                        (
                            [source] => 
                            [destination] => KK_INSTITUT
                            [default] => 
                            [function] => 
                        )

                    [31] => Array
                        (
                            [source] => customers_date_added
                            [destination] => ERSTKONTAKTAM
                            [default] => 
                            [function] => xtc_date_to_vario_date
                        )

                    [32] => Array
                        (
                            [source] => customers_host
                            [destination] => ERSTKONTAKTBEM
                            [default] => 
                            [function] => 
                        )

                    [33] => Array
                        (
                            [source] => customers_newsletter
                            [destination] => B01
                            [default] => 
                            [function] => xtc_bool_to_vario_bool
                        )

                    [34] => Array
                        (
                            [source] => customers_dob
                            [destination] => D01
                            [default] => 
                            [function] => xtc_date_to_vario_date
                        )

                    [35] => Array
                        (
                            [source] => customers_password
                            [destination] => WEB_KENNWORT_MD5
                            [default] => 
                            [function] => 
                        )

                    [36] => Array
                        (
                            [source] => customers_date_added
                            [destination] => ANG_AM
                            [default] => 
                            [function] => xtc_date_to_vario_date
                        )

                    [37] => Array
                        (
                            [source] => 
                            [destination] => ANG_VON
                            [default] => VAE
                            [function] => 
                        )

                    [38] => Array
                        (
                            [source] => address_last_modified
                            [destination] => GEA_AM
                            [default] => 
                            [function] => xtc_date_to_vario_date
                        )

                    [39] => Array
                        (
                            [source] => 
                            [destination] => GEA_VON
                            [default] => VAE
                            [function] => 
                        )

                    [40] => Array
                        (
                            [source] => vertreter1
                            [destination] => VERTRETER1
                            [default] => 
                            [function] => 
                        )

                    [41] => Array
                        (
                            [source] => 
                            [destination] => VERSION
                            [default] => 8.0.000.000
                            [function] => 
                        )

                    [42] => Array
                        (
                            [source] => 
                            [destination] => VERSION_INFO
                            [default] => GAMBIOGX2
                            [function] => 
                        )

                )

        )

)
</pre><pre>START export_order: 400210</pre><pre>START bek_export: 2-400210</pre><pre>--> START select_customers_data: 2</pre><pre>--> ENDE select_customers_data: Array
(
    [customers_id] => 2
    [customers_cid] => 2
    [customers_vat_id] => 
    [customers_status] => 1
    [customers_gender] => f
    [customers_firstname] => Susi
    [customers_lastname] => Sonnenschein
    [customers_email_address] => test@eshop-source.com
    [customers_telephone] => 0123456789
    [account_type] => 1
    [refferers_id] => 0
    [customers_date_added] => 2018-08-29 12:19:46
    [customers_last_modified] => 2018-08-29 16:48:39
    [entry_gender] => f
    [entry_company] => 
    [entry_firstname] => Susi
    [entry_lastname] => Sonnenschein
    [entry_street_address] => Magdaleenstr. 13 
    [entry_suburb] => 
    [entry_postcode] => 01458
    [entry_city] => Ottendorf-Okrilla
    [entry_state] => 
    [entry_country_id] => 81
    [address_date_added] => 2018-08-29 12:19:46
    [address_last_modified] => 2018-08-29 12:19:46
    [countries_iso_code_2] => DE
    [customers_status_name] => Gast
    [customers_status_show_price_tax] => 1
    [customers_status_add_tax_ot] => 1
    [banktransfer_owner] => 
    [banktransfer_number] => 
    [banktransfer_bankname] => 
    [banktransfer_blz] => 
    [cc_number] => 
    [cc_cvv] => 123
    [cc_start] => 
    [cc_expires] => 
    [cc_owner] => 
    [BELEG_KUNDE] => BELEG
    [BXX] => B01
    [DXX] => D01
    [PREISGRUPPE] => 1
    [vertreter1] => 
)
</pre><pre>--> START select_orders_data: 400210</pre><pre>--> ENDE select_orders_data: Array
(
    [orders_id] => 400210
    [customers_id] => 2
    [customers_cid] => 2
    [customers_vat_id] => 
    [customers_status] => 1
    [customers_status_name] => Gast
    [customers_status_discount] => 0.00
    [customers_name] => Susi Sonnenschein
    [customers_firstname] => Susi
    [customers_lastname] => Sonnenschein
    [customers_company] => 
    [customers_street_address] => Magdaleenstr. 13 
    [customers_city] => Ottendorf-Okrilla
    [customers_postcode] => 01458
    [customers_country] => Germany
    [customers_country_iso_code_2] => DE
    [customers_telephone] => 0123456789
    [customers_email_address] => test@eshop-source.com
    [customers_address_format_id] => 5
    [delivery_name] => Susi Sonnenschein
    [delivery_firstname] => Susi
    [delivery_lastname] => Sonnenschein
    [delivery_company] => 
    [delivery_street_address] => Magdaleenstr. 13 
    [delivery_city] => Ottendorf-Okrilla
    [delivery_postcode] => 01458
    [delivery_country] => Germany
    [delivery_country_iso_code_2] => DE
    [delivery_address_format_id] => 5
    [billing_name] => Susi Sonnenschein
    [billing_firstname] => Susi
    [billing_lastname] => Sonnenschein
    [billing_company] => 
    [billing_street_address] => Magdaleenstr. 13 
    [billing_city] => Ottendorf-Okrilla
    [billing_postcode] => 01458
    [billing_country] => Germany
    [billing_country_iso_code_2] => DE
    [billing_address_format_id] => 5
    [delivery_suburb] => 
    [payment_method] => invoice
    [cc_type] => 
    [cc_owner] => 
    [cc_number] => 
    [cc_expires] => 
    [cc_start] => 
    [cc_issue] => 
    [cc_cvv] => 123
    [comments] => 
    [last_modified] => 2018-08-29 16:48:39
    [date_purchased] => 2018-08-29 14:19:45
    [orders_status] => 1
    [orders_date_finished] => 
    [currency] => EUR
    [currency_value] => 1.00000000
    [account_type] => 1
    [payment_class] => invoice
    [shipping_method] => Deutsche Post (Versand nach DE:  (1 x 2 kg))
    [shipping_class] => dp_dp
    [customers_ip] => 
    [language] => german
    [refferers_id] => 0
    [conversion_type] => 1
    [orders_ident_key] => 
    [customers_status_id] => 1
    [customers_status_show_price_tax] => 1
    [BELEG_KUNDE] => BELEG
    [PREISGRUPPE] => 1
)
</pre><pre>      bek_export-brutto: 1</pre><pre>--> START assign_field_values (id): 400210</pre><pre>BEK_EXPORT: getFrachtkosten - ot_shipping: 6.7000</pre><pre>BEK_EXPORT: getFrachtkosten - ot_loworderfee: </pre><pre>BEK_EXPORT: getFrachtkosten - ot_shipping: 6.7000</pre><pre>BEK_EXPORT: getFrachtkosten - ot_shipping: 6.7000</pre><pre>BEK_EXPORT: getFrachtkosten - ot_loworderfee: </pre><pre>BEK_EXPORT: getFrachtkosten - ot_shipping: 6.7000</pre><pre>--> ENDE assign_field_values: Array
(
    [1] => Array
        (
            [WEB_ID] => 400210
            [BELEGNR] => T0400210
            [BELEGART] => 00
            [BELEGSCHLUESSEL] => 00T0400210
            [BETREFF] => 400210
            [WEB_ADRESSNR] => 2
            [KUNDENNR] => 2
            [NAMEZEILE1] => Frau
            [NAMEZEILE2] => Susi Sonnenschein
            [NAMEZEILE3] => Magdaleenstr. 13
            [NAMEZEILE4] => 
            [NAMEZEILE5] => DE 01458 Ottendorf-Okrilla
            [NAMEZEILE6] => 
            [NAMEZEILE7] => 
            [ANREDE] => Frau
            [FIRMA] => 
            [VORNAME] => Susi
            [NACHNAME] => Sonnenschein
            [STRASSE] => Magdaleenstr. 13 
            [PLZ] => 01458
            [ORT] => Ottendorf-Okrilla
            [LKZ] => DE
            [LAND] => Germany
            [TELEFON1] => 0123456789
            [EMAIL] => test@eshop-source.com
            [WEB_EMAIL] => test@eshop-source.com
            [USTNR] => 
            [LSNAME1] => Frau
            [LSNAME2] => Susi Sonnenschein
            [LSNAME3] => Magdaleenstr. 13
            [LSNAME4] => 
            [LSNAME5] => DE 01458 Ottendorf-Okrilla
            [LSNAME6] => 
            [LSNAME7] => 
            [LS_ANREDE] => Frau
            [LS_FIRMA] => 
            [LS_VORNAME] => Susi
            [LS_NACHNAME] => Sonnenschein
            [LS_STRASSE] => Magdaleenstr. 13 
            [LS_PLZ] => 01458
            [LS_ORT] => Ottendorf-Okrilla
            [LS_LKZ] => DE
            [LS_LAND] => Germany
            [RENAME1] => Frau
            [RENAME2] => Susi Sonnenschein
            [RENAME3] => Magdaleenstr. 13
            [RENAME4] => 
            [RENAME5] => DE 01458 Ottendorf-Okrilla
            [RENAME6] => 
            [RENAME7] => 
            [RE_ANREDE] => Frau
            [RE_FIRMA] => 
            [RE_VORNAME] => Susi
            [RE_NACHNAME] => Sonnenschein
            [RE_STRASSE] => Magdaleenstr. 13 
            [RE_PLZ] => 01458
            [RE_ORT] => Ottendorf-Okrilla
            [RE_LKZ] => DE
            [RE_LAND] => Germany
            [BELEGSTATUS] => 1
            [BESTELLUNGVOM] => 29.08.2018
            [WAEHRUNG] => EUR
            [FAKTURIERUNGSART] => 1
            [OHNEMWST] => N
            [PREISGRUPPE] => 1
            [BETRAGBRUTTO] => 76,7000
            [RABATT1] => 
            [RABATT1TEXT] => 
            [RABATT1BETRAG] => 
            [RABATT2] => 
            [RABATT2TEXT] => 
            [RABATT2BETRAG] => 
            [VERSICHERUNGBRUTTO] => 0
            [FRACHTKOSTENBRUTTO] => 6,7000
            [FRACHTKOSTENMANUELL] => J
            [NACHNAHMEBRUTTO] => 
            [ZAHLART] => invoice
            [LIEFERBEDINGUNG] => dp
            [BEMERKUNG] => 
            [EIGENEBEMERKUNG] => 2018-08-29 12:19:54: Bestellung 400210 f
, 2018-08-29 14:21:44: Bestellung 400210 f
, 2018-08-29 14:48:13: Bestellung 400210 f

            [BESTELLT_AM] => 29.08.2018
            [ANG_AM] => 29.08.2018
            [ANG_VON] => BEB
            [TRANSAKTIONSTYP] => 0
            [TRANSAKTIONSNUMMER] => 400210
            [VERSION] => 8.0.000.000
            [VERSION_INFO] => GAMBIOGX2
            [PAYMENT_EXT_REFERENZ] => 
        )

)
</pre><pre> ENDE bek_export: </pre><pre>START bep_export: 400210-1(1)</pre><pre>--> START select_orders_products_data: 1</pre><pre>         select_orders_products_data - sql: 
select distinct 
    op.orders_products_id
  , op.orders_id
  , op.products_id
  , coalesce(ppc.combi_model, op.products_model) as products_model
  , coalesce(vart.artikelbezeichnung1, op.products_name) as products_name
  , op.products_quantity
  , op.products_price
  , op.products_discount_made
  , op.final_price  
  , op.products_tax
  , op.allow_tax

  , cs.customers_status_show_price_tax

  from orders_products op
  left join orders_products_properties opp on opp.orders_products_id = op.orders_products_id
  left join products_properties_combis ppc on ppc.products_properties_combis_id = opp.products_properties_combis_id
  left join vario_art vart on vart.artikelnr = ppc.combi_model

  left join orders o on op.orders_id = o.orders_id
  left join customers_status cs on o.customers_status = cs.customers_status_id

 where op.orders_products_id = 1 limit 0,1</pre><pre>--> ENDE select_orders_products_data: Array
(
    [orders_products_id] => 1
    [orders_id] => 400210
    [products_id] => 4
    [products_model] => 301
    [products_name] => Zweite Hängematte, klein
    [products_quantity] => 1.0000
    [products_price] => 10.0000
    [products_discount_made] => 0.00
    [final_price] => 10.0000
    [products_tax] => 19.0000
    [allow_tax] => 1
    [customers_status_show_price_tax] => 1
)
</pre><pre>--> START assign_field_values (id): 400210</pre><pre>--> ENDE assign_field_values: Array
(
    [1] => Array
        (
            [WEB_BEK_ID] => 400210
            [WEB_ID] => 1
            [SCHLUESSEL] => 00T0400210000001
            [BELEGSCHLUESSEL] => 00T0400210
            [BELEGNR] => T0400210
            [BELEGART] => 00
            [POART] => A
            [PO] => 1
            [PE] => 1
            [ARTIKELNR] => 301
            [BEZEICHNUNG] => Zweite Hängematte, klein
            [LANGTEXT] => 
            [MENGE] => 1,0000
            [EINZELPREISBRUTTO] => 10
            [RABATT] => 0
            [GESAMTPREISBRUTTO] => 10
            [VERSION] => 8.0.000.000
            [VERSION_INFO] => GAMBIOGX2
        )

)
</pre><pre> ENDE bep_export: </pre><pre>START bep_export: 400210-2(2)</pre><pre>--> START select_orders_products_data: 2</pre><pre>         select_orders_products_data - sql: 
select distinct 
    op.orders_products_id
  , op.orders_id
  , op.products_id
  , coalesce(ppc.combi_model, op.products_model) as products_model
  , coalesce(vart.artikelbezeichnung1, op.products_name) as products_name
  , op.products_quantity
  , op.products_price
  , op.products_discount_made
  , op.final_price  
  , op.products_tax
  , op.allow_tax

  , cs.customers_status_show_price_tax

  from orders_products op
  left join orders_products_properties opp on opp.orders_products_id = op.orders_products_id
  left join products_properties_combis ppc on ppc.products_properties_combis_id = opp.products_properties_combis_id
  left join vario_art vart on vart.artikelnr = ppc.combi_model

  left join orders o on op.orders_id = o.orders_id
  left join customers_status cs on o.customers_status = cs.customers_status_id

 where op.orders_products_id = 2 limit 0,1</pre><pre>--> ENDE select_orders_products_data: Array
(
    [orders_products_id] => 2
    [orders_id] => 400210
    [products_id] => 3
    [products_model] => 2
    [products_name] => Hängematte
    [products_quantity] => 1.0000
    [products_price] => 45.0000
    [products_discount_made] => 0.00
    [final_price] => 45.0000
    [products_tax] => 19.0000
    [allow_tax] => 1
    [customers_status_show_price_tax] => 1
)
</pre><pre>--> START assign_field_values (id): 400210</pre><pre>--> ENDE assign_field_values: Array
(
    [1] => Array
        (
            [WEB_BEK_ID] => 400210
            [WEB_ID] => 2
            [SCHLUESSEL] => 00T0400210000002
            [BELEGSCHLUESSEL] => 00T0400210
            [BELEGNR] => T0400210
            [BELEGART] => 00
            [POART] => A
            [PO] => 2
            [PE] => 1
            [ARTIKELNR] => 2
            [BEZEICHNUNG] => Hängematte
            [LANGTEXT] => 
            [MENGE] => 1,0000
            [EINZELPREISBRUTTO] => 45
            [RABATT] => 0
            [GESAMTPREISBRUTTO] => 45
            [VERSION] => 8.0.000.000
            [VERSION_INFO] => GAMBIOGX2
        )

)
</pre><pre> ENDE bep_export: </pre><pre>START bep_export: 400210-3(3)</pre><pre>--> START select_orders_products_data: 3</pre><pre>         select_orders_products_data - sql: 
select distinct 
    op.orders_products_id
  , op.orders_id
  , op.products_id
  , coalesce(ppc.combi_model, op.products_model) as products_model
  , coalesce(vart.artikelbezeichnung1, op.products_name) as products_name
  , op.products_quantity
  , op.products_price
  , op.products_discount_made
  , op.final_price  
  , op.products_tax
  , op.allow_tax

  , cs.customers_status_show_price_tax

  from orders_products op
  left join orders_products_properties opp on opp.orders_products_id = op.orders_products_id
  left join products_properties_combis ppc on ppc.products_properties_combis_id = opp.products_properties_combis_id
  left join vario_art vart on vart.artikelnr = ppc.combi_model

  left join orders o on op.orders_id = o.orders_id
  left join customers_status cs on o.customers_status = cs.customers_status_id

 where op.orders_products_id = 3 limit 0,1</pre><pre>--> ENDE select_orders_products_data: Array
(
    [orders_products_id] => 3
    [orders_id] => 400210
    [products_id] => 1
    [products_model] => s-gold
    [products_name] => Testartikel
    [products_quantity] => 1.0000
    [products_price] => 15.0000
    [products_discount_made] => 0.00
    [final_price] => 15.0000
    [products_tax] => 19.0000
    [allow_tax] => 1
    [customers_status_show_price_tax] => 1
)
</pre><pre>--> START assign_field_values (id): 400210</pre><pre>--> ENDE assign_field_values: Array
(
    [1] => Array
        (
            [WEB_BEK_ID] => 400210
            [WEB_ID] => 3
            [SCHLUESSEL] => 00T0400210000003
            [BELEGSCHLUESSEL] => 00T0400210
            [BELEGNR] => T0400210
            [BELEGART] => 00
            [POART] => A
            [PO] => 3
            [PE] => 1
            [ARTIKELNR] => s-gold
            [BEZEICHNUNG] => Testartikel
            [LANGTEXT] => 
            [MENGE] => 1,0000
            [EINZELPREISBRUTTO] => 15
            [RABATT] => 0
            [GESAMTPREISBRUTTO] => 15
            [VERSION] => 8.0.000.000
            [VERSION_INFO] => GAMBIOGX2
        )

)
</pre><pre> ENDE bep_export: </pre><pre> ENDE export_order: 400210</pre><style type="text/css">
						.gambio_error_box {
							font-size: 1em !important;
							color:  black !important;
							margin: 0 !important;
							padding: 0 !important;
							display: block;
						}
						
						.gambio_error_box a.unfolder {
							color: #000000 !important;
							text-decoration: none !important;
							outline: none !important;
							font-family: monospace !important;
							font-size: 12px !important;
						}
						
						.gambio_error_box a.unfolder:hover {
							color: #0000FF !important;
							text-decoration: underline !important;
						}
						
						.gambio_error_box.head.error {
							background-color: #ff9797 !important;
						}
						
						.gambio_error_box.details.error {
							background-color: #ffcaca !important;
						}
						
						.gambio_error_box.subdetails.error {
							background-color: #ffdddd !important;
						}
						
						.gambio_error_box.head.warning {
							background-color: #eecc88 !important;
						}
						
						.gambio_error_box.details.warning {
							background-color: #ffeeaa !important;
						}
						
						.gambio_error_box.subdetails.warning {
							background-color: #fff5cc !important;
						}
						
						.gambio_error_box.head.notice {
							background-color: #9797ff !important;
						}
						
						.gambio_error_box.details.notice {
							background-color: #cacaff !important;
						}
						
						.gambio_error_box.subdetails.notice {
							background-color: #ddddff !important;
						}
						
						.gambio_error_box a {
							color:  blue !important;
						}
					</style><pre style="margin: 0; padding: 0"><span class="gambio_error_box head warning"><a href="#" class="unfolder" onclick="if(document.getElementById('error_49543').style.display == 'none'){document.getElementById('error_49543').style.display='block';}else{document.getElementById('error_49543').style.display='none';}return false;"><b>WARNING(2): </b>"ini_set(): A session is active. You cannot change the session module's ini settings at this time"</a></span><span id="error_49543" class="gambio_error_box details warning" style="display: none;"></span></pre><style type="text/css">
						.gambio_error_box {
							font-size: 1em !important;
							color:  black !important;
							margin: 0 !important;
							padding: 0 !important;
							display: block;
						}
						
						.gambio_error_box a.unfolder {
							color: #000000 !important;
							text-decoration: none !important;
							outline: none !important;
							font-family: monospace !important;
							font-size: 12px !important;
						}
						
						.gambio_error_box a.unfolder:hover {
							color: #0000FF !important;
							text-decoration: underline !important;
						}
						
						.gambio_error_box.head.error {
							background-color: #ff9797 !important;
						}
						
						.gambio_error_box.details.error {
							background-color: #ffcaca !important;
						}
						
						.gambio_error_box.subdetails.error {
							background-color: #ffdddd !important;
						}
						
						.gambio_error_box.head.warning {
							background-color: #eecc88 !important;
						}
						
						.gambio_error_box.details.warning {
							background-color: #ffeeaa !important;
						}
						
						.gambio_error_box.subdetails.warning {
							background-color: #fff5cc !important;
						}
						
						.gambio_error_box.head.notice {
							background-color: #9797ff !important;
						}
						
						.gambio_error_box.details.notice {
							background-color: #cacaff !important;
						}
						
						.gambio_error_box.subdetails.notice {
							background-color: #ddddff !important;
						}
						
						.gambio_error_box a {
							color:  blue !important;
						}
					</style><pre style="margin: 0; padding: 0"><span class="gambio_error_box head warning"><a href="#" class="unfolder" onclick="if(document.getElementById('error_37456').style.display == 'none'){document.getElementById('error_37456').style.display='block';}else{document.getElementById('error_37456').style.display='none';}return false;"><b>WARNING(2): </b>"ini_set(): A session is active. You cannot change the session module's ini settings at this time"</a></span><span id="error_37456" class="gambio_error_box details warning" style="display: none;"></span></pre>
29.08.2018 16:48:50 [RepliziereShop.aShop.Uploaden] Upload aktiv.
29.08.2018 16:48:50 [CheckUploadPaths.] Prüfe lokale Upload-Pfade
29.08.2018 16:48:51 [UploadToShop.xp_fill_rweb] Erzeuge zu replizierende Daten ....
29.08.2018 16:48:51 [UploadToShop.xp_rweb_sweep] Verdichte zu replizierende Daten
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'PAR' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'SPR' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'ADR' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'KAT' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'KAT_SPR' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'HST' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'ART' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'AAT' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'ALA' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'XSE_GRP' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'ART_XSE' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'AP1' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'AP3' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'AP5' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'ARD' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'ITM' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'GFX' gefunden.
29.08.2018 16:48:51 [UploadToShop.FqrRWEB] Keine zu replizierenden Daten für Tabelle 'BEK' gefunden.
29.08.2018 16:48:51 [RepliziereShop.] Entsperre Filiale 901 'GX3 Shop' (FIL_ID: 4) vom exklusiven Zugriff
29.08.2018 16:48:51 [RepliziereShop.Finally] Replikation beendet.
29.08.2018 16:48:51 [Replizieren.AutoVerarbeiten] Starte automatischen Import...

 

dazu noch eine Fehlermeldung aus dem Serverlog:

Zitat
AH01071: Got error 'PHP message: PHP Warning: ini_set(): A session is active. You cannot change the session module's ini settings at this time in /var/www/vhosts/eshop-source.de/dev-gx310.eshop-source.de/admin/includes/application_top.php on line 79\n'

 

Link zu diesem Kommentar
Auf anderen Seiten teilen
  • 0
J. Wigandt Newbie

J. Wigandt

Geschrieben
Geschrieben
vor 15 Stunden schrieb rene:

den Fehler mit ini_set habe ich behoben ... Hintergrund ist, das eine Session nicht zweimal gestartet werden sollte ...

entsprechend das session_start() in der vario_export7.php auskommentiert. 

Hallo rene,

das ist richtig und war als Workaround für Gambio 3.9 mit DSGVO Update Paket eingebaut worden, da wegen den Service Pack die Session nicht gestartet wurde. Das Problem besteht mit Gambio 3.10 (Dort ist das DSGVO Service Pack bereits integriert) nicht mehr, deswegen ist es auch in neueren Versionen der Schnittstelle auch nicht mehr enthalten.

Link zu diesem Kommentar
Auf anderen Seiten teilen

Dein Kommentar

Du kannst jetzt schreiben und Dich später registrieren. Wenn Du ein Konto hast, melde Dich jetzt an, um unter Deinem Benutzernamen zu schreiben.

Gast
Diese Frage beantworten...

×   Du hast formatierten Text eingefügt.   Formatierung jetzt entfernen

  Nur 75 Emojis sind erlaubt.

×   Dein Link wurde automatisch eingebettet.   Einbetten rückgängig machen und als Link darstellen

×   Dein vorheriger Inhalt wurde wiederhergestellt.   Editor leeren

×   Du kannst Bilder nicht direkt einfügen. Lade Bilder hoch oder lade sie von einer URL.

×
 Teilen
Zur Liste der Fragen
×
×
  • Neu erstellen...