Blank page after Step 4, ver 4.5.0c

[AndySpeedie]

Hiya

Today I've spent about 12 hours trying to get this to work and now its 3am and I'm off to bed.

My problem is that after compeleting all FOUR pages I click next and just get a blank page, nothing about config.php or anything.

I checked permissions, all the PDFs, forum, change from php 5.1.6 to 5.1.1, made every change I can find to php.ini, rebooted dozens of times and still no luck.

My test setup is
Web Server is XP Pro running IIS, php 5.1.1, ASP 2 and SugarCRM 4.5.0.c - well not quite running it :-(
Database is MS SQL on W2k

The basic XP web server/W2K db server is working fine on a .net project

Help please

[ruchida]

Hi,
The Step 4 phase is trying to connect a DB server but seems to be failing.

Is there any log file generated in the SugarCRM root directory or IIS?

Is your DB server MS SQL 2005 Express?

Have you copied ntwdblib.dll, which is bundled with the package to your Windows system directory?

[AndySpeedie]

Hi,

No log file in the SurgarCRM root, the IIS log file just shows GETs and POSTs, no errors or clues. Last 6 entries are

22:48:10 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/install/dbConfig.js 304
22:48:10 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/include/pngbehavior.htc 304
22:48:32 127.0.0.1 POST /SugarSuite-for-Microsoft-Full-4.5.0c/install.php 200
22:48:32 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/install/siteConfig.js 304
22:48:32 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/include/pngbehavior.htc 304
22:48:40 127.0.0.1 POST /SugarSuite-for-Microsoft-Full-4.5.0c/install.php 200

The database version is MS SQL 2000. I am aware that 2005 is preferred but I understood the mechanics of how connections are made are the same.

Yep, copied ntwdblid.dll the Windows system directory.

Is there anyway to get error message to appear insterad of blank pages ?

Thanks for the help

[Bachrach]

I have the same exact issue. I checked the database and found that the user account and database was built. There page that was blank indicated that there was a problem with the page.

I checked the Apache error.log and found this error -
[Wed Oct 11 23:51:52 2006] [error] [client 207.244.162.25] PHP Notice: Undefined index: path in C:\\webroots\\crm.genericdomain.com\\install\\inst all_utils.php on line 701, referer: http://www.genericdomain.com:81/install.php

System Details -

Sugar CRM 4.5.0.d
Microsoft Windows Server 2003 Service Pack 1
Apache 2.2
php 5.1.4 (Also tried 5.1.6)
ntwdblib.dll 2000.80.2039.0
SQL Server Standard Edition (SP4)
Server Collation: SQL_Latin1_General_CP1_CI_AS

Help!

[ruchida]

Hi,

No log file in the SurgarCRM root, the IIS log file just shows GETs and POSTs, no errors or clues. Last 6 entries are

22:48:10 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/install/dbConfig.js 304
22:48:10 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/include/pngbehavior.htc 304
22:48:32 127.0.0.1 POST /SugarSuite-for-Microsoft-Full-4.5.0c/install.php 200
22:48:32 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/install/siteConfig.js 304
22:48:32 127.0.0.1 GET /SugarSuite-for-Microsoft-Full-4.5.0c/include/pngbehavior.htc 304
22:48:40 127.0.0.1 POST /SugarSuite-for-Microsoft-Full-4.5.0c/install.php 200

The database version is MS SQL 2000. I am aware that 2005 is preferred but I understood the mechanics of how connections are made are the same.

Yep, copied ntwdblid.dll the Windows system directory.

Is there anyway to get error message to appear insterad of blank pages ?

Thanks for the help

I'm not sure if it's related to the step 4 process, but unfortunately there are some SQLs that are not supported by MS SQL Server 2000.

[AndySpeedie]

I'll try installing SQL Express locally and let you know the outcome.

Regarding my fellow sufferer, my ntwdblib.dll is version 2000.80.164.0 and its straight from the SugarCRM install. I am afriad thats all the help I can give. Mind you, at least you are getting errors in your log files, mine give the apperance that everything is working just fine.

[AndySpeedie]

Next installment

Installed SQL Express and I still get a blank page after Step 4.

40 hours so far and I'm afraid I'm giving up. I've installed thousands of software packages over the 20 years I been working with computers and can not remember the last time I gave up.

Now I'm off to buy Goldmine :-(

If any one has any suggestions I'm willing to try them and give feedback

[chrisky]

Next installment

Installed SQL Express and I still get a blank page after Step 4.

40 hours so far and I'm afraid I'm giving up. I've installed thousands of software packages over the 20 years I been working with computers and can not remember the last time I gave up.

Now I'm off to buy Goldmine :-(

If any one has any suggestions I'm willing to try them and give feedback

Yeah, my first suggestion would try another sql server..
For example, trying editing you config.php file to ustilize a known working sql server from myself (would be willing to setup a db that you could have access to for a few days for testing and diagnosing) or anyone else with functioning sql servers..

Along those lines, I assume you have more than one puter? Everybody does these days..

Try installing the windows 'bitrock' versions of Sugar onto other computers of yours, and see if you can come up with a functioning (independant) sugar setup on a windows system.

In my case, to date, I have installed under windows once.. On my notebook is one of the bitrock installations, fully functioning, though I've never used it, not even for 5 mins.. lol
But it is, obviously, a functioning sql server under windows combined with a functioning copy of Sugar..

Here's where I'm going with it... The config.php file of a sugar installation is where the sql server, database name, and login info is located.. So view/get those details from say a working copy on a window system, and then edit the non-working copy of sugar on a different system to use the sql database config settings of the other system..

I'll just quit now, as it sounds like you're good and experienced..

On the topic of GM.... ARGH! This isn't place for me to get into that...
I'll make it simple, and say... "YOU'RE LUDACRIST" for considering to go near Frontrange...

Prior to finally moving over to Sugar at the beginning of the year, we've been using GM for a long time..

Lemme try a simpler angle... Wouldn't like $10 a month or something (for linux hosting) be ALOT cheaper than Goldmine?

GM still has alot over sugar, but at least Sugar has the "POTENTIONAL", where GM doesn't.. Bummer that frontrange is not only closed source, but went to the extreme of being anti-thirdparty developement..

Anyways, let me know how things play out..

[CKURE]

I am having this same problem with

ver 4.5.0d
MYSQL
Windows 2003 Server


Im I going to have to buy GM too? 10 hours now.

Thanks for any help you can give.

[daguayo]

Same problem here:
- SugarCRM 4.5.0d
- Windows 2003 Server + IIS 6
- MySql 4.1.18
- PHP 5.0.4

Could not find any error message into logs. I checked connection parameters and they're correct.

Thanks in advance.