Mysql [localhost] Error 5: Out of memory (Needed 4278190063)

Hi
I am running WAMP: PHP5.3, Mysql 5.1.36 and Apache 2.0.58
We had a server crash but managed to recover data from our virtual server

I have now created a new virtual server and are importing the databases again.
There where alot of corrupted tables etc, but fixed most of them with myisamchk

I have one fault left and that is in a Joomla table called jos_plugins.
When trying to run mysql repair it says:
the table jos_plugins (joomla) will not repair.
It says [localhost] Error 5: Out of memory (Needed 4278190063)

I read another question here and downgraded to PHP 5.1.6 but that did not do the difference
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/Apache/Q_24083017.html?sfQueryTermInfo=1+10+30+5+error+memori+mysql+out

Does anyone know what to do to clear this mysql error

morten444Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Beverley PortlockConnect With a Mentor Commented:
"Yes I had a backup of it thats 1 month old. Tried to only copy over this 3 files but same result. I was wondering if there where a mysql bug as i find it strange that old backup have same fault."

That is strange. Are there a lot of indexes on this table? If so, note them down, delete them, add the data to the table then put the indexes back one at a time.

The other trick to try is to create a database with a new name and load the old backup into that and see if it all builds correctly.


What is on \joomla\plugin\helper.php on lines 54 and 95? The error "Trying to get property of non-object" means that the bit to the left of the -> has not been created correctly. So let us say that the line in question looks like this

$someObject->someProperty = 1234;

Then it would be the $someObject part that was wrong so trace it backwards until you come to where it was instantiated

$someObject = new ObjectClassOfSomeSort();

and then see where the class definition is kept. That will head you in the right general direction.
0
 
Beverley PortlockCommented:
That's 4.3GB of memory. Just how big is this table?
0
 
morten444Author Commented:
Hi
The file is very small

jos_plugin.frm   9KB
jos_plugin.MYD 3KB
jos_plugin.MYI   5KB

So it must be corrupt i guess. Any good way to try to repair it/replace it?

I am quite new to mysql so having problems reading very tech documentation :)


0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Beverley PortlockCommented:
I would delete/rename the table and copy a fresh one from a similar joomla installation. You've nothing to lose because the current table doesn't work anyway. If it's corrupt beyond repair, then it is corrupt beyond repair.

I suspect I know the answer to the next question..... did you have a backup of this database?
0
 
morten444Author Commented:
Hi
thanks for your answer
Yes I had a backup of it thats 1 month old. Tried to only copy over this 3 files but same result.
I was wondering if there where a mysql bug as i find it strange that old backup have same fault.

I will try to empty it and try again
You can now the page nearly recovered on http://new.plastikkirurgi-glostrup.dk/
The error at the top.. wonder if thats related as its in the plugin folder.

0
 
morten444Author Commented:
Created new database
Copied the 3 files from new to old and it now works.
files only have list of plugins, so makde sure same template was installed in the new
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.