Memory exhausted error in admin panel after upgrade to 2.8

Even after applying the fixed file I still have to now use max memory usage of 64M when 32M was just fine before upgrading to 2.8.

Michael, I followed the advice at the link you provided, but it just duplicated all of the database categories, now titled wp_2comments, etc… when I run the new installation it doesn’t find any of the old posts.

In other words, the instructions there allowed me to import the 10 old WP SQL tables into my new database, as ten ADDITIONAL tables. But how can I get WP to recognize them?

mcbalz,

If you are moving to a new site, but just want your old tables, you should be DROPping the new tables then do the SQL import.

With that said, if you are sure you want to merge the two databases might restore the old tables into their own database, access those tables as a normal WordPress site, then do Tools->Export.

Then with the new tables blog do Tools->Import->WordPress.

Michael,

I am (or rather, have already) moved to a new site. I was forced to do that. At present, it is a totally blank WP install, with no custom theme and only one post… “Hello World!”

There’s no way, it seems, for me to access the old tables as a normal WordPress site… they are a .sql file. That is the only form in which they exist.

But if I delete the new tables in the new database, then import the .sql file containing the old tables, the site doesn’t work. A blank screen comes up.

What do you make of this?

MCB

I should clarify my last post… my new WP install is now dead because I deleted the old tables and imported the new ones in their place. Strangely, they did not import with the proper names (they added a “2” in front of the names, i.e. wp_2comments instead of wp_comments). I renamed the tables to wp_comments, etc.

But a completely blank browser window is all I get. WordPress ceases to function entirely.

Also, there doesn’t seem to be any way for me to get it back, short of recreating the database entirely from scratch, and reinstalling a freshly unpacked WP from the .zip. In other words, starting really from the beginning again. Which leaves me where I was.

But if I delete the new tables in the new database, then import the .sql file containing the old tables, the site doesn’t work. A blank screen comes up.

The new domain is the same as the old domain?
The $table_prefix is the same?
WordPress is installed in the SAME folder (e.g. web-root) at the new host as it was at the old host?

Michael, I really appreciate your patience and persistence here. You are an IT god.

The answers to your questions are:
yes
NO (I didn’t realize this before, but you caused me to check)
yes

So, in the new, working, but empty WP install, I corrected the $table_prefix in the wp-config.php file. Then I deleted all the tables in the new, working but otherwise empty database. And I imported all the old tables, which had the different table prefixes.

Now I am going to test the thing… drumroll please…

No, I am so sorry… it doesn’t work. A blank screen comes up, that’s all. Why is this happening?

*** later ***

I finally did make this work… by tinkering with the existing tables in the new install. Here’s how I did it.

First, I once again deleted all the tables inside my database, and ran a fresh install on the WP 2.8. What I learned from doing this (3 times before I got everything right) is that the “5-minute install” process is designed to take an empty database and set it up with the appropriate table structure. (Therefore, If you first delete the tables in your MySQL database and then try to open up your blog, it will effectively reinstall itself; like I said I did this about three times).

Trying to import the old tables into the new ones did not work. There were errors in the import. The inner structure of the tables did not match. It turns out that the backed up tables from my old blog were not created by a WP 2.8 install. What version was out in the days immediately prior to the official release? That was what I used.

Anyway, the result was that the WP_links, and the WP_Options table were both incompatible with the new release. But what I learned in the process was that the data had partially imported. I got working comments, but not working posts. It was importing the tables alphabetically and quitting (exiting the process) when something incompatible came up.

So what I did was I took a copy of the MySQL database dump file from the previous version and, using a text editor, deleted all the data relating to the options, links, and users tables (4 tables) leaving the relevant tables only for comments, posts, and terms (6 tables).

I then deleted all the comments, posts, and terms related tables on the new install. Then imported the copy.

BINGO. My blog is up and running. Time to customize.

https://eschata.apocryphum.com/

Hi, I see these posts are related to my problem except I got the following error not from upgrading. I already had 2.8 and was just adding plugins:

Manage Plugins
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 7680 bytes) in /home2/beeroyal/public_html/wp-includes/kses.php(401) : runtime-created function on line 1

I cannot get inot my plugins to delete or deactivate any. What can I do?
Thanks,

@nancylamont
How to deactivate all plugins when not able to access the administrative menus?

Adding
define(‘WP_MEMORY_LIMIT’, ’64M’);

to config.php as suggested by gestroud
solved my problem.

I had the same errors. finally got it fixed. editing config.php and adding php.ini didnt work for me.
try this link https://tinyurl.com/ntml96 …..i made a post on how i made it work. hope that helps ??

@elking10: I was actually upgrading a site for a client, and got this error. I had just upgraded another blog to 2.8, so I was a little puzzled. I saw on the sidebar that they had several plugins that needed updates. I went through one by one until I got to TDO miniforms… and I got the same error I got originally while trying to upgrade to version 2.8.1.: memory exhausted. I still poked around with the memory fixes for a while, but when I came across your comment, I realized the plugin was the issue. Deactivated it, upgraded WP, and re-activated it. It worked! ?? Now I just have to figure out how to update TDO MiniForms as it’s still exhausting the memory…

@ MichaelH, thanks for the “restoring your database from backup” link ??

[signature moderated Please read the Forum Rules]

You could also add this line to your wp-config.php

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

This way you won’t have to constantly make the fix again whenever you upgrade WordPress.

This worked for ME Thanks G!!!!

For me the solution was to deactivate the plugin

Simple Tags

After that I recived no more error messages.