The reason of asking is an addon to my `database errors` post below.

3 times I have done a fresh install of 2.4 on 34SP host, which installs ok, can use cms ok, can run /dev/build/ ok.

The problems /errors come when I upload my theme / site / modules and import database, all of which run on localhost no problem.

Is it best to upload everything at once or piecemeal? is one way any more likely to succeed than another?

Is there anything that needs altering or configuring differently before uploading to another server?

Seeing as I get different but serious errors each time, I presume the problem is in the process rather than the code

Any advice would be appreciated

Regards
Mike

Willr
Thanks for the reply

after a fresh install of 2.4, the config.php is overwritten, I upload my config.php to include...

ini_set('memory_limit','256M');
Director::set_environment_type("Dev");
require_once('conf/ConfigureFromEnv.php');

I run /dev/build which puts these lines ABOVE the database

* 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)

Entering /mysite/admin, these lines are at the top of all pages with most admin buttons missing.

If I drop the database and upload my site complete with importing my database, run /dev/build and 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

Yet the member and member password entries are in the database

Sean gave a couple of suggestions which did not work

I seem to be stumped every which way I try to install, I just hope someone can help

Regards
Mike

Willr
Thanks for your help, I managed to import the database ok and running dev/build?isDev=1 did the trick, it installed ok

The trying to flush the cache with /admin/?flush=1 I got this error plus a long list it could not query....

------------------------

[User Error] Couldn't run query: SELECT "SiteTree"."ClassName", ...etc: etc:

-----------------------

GET /Security/login?BackURL=%2Fadmin%2F%3Fflush%3D1

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

-------------------------
I have got these errors in the server log, Is this a memory issue?

Mon Jun 07 22:56:27 2010] [error] [client 195.137.8.183] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 41650 bytes) in /var/www/vhosts/kentishweald.co.uk/httpdocs/sapphire/profiler/Profiler.php on line 88
[Mon Jun 07 23:33:28 2010] [error] [client 195.137.8.183] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 86 bytes) in /var/www/vhosts/kentishweald.co.uk/httpdocs/sapphire/core/model/ErrorPage.php on line 222
[Mon Jun 07 23:33:48 2010] [error] [client 195.137.8.183] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 232 bytes) in /var/www/vhosts/kentishweald.co.uk/httpdocs/sapphire/core/model/ErrorPage.php on line 222

Can anyone help with this please

Regards
Mike