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.

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   1345 Views


Community Member, 347 Posts

1 May 2011 at 5:04am

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

516 }
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 }
525 user_error($msg, $errorLevel);
526 }
528 /**
529 * Return a boolean type-formatted string
530 *
531 * @param array $values Contains a tokenised list of info about this data type
•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
Line 78 of ClassInfo.php
Line 862 of Security.php
Line 81 of Controller.php
Line 97 of RootURLController.php
Line 282 of Director.php
Line 125 of Director.php
Line 127 of main.php


Forum Moderator, 5521 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