Hi David,
Hope everything is great at your end.
I recently decided to change my hosting company and have been trying to move my PT installation. I was on a dedicated server before and now moved to new dedicated box with another host (WHM/cPanel).
I get following error on home page and all other pages:
Warning: Cannot modify header information - headers already sent by (output started at /home/fobocom/public_html/html/header.php:3) in /home/fobocom/public_html/html/header.php on line 13 And while importing feeds, I get this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fobocom/public_html/includes/database.php on line 21
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fobocom/public_html/includes/database.php on line 26 Last time I moved to a dedicated server, I remember following your advice regarding changing some of the server parameters. Unfortunately, I can't find that again. Since both servers have same PHP and MYSQL version, the errors are being caused by some wrong server parameters.
1 - Can you please let me know how I can check and modify those php parameters required to run a large PT database?
2 - And the best recommendation on how to move servers for a PT installation across dedicated servers?
I will appreciate your guidance and thanks a million in advance.
Regards
Bloach
Hello Bloach,
Could you email me your html/header.php and I'll check what's happening at line 13 to cause the "cannot modify headers" warning.
Details for MySQL server configuration for very large sites can be found here...
http://www.pricetapestry.com/node/732
Regarding your import errors; this may be to do with a modification to your code requiring a database change that has not been copied across from your old installation. What i'll do is reply to your email re: header.php with the debug version of includes/database.php that will reveal the SQL causing the error, and the actual MySQL error message which should indicate the problem...
Cheers,
David.