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're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Hosting Requirements /

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

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

Cannot flush DB on live site

Go to End

4 Posts   2511 Views


Community Member, 95 Posts

6 March 2009 at 8:10am

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
The website server has not been able to respond to your request.

Any help? Thanks!

~ James


Forum Moderator, 5523 Posts

6 March 2009 at 12:02pm

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



Community Member, 95 Posts

6 March 2009 at 12:44pm

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


Administrator, 690 Posts

6 March 2009 at 12:51pm

Yeah that should do it.