Gelöst Neue Kategorien anlegen nicht möglich

[oso]

Hallo

Wir setzen die 099974 und den 1.0.8 Connector ein. Leider können wir keine neuen Kategorien mehr erstellen. Folgende Meldung erscheint.

Fehler:
Exception: An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, "|14|3|", 1, null, 0, 0, 0, "2015-09-01 11:06:58", "2015-09-01 11:06:58", null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null
Kategorien-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der Wawi notwendig sind!
An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, "|14|3|", 1, null, 0, 0, 0, "2015-09-01 11:06:58", "2015-09-01 11:06:58", null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null
Exception: An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, "|14|3|", 1, null, 0, 0, 0, "2015-09-01 11:06:58", "2015-09-01 11:06:58", null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null

Response: {"result":[],"error":{"code":0,"message":"An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, \"|14|3|\", 1, null, 0, 0, 0, \"2015-09-01 11:06:58\", \"2015-09-01 11:06:58\", null]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null","data":null},"jtlrpc":"2.0","id":"dae2694f9ee74519902acbbf8f9ed17e"}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.juVSJn0Isw(String , Object , Boolean , NetworkCredential )


Das Log sieht folgend aus.

JTL-Wawi: StartForm()
JTL-Wawi: MainWindow != null
JTL-Wawi: Sync start
JTL-Wawi: Licence is valid
JTL-Wawi: InitCall OK
JTL-Wawi: Initialize model getters...
>>> Customer.statistic: {
"method": "Customer.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "b1f02bf205d04fb5bc53931c7bbc3668"
}
<<< Customer.statistic: {"result":{"available":0,"controllerName":"customer"},"error":null,"jtlrpc":"2.0","id":"b1f02bf205d04fb5bc53931c7bbc3668"}
(267.8025 milliseconds)
>>> Payment.statistic: {
"method": "Payment.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "87bb0ec9e3544dbda323d47ca04b63a8"
}
<<< Payment.statistic: {"result":{"available":7,"controllerName":"payment"},"error":null,"jtlrpc":"2.0","id":"87bb0ec9e3544dbda323d47ca04b63a8"}
(276.7423 milliseconds)
<<< Image.statistic: {"result":{"available":0,"controllerName":"image"},"error":null,"jtlrpc":"2.0","id":"c910c8de1df445f9aed7d4fcf7a2cbd4"}
(280.62 milliseconds)
<<< Specific.statistic: {"result":{"available":0,"controllerName":"specific"},"error":null,"jtlrpc":"2.0","id":"7d1477ffdd704980905945d58b96b5ae"}
(291.0846 milliseconds)
<<< Manufacturer.statistic: {"result":{"available":0,"controllerName":"manufacturer"},"error":null,"jtlrpc":"2.0","id":"de006609e69941199ca8aa060372c002"}
(280.8596 milliseconds)
JTL-Wawi: ModelGetters OK
>>> global_data.pull: {
"method": "global_data.pull",
"params": {
"limit": 50,
"filters": {}
},
"jtlrpc": "2.0",
"id": "2448838e610444feb2a4e5e851590516"
}
<<< global_data.pull: {"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["1",0],"delimiterCent":"","delimiterThousand":"","factor":1,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"CHF","name":"Schweizer Franken","nameHtml":"CHF"}],"customerGroups":[{"id":["1",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["1",0],"languageISO":"ger","name":"Shopkunden"}]},{"id":["2",0],"applyNetPrice":false,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["2",0],"languageISO":"ger","name":"H\u00e4ndler"}]}],"languages":[{"id":["2",0],"isDefault":false,"languageISO":"eng","nameEnglish":"Englisch","nameGerman":"Englisch"},{"id":["44",0],"isDefault":true,"languageISO":"ger","nameEnglish":"Deutsch","nameGerman":"Deutsch"}],"measurementUnits":[{"id":["1",0],"code":"L","displayCode":"Liter","i18ns":[]},{"id":["2",0],"code":"g","displayCode":"Gramm","i18ns":[]},{"id":["5",0],"code":"lfm","displayCode":"lfm","i18ns":[]},{"id":["6",0],"code":"kg","displayCode":"Kilogramm","i18ns":[]},{"id":["8",0],"code":"Paket(e)","displayCode":"Paket(e)","i18ns":[]},{"id":["9",0],"code":"Stck.","displayCode":"St\u00fcck","i18ns":[]},{"id":["10",0],"code":"m","displayCode":"Meter","i18ns":[]},{"id":["11",0],"code":"mm","displayCode":"Millimeter","i18ns":[]},{"id":["12",0],"code":"cm","displayCode":"Centimeter","i18ns":[]},{"id":["13",0],"code":"dm","displayCode":"Dezimeter","i18ns":[]},{"id":["14",0],"code":"[in_i]","displayCode":"Zoll","i18ns":[]},{"id":["15",0],"code":"km","displayCode":"Kilometer","i18ns":[]},{"id":["16",0],"code":"mg","displayCode":"Milligramm","i18ns":[]},{"id":["17",0],"code":"[lb_av]","displayCode":"Pfund","i18ns":[]},{"id":["18",0],"code":"t","displayCode":"Tonne","i18ns":[]},{"id":["19",0],"code":"m2","displayCode":"Quadratmeter","i18ns":[]},{"id":["20",0],"code":"mm2","displayCode":"Quadratmillimeter","i18ns":[]},{"id":["21",0],"code":"cm2","displayCode":"Quadratcentimeter","i18ns":[]},{"id":["22",0],"code":"mL","displayCode":"Milliliter","i18ns":[]},{"id":["23",0],"code":"dL","displayCode":"Deziliter","i18ns":[]},{"id":["24",0],"code":"cL","displayCode":"Centiliter","i18ns":[]},{"id":["25",0],"code":"m3","displayCode":"Kubikmeter","i18ns":[]},{"id":["26",0],"code":"cm3","displayCode":"Kubikcentimeter","i18ns":[]}],"productTypes":[],"shippingClasses":[],"taxRates":[{"id":["1",0],"rate":8},{"id":["4",0],"rate":2.5}],"units":[{"id":["1",0],"i18ns":[{"unitId":["1",0],"languageISO":"ger","name":""}]},{"id":["2",0],"i18ns":[{"unitId":["2",0],"languageISO":"ger","name":""}]}],"warehouses":[]}],"error":null,"jtlrpc":"2.0","id":"2448838e610444feb2a4e5e851590516"}
(305.5248 milliseconds)
>>> category.push: {
"method": "category.push",
"params": [
{
"attributes": [],
"customerGroups": [],
"i18ns": [
{
"categoryId": [
"",
224
],
"languageISO": "ger",
"name": "Neuheiten",
"description": "",
"urlPath": "",
"metaDescription": "",
"titleTag": "",
"metaKeywords": ""
}
],
"invisibilities": [],
"level": 2,
"entityType": "Category",
"id": [
"",
224
],
"parentCategoryId": [
"",
10
],
"isActive": true,
"sort": 0
}
],
"jtlrpc": "2.0",
"id": "dae2694f9ee74519902acbbf8f9ed17e"
}
JTL-Wawi: End sync
Exception: An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, "|14|3|", 1, null, 0, 0, 0, "2015-09-01 11:06:58", "2015-09-01 11:06:58", null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null
Kategorien-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der Wawi notwendig sind!
An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, "|14|3|", 1, null, 0, 0, 0, "2015-09-01 11:06:58", "2015-09-01 11:06:58", null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null
Exception: An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, "|14|3|", 1, null, 0, 0, 0, "2015-09-01 11:06:58", "2015-09-01 11:06:58", null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null

Response: {"result":[],"error":{"code":0,"message":"An exception occurred while executing 'INSERT INTO s_categories (parent, description, position, metakeywords, metadescription, cmsheadline, cmstext, active, template, blog, path, showfiltergroups, external, hidefilter, hidetop, noviewselect, changed, added, mediaID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14, null, 0, null, null, null, null, 1, null, 0, \"|14|3|\", 1, null, 0, 0, 0, \"2015-09-01 11:06:58\", \"2015-09-01 11:06:58\", null]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null","data":null},"jtlrpc":"2.0","id":"dae2694f9ee74519902acbbf8f9ed17e"}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.juVSJn0Isw(String , Object , Boolean , NetworkCredential )

 

[oso]

AW: Neue Kategorien anlegen nicht möglich

Hab nun auch noch die 75er und den Connector 1.0.9 installiert. Leider der gleiche Fehler.

 

[Daniel B.]

AW: Neue Kategorien anlegen nicht möglich

Hey,

wie sieht denn deine Kategoriestruktur aus? Welche Standardsprache hat dein Shop?

Lg,
Daniel

 

[oso]

AW: Neue Kategorien anlegen nicht möglich

Ich habe dir einen Screenshot per Mail gesendet.

 

[Daniel B.]

AW: Neue Kategorien anlegen nicht möglich

Schwierig.

Wie sehen deine Shops im Shopware aus? Welche Sprache hat dein default Shop?
Kann an einem Sprachproblem liegen.

 

[oso]

AW: Neue Kategorien anlegen nicht möglich

Dein Tipp war richtig.
Ich hatte die Lokalisierung im Shop auf "Deutsch (Schweiz)" geändert. Dann funktioniert der Kategorienabgleich nicht mehr. Habs wieder zurückgeändert, nun geht es. Danke!
Das Problem mit den Merkmalen besteht jedoch weiterhin. Es werden nur 2 Merkmale an den Shop übertragen.

 

[Daniel B.]

AW: Neue Kategorien anlegen nicht möglich

Merkmale bitte hier hin: http://forum.jtl-software.de/shopwa...h-der-merkmale-funktioniert-nicht-sauber.html

 

[Temel]

AW: Neue Kategorien anlegen nicht möglich

Dein Tipp war richtig.
Ich hatte die Lokalisierung im Shop auf "Deutsch (Schweiz)" geändert. Dann funktioniert der Kategorienabgleich nicht mehr.

Hallo

Ich nutze die aktuelle JTL-WAWI Version und die aktuelle Connector Version sowie die aktuelle Shopware Version (wurde alles neu installiert).
Ich habe leider das gleiche Problem mit der Lokalisierung Deutsch (Schweiz). Da ich die Lokalisierung benötige, frage ich mich, ob es aktuell einen Weg gibt den JTL-Connector in Verbindung mit Shopware Lokalisierung Deutsch (Schweiz) nutzen zu können?

Besten Dank für Eure Unterstützung.