Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » building database error

Our old forums are still available as a read-only archive.

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

Page: 1
Go to End
Author Topic: 1724 Views
  • nicb07
    Avatar
    4 Posts

    building database error Link to this post

    Hi,

    I'm trying to follow the first tutorial and have got to the 'Using a different template for the home page' section and am trying to rebuild the database using http://localhost:3000/db/build?flush=1. It creates some table then I get an error:

    FATAL ERROR: DATABASE ERROR: Couldn't run query: SHOW FULL FIELDS IN `VirtualPage` | Can't create/write to file 'C:\WINDOWS\TEMP\#sql_158_0.MYI' (Errcode: 17)
    At line 386 in C:\lighttpd\htdocs\sapphire\core\model\Database.php

    Debug (Debug::showError() in line 147 of Debug.php)
    msg =
    Couldn't run query: SHOW FULL FIELDS IN `VirtualPage` | Can't create/write to file 'C:\WINDOWS\TEMP\#sql_158_0.MYI' (Errcode: 17)
    errorLevel =
    256

    Anyone experienced this error before?

    Thanks

    Nicki

  • xeraa
    Avatar
    Google Summer of Code Hacker
    58 Posts

    Re: building database error Link to this post

    it could be related to missing right (does your current user have full rights in the temp folder?) or to the virus scanner (somehow locking files while scanning them and causing this problem).

    i would check permissions first and then try to disable the virus scanner while installing.

  • nicb07
    Avatar
    4 Posts

    Re: building database error Link to this post

    Cheers! got it working now

    1724 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.