Exception thrown, cannot see Members

[RIPhoto2018]

When I click on Members under eMember menu, I get the following error on a blank screen:

=========================

Exception thrown

DateTime::__construct(): Failed to parse time string (Days) at position 0 (D): The timezone could not be found in the database

=========================

I cannot do anything with the members, display, edit, add, delete, all not accessible. I am not sure what caused it nor do I have any idea how to fix the problem. I will appreciate your assistance.

The site is riphotocenter.org

Thank you,

[wzp]

Does the error message tell you anything about the file or line number, the error occurred on?

Also, did you recently change ANYTHING, ANYPLACE about your date format or timezone? Because that’s what the error is complaining about.

[RIPhoto2018]

Nothing other than what I pasted in the original post, wzp. Appreciate your help. I have not changed any date format or timezone. I went to check the timezone in WordPress settings, it was set where it was before. To see if it would help, I removed the check mark from “Use WordPress Timezone:” in eMember settings, it did not.

I did a general search on Google and noticed similar questions asked by Joomla users but could not find anything specific to WordPress let alone eMember.

[RIPhoto2018]

I am not sure if related, but I created a bulk mail using Email Broadcast to be sent out later. However, that is not visible anywhere when I go to the Email Broadcast screen. Could scheduling that may be a trigger?

Thinking along these lines, I disabled that add on which did not make any difference in the problem. But, I have not tried deactivating and reactivating eMember.

[admin]

I think the following error message is the key:

The timezone could not be found in the database

Did you go to the settings and enable the “Use WordPress Timezone” option? Which timezone are you using in your WordPress’s general settings?

It is also a good idea to do the following test just to make sure this is not a conflict related issue:

https://support.tipsandtricks-hq.com/forums/topic/test-to-identy-a-conflicting-theme-or-plugin

[RIPhoto2018]

It was working fine, I imported members from a spreadsheet, added a few manually, and was able to view and edit members. The option to use WordPress Timezone was enabled, when I got the error message I disabled it to see if it would help, it did not. I will go back and enable it again to see if it helps.

I am using the Genesis framework and one of their child themes, News Pro. As I said, this emerged out of the blue. I asked my hosting company if there was something on the server, they suggested that I check the compatibility of the plugin with the PHP version they have installed, version 7.

Will it make any difference if I deactivate and then reactivate the eMember plugin? Deactivate, delete the plugin folder from FtP and upload a new copy?

Could it be related to the Email Broadcast issue I explained in the appended message later? I created a message to be sent later and it is not visible anywhere, I have no idea where it went.

Would you like to have an admin account to login and view the setup?

Thanks

[RIPhoto2018]

Since I wrote the above reply, I have done the following with no success in fixing the problem:

1. I switched the theme to the standard WordPress Twenty Seventeen, that did not fix the problem

2. I switched back to my Genesis child theme and disabled eMember. Then using FTP I deleted the folder from the plugins and uploaded a fresh copy. That did not fix the problem.

3. I disabled all the plugins, and that FIXED the problem

4. Trying them one at a time, I narrowed it to NextGEN Gallery which is a vital part of this site. When it is disabled, I can go into Members option in the dashboard.

I will write and report this to NextGEN as well. You have a relationship with them, I will appreciate if you could use your channel to coordinate an expedient fix to this problem.

Here is the link to my support post on NextGEN Gallery on WordPress.org.

https://wordpress.org/support/topic/conflict-with-emember-plugin/

UPDATE: Although I can go into Members, I noticed that I have lost a good number of the members on that screen. If I look into the database using phpMyAdmin, there are more members than shown in the Members tab. In fact, the Members screen shows total of 94, active 36, and displays SOME of them with no apparent pattern. If I sort desccending by the member ID, I can see the last member IDs and their records. But, if sorted by say name, I can see 1-32 on the first screen, 51-56 on the second screen, there is no more after that. Just two pages.

Thank you,

[RIPhoto2018]

Sorry to keep writing, but I am trying to provide as much information as I can so that we can resolve this issue quickly.

I have a staging site where I have the eMember and NextGEN installed and they seem to coexist without problems. Will it help:

1. If I provided the members table from both in Excel or SQL format that I will get from phpMyAdmin?

2. If there is a way, could we replace one table with another and see if that helps? If this is feasable, is there a way to do it without automatically generating the password changed email sent to all?

Thank you

[admin]

It will be best if I can check the admin side of your site. I will send you an email for it.

[RIPhoto2018]

The requested information has been sent via e-mail by the site developer.

[RIPhoto2018]

I appreciate your coming and taking a look at the back end of the site. Since I received your e-mail I did the following which SEEMS to have resolved the issue on a staging copy of the site:

1. Created a staging copy using WP Staging plugin

2. On the staging site, I deleted Email Broadcast, eMember Extended, and disabled NextGEN Gallery

3. I was able to go in and start reviewing the members. On the first page of the listing, I noticed the last member displayed had incomplete information after the Subscription Starts colum. So, I deleted that member

4. That seemed to clear the path to display more members

5. Likewise, I noticed similar entries that seemed to have corrupt records and I kept deleting them.

6. All in all, I deleted 10 such records to end up with 84 entries instead of 94 and enabled NextGEN Gallery

7. I am able to go in to Members and see the complete list of 84 members.

Now, the question is whether there is a reasonable method you may have to check the integrity of the database so that I can replicate the process on the live site.

I will send this as a reply to the e-mail message I received to see which one reaches you first.

Thank you,

[RIPhoto2018]

I am updating this thread for future information. After a long email exchange, I found the root of the problem. It was in the Membership Levels. All the levels are supposed to be expiring after 365 days, one was set to expire after a set date and the date field was blank. I am not sure how it happened, but I changed it to expire after 365 days as the others and it seems to be fine now.

I consider this issue to be resolved, through persistence, investigation, luck, and a hint from the problem members when I could see them.

FYI.

[Author]

Posts