Getting Started

Database Error

Home › Forums › Newsletter Plugin Support › Database Error

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • July 29, 2023 at 12:29 pm #304622
    tperke
    Participant

    When I want to save an e-mail address, I get the following error message: “Database error. If you were saving a newsletter try a table upgrade from the status panel.”

    I opened the file “store-2023-07-b37a38ec.txt” for this purpose. Here are the contents:

    29-07-2023 10:08:15 – FATAL – 7.8.9 – 93,5 MB/1 GB – xyz > Unknown column ‘list_41’ in ‘field list’
    29-07-2023 10:08:15 – FATAL – 7.8.9 – 93,5 MB/1 GB – xyz > UPDATE CXkVskapnewsletter SET email = ‘kontakt@chris-andfriends.de’, name = ”, surname = ”, sex = ‘n’, status = ‘C’, language = ”, test = ‘0’, feed = ‘0’, list_1 = ‘0’, list_2 = ‘0’, list_3 = ‘0’, list_4 = ‘0’, list_5 = ‘0’, list_6 = ‘0’, list_7 = ‘0’, list_8 = ‘0’, list_9 = ‘0’, list_10 = ‘0’, list_11 = ‘0’, list_12 = ‘0’, list_13 = ‘0’, list_14 = ‘0’, list_15 = ‘0’, list_16 = ‘0’, profile_1 = ”, profile_2 = ”, profile_3 = ”, profile_4 = ”, profile_5 = ”, profile_6 = ”, profile_7 = ”, profile_8 = ”, profile_9 = ”, profile_10 = ”, profile_11 = ”, profile_12 = ”, profile_13 = ”, profile_14 = ”, profile_15 = ”, profile_16 = ”, profile_17 = ”, profile_18 = ”, profile_19 = ”, profile_20 = ”, wp_user_id = ‘0’, token = ‘876a091724’, list_17 = ‘0’, list_18 = ‘0’, list_19 = ‘0’, list_20 = ‘0’, list_21 = ‘0’, list_22 = ‘0’, list_23 = ‘0’, list_24 = ‘0’, list_25 = ‘0’, list_26 = ‘0’, list_27 = ‘0’, list_28 = ‘0’, list_29 = ‘0’, list_30 = ‘0’, list_31 = ‘0’, list_32 = ‘0’, list_33 = ‘0’, list_34 = ‘0’, list_35 = ‘0’, list_36 = ‘0’, list_37 = ‘0’, list_38 = ‘0’, list_39 = ‘0’, list_40 = ‘0’, list_41 = ‘0’, list_42 = ‘0’, list_43 = ‘0’, list_44 = ‘0’, list_45 = ‘0’, list_46 = ‘0’, list_47 = ‘0’, list_48 = ‘0’, list_49 = ‘0’, list_50 = ‘0’, list_51 = ‘0’, list_52 = ‘0’, list_53 = ‘0’, list_54 = ‘0’, list_55 = ‘0’, list_56 = ‘0’, list_57 = ‘0’, list_58 = ‘0’, list_59 = ‘0’, list_60 = ‘0’, list_61 = ‘0’, list_62 = ‘0’, list_63 = ‘0’, list_64 = ‘0’, list_65 = ‘0’, list_66 = ‘0’, list_67 = ‘0’, list_68 = ‘0’, list_69 = ‘0’, list_70 = ‘0’, list_71 = ‘0’, list_72 = ‘0’, list_73 = ‘0’, list_74 = ‘0’, list_75 = ‘0’, list_76 = ‘0’, list_77 = ‘0’, list_78 = ‘0’, list_79 = ‘0’, list_80 = ‘0’, list_81 = ‘0’, list_82 = ‘0’, list_83 = ‘0’, list_84 = ‘0’, list_85 = ‘0’, list_86 = ‘0’, list_87 = ‘0’, list_88 = ‘0’, list_89 = ‘0’, list_90 = ‘0’, list_91 = ‘0’, list_92 = ‘0’, list_93 = ‘0’, list_94 = ‘0’, list_95 = ‘0’, list_96 = ‘0’, list_97 = ‘0’, list_98 = ‘0’, list_99 = ‘0’, list_100 = ‘0’ WHERE id = ‘910’

    July 29, 2023 at 2:08 pm #304626
    Stefano
    Keymaster

    Hi, looking at the error, the man number of lists has been changed with a define in your wp-config.php to raise the number to 100, but the plugin needs to be deactivated and reactivate to update the database.

    July 29, 2023 at 2:51 pm #304627
    tperke
    Participant

    It can’t be because of that. Because the error occurred before I had changed the wp-config..

    July 29, 2023 at 3:39 pm #304628
    Stefano
    Keymaster

    Hi, in your code it is clearly trying to save data for the list number 100 and that is only possible if the max number of lists has been customized. Check your wp-config.php. If you can’t find the define that changes the number of lists, you should check the functions.php of your theme, which is activated before all plugins.

    Newsletter creates 40 lists on installation.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.