• Resolved Rhapsody348

    (@rhapsody348)


    The following error log entry is created whenever a new site is created in a Multisite installation (subdomains):

    [24-Apr-2022 19:49:14 UTC] WordPress database error Table 'crewmgrc_wpcrmgr.wp_59_options' doesn't exist for query INSERT INTOwp_59_options(option_name,option_value,autoload) VALUES ('aiowpsec_db_version', '1.9', 'yes') ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload) made by wpmu_create_blog, wp_insert_site, do_action('wp_insert_site'), WP_Hook->do_action, WP_Hook->apply_filters, aiowps_ms_handle_new_site, AIOWPSecurity_Installer::create_db_tables, update_option, add_option

    I believe this may be hooked too soon as the table definitely exists when the site is created as I have checked it using phpMyAdmin.

    The function calling this is on line 149 of the file /wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-installer.php

    		update_option("aiowpsec_db_version", AIO_WP_SECURITY_DB_VERSION);
    

    Consider moving this to a hook called later in the initialization / setup of a new site.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support vupdraft

    (@vupdraft)

    Hi,

    Thank you for this, this has been reported to our development team for further investigation

    Thread Starter Rhapsody348

    (@rhapsody348)

    If you would like me to beta test some of the fixes on my multisite test server, please let me know. It is setup the same as my production server using a different subdomain as root.

    Plugin Support vupdraft

    (@vupdraft)

    @rhapsody348 – Thanks for this, if you could give it a test when its released and report back any errors that would be great.

    Thread Starter Rhapsody348

    (@rhapsody348)

    Just checking if the release is close since it has been just over 3 months since it was reported. I’ll test as soon as it is available.

    Thread Starter Rhapsody348

    (@rhapsody348)

    I realized I never posted with the results. This is definitely fixed and works great. Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Multisite Error Log Generation when New Site Created’ is closed to new replies.