Support

Home Forums Event Espresso Premium Upgrade from Version 4.4.8.p to 4.6.23.p stalls on database upgrade 4.6

Upgrade from Version 4.4.8.p to 4.6.23.p stalls on database upgrade 4.6

Posted: April 24, 2015 at 4:13 pm


ATD Cascadia Chapter

April 24, 2015 at 4:13 pm

When updating 4.4.8.p to 4.6.23.p the database upgrade/migrate from 4.5 to 4.6 stalls at 97%. I’ve waited 10+ minutes for the update to complete but it just hangs and doesn’t upgrade.


Lorenzo Orlando Caum

  • Support Staff

April 27, 2015 at 4:14 pm

Hello,

Could you please create a temporary WordPress admin login so we can take a closer look at this issue?

Specifically, we would like to look at your database using a tool like PHPMyAdmin.

Please share that temporary login through the secure link below:

https://eventespresso.com/send-login-details/

Thanks


Lorenzo


Josh

  • Support Staff

April 27, 2015 at 5:08 pm

You can also try adding the following to your wp-config.php file:

define( 'EE_MIGRATION_STEP_SIZE', 5);

This will make the migration manager migrate only 5 records per request instead of the default 50. That means the migration will go much slower but it will reduce the chance of a timeout.


ATD Cascadia Chapter

April 30, 2015 at 6:42 pm

I’ve sent the information for the database via link you posted.


ATD Cascadia Chapter

May 5, 2015 at 4:53 pm

Is there any update on this? I tried to update with the function that Josh mentioned but it just hangs at 98% and doesn’t go past.


Lorenzo Orlando Caum

  • Support Staff

May 6, 2015 at 4:27 pm

Hi, I replied to your email earlier. I’ve asked a developer to take a look at the database to see if we can determine why its not completing.

I’ll follow up with you tomorrow via email.

Thanks


Lorenzo


ATD Cascadia Chapter

May 8, 2015 at 3:56 pm

So I cloned the site to a new server to try updating the database. It worked fine and other issues we were having (visual editor and date picker not showing on edit event pages) were fixed. I cloned the site back to the original host (liquidweb) and now I’m getting memory issues. After talking to support they are saying the EE is limiting the memory somewhere. We’ve added memory_limit to wp-config but it’s still giving a memory error.

From support at LiquidWeb: “The only way to get this to work is to disable Event Espresso. I tried a few work arounds with the PHP memory_limit however it appears there is someplace in their code that they are dynamically setting this to a lower value.”

The hosting environment (VPS with only this one site) should have enough memory for this site. Any fixes or ideas?


Tony

  • Support Staff

May 11, 2015 at 5:41 am

Hi there,

That statement is false, at no point will Event Espresso set your memory limit and yes a VPS with a single site should be more than adequate to run Event Espresso.

WordPress itself sets the memory limit to 40MB IF your php_memory limit within php.ini is set to a lower value.

You mentioned a Visual Editor, would this be Visual Composer (VC) or another? Most visual editors are heavy on the resources and Event Espresso also uses more memory than most plugins (because it does a lot more).

VC recommends 128MB as standard.

Can you go to Event Espresso -> Maintenance -> System Information.

Search for wp_memory and you’ll find something like this – http://take.ms/I9TbG

Can you tell me the value displayed there please? (Note Event Espresso simply reads this value and does not set it)

You can usually alter this value by editing your wp-config.php file, details here:

http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP

But its basically adding (or editing if currently there):

define( 'WP_MEMORY_LIMIT', '128M' );

However it depends on your host setup as this setting can be overridden on your server.


ATD Cascadia Chapter

May 11, 2015 at 4:11 pm

I’m unable to even get to that screen without getting:
“Fatal error: Out of memory (allocated 90177536) (tried to allocate 7680 bytes) in ….”

That’s with the wp-config memory limit set at 512M.

When I mentioned the Visual editor I mean the post editor that’s built into WordPress that allows “Visual” and “Text” editing of the event or post’s description. Not Visual Composer or anything added on

– Adam


Lorenzo Orlando Caum

  • Support Staff

May 11, 2015 at 6:08 pm

Hi, could you let us know the value that is set for wp_memory in the system information page?

https://monosnap.com/file/O3B1P6d47f06ckVEQuC8icWYfzSx7P

You mentioned that you tried 512M via your wp-config.php file but what does it show in the system information screen?


Lorenzo


ATD Cascadia Chapter

May 12, 2015 at 2:15 pm

Where is this “system information page”? If you’re referring to the one in EE then I’m unable to get to it at all because I get a “Fatal error: Out of memory” error.


Tony

  • Support Staff

May 12, 2015 at 2:25 pm

“Fatal error: Out of memory (allocated 90177536) (tried to allocate 7680 bytes) in …”

90177536 byes == ~90MB

What this usually means is that your host is overriding the value you set within wp-config.php.

Starting with the easiest to check, where are you adding the wp_memory_limit definition? Within the wp-config.php file it must be above this line:

require_once(ABSPATH . 'wp-settings.php');

Usually just above this comment:

/* That’s all, stop editing! Happy blogging. */

http://take.ms/lqtG2

What kind of hosting package are you using?


ATD Cascadia Chapter

May 12, 2015 at 2:35 pm

/** Memory Limit Setting */

define(‘WP_MEMORY_LIMIT’, ‘512M’ );

/** MySQL settings – You can get this info from your web host ** //

We have it above both the MySql settings and the require_once for wp-settings.php.

We’re using a VPS from LiquidWeb with only this one site hosted on it.


Tony

  • Support Staff

May 12, 2015 at 3:10 pm

Ok, so that should apply fine.

Have you tried restarting apache?


ATD Cascadia Chapter

May 12, 2015 at 7:01 pm

Restarted Apache but still having issues. Host is looking into it but any suggestions would be greatly appreciated. It seems to all stop when disabling EE but that doesn’t mean that’s it.


Tony

  • Support Staff

May 13, 2015 at 12:53 am

Hmm, strange.

It seems to all stop when disabling EE but that doesn’t mean that’s it.

Event Espresso is taking you over your limit, because your limit is still at 90MB.

With Event Espresso disabled install a plugin such as this:

https://wordpress.org/plugins/wp-memory-usage/

That will add something like this – http://take.ms/i7oX3 to you dashboard.

It shows your current memory limit and your current memory consumption.

What does it show your memory limit as?

Do you have any custom php.ini files saved within wordpress? Usually within /wp-admin/ but could also be within root.


ATD Cascadia Chapter

May 13, 2015 at 2:54 pm

I installed the memory plugin and it shows me I have Memory limit : 1024 MB and Memory usage : 81.47 MB. That seems like plenty. The server has 2gigs of memory.

http://www.evernote.com/shard/s323/sh/ce384de2-d822-4128-890b-ae7c77fc6d08/3751596748163f524009470206a909f7

I see the hosting company has tried php.ini in both the wp-admin folder and the root folders as they both have php.ini.back (I’m assuming a backup because it didn’t work) which are all set to 512mb.


Tony

  • Support Staff

May 13, 2015 at 4:11 pm

I noticed you’d sent log in details so I took a quick look over the files.

There’s something really strange going on with the server set-up.

php_info() within root shows a memory limit of 300M, WP shows a limit of 1024M, EE shows a limit of 80M, php.ini with wp-admin has 100M, php.ini.backup has the limit at 72M.

I’m not sure which should/would be used but ‘something’ is a miss with this setup, there’s just too many different values being shown. .htaccess also shows multiple version of the same rulesets.

I would recommend contacting your host and have them investigate this further, I doubt very much this is an issue with Event Espresso, but a server config issue, unfortunately what within the config is currently a mystery.

You host should be able to provide further details as they will know their server better than anyone.


Tony

  • Support Staff

May 13, 2015 at 4:11 pm

I noticed you’d sent log in details so I took a quick look over the files.

There’s something really strange going on with the server set-up.

php_info() within root shows a memory limit of 300M, WP shows a limit of 1024M, EE shows a limit of 80M, php.ini with wp-admin has 100M, php.ini.backup has the limit at 72M.

I’m not sure which should/would be used but ‘something’ is a miss with this setup, there’s just too many different values being shown. .htaccess also shows multiple version of the same rulesets.

I would recommend contacting your host and have them investigate this further, I doubt very much this is an issue with Event Espresso, but a server config issue, unfortunately what within the config is currently a mystery.

You host should be able to provide further details as they will know their server better than anyone.


Tony

  • Support Staff

May 13, 2015 at 4:28 pm

I also noticed you have a /plugins/ directory within /cache/ that contains all of the sites plugins.

Then wp-content/plugins/ also has plugins within there.

That’s not something I’ve seen before and I’m unsure how that would work, is that something you have set up yourself?


ATD Cascadia Chapter

May 13, 2015 at 4:46 pm

It’s not something that I’ve setup or know exactly why that’s like that. Possibly the host troubleshooting the issues or an old caching plugin. There’s no caching currently.

The host is currently looking into the memory issues more to see if they can find the 90meg limit it looks like it’s set to.


Tony

  • Support Staff

May 13, 2015 at 5:12 pm

It’s not something that I’ve setup or know exactly why that’s like that. Possibly the host troubleshooting the issues or an old caching plugin. There’s no caching currently.

I’ve not seen plugins stored within the cache directory before, I don’t think they would actually work from there so I’m not sure why it would be set up that way.

The host is currently looking into the memory issues more to see if they can find the 90meg limit it looks like it’s set to.

It’s a really strange issue, please let us know what your host finds.


ATD Cascadia Chapter

May 14, 2015 at 5:28 pm

Resolved! It was a memory issue with the hosting environment.

In hopes of helping others with this same issue:

From my hosts support: “Apache was limited to how much memory it could use in total with the following line: RLimitMEM 186004821”

I truly appreciate the help from the support staff here and thanks for sticking with it and spending the time to fix this error!


Tony

  • Support Staff

May 15, 2015 at 7:32 am

Thank you for letting us know, Adam.

I’m glad your host found the cause and your now back up an running, any further problems just let us know.

Have a great day.

The support post ‘Upgrade from Version 4.4.8.p to 4.6.23.p stalls on database upgrade 4.6’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso