Speichern in Produktbearbeitung geht nicht nach Update auf 4.1.3

[Holz]

Hallo,
nachdem das Update auf 4.1.3. nun funktioniert hat, geht das Speichern in der Produktbearbeitung nicht.
Es erscheint eine weiße Seite.
Im Debug-Modus (Plugins sind auch bereits deaktiviert) kommt folgende Fehlermeldung:

Datenbankfehler: Unknown column 'pos' in 'field list'
#0 wpsg\Exceptionhandler::exception(wpsg\Exception Object ([wpsg\Exceptiontyp] => 1,[wpsg\Exceptiondata] => Array ([0] => Array ([0] => Letzter Query,[1] => UPDATE `wp_wpsg_products` SET `name` = 'Zirbenkissen 20 x 30 cm', `disabled` = '0', `detailname` = 'Zirbenkissen 20 x 30 cm', `shortdesc` = '', `beschreibung` = 'Bei Fragen oder technischen Problemen rufen Sie uns bitte an: 034903-30179 oder 0177-2011145\r\n
Zirbenkissen 20 x 30 cm
\r\nMit Zirbe schläft es sich besser!\r\n
\r\n
Vermindert die Wetterfühligkeit
\r\n
Bringt mehr Entspannung in den Schlaf
\r\n
Vertreibt Motten und Bakterien!
\r\n
5 % Rabatt bei Vorkasse!
\r\n
', `longdescription` = '', `moreinfos` = '', `anr` = '44150000ZK20', `pos` = '', `mwst_key` = 'c', `ptemplate_file` = 'standard.phtml', `posturl` = 'http://www.moebelsysteme-mg.de/shop/vie ... e-zahlung/', `posturl_verkauf` = '0', `posturl_bezahlung` = '1', `partikel` = '', `euleistungsortregel` = '0', `basket_multiple` = '0', `rating` = '0', `allowedpayments` = '1,2', `allowedshipping` = '6_8', `preis` = '17.50', `oldprice` = '0.00', `ean` = '', `gtin` = '', `wpsg_mod_deliverytime_deliverytime` = '0', `wpsg_mod_deliverytime_storeproduct` = '0', `wpsg_mod_deliverytime_storetext` = '', `wpsg_mod_deliverytime_storelink` = '0', `wpsg_mod_deliverytime_source` = '0', `wpsg_mod_deliverytime_delay` = '', `wpsg_mod_deliverytime_delaytext` = '', `wpsg_mod_deliverytime_delaytime` = '', `wpsg_mod_deliverytime_holiday` = '', `wpsg_mod_deliverytime_holidaytext` = '', `wpsg_mod_deliverytime_holidayStart` = '', `wpsg_mod_deliverytime_holidayEnd` = '' WHERE `id` = '1')),[*message] => Unknown column 'pos' in 'field list',[Exceptionstring] => wpsg\Exception: Unknown column 'pos' in 'field list' in /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php:19
Stack trace:
#0 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php(261): wpsg_db->handleError()
#1 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php(912): wpsg_db->UpdateQuery('wp_wpsg_product...', Array, '`id` = '1'')
#2 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php(49): wpsg_ProduktController->saveAction()
#3 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/lib/filter_functions.inc.php(22): wpsg_ProduktController->dispatch()
#4 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-includes/class-wp-hook.php(286): wpsg_dispatch('')
#5 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
#6 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
#7 /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-admin/admin.php(253): do_action('wpshopgermany_p...')
#8 {main},[*code] => 0,[*file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php,[*line] => 19,[Exceptiontrace] => Array ([0] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php,[line] => 261,[function] => handleError,[class] => wpsg_db,[type] => ->,[args] => Array ()),[1] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php,[line] => 912,[function] => UpdateQuery,[class] => wpsg_db,[type] => ->,[args] => Array ([0] => wp_wpsg_products,[1] => Array ([name] => Zirbenkissen 20 x 30 cm,[disabled] => 0,[detailname] => Zirbenkissen 20 x 30 cm,[shortdesc] => ,[beschreibung] => Bei Fragen oder technischen Problemen rufen Sie uns bitte an: 034903-30179 oder 0177-2011145\r\n
Zirbenkissen 20 x 30 cm
\r\nMit Zirbe schläft es sich besser!\r\n
\r\n
Vermindert die Wetterfühligkeit
\r\n
Bringt mehr Entspannung in den Schlaf
\r\n
Vertreibt Motten und Bakterien!
\r\n
5 {81fdc4318aac07142a17db1087ab434ebc3f0e6434cc2cf897140672eec5f269} Rabatt bei Vorkasse!
\r\n
,[longdescription] => ,[moreinfos] => ,[anr] => 44150000ZK20,[pos] => ,[mwst_key] => c,[ptemplate_file] => standard.phtml,[posturl] => http://www.moebelsysteme-mg.de/shop/vie ... rl_verkauf] => 0,[posturl_bezahlung] => 1,[partikel] => ,[euleistungsortregel] => 0,[basket_multiple] => 0,[rating] => 0,[allowedpayments] => 1,2,[allowedshipping] => 6_8,[preis] => 17.50,[oldprice] => 0.00,[ean] => ,[gtin] => ,[wpsg_mod_deliverytime_deliverytime] => 0,[wpsg_mod_deliverytime_storeproduct] => 0,[wpsg_mod_deliverytime_storetext] => ,[wpsg_mod_deliverytime_storelink] => 0,[wpsg_mod_deliverytime_source] => 0,[wpsg_mod_deliverytime_delay] => ,[wpsg_mod_deliverytime_delaytext] => ,[wpsg_mod_deliverytime_delaytime] => ,[wpsg_mod_deliverytime_holiday] => ,[wpsg_mod_deliverytime_holidaytext] => ,[wpsg_mod_deliverytime_holidayStart] => ,[wpsg_mod_deliverytime_holidayEnd] => ),[2] => `id` = '1')),[2] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php,[line] => 49,[function] => saveAction,[class] => wpsg_ProduktController,[type] => ->,[args] => Array ()),[3] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-content/plugins/wpshopgermany-free/lib/filter_functions.inc.php,[line] => 22,[function] => dispatch,[class] => wpsg_ProduktController,[type] => ->,[args] => Array ()),[4] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-includes/class-wp-hook.php,[line] => 286,[function] => wpsg_dispatch,[args] => Array ([0] => )),[5] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-includes/class-wp-hook.php,[line] => 310,[function] => apply_filters,[class] => WP_Hook,[type] => ->,[args] => Array ([0] => ,[1] => Array ([0] => ))),[6] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-includes/plugin.php,[line] => 465,[function] => do_action,[class] => WP_Hook,[type] => ->,[args] => Array ([0] => Array ([0] => ))),[7] => Array ([file] => /mnt/web421/b1/06/54535806/htdocs/WordPress_01/wp-admin/admin.php,[line] => 253,[function] => do_action,[args] => Array ([0] => wpshopgermany_page_wpsg-Produkt))),[Exceptionprevious] => ))

[ThoGoe]

Hallo!

Bitte aktualisiere einmal deine Datenbank unter wpShopGermany > Konfiguration > Einstellungen. Besteht das Problem weiter?

Liebe Grüße

[Gitta]

Hallo,

ich habe das gleiche Problem, das auch nach Aktualisierung der Datenbank weiterhin besteht.

Ich bekomme nach Aktivierung des Debug-Modus folgende Fehlermeldung:

Datenbankfehler: Unknown column 'pos' in 'field list'
#0 wpsg\Exceptionhandler::exception(wpsg\Exception Object ([wpsg\Exceptiontyp] => 1,[wpsg\Exceptiondata] => Array ([0] => Array ([0] => Letzter Query,[1] => UPDATE `wp_NjrEK_5_awpsg_products` SET `name` = 'Cremerezept-Rechner 2.0', `disabled` = '0', `detailname` = '', `shortdesc` = '', `beschreibung` = '', `longdescription` = '', `moreinfos` = '', `anr` = '041905', `pos` = '', `mwst_key` = 'e', `ptemplate_file` = 'standard.phtml', `posturl` = '', `posturl_verkauf` = '0', `posturl_bezahlung` = '0', `partikel` = '', `euleistungsortregel` = '0', `basket_multiple` = '4', `rating` = '0', `allowedpayments` = '1,2', `allowedshipping` = '6_2', `preis` = '19.90', `oldprice` = '0.00', `weight` = '0.00', `wpsg_mod_deliverytime_deliverytime` = '0', `wpsg_mod_deliverytime_storeproduct` = '0', `wpsg_mod_deliverytime_storetext` = '', `wpsg_mod_deliverytime_storelink` = '0', `wpsg_mod_deliverytime_source` = '0', `wpsg_mod_deliverytime_delay` = '', `wpsg_mod_deliverytime_delaytext` = '', `wpsg_mod_deliverytime_delaytime` = '', `wpsg_mod_deliverytime_holiday` = '', `wpsg_mod_deliverytime_holidaytext` = '', `wpsg_mod_deliverytime_holidayStart` = '', `wpsg_mod_deliverytime_holidayEnd` = '' WHERE `id` = '15')),[*message] => Unknown column 'pos' in 'field list',[Exceptionstring] => wpsg\Exception: Unknown column 'pos' in 'field list' in /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php:19
Stack trace:
#0 /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php(261): wpsg_db->handleError()
#1 /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php(912): wpsg_db->UpdateQuery('wp_NjrEK_5_awps...', Array, '`id` = '15'')
#2 /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php(49): wpsg_ProduktController->saveAction()
#3 /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/lib/filter_functions.inc.php(22): wpsg_ProduktController->dispatch()
#4 /home2/hobbykos/public_html/wdps/wp-includes/class-wp-hook.php(286): wpsg_dispatch('')
#5 /home2/hobbykos/public_html/wdps/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
#6 /home2/hobbykos/public_html/wdps/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
#7 /home2/hobbykos/public_html/wdps/wp-admin/admin.php(253): do_action('wpshopgermany_p...')
#8 {main},[*code] => 0,[*file] => /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php,[*line] => 19,[Exceptiontrace] => Array ([0] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php,[line] => 261,[function] => handleError,[class] => wpsg_db,[type] => ->,[args] => Array ()),[1] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php,[line] => 912,[function] => UpdateQuery,[class] => wpsg_db,[type] => ->,[args] => Array ([0] => wp_NjrEK_5_awpsg_products,[1] => Array ([name] => Cremerezept-Rechner 2.0,[disabled] => 0,[detailname] => ,[shortdesc] => ,[beschreibung] => ,[longdescription] => ,[moreinfos] => ,[anr] => 041905,[pos] => ,[mwst_key] => e,[ptemplate_file] => standard.phtml,[posturl] => ,[posturl_verkauf] => 0,[posturl_bezahlung] => 0,[partikel] => ,[euleistungsortregel] => 0,[basket_multiple] => 4,[rating] => 0,[allowedpayments] => 1,2,[allowedshipping] => 6_2,[preis] => 19.90,[oldprice] => 0.00,[weight] => 0.00,[wpsg_mod_deliverytime_deliverytime] => 0,[wpsg_mod_deliverytime_storeproduct] => 0,[wpsg_mod_deliverytime_storetext] => ,[wpsg_mod_deliverytime_storelink] => 0,[wpsg_mod_deliverytime_source] => 0,[wpsg_mod_deliverytime_delay] => ,[wpsg_mod_deliverytime_delaytext] => ,[wpsg_mod_deliverytime_delaytime] => ,[wpsg_mod_deliverytime_holiday] => ,[wpsg_mod_deliverytime_holidaytext] => ,[wpsg_mod_deliverytime_holidayStart] => ,[wpsg_mod_deliverytime_holidayEnd] => ),[2] => `id` = '15')),[2] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php,[line] => 49,[function] => saveAction,[class] => wpsg_ProduktController,[type] => ->,[args] => Array ()),[3] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-content/plugins/wpshopgermany-free/lib/filter_functions.inc.php,[line] => 22,[function] => dispatch,[class] => wpsg_ProduktController,[type] => ->,[args] => Array ()),[4] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-includes/class-wp-hook.php,[line] => 286,[function] => wpsg_dispatch,[args] => Array ([0] => )),[5] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-includes/class-wp-hook.php,[line] => 310,[function] => apply_filters,[class] => WP_Hook,[type] => ->,[args] => Array ([0] => ,[1] => Array ([0] => ))),[6] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-includes/plugin.php,[line] => 465,[function] => do_action,[class] => WP_Hook,[type] => ->,[args] => Array ([0] => Array ([0] => ))),[7] => Array ([file] => /home2/hobbykos/public_html/wdps/wp-admin/admin.php,[line] => 253,[function] => do_action,[args] => Array ([0] => wpshopgermany_page_wpsg-Produkt))),[Exceptionprevious] => ))

[driefmeier.com]

Wir haben hier das gleiche Problem!
@ThoGoe -> gibt es hierzu ein Update?!

[ThoGoe]

Hallo!

Bitte aktualisiere erneut deine Datenbank unter wpShopGermany > Konfiguration > Einstellungen. Damit sollte das Problem behoben sein.

Liebe Grüße

[driefmeier.com]

Hallo ThoGoe,

auch nach aktualsieren der DB ...

Datenbankfehler: Unknown column 'pos' in 'field list'
#0 wpsg\Exceptionhandler::exception(wpsg\Exception Object ([wpsg\Exceptiontyp] => 1,[wpsg\Exceptiondata] => Array ([0] => Array ([0] => Letzter Query,[1] => UPDATE `rw_wpsg_products` SET `name` = '2015 Fongaban', `disabled` = '0', `detailname` = '', `shortdesc` = 'Meine persönliche Top-Empfehlung!', `beschreibung` = 'test', `longdescription` = '', `moreinfos` = '', `anr` = '86', `pos` = '', `mwst_key` = 'c', `ptemplate_file` = 'standard.phtml', `posturl` = '', `posturl_verkauf` = '0', `posturl_bezahlung` = '0', `partikel` = '2293', `euleistungsortregel` = '0', `basket_multiple` = '0', `rating` = '0', `allowedpayments` = '', `allowedshipping` = '', `preis` = '10.90', `oldprice` = '0.00' WHERE `id` = '86')),[*message] => Unknown column 'pos' in 'field list',[Exceptionstring] => wpsg\Exception: Unknown column 'pos' in 'field list' in /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php:19
Stack trace:
#0 /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php(261): wpsg_db->handleError()
#1 /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php(912): wpsg_db->UpdateQuery('rw_wpsg_product...', Array, '`id` = '86'')
#2 /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php(49): wpsg_ProduktController->saveAction()
#3 /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/lib/filter_functions.inc.php(22): wpsg_ProduktController->dispatch()
#4 /var/www/web212/html/websplash/wp-includes/class-wp-hook.php(286): wpsg_dispatch('')
#5 /var/www/web212/html/websplash/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
#6 /var/www/web212/html/websplash/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
#7 /var/www/web212/html/websplash/wp-admin/admin.php(253): do_action('wpshopgermany_p...')
#8 {main},[*code] => 0,[*file] => /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php,[*line] => 19,[Exceptiontrace] => Array ([0] => Array ([file] => /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/lib/wpsg_db.class.php,[line] => 261,[function] => handleError,[class] => wpsg_db,[type] => ->,[args] => Array ()),[1] => Array ([file] => /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php,[line] => 912,[function] => UpdateQuery,[class] => wpsg_db,[type] => ->,[args] => Array ([0] => rw_wpsg_products,[1] => Array ([name] => 2015 Fongaban,[disabled] => 0,[detailname] => ,[shortdesc] => Meine persönliche Top-Empfehlung!,[beschreibung] => test,[longdescription] => ,[moreinfos] => ,[anr] => 86,[pos] => ,[mwst_key] => c,[ptemplate_file] => standard.phtml,[posturl] => ,[posturl_verkauf] => 0,[posturl_bezahlung] => 0,[partikel] => 2293,[euleistungsortregel] => 0,[basket_multiple] => 0,[rating] => 0,[allowedpayments] => ,[allowedshipping] => ,[preis] => 10.90,[oldprice] => 0.00),[2] => `id` = '86')),[2] => Array ([file] => /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/controller/wpsg_ProduktController.class.php,[line] => 49,[function] => saveAction,[class] => wpsg_ProduktController,[type] => ->,[args] => Array ()),[3] => Array ([file] => /var/www/web212/html/websplash/wp-content/plugins/wpshopgermany-free/lib/filter_functions.inc.php,[line] => 22,[function] => dispatch,[class] => wpsg_ProduktController,[type] => ->,[args] => Array ()),[4] => Array ([file] => /var/www/web212/html/websplash/wp-includes/class-wp-hook.php,[line] => 286,[function] => wpsg_dispatch,[args] => Array ([0] => )),[5] => Array ([file] => /var/www/web212/html/websplash/wp-includes/class-wp-hook.php,[line] => 310,[function] => apply_filters,[class] => WP_Hook,[type] => ->,[args] => Array ([0] => ,[1] => Array ([0] => ))),[6] => Array ([file] => /var/www/web212/html/websplash/wp-includes/plugin.php,[line] => 465,[function] => do_action,[class] => WP_Hook,[type] => ->,[args] => Array ([0] => Array ([0] => ))),[7] => Array ([file] => /var/www/web212/html/websplash/wp-admin/admin.php,[line] => 253,[function] => do_action,[args] => Array ([0] => wpshopgermany_page_wpsg-Produkt))),[Exceptionprevious] => ))

[driefmeier.com]

@ThoGoe: Beleg das DB aktuell ist.

[ThoGoe]

Hallo!

Vielen Dank für den Hinweis. Es ist tatsächlich so, dass der Fehler verschwindet, wenn die Datenbank aktualisiert wird UND man das Modul ProduktArtikel aktiv hat.
Liegt das Modul ProduktArtikel nicht im aktiven Zustand vor, gibt es zwei Möglichkeiten:

Möglichkeit 1: Man aktiviert das Modul im Demomodus (beachte: die Demozeit läuft damit ab)
Möglichkeit 2: Man nutzt unseren Bugfix im Anhang. Das Zip entpacken und den Ordner via FTP in den Pluginsordner unter wp-content/plugins hineinkopieren. Bitte nicht den bestehenden Ordner "wpshopgermany-free" löschen!

Liebe Grüße

[Holz]

Hallo,
nach dem Aktivieren des Produktartikelmodules funktioniert das Speichern jetzt auch bei uns.
Warum muß man eigentlich nach jedem Update das Modul Produktartikel separat aktualisieren?

Gruß

[Gabriele Sch.]

Hallo,

Info: ich hatte das Modul bereits aktualisiert, hatte aber das selbe Problem.
Über die Konfoguaration nochmals aktualisiert und nun geht's.

Viele Grüße

[ThoGoe]

Hallo!

Wir hatten eine Einstellung speziell für das Modul ProduktArtikel verändert. Daher kam es leider dazu, dass das Modul eigens noch einmal aktualisiert werden musste.

Liebe Grüße

[Achim]

Wann wird es ein Update geben, in dem dieser Fehler behoben ist?
Echt Leute, das ist mehr als deprimierend. Ich habe eine Enterprise gekauft und kann keine Produkte speichern, nach einem Update.
Ich habe mich eingefuchst und war froh dass alles läuft, und jetzt muss ich wieder mit FTP rumkaspern.

[ThoGoe]

Hallo!

Einen Bugfix hatten wir bereits am 12. April 2019 geliefert. Die neue Version befindet sich aktuell noch in der Beta-Phase. Gerne kannst du Sie hier herunterladen und ausprobieren. Der angesprochene Bugfix ist dort natürlich enthalten.

Liebe Grüße