Getting so many "Cannot modify header information" warnings

By sad-plast on 18 Sep 2008 at 12:18 UTC

Dear,

I am getting so many "Cannot modify header information - headers ... " and some Table warning, it seems there had been something unusuall.

FYI here are the errors that I get:

Warning: Unknown column 'data' in 'field list' query: SELECT data, created, headers, expire, serialized FROM ishc_cache WHERE cid = 'variables' in /home/plastasia/domains/plastica.asia/public_html/dp/includes/database.mysql.inc on line 128

Warning: Unknown column 'cid' in 'where clause' query: UPDATE ishc_cache SET data = 'a:252:{s:13:\"theme_default\";s:7:\"pixture\";s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:18:\"drupal_private_key\";s:64:\"967cce04a947437e02175642fbce40ec71cb6c44d3086f95cff9fede3bacf508\";s:10:\"menu_masks\";a:18:{i:0;i:63;i:1;i:62;i:2;i:61;i:3;i:59;i:4;i:31;i:5;i:30;i:6;i:29;i:7;i:24;i:8;i:21;i:9;i:15;i:10;i:14;i:11;i:11;i:12;i:7;i:13;i:6;i:14;i:5;i:15;i:3;i:16;i:2;i:17;i:1;}s:12:\"install_task\";s:4:\"done\";s:13:\"menu_expanded\";a:0:{}s:9:\"site_name\";s:17:\"www.plastica.asia\";s:9:\"site_mail\";s:18:\"info@plastica.asia\";s:21:\"date_default_timezone\";s:4:\"3600\";s:23:\"user_email_verification\";b:1;s:9:\"clean_url\";s:1:\"1\";s:12:\"install_time\";i:122089 in /home/plastasia/domains/plastica.asia/public_html/dp/includes/database.mysql.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /home/plastasia/domains/plastica.asia/public_html/dp/includes/database.mysql.inc:128) in /home/plastasia/domains/plastica.asia/public_html/dp/includes/bootstrap.inc on line 582

the site is http://www.plastica.asia.

Any help would be appreciated

Comments

Figure this out?

bomarmonk commented 21 March 2009 at 00:45

I am getting the same errors, so I'll post back here if I find the solution. This happened after I moved to a new host and transferred my database and files. I have another Drupal 6 site up and running with the same host and the same account, so I know that's not the problem.

My case: wrong database

bomarmonk commented 21 March 2009 at 16:10

In my case, I simply imported the wrong data into my new MySQL database (after switching hosts). I had to e-mail my previous host and beg them to send me a backup of the data. Luckily, Dreamhost is nice. With the right data, these errors went away for me.

Getting this too - post-migration

snorkers commented 25 March 2009 at 03:27

I had to upgrade my development machine and thought I'd easily migrate all of my Drupal 6 sites. However, I cannot login to any one of my sites on the new machine, and if I play around with MySQL I get a fistful of errors if I try and write directly to one of the databases (desperate stuff, but I'm struggling).
Things I've looked at include:
- double checking I'd actually grabbed the right MySQL dump
- ensured MySQL can deal with both InnoDB and MyISAM tables (tweaking my.ini or my.cnf)
- giving loads of resources to PHP and MySQL (more memory, packet size, buffer size etc)

The sites I'm trying to access allow me to view a page as an unauthorized user. When I log in I just get sent back to the user/login page. Cannot run update.php (even with $update_free_access set to TRUE). And nothing is being entered into the watchdog table. Kinda feels like I have a read only database in my migrated set up... which is why I've been trying to add tables/data directly via MySQL. When I do try and add data I get the said MySQL errors:
Warning: Cannot modify header information...
So struggling here and would welcome a pointer from anyone who knows a little more about correct configuration of PHP/MySQL (a brand new OSX10.5 machine, having been unsuccessful with a Vista machine too)