Support » Plugin: Event List » All the upcoming events have disappeared

  • I updated a bunch of plugins last week but I can’t say for sure if Event List was one of them. However, upon checking my site today I found out that all the upcoming events have disappeared and the last past events are from a year ago, even though there has been tens of events after that. I just noticed that there’s a new update for the plugin so I installed that but, as one may guess, that didn’t bring the events back.

    I suppose the only way to fix this is to create all the events all over again (I was dumb not to make a backup last week…), but seeing that the events somehow got deleted this might be something to look into? I know for sure that none of the other admins of my site are behind this.

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 15 replies - 16 through 30 (of 49 total)
  • Plugin Author mibuthu

    (@mibuthu)

    @zimbo000 – Thanks for the info, so with this small amount of events it should not be a problem of a timeout. I’m waiting for your log-data.

    Here is your requested info:

    DELETE FROM wp_options WHERE option_name = 'el_last_upgr_version';
    INSERT IGNORE INTO wp_options (option_name, option_value) VALUES ('el_db_version', '2');

    The first SQL query deletes the option “el_last_upgr_version” from the database which is created and used for upgrade checking since version 0.8.0.
    The second SQL query adds the option “el_db_version” which was used for database upgrades of the events table prior version 0.8.0.
    With these 2 changes in the database the upgrade process will be started again. So if you load a WordPress admin page after this database changes the upgrade process will be executed.

    DELETE FROM wp_posts WHERE post_type = 'el_events';
    DELETE FROM wp_postmeta WHERE meta_key = 'startdate' OR meta_key = 'enddate' OR meta_key = 'starttime' OR meta_key = 'location';

    This SQL queries are optional and will delete the already created events in the new data format. The old data format (separate database table wp_event_list) is still available, so if the upgrade is executed again, this events will be re-created in the new data format.
    This step is not necessarily required, because in 0.8.1 I have included a check for already existing events, so that no duplicate event will be created.

    • This reply was modified 1 year, 7 months ago by  mibuthu.

    @mibuthu
    I deleted the event list directory in /wp-content/plugins, did Add New Plugin using event-list.0.7.12.zip.

    Ran SQL
    DELETE FROM wp_posts WHERE post_type = ‘el_events’;
    DELETE FROM wp_postmeta WHERE meta_key = ‘startdate’ OR meta_key = ‘enddate’ OR meta_key = ‘starttime’ OR meta_key = ‘location’;
    to remove new format.

    Activated 0.7.12, upcoming events visible in Event List and on live page.

    Updated to 0.8.1.

    First attempt after update to access the Event List page gave this error.

    “WordPress > Error
    Sorry, you are not allowed to access this page.”

    Tried again and the page displayed correctly. No upcoming events displayed on Event List or on live page.

    Ran SQL
    DELETE FROM wp_options WHERE option_name = ‘el_last_upgr_version’;
    INSERT IGNORE INTO wp_options (option_name, option_value) VALUES (‘el_db_version’, ‘2’);

    When I did this 3 days ago on the first update attempt, the upcoming events then displayed. This time…

    Message displayed top of each admin page –
    ‘Upgrade of plugin “Event List” successful:
    Upgrade is already running’

    Plugin looks like it’s hung. Kept hard refreshing the page to clear cache for about 10 minutes, message still displayed. No upcoming events in Event List.

    Tried to deactivate plugin and activate but no change, ‘running’ message re-appeared.

    Deactivated and ran last SQL again. On activation, ‘Upgrade is already running’ message displays again. Still no events showing.

    Deactivated plugin, deleted directory, re-installed 0.7.12, ran SQL –
    DELETE FROM wp_posts WHERE post_type = ‘el_events’;# 51 rows affected.
    DELETE FROM wp_postmeta WHERE meta_key = ‘startdate’ OR meta_key = ‘enddate’ OR meta_key = ‘starttime’ OR meta_key = ‘location’;# 204 rows affected.

    Activated plugin, upcoming events appeared in Event List and on live page, all old events still listed in Events.

    No PHP errors reported.

    Not sure how I can help further. Please advise if my sequence of actions is incorrect or if you can offer other suggestions/SQL to find out why the events are not showing after update and/or how to stop the ‘Upgrade is already running’ message.

    Plugin Author mibuthu

    (@mibuthu)

    @zimbo000 – thanks for the info, but unfortunately still no idea whats the problem.

    Would be great if you can provide the following:

    • Complete log output which is created during the upgrade
    • A backup of data in the database table “wp_event_list”

    With this data i can have a look when the upgrade stops exactly and I can check the upgrade with your event-data.

    If you need help to prepare this data, please tell me.

    Thanks in advance.

    Happy to help.

    Backup I can do but how do I create the log output?

    Have you a Dropbox account or similar I can send the files to when ready?

    Plugin Author mibuthu

    (@mibuthu)

    To enable the debug logging add/edit the following lines in your wp-config.php:

    define( 'WP_DEBUG', true );
    define( 'WP_DEBUG_LOG', true );

    After that change all errors and warnings should be written to the file “/wp-content/debug.log”.

    See this link for more information.

    You can provide your files here.

    Thanks in advance.

    Files uploaded:
    wp_event_list.sql
    debug.log

    Actions taken:
    Turned on debug
    Updated plugin from 0.7.12 to 0.8.1
    Successful update, tried to access Event List
    Got repeated error:
    “WordPress > Error
    Sorry, you are not allowed to access this page.”
    Numerous hard cache refreshes made no difference
    Killed the tab, logged in again, could access Event List

    Message dislayed:
    ‘Upgrade of plugin “Event List” successful:
    Upgrade is already running’
    No upcoming events shown, nor any on live page
    Kept refreshing, upgrade running message would not go away

    About 10 minutes later, no change, ran SQL – result:
    DELETE FROM wp_options WHERE option_name = ‘el_last_upgr_version’;# MySQL returned an empty result set (i.e. zero rows).
    INSERT IGNORE INTO wp_options (option_name, option_value) VALUES (‘el_db_version’, ‘2’);# MySQL returned an empty result set (i.e. zero rows).

    No change. No upcoming events, upgrade message still displayed.

    Turned off debug, reverted back to 0.7.12. Could access Event List straight after activation i.e. no “no access” error, upcoming events visible again plus shown on live page

    PHP logging file on my host service is empty.

    Hope this is helpful.

    NB. That upload link gives a security/not safe/go back page when first accessed.

    Plugin Author mibuthu

    (@mibuthu)

    @zimbo000 – Thanks for your help.

    I have tried the upgrade process with your events and it worked in my installation without any problems.

    Unfortunately your debug.log does not help because the upgrade seem to be interupted, so the running upgrade check option is still in the database which avoids the upgrade from running again.

    So can you please execute the following steps again to create a new debug output:

    • Delete the old debug.log file in wp-content. The debug output still shall be enabled.
    • Delete the events in the new format and reset the options to the old format (including the removal of the “upgrade_in_progress” option):
      DELETE FROM wp_posts WHERE post_type = 'el_events';
      DELETE FROM wp_postmeta WHERE meta_key = 'startdate' OR meta_key = 'enddate' OR meta_key = 'starttime' OR meta_key = 'location';
      DELETE FROM wp_options WHERE option_name = 'el_last_upgr_version';
      DELETE FROM wp_options WHERE option_name = 'el_upgrade_in_progress';
      INSERT IGNORE INTO wp_options (option_name, option_value) VALUES ('el_db_version', '2');
    • Goto an admin page of your WordPress installation. –> Upgrade is executed
    • Reset the options to the old format again (without deleting the events in new format):
      DELETE FROM wp_options WHERE option_name = 'el_last_upgr_version';
      DELETE FROM wp_options WHERE option_name = 'el_upgrade_in_progress';
      INSERT IGNORE INTO wp_options (option_name, option_value) VALUES ('el_db_version', '2');
    • Goto an admin page of your WordPress installation again to execute the upgrade again.
    • Upload the debug.log message again.

    Thanks in advance for your help!

    • This reply was modified 1 year, 7 months ago by  mibuthu.

    Here we go – not as anticipated though. Log file uploaded. Hope it helps. I’m going on vacation tomorrow for about a week. I might be able to do something else if you need it before I go, otherwise it will have to wait I’m afraid.

    DELETE FROM wp_posts WHERE post_type = ‘el_events’;# 228 rows affected.

    DELETE FROM wp_postmeta WHERE meta_key = ‘startdate’ OR meta_key = ‘enddate’ OR meta_key = ‘starttime’ OR meta_key = ‘location’;# 912 rows affected.

    DELETE FROM wp_options WHERE option_name = ‘el_last_upgr_version’;# 1 row affected.

    DELETE FROM wp_options WHERE option_name = ‘el_upgrade_in_progress’;# MySQL returned an empty result set (i.e. zero rows).

    INSERT IGNORE INTO wp_options (option_name, option_value) VALUES (‘el_db_version’, ‘2’);# 1 row affected.

    Update to 0.8.1

    Upcoming events displayed in Event List and on live page

    DELETE FROM wp_options WHERE option_name = ‘el_last_upgr_version’;# 1 row affected.

    DELETE FROM wp_options WHERE option_name = ‘el_upgrade_in_progress’;# MySQL returned an empty result set (i.e. zero rows).

    INSERT IGNORE INTO wp_options (option_name, option_value) VALUES (‘el_db_version’, ‘2’);# 1 row affected.

    ‘Upgrade is already running’ briefly displayed but goes away

    Plugin version showing as 0.8.1 – cannot upgrade again as instructed

    Upcoming events displayed in Event List and on live page

    Plugin Author mibuthu

    (@mibuthu)

    Thanks @zimbo000 for the information.

    But are there still events missing?
    According to the log file all events where imported correctly.

    Hi, I have just updated to v0.8.1 & virtually all of our past events are not showing, except for 3 in 2013! When I first clicked on Event list in Admin it took an age, presumably upgrading the data structure & at the end there was a message saying it couldn’t access that page. However, it now says Upgrade of plugin “Event List” successful. I have updated the widget. Our site is http://www.womvg.org
    I have also updated to WP 4.9.4 & the site is PHP 5.6

    Please advise me what to do & how to do it. Do I need to trigger the upgrade of the old database structure again? Or do I need to go back to v0.7.12 until this is fixed?
    Thanks.

    @mibuthu
    Back from vacation…

    But are there still events missing?
    According to the log file all events where imported correctly.

    As per my last reply, everything is fine, all events are there. So going back to my OP on this topic – the initial 0.8.1 upgrade I did, did not work and I could not see the events until I ran one of the SQL queries. But we cannot seem to reproduce this. If you think there’s anything else I can do, let me know.

    Maybe @womvc-web, last post, can help you reproduce it?

    Hi @mibuthu & @zimbo000. Apologies for the delayed response, but I had to find out how to do this!
    I have run your recommended SQL queries using phpMyAdmin on MYSQL database. These are the results of the SQL queries:

    DELETE FROM wp_posts WHERE post_type = ‘el_events’;# 3 rows affected.
    DELETE FROM wp_postmeta WHERE meta_key = ‘startdate’ OR meta_key = ‘enddate’ OR meta_key = ‘starttime’ OR meta_key = ‘location’;# 12 rows affected.
    DELETE FROM wp_options WHERE option_name = ‘el_last_upgr_version’;# 1 row affected.
    INSERT IGNORE INTO wp_options (option_name, option_value) VALUES (‘el_db_version’, ‘2’);# MySQL returned an empty result set (i.e. zero rows).

    I went to an admin page of your WordPress installation again to execute the upgrade again. However, it appears that the upgrade process does not restart & I still have the following message displaying on the admin page:

    Upgrade of plugin “Event List” successful:
    Upgrade is already running

    The result is now that no events are being displayed. However, the event categories are still there. Are these processed/affected by the upgrade?

    Please advise me on my next course of action to correct the upgrade.

    Thanks, Rob

    Hi, I’m thinking I’ll just reverse the upgrade for now & go back to v0.7.12 until further advised. Thanks

    Plugin Author mibuthu

    (@mibuthu)

    Sorry for the late reply. I have now prepared another improvement in the upgrade process.
    With the new version there is no need to enable the debug output or to edit the database. A upgrade log will automatically be written in the plugin directory (e.g. wp-content/plugins/event-list/upgrade.log). Additionally if you have already done the upgrade you can manually trigger the upgrade again if you add the argument “resume-el-upgr=0.8.0” to your admin url (e.g. http://your-site.com/wp-admin/index.php?resume-el-upgr=0.8.0).

    It would be great if one of you can test this before I do the official release.
    You can download the actual development version here.

    Please provide the upgrade.log file if you still have problems.

    Thanks in advance.

    I just tried to update to the development version but got:

    Plugin could not be activated because it triggered a fatal error.
    Fatal error: Cannot declare class Event_List, because the name is already in use in /www2/6c5/dev.henley-art-crafts-guild.org/web/wp-content/plugins/wp-event-list-develop/event-list.php on line 41

    Version 0.7.12 is already active on the site and has upcoming events so I did a plugin Add New and Upload File for the zip file. This gave the error but created another Event List instance for 0.8.1 but it was inactive. So I inactivated 0.7.12 and activated 0.8.1, which worked – but it’s got no events, because the upcoming events are in the 0.7.12 version. ‘upgrade.log’ is empty.

    How do I upgrade 0.7.12 to 0.8.1 using the develop.zip file?

Viewing 15 replies - 16 through 30 (of 49 total)
  • The topic ‘All the upcoming events have disappeared’ is closed to new replies.