installed a clean 2.4 on a new host ( apache server) installed fine.
uploaded mytheme,mysite and modules and imported database which installed ok.
when I ran dev/build/?flush=1 I get this error.....

[User Error] Couldn't run query: SHOW FULL FIELDS IN "Member" Table 'SS_mysite.Member' doesn't exist
GET /dev/build/?flush=all

Line 536 in /var/www/vhosts/kentishweald.co.uk/httpdocs/sapphire/core/model/MySQLDatabase.php
Source

527    }
528    
529    function databaseError($msg, $errorLevel = E_USER_ERROR) {
530       // try to extract and format query
531       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
532          $formatter = new SQLFormatter();
533          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
534       }
535       
536       user_error($msg, $errorLevel);
537    }
538    
539    /**
540     * Return a boolean type-formatted string
541     *
542     * @param array $values Contains a tokenised list of info about this data type

Trace

* Couldn't run query: SHOW FULL FIELDS IN "Member" Table 'SS_mysite.Member' doesn't exist
Line 536 of MySQLDatabase.php
* MySQLDatabase->databaseError(Couldn't run query: SHOW FULL FIELDS IN "Member" | Table 'SS_mysite.Member' doesn't exist,256)
Line 134 of MySQLDatabase.php
* MySQLDatabase->query(SHOW FULL FIELDS IN "Member",256)
Line 126 of DB.php
* DB::query(SHOW FULL FIELDS IN "Member")
Line 343 of MySQLDatabase.php
* MySQLDatabase->fieldList(Member)
Line 285 of DB.php
* DB::fieldList(Member)
Line 850 of Security.php
* Security::database_is_ready()
Line 28 of DevelopmentAdmin.php
* DevelopmentAdmin->init()
Line 136 of Controller.php
* Controller->handleRequest(SS_HTTPRequest)
Line 283 of Director.php
* Director::handleRequest(SS_HTTPRequest,Session)
Line 127 of Director.php
* Director::direct(/dev/build/)
Line 127 of main.php

The member and member password entries are in the database

anyone got any ideas what is wrong

Regards
Mike

Sean
thanks for the reply, I will try your suggestion and if no go a fresh install to get it running

Regards
Mike

update....

Twice now after dev/build I get these lines above the silverstripe logo both in the database and a messed up page in the cms page ---------

* Director::set_environment_type(Dev)
Line 28 of _config.php
* require_once(/var/www/vhosts/kentishweald.co.uk/httpdocs/mysite/_config.php)
Line 7011 of manifest-main
* require_once(/var/www/vhosts/kentishweald.co.uk/httpdocs/silverstripe-cache/manifest-main)
Line 66 of ManifestBuilder.php
* ManifestBuilder::include_manifest()
Line 205 of Core.php
* require_once(/var/www/vhosts/kentishweald.co.uk/httpdocs/sapphire/core/Core.php)
Line 61 of main.php

Environment Builder (formerly db/build)

Regards
Mike