Plug in does not save options/settings to database

  • Resolved laCabriole

    (@lacabriole)


    8 years, 9 months ago

    Having this as it seems known and returning problem I read a dozen of threads about it but can’t find a given solution.
    I’m using this plug (vers. 5.2.2) in in a very complex WP 3.5 installation for about 2 years without any problems on another domain but with the same hosting firm. Nice Plug in.

    Now I’m setting up a fresh and only “Event Manager” site: Wp 4.4.2 French with latest plugIn version. No other plugs – default Theme 2016. Out of the box and no modifications. But no way to make it work! ( 128 mb php memory) . It’s on https://demo.messanges.net

    The settings of the plugIn won’t save to DB, which is to the wp_options table. The theme respectively WP does save to this table without problems.
    When i do manual changes of em relevant fields in the wp_options table these modifications are read without problems and they are refleced in the settings page of EM. (The 6 em_ specific tables work fine though – they save and get back everything as far as I see.)

    I switched DEBUG mode on : no ERRORS!
    When I set EM back to default in the admin section I got the following data base errors which do not relate to the wp_option table:

    Erreur de la base de données WordPress?: [Unknown column ‘event_notes’ in ‘ac_em_events’]
    ALTER TABLE ac_em_events CHANGE event_notes post_content longtext NULL DEFAULT NULL
    Erreur de la base de données WordPress?: [Unknown column ‘location_description’ in ‘ac_em_locations’]
    ALTER TABLE ac_em_locations CHANGE location_description post_content longtext NULL DEFAULT NULL

    When I tried to deinstall EM from the admin section I got the following ERRORS :

    Erreur de la base de données WordPress?: [Unknown table ‘ac_dbem_recurrence’]
    DROP TABLE ac_dbem_recurrence
    Erreur de la base de données WordPress?: [Unknown table ‘ac_em_categories’]
    DROP TABLE ac_em_categories

    (I used the table prefix ac_ for this installation.)

    I tried 3 older WP-EM combinations, even the one I mentioned above without any better results.

    Did you/anybody ever find out about this issue ? … for instance any specifications concerning the dB specs/requirements ?

    Thanx in advance
    Micky

    https://www.ads-software.com/plugins/events-manager/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter laCabriole

    (@lacabriole)

    Hi again, it seems as if the issue is bound to minimum requirements either of PHP version or mysql version. I succeeded in installing EM without problems on a webspace which runs php 5.6 with a mysql db version 5.5.

    Which of the two is the requirement ? Or are they both required ?
    If so these should be mentioned in the description of the PlugIn, I think.

    Thanx for getting back to me
    Micky

    Hi Micky,

    I think the issue here is when using PHP 7. Are you able to switch PHP versions on your new test server and see if the issues reappear?

    Thread Starter laCabriole

    (@lacabriole)

    Thanx for the answer,

    It is actually the PHP version – I found out. The webspace I first tried runs on PHP 5.2, which does not work. The installation on PHP 5.6. works.
    The mysql is not the issue. Both hosts had version 5.5 installed.

    As it seems to me this shows a minimum PHP requirement by some code bits of EM. It would be worth it to find out exactly. I did not try PHP 7.

    regards
    Micky

    Ok, thanks for testing to confirm the problem. This has already been reported to the Dev team so there should be an update to fix this.

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    Hi Micky,

    Sorry for the delay. My initial thought is I don’t think it’s a PHP version issue. We develop with the minimum PHP version required by WP in mind.

    Are you able to reproduce this more than once? The errors you stated say to me that an installation of EM went wrong at one point, and the tables we usually install weren’t installed.

    The solution would be to delete the dbem_version value from the wp_options table and trigger an update/install of EM, which will recreate the tables that are missing.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Plug in does not save options/settings to database’ is closed to new replies.