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


Reply


2 Posts   1217 Views

Avatar
Webdoc

Community Member, 334 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, 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 http://dev.mysql.com/doc/refman/5.0/en/out-of-memory.html