ingo.graebner
Aktives Mitglied
Folgende Exception tritt nun auf wenn Bestellungen abgerufen werden:
Connector Version: 1.4.0.1
JTL-Wawi Version: 1.0.4.3
Webshop Version: 1.9.2
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_trans_id != null' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_payment` AS `main_table` WHERE (((`jtl_erp_id` = 0) OR (`jtl_erp_id` IS NULL))) AND (`last_trans_id != null` = '') at payment.pull
Zahlungen-Empfangen-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der Wawi notwendig sind!
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_trans_id != null' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_payment` AS `main_table` WHERE (((`jtl_erp_id` = 0) OR (`jtl_erp_id` IS NULL))) AND (`last_trans_id != null` = '') at payment.pull
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_trans_id != null' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_payment` AS `main_table` WHERE (((`jtl_erp_id` = 0) OR (`jtl_erp_id` IS NULL))) AND (`last_trans_id != null` = '') at payment.pull
Womit auch klar ist was schief geht: ...AND (`last_trans_id != null` = '')
Connector Version: 1.4.0.1
JTL-Wawi Version: 1.0.4.3
Webshop Version: 1.9.2
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_trans_id != null' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_payment` AS `main_table` WHERE (((`jtl_erp_id` = 0) OR (`jtl_erp_id` IS NULL))) AND (`last_trans_id != null` = '') at payment.pull
Zahlungen-Empfangen-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der Wawi notwendig sind!
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_trans_id != null' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_payment` AS `main_table` WHERE (((`jtl_erp_id` = 0) OR (`jtl_erp_id` IS NULL))) AND (`last_trans_id != null` = '') at payment.pull
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_trans_id != null' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_payment` AS `main_table` WHERE (((`jtl_erp_id` = 0) OR (`jtl_erp_id` IS NULL))) AND (`last_trans_id != null` = '') at payment.pull
Womit auch klar ist was schief geht: ...AND (`last_trans_id != null` = '')