Jump to:

4873 Posts in 7171 Topics by 1471 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » database errors on install

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

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

Page: 1
Go to End
Author Topic: 1631 Views
  • oldwrinkly
    Avatar
    Community Member
    34 Posts

    database errors on install Link to this post

    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
    Avatar
    Forum Moderator
    921 Posts

    Re: database errors on install Link to this post

    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

  • oldwrinkly
    Avatar
    Community Member
    34 Posts

    Re: database errors on install Link to this post

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

    Regards
    Mike

  • oldwrinkly
    Avatar
    Community Member
    34 Posts

    Re: database errors on install Link to this post

    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

  • oldwrinkly
    Avatar
    Community Member
    34 Posts

    Re: database errors on install Link to this post

    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

    1631 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.