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

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

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

Yeah that should do it.