Ich habe Name, PLZ und Ort als Pflichtfeld eingestellt, damit ich meine Newsletter regional filtern und verschicken kann. Nun musste ich zu meinem Bedauern feststellen, dass bei allen Kunden, die sich eingetragen haben, nur Name und E-Mai-Adresse abgespeichert wurden. Darum habe ich heute nochmal einen Test-Eintrag in das Online-Formular gemacht mit folgendem Ergebnis:
Die Abfrage nach allen Pflichtfeldern im Formular funktioniert (d.h. es gibt die Fehlermeldung, dass die Pflichtfelder nicht vollständig ausgefüllt wurden). D.h. die Daten müssen eingegeben worden sein, sonst wäre ja keine Anmeldung zustandegekommen. Diese Daten werden aber leider nicht in die Datenbank übernommen! Wenn ich in die Abonnentenverwaltung gehe, bleiben diese Datenfelder leer! Auch über phpMyAdmin sehe ich, dass diese Datenbankfelder leer sind!
Auch die logfiles haben da so einige Datenbankfehler, bei denen mir allerdings das Fachwissen fehlt um diese zu beurteilen, hier der log zu meinem Test:
Code: Alles auswählen
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_newsletter ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'abo_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_newsletter_abo ADD INDEX abo_id (`abo_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'nl_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_newsletter_abo ADD INDEX nl_id (`nl_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'send' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_newsletter_abo ADD INDEX send (`send`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'schedule_date' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_newsletter_abo ADD INDEX schedule_date (`schedule_date`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_newsletter_abo ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_abonnenten ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_groups ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_abonnent_group ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'abo_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_abonnent_group ADD INDEX abo_id (`abo_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'group_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_abonnent_group ADD INDEX group_id (`group_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, include('/plugins/wpnewslettergermany/lib/install.php'), dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->install, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'uf_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields_abo ADD INDEX uf_id (`uf_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->install, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'abo_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields_abo ADD INDEX abo_id (`abo_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->install, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields_abo ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->install, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_abonnenten_bounces ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->install, wpng_PluginController->callMods, call_user_func_array, wpng_mod_bounce->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'uf_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields_abo ADD INDEX uf_id (`uf_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Duplicate key name 'abo_id' f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields_abo ADD INDEX abo_id (`abo_id`) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_userfields_abo ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->callMods, call_user_func_array, wpng_mod_userfields->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin
14.04.2015 20:16:24 xxxx.xx [client xx.xxx.xx.x] WordPress-Datenbank-Fehler Multiple primary key defined f\xc3\xbcr Abfrage ALTER TABLE wp_wpng_abonnenten_bounces ADD PRIMARY KEY id (id) von do_action('toplevel_page_wpng-Admin'), call_user_func_array, wpng_dispatch, wpng_AdminController->indexAction, wpng_AdminController->configGeneralAction, wpng_PluginController->callMods, call_user_func_array, wpng_mod_bounce->install, dbDelta, referer: http://www.xxxx.xx/wp-admin/admin.php?page=wpng-Admin