Errors on update

I just checked it again.

This errors only happen when activating one of the following version

– 4.9.4
– 4.9.3
– 4.9.2
– 4.9.1

It does not happen on 4.9.0.

Hi, the problem has been generated by the use of “dbdelta” which should be more efficient in creating and updating the table. I’ve released just now a fix because the sql statment was not perfect, I don’t know if that was generating the notices.

The notices you see seems related to a parsing problem of the table structure. Try to update to version 4.9.6 and let me know and thank you very much for your support!

Stefano.

No, does not work.

[23-May-2017 07:16:31 UTC] PHP Notice: Undefined index: index_type in /var/www/blog/wp-admin/includes/upgrade.php on line 2283
[23-May-2017 07:16:31 UTC] PHP Notice: Undefined index: index_name in /var/www/blog/wp-admin/includes/upgrade.php on line 2289
[23-May-2017 07:16:31 UTC] PHP Notice: Undefined index: index_columns in /var/www/blog/wp-admin/includes/upgrade.php on line 2292
[23-May-2017 07:16:31 UTC] PHP Notice: Undefined index: column_name in /var/www/blog/wp-admin/includes/upgrade.php on line 2320
[23-May-2017 07:16:32 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘()’ at line 1 für Abfrage ALTER TABLE wp_newsletter ADD () von activate_plugin, do_action(‘activate_newsletter/plugin.php’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, newsletter_activate, NewsletterUsers->upgrade, dbDelta

Could you enter the status panel of newsletter adding to the url &debug=1 then copy and paste the structure of wp_newsletter table reported at bottom of the page?

If you prefer contact me at [email protected] so I can do it for you.

Stefano.

Field Type Null Key Default Extra
id int(11) NO PRI auto_increment
email varchar(100) NO UNI
name varchar(100) NO
surname varchar(100) NO
sex char(1) NO n
status varchar(1) NO S
created timestamp NO CURRENT_TIMESTAMP
token varchar(50) NO
feed tinyint(4) NO 0
feed_time bigint(20) NO 0
country varchar(4) NO
list_1 tinyint(4) NO 0
list_2 tinyint(4) NO 0
list_3 tinyint(4) NO 0
list_4 tinyint(4) NO 0
list_5 tinyint(4) NO 0
list_6 tinyint(4) NO 0
list_7 tinyint(4) NO 0
list_8 tinyint(4) NO 0
list_9 tinyint(4) NO 0
list_10 tinyint(4) NO 0
list_11 tinyint(4) NO 0
list_12 tinyint(4) NO 0
list_13 tinyint(4) NO 0
list_14 tinyint(4) NO 0
list_15 tinyint(4) NO 0
list_16 tinyint(4) NO 0
list_17 tinyint(4) NO 0
list_18 tinyint(4) NO 0
list_19 tinyint(4) NO 0
list_20 tinyint(4) NO 0
profile_1 varchar(255) NO
profile_2 varchar(255) NO
profile_3 varchar(255) NO
profile_4 varchar(255) NO
profile_5 varchar(255) NO
profile_6 varchar(255) NO
profile_7 varchar(255) NO
profile_8 varchar(255) NO
profile_9 varchar(255) NO
profile_10 varchar(255) NO
profile_11 varchar(255) NO
profile_12 varchar(255) NO
profile_13 varchar(255) NO
profile_14 varchar(255) NO
profile_15 varchar(255) NO
profile_16 varchar(255) NO
profile_17 varchar(255) NO
profile_18 varchar(255) NO
profile_19 varchar(255) NO
profile_20 varchar(255) NO
referrer varchar(50) NO
http_referer varchar(255) NO
wp_user_id int(11) NO 0
ip varchar(50) NO
test tinyint(4) NO 0
flow tinyint(4) NO 0
unsub_email_id int(11) NO 0
unsub_time int(11) NO 0
list int(11) NO 0
profile mediumtext YES
followup_step tinyint(4) NO 0
followup_time bigint(20) NO 0
followup tinyint(4) NO 0
region varchar(100) NO
city varchar(100) NO