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   2040 Views

Avatar
Valorinbattle

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

Any help? Thanks!

~ James

Avatar
Willr

Forum Moderator, 5513 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

Director::set_environment_type("dev");

Avatar
Valorinbattle

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

Avatar
Sam

Administrator, 685 Posts

6 March 2009 at 12:51pm

Yeah that should do it.