POST http://[MYURL]/admin/getshowdeletedsubtree?ajax=1&ID=0 500 Internal Server Error

500//ERROR [User Error]: Couldn't run query:
CREATE TEMPORARY TABLE IF NOT EXISTS _ArchiveSiteTree (
            RecordID INT NOT NULL PRIMARY KEY,
            Version INT NOT NULL
         )

Access denied for user '[MYSQLCREDS]'@'%' to database '[MYSQLCREDS]'
IN POST /admin/getshowdeletedsubtree?ajax=1&ID=0
Line 401 in [PATH]/sapphire/core/model/MySQLDatabase.php

Source
======
392:    }
393:
394:    function databaseError($msg, $errorLevel = E_USER_ERROR) {
395:       // try to extract and format query
396:       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397:          $formatter = new SQLFormatter();
398:          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399:       }
400:
* 401:       user_error($msg, $errorLevel);
402:    }
403: }
404:
405: /**
406: * A result-set from a MySQL database.
407: * @package sapphire

<ul>user_error(Couldn't run query:
CREATE TEMPORARY TABLE IF NOT EXISTS _ArchiveSiteTree (
            RecordID INT NOT NULL PRIMARY KEY,
            Version INT NOT NULL
         )

Access denied for user '[MYSQLCREDS]'@'%' to database '[MYSQLCREDS]',256)
line 401 of MySQLDatabase.php

MySQLDatabase->databaseError(Couldn't run query: CREATE TEMPORARY TABLE IF NOT EXISTS _ArchiveSiteTree (
            RecordID INT NOT NULL PRIMARY KEY,
            Version INT NOT NULL
         ) | Access denied for user '[MYSQLCREDS]'@'%' to database '[MYSQLCREDS]',256)
line 102 of MySQLDatabase.php

MySQLDatabase->query(CREATE TEMPORARY TABLE IF NOT EXISTS _ArchiveSiteTree (
            RecordID INT NOT NULL PRIMARY KEY,
            Version INT NOT NULL
         ),256)
line 120 of DB.php

DB::query(CREATE TEMPORARY TABLE IF NOT EXISTS _ArchiveSiteTree (
            RecordID INT NOT NULL PRIMARY KEY,
            Version INT NOT NULL
         ))
line 108 of Versioned.php

Versioned::requireArchiveTempTable(SiteTree)
line 733 of Versioned.php

Versioned::get_including_deleted(SiteTree,ParentID = 0)
line 515 of Hierarchy.php

Hierarchy->AllHistoricalChildren(CMSMain)

call_user_func_array(Array,Array)
line 550 of Object.php

Object->__call(AllHistoricalChildren,Array)

SiteTree->AllHistoricalChildren(CMSMain)
line 151 of Hierarchy.php

Hierarchy->markChildren(SiteTree,CMSMain,AllHistoricalChildren)
line 85 of Hierarchy.php

Hierarchy->markPartialTree(30,CMSMain,AllHistoricalChildren)

call_user_func_array(Array,Array)
line 550 of Object.php

Object->__call(markPartialTree,Array)

SiteTree->markPartialTree(30,CMSMain,AllHistoricalChildren)
line 479 of LeftAndMain.php

LeftAndMain->getSiteTreeFor(SiteTree,0,AllHistoricalChildren)
line 159 of CMSMain.php

CMSMain->getshowdeletedsubtree(HTTPRequest)
line 159 of Controller.php

Controller->handleAction(HTTPRequest)
line 129 of RequestHandler.php

RequestHandler->handleRequest(HTTPRequest)
line 119 of Controller.php

Controller->handleRequest(HTTPRequest)
line 277 of Director.php

Director::handleRequest(HTTPRequest,Session)
line 121 of Director.php

Director::direct(/admin/getshowdeletedsubtree)
line 118 of main.php

</ul>
http://[MYURL]/jsparty/prototype.js?m=1264795354
Line 658

500//There has been an error
http://[MYURL]/silverstripe/assets/base.js?m=1264788920
Line 55

which reads:
var Ajax={getTransport:function(){return Try.these(function(){return new ActiveXObject('Msxml2.XMLHTTP')},function(){return new ActiveXObject('Microsoft.XMLHTTP')},function(){return new XMLHttpRequest()})||false;},activeRequestCount:0}