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.

Hosting Requirements

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

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

Cannot flush DB on live site


Reply

4 Posts   1986 Views

Avatar
Valorinbattle

6 March 2009 at 8:10am Community Member, 95 Posts

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

Avatar
Willr

6 March 2009 at 12:02pm Forum Moderator, 5511 Posts

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");

Avatar
Valorinbattle

6 March 2009 at 12:44pm Community Member, 95 Posts

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

Avatar
Sam

6 March 2009 at 12:51pm Administrator, 685 Posts

Yeah that should do it.