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, biapar, Willr, Ingo, swaiba, simon_w

site gives error


2 Posts   1217 Views


Community Member, 334 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, 5513 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