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.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

database errors on install


Reply


5 Posts   1755 Views

Avatar
oldwrinkly

Community Member, 34 Posts

4 June 2010 at 11:33am

Edited: 04/06/2010 11:35am

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

Avatar
Sean

Forum Moderator, 922 Posts

4 June 2010 at 2:49pm

Edited: 04/06/2010 2:49pm

So the table "Member" actually exists in the SS_mysite database?

My suggestion would be to dev/build on an empty (or all tables truncated) database, and then import the tables you need one by one after that build has been done.

Sean

Avatar
oldwrinkly

Community Member, 34 Posts

5 June 2010 at 4:25am

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

Regards
Mike

Avatar
oldwrinkly

Community Member, 34 Posts

5 June 2010 at 7:09am

Update....

I dropped the database, did a /dev/build/ and re-exported / imported the database again.
run /dev/build/ with the same results.

tried a database repair all ok, tried a database check and got this warning for most of the entries including sitetree....

More than one INDEX key was created for column `RecordID`

I presume something has been duplicated somehow,
must admit I am out of my depth with databases

Regards
Mike

Avatar
oldwrinkly

Community Member, 34 Posts

5 June 2010 at 10:30am

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