PDA

View Full Version : Server crashed, problems after restore



david_scott
Mon 21st Sep '09, 11:39am
>Server that was running VBulletin v 3.6 crashed.
>It is a windows 2000 server, running on IIS. It was running on php version 2.5.
>I have a backup of the folder that contained all the files for the vbulletin forum.
>I have a backup of the mysql database.
>I have a backup of the php directory.

What I have done:
>Uploaded the forum folder to the IIS wwwroot folder in inetpub.
>Copied the php folder to c:\php. Followed the instructions to get php working properly. I am able to get the phptest file to load if I navigate to it in IIS. right click it and type browse.
>Restored the mysql database. Edited the config.php file to point to the mysql database.

here is what is happening:

It seems to be working fine from the server. However, when I browse to it from a client workstation, the page loads, but however after logging in, there is just a blank page.

I have followed numerous instructions on how to resolve "blank pages" to no avail. Where else can I be looking or what did I do wrong in the first place?

My next step is to start over again using the install/upgrade instructions.

Any help would be appreciated!

dodgeboard.com
Mon 21st Sep '09, 12:31pm
So, you did already try re-uploading (overwriting) the php files again using ascii? not auto...?

see also: http://www.vbulletin.com/forum/showthread.php?t=318441

IBxAnders
Mon 21st Sep '09, 12:55pm
>Server that was running VBulletin v 3.6 crashed.
>It is a windows 2000 server, running on IIS. It was running on php version 2.5.
>I have a backup of the folder that contained all the files for the vbulletin forum.
>I have a backup of the mysql database.
>I have a backup of the php directory.

What I have done:
>Uploaded the forum folder to the IIS wwwroot folder in inetpub.
>Copied the php folder to c:\php. Followed the instructions to get php working properly. I am able to get the phptest file to load if I navigate to it in IIS. right click it and type browse.
>Restored the mysql database. Edited the config.php file to point to the mysql database.

here is what is happening:

It seems to be working fine from the server. However, when I browse to it from a client workstation, the page loads, but however after logging in, there is just a blank page.

I have followed numerous instructions on how to resolve "blank pages" to no avail. Where else can I be looking or what did I do wrong in the first place?

My next step is to start over again using the install/upgrade instructions.

Any help would be appreciated!

Have you tried disabling all products in config.php file:

define('DISABLE_HOOKS', 1);

snakes1100
Mon 21st Sep '09, 8:42pm
http://www.vbulletin.com/docs/html/main/blank_pages

david_scott
Tue 22nd Sep '09, 11:51am
How do I copy the php files in ASCII format and not auto?

dodgeboard.com
Tue 22nd Sep '09, 11:59am
Copying files in ascii, not auto (http://www.lmgtfy.com/?q=copy+the+php+files+in+ASCII+format+and+not+auto %3F+)

david_scott
Tue 22nd Sep '09, 12:11pm
Ok so ....i don't have any extra lines in my config.php file. my php test page loads fine but its says my php.ini path is c:\winnt but then the line after that says c:\php\php.ini

I added the the disable hooks line in my config.php and that didn't work.

david_scott
Tue 22nd Sep '09, 12:23pm
Copying files in ascii, not auto (http://www.lmgtfy.com/?q=copy+the+php+files+in+ASCII+format+and+not+auto %3F+)

Cute.......

I did google it before I posted. Most of the hits talk about ftp in ascii format. I am not using ftp. I have downloaded a zip of the php and extracted on the hard drive of the web server. The website is hosted internally on a server so no need to ftp...

unless you are saying I still need to ftp them in ascii format anyway instead of just extracting directly to a folder?

david_scott
Tue 22nd Sep '09, 12:52pm
I guess what gets me is why does it work fine from the server but not the clients? the server and clients are all on the same network segment.

david_scott
Fri 25th Sep '09, 10:40am
Worked with support and turns out the issue was being caused by sql being in strict mode:

"I have inspected the installation and i found that you are using MySQL in strickt mode. I have updated your config.php file (C:\Inetpub\wwwroot\Forum\includes\config.php) to reflect this by changing:

$config['Database']['force_sql_mode'] = false;

to:

$config['Database']['force_sql_mode'] = true;"

Wayne Luke
Fri 25th Sep '09, 11:02am
Not really sarcastic in the text. The link is a little over the top but this is the most common reason.

Make sure the files are in an ASCII format and not UTF-8. Especially the config.php which you edited on the computer. Many applications default to storing files in UTF-8 format which can introduce hidden characters that lead to PHP errors and blank pages. This is especially prevalent because the space character in UTF-8 is not the same character in an ASCII file. So if you copy and paste from one application to another, you can cause problems as well. To find inappropriate characters make sure you're using a program that can show hidden spaces.

dodgeboard.com
Fri 25th Sep '09, 11:44am
You did say "Any help would be appreciated"

My apologies if I offended you David. I really was trying to help you.


You gotta lighten up bud.

david_scott
Fri 25th Sep '09, 11:48am
No problem. I'm being overly sensitive anyway. I actually kind of like your link by the way. I have a lazy co-worker who i am going to use this on! haha

And I deleted my whiney posts crying that i was being picked on

thanks

dodgeboard.com
Fri 25th Sep '09, 11:50am
cheers. Good luck with your forums.

david_scott
Fri 25th Sep '09, 12:12pm
Thanks its actually our customer's forum, we helped in restoring it, but thanks!