All the upcoming events have disappeared

@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 7 years 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.

@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?

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.

@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 7 years 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

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 https://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

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. https://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?