Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

site gives error


Go to End


2 Posts   1555 Views

Avatar
Webdoc

Community Member, 349 Posts

1 May 2011 at 5:04am

[User Error] Couldn't run query: SHOW TABLES; Out of memory (Needed 2094560 bytes)
GET /
Line 525 in /home/osterval/public_html/sapphire/core/model/MySQLDatabase.php

Source
516 }
517
518 function databaseError($msg, $errorLevel = E_USER_ERROR) {
519 // try to extract and format query
520 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
521 $formatter = new SQLFormatter();
522 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
523 }
524
525 user_error($msg, $errorLevel);
526 }
527
528 /**
529 * Return a boolean type-formatted string
530 *
531 * @param array $values Contains a tokenised list of info about this data type
Trace
•Couldn't run query: SHOW TABLES; Out of memory (Needed 2094560 bytes)
Line 525 of MySQLDatabase.php
•MySQLDatabase->databaseError(Couldn't run query: SHOW TABLES; | Out of memory (Needed 2094560 bytes),256)
Line 123 of MySQLDatabase.php
•MySQLDatabase->query(SHOW TABLES;,256)
Line 129 of DB.php
•DB::query(SHOW TABLES;)
Line 40 of ClassInfo.php
•ClassInfo::hasTable(Object)
Line 78 of ClassInfo.php
•ClassInfo::dataClassesFor(Member)
Line 862 of Security.php
•Security::database_is_ready()
Line 81 of Controller.php
•Controller->init()
Line 97 of RootURLController.php
•RootURLController->handleRequest(SS_HTTPRequest)
Line 282 of Director.php
•Director::handleRequest(SS_HTTPRequest,Session)
Line 125 of Director.php
•Director::direct(/)
Line 127 of main.php

Avatar
Willr

Forum Moderator, 5523 Posts

1 May 2011 at 4:55pm

As the error message says right there at the top - Your mysql install is out of memory. SS requires that query to rebuild the database so you can't get rid of it but you can find some information about it and possible solutions online - e.g http://dev.mysql.com/doc/refman/5.0/en/out-of-memory.html