Jump to:

546 Posts in 2160 Topics by 237 members

Hosting Requirements

SilverStripe Forums » Hosting Requirements » Cannot flush DB on live site

What you need to consider when choosing a hosting provider and plan.

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

Page: 1
Go to End
Author Topic: 1925 Views
  • Valorinbattle
    Avatar
    Community Member
    95 Posts

    Cannot flush DB on live site Link to this post

    I added a new Page type on my local site and everything worked great. But once I FTP'd that new pagetype to the hosted site and tried to flush the database, I got this error:

    Building Database
    Creating database tables
    • Newsletter
    • Newsletter_SentRecipient
    • Newsletter_Recipient
    • NewsletterType
    • PageComment
    • BrowserPollSubmission
    • Email_BounceRecord
    • Email_BlackList
    • Table Email_BlackList: repaired
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/l/o/v/lovesdoor/html/sapphire/core/model/DatabaseAdmin.php:137) in /home/content/l/o/v/lovesdoor/html/sapphire/core/Debug.php on line 151
    Error
    The website server has not been able to respond to your request.

    Any help? Thanks!

    ~ James

  • Willr
    Avatar
    Forum Moderator
    5462 Posts

    Re: Cannot flush DB on live site Link to this post

    Thats just a generic error. Try putting the site in dev mode to view the full error or view the apache logs.

    To put the site in dev mode just have this code in your mysite/_config.php file

    Director::set_environment_type("dev");

  • Valorinbattle
    Avatar
    Community Member
    95 Posts

    Re: Cannot flush DB on live site Link to this post

    Thanks WillR.

    Okay, so I get this (and a long list of other errors) but this is in red:

    FATAL ERROR: DATABASE ERROR: Couldn't run query: SHOW FULL FIELDS IN `Email_BlackList` | Table 'lov0905904081642.Email_BlackList' doesn't exist
    At line 431 in /home/content/l/o/v/lovesdoor/html/sapphire/core/model/Database.php

    So if I just drop Email_BlackList and re-import that field will it fix it?

    ~ James

  • Sam
    Avatar
    Administrator
    679 Posts

    Re: Cannot flush DB on live site Link to this post

    Yeah that should do it.

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