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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

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

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

database errors on install


Go to End


5 Posts   2882 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