Blank page after rolling back to 4.2.1

[dave.mcl]

After following instructions from this thread I get a blank page.
Tried a blank config.php to get install.php to run, same blank page.
Checked upgrade_history table - no references to 4.5.0

sugarcrm.log
08/10/06 15:21:29,301 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry 'c22c052e-4e97-1493-2dfe-43f108465d7c' for key 1
08/10/06 15:21:29,329 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry '90d96178-695e-9002-8234-43f1099602c7' for key 1
08/10/06 15:21:29,357 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry '564d60bc-8303-5228-16d9-43f00301c761' for key 1
08/10/06 15:21:29,385 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry 'acc50085-16cc-a5dd-499c-43f027ba1cec' for key 1
08/10/06 15:21:29,413 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry '70270b47-c5f7-da91-8ba0-43f0255c1f87' for key 1
08/10/06 15:21:29,442 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry 'bbde2325-6a19-cf96-e824-43f02f8ecf6f' for key 1
08/10/06 15:21:29,470 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry '978c8a88-3a42-1c41-996a-43f025b2574e' for key 1
08/10/06 15:27:17,345 [5288] FATAL SugarCRM - Error fetching relationship from cache quotes_billto_accounts
08/10/06 15:27:17,348 [5288] FATAL SugarCRM - Error fetching relationship from cache quotes_shipto_accounts
08/10/06 15:34:16,574 [5288] ERROR SugarCRM - MySQL error 1062: Duplicate entry '9037d4bc-a7c5-4186-8e81-43f030df4bd9' for key 1
08/28/06 14:59:28,554 [4332] FATAL SugarCRM - SECURITY: User authentication for kathyi failed
08/28/06 14:59:29,704 [4332] FATAL SugarCRM - SECURITY: User authentication for kathyi failed
09/08/06 15:29:38,015 [1192] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/08/06 15:34:02,435 [1192] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/08/06 15:34:13,828 [1192] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/08/06 15:34:22,704 [1192] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/08/06 15:37:13,344 [1192] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/09/06 12:15:03,902 [1392] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/09/06 12:25:00,481 [2728] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/10/06 12:15:00,570 [3768] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/10/06 12:25:00,482 [2556] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'
09/11/06 11:19:41,221 [1744] FATAL SugarCRM - MySQL error 1193: Unknown system variable 'NAMES'

Any ideas ?
TIA
Dave

[dave.mcl]

Platform: Windows 2003;IIS;MySQL 4.0.22 (upgraded to 4.1.21);PHP 5.0.2

Looks like its PHP related, On checkSystem.php it dies on the session check, which is weird because this has never been an issue in the past.

Heres my phpinfo output:

phpinfo()
PHP Version => 5.0.2

System => Windows NT DIABLO 5.2 build 3790
Build Date => Sep 24 2004 01:24:24
Configure Command => cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
Server API => Command Line Interface
Virtual Directory Support => enabled
Configuration File (php.ini) Path => c:\PHP\php.ini
PHP API => 20031224
PHP Extension => 20040412
Zend Extension => 220040412
Debug Build => no
Thread Safety => enabled
IPv6 Support => enabled
Registered PHP Streams => php, file, http, ftp, compress.zlib
Registered Stream Socket Transports => tcp, udp

Configuration

PHP Core

Directive => Local Value => Master Value
allow_call_time_pass_reference => Off => Off
allow_url_fopen => On => On
always_populate_raw_post_data => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
asp_tags => Off => Off
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => C:\PHP\extras\browscap.ini => C:\PHP\extras\browscap.ini
default_charset => no value => no value
default_mimetype => text/html => text/html
define_syslog_variables => Off => Off
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => Off => Off
display_startup_errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => Off => Off
error_append_string => no value => no value
error_log => no value => no value
error_prepend_string => no value => no value
error_reporting => 2047 => 2047
expose_php => On => On
extension_dir => C:\PHP\ext\ => C:\PHP\ext\
file_uploads => On => On
highlight.bg => #FFFFFF => #FFFFFF
highlight.comment => #FF8000 => #FF8000
highlight.default => #0000BB => #0000BB
highlight.html => #000000 => #000000
highlight.keyword => #007700 => #007700
highlight.string => #DD0000 => #DD0000
html_errors => Off => On
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => Off
include_path => .;c:\php\includes => .;c:\php\includes
log_errors => On => On
log_errors_max_len => 1024 => 1024
magic_quotes_gpc => Off => Off
magic_quotes_runtime => Off => Off
magic_quotes_sybase => Off => Off
mail.force_extra_parameters => no value => no value
max_execution_time => 0 => 30
max_input_time => 60 => 60
open_basedir => no value => no value
output_buffering => 0 => 4096
output_handler => no value => no value
post_max_size => 8M => 8M
precision => 14 => 14
register_argc_argv => On => Off
register_globals => Off => Off
register_long_arrays => Off => Off
report_memleaks => On => On
report_zend_debug => Off => Off
safe_mode => Off => Off
safe_mode_exec_dir => no value => no value
safe_mode_gid => Off => Off
safe_mode_include_dir => no value => no value
sendmail_from => no value => no value
sendmail_path => no value => no value
serialize_precision => 100 => 100
short_open_tag => On => On
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 6M => 6M
upload_tmp_dir => C:\PHP\temp => C:\PHP\temp
user_dir => no value => no value
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
y2k_compliance => On => On
zend.ze1_compatibility_mode => Off => Off

bcmath

BCMath support => enabled

calendar

Calendar support => enabled

com_dotnet

COM support => enabled
DCOM support => disabled
.Net support => enabled

Directive => Local Value => Master Value
com.allow_dcom => 0 => 0
com.autoregister_casesensitive => 1 => 1
com.autoregister_typelib => 0 => 0
com.autoregister_verbose => 0 => 0
com.code_page => no value => no value
com.typelib_file => no value => no value

ctype

ctype functions => enabled

curl

CURL support => enabled
CURL Information => libcurl/7.11.2 OpenSSL/0.9.7c zlib/1.1.4

dom

DOM/XML => enabled
DOM/XML API Version => 20031129
libxml Version => 2.6.11
HTML Support => enabled
XPath Support => enabled
XPointer Support => enabled
Schema Support => enabled
RelaxNG Support => enabled

ftp

FTP support => enabled

gd

GD Support => enabled
GD Version => bundled (2.0.28 compatible)
FreeType Support => enabled
FreeType Linkage => with freetype
FreeType Version => 2.1.9
GIF Read Support => enabled
GIF Create Support => enabled
JPG Support => enabled
PNG Support => enabled
WBMP Support => enabled
XBM Support => enabled

iconv

iconv support => enabled
iconv implementation => "libiconv"
iconv library version => 1.9

Directive => Local Value => Master Value
iconv.input_encoding => ISO-8859-1 => ISO-8859-1
iconv.internal_encoding => ISO-8859-1 => ISO-8859-1
iconv.output_encoding => ISO-8859-1 => ISO-8859-1

imap

IMAP c-Client Version => 2000

libxml

libXML support => active
libXML Version => 2.6.11
libXML streams => enabled

mbstring

Multibyte Support => enabled
Multibyte string engine => libmbfl
Multibyte (japanese) regex support => enabled
Multibyte regex (oniguruma) version => 2.2.4

Directive => Local Value => Master Value
mbstring.detect_order => no value => no value
mbstring.encoding_translation => Off => Off
mbstring.func_overload => 0 => 0
mbstring.http_input => pass => pass
mbstring.http_output => pass => pass
mbstring.internal_encoding => ISO-8859-1 => no value
mbstring.language => neutral => neutral
mbstring.substitute_character => no value => no value

mhash

MHASH support => Enabled
MHASH API Version => 20020524

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 3.23.57

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => no value => no value
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off

[dave.mcl]

odbc

ODBC Support => enabled
Active Persistent Links => 0
Active Links => 0
ODBC library => Win32

Directive => Local Value => Master Value
odbc.allow_persistent => On => On
odbc.check_persistent => On => On
odbc.default_db => no value => no value
odbc.default_pw => <i>no value</i> => <i>no value</i>
odbc.default_user => no value => no value
odbc.defaultbinmode => return as is => return as is
odbc.defaultlrl => return up to 4096 bytes => return up to 4096 bytes
odbc.max_links => Unlimited => Unlimited
odbc.max_persistent => Unlimited => Unlimited

pcre

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 4.5 01-December-2003

session

Session Support => enabled
Registered save handlers => files user sqlite
Registered serializer handlers => php php_binary wddx

Directive => Local Value => Master Value
session.auto_start => Off => Off
session.bug_compat_42 => Off => Off
session.bug_compat_warn => On => On
session.cache_expire => 180 => 180
session.cache_limiter => nocache => nocache
session.cookie_domain => no value => no value
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_secure => Off => Off
session.entropy_file => no value => no value
session.entropy_length => 0 => 0
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.hash_bits_per_character => 5 => 5
session.hash_function => 0 => 0
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => c:\php\temp => c:\php\temp
session.serialize_handler => php => php
session.use_cookies => On => On
session.use_only_cookies => Off => Off
session.use_trans_sid => 0 => 0

SimpleXML

Simplexml support => enabled
Revision => $Revision: 1.139.2.4 $
Schema support => enabled

SPL

SPL support => enabled
Interfaces => RecursiveIterator, SeekableIterator
Classes => ArrayObject, ArrayIterator, CachingIterator, CachingRecursiveIterator, DirectoryIterator, FilterIterator, LimitIterator, ParentIterator, RecursiveDirectoryIterator, RecursiveIteratorIterator, SimpleXMLIterator

SQLite

SQLite support => enabled
PECL Module version => 2.0-dev $Id: sqlite.c,v 1.146.2.2 2004/08/02 22:43:42 iliaa Exp $
SQLite Library => 2.8.14
SQLite Encoding => iso8859

Directive => Local Value => Master Value
sqlite.assoc_case => 0 => 0

standard

Regex Library => Bundled library enabled
Dynamic Library Support => enabled
Internal Sendmail Support for Windows => enabled

Directive => Local Value => Master Value
assert.active => 1 => 1
assert.bail => 0 => 0
assert.callback => no value => no value
assert.quiet_eval => 0 => 0
assert.warning => 1 => 1
auto_detect_line_endings => 0 => 0
date.default_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.83 => 90.83
date.sunset_zenith => 90.83 => 90.83
default_socket_timeout => 60 => 60
safe_mode_allowed_env_vars => PHP_ => PHP_
safe_mode_protected_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH
url_rewriter.tags => a=href,area=href,frame=src,input=src,form=fakeentr y => a=href,area=href,frame=src,input=src,form=fakeentr y
user_agent => no value => no value

tokenizer

Tokenizer Support => enabled

wddx

WDDX Support => enabled
WDDX Session Serializer => enabled

xml

XML Support => active
XML Namespace Support => active
libxml2 Version => 2.6.11

zlib

ZLib Support => enabled
Compiled Version => 1.1.4
Linked Version => 1.1.4

Directive => Local Value => Master Value
zlib.output_compression => Off => Off
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value

Additional Modules

Module Name


PHP Variables

Variable => Value
_SERVER["ALLUSERSPROFILE"] => C:\Documents and Settings\All Users
_SERVER["APPDATA"] => C:\Documents and Settings\davidm.IMS.000\Application Data
_SERVER["CLIENTNAME"] => MISU
_SERVER["ClusterLog"] => C:\WINDOWS\Cluster\cluster.log
_SERVER["CommonProgramFiles"] => C:\Program Files\Common Files
_SERVER["COMPUTERNAME"] => DIABLO
_SERVER["ComSpec"] => C:\WINDOWS\system32\cmd.exe
_SERVER["FP_NO_HOST_CHECK"] => NO
_SERVER["HOMEDRIVE"] => H:
_SERVER["HOMEPATH"] => \
_SERVER["HOMESHARE"] => \\diablo\users\davidm
_SERVER["LOGONSERVER"] => \\DIABLO
_SERVER["NUMBER_OF_PROCESSORS"] => 1
_SERVER["OS"] => Windows_NT
_SERVER["Path"] => C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32 \Wbem;c:\PHP;C:\Program Files\WatchGuard\wsm8\bin;C:\mysql\bin
_SERVER["PATHEXT"] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;. LNK
_SERVER["PHPRC"] => c:\PHP
_SERVER["PROCESSOR_ARCHITECTURE"] => x86
_SERVER["PROCESSOR_IDENTIFIER"] => x86 Family 6 Model 11 Stepping 1, GenuineIntel
_SERVER["PROCESSOR_LEVEL"] => 6
_SERVER["PROCESSOR_REVISION"] => 0b01
_SERVER["ProgramFiles"] => C:\Program Files
_SERVER["PROMPT"] => $P$G
_SERVER["SESSIONNAME"] => RDP-Tcp#1
_SERVER["SystemDrive"] => C:
_SERVER["SystemRoot"] => C:\WINDOWS
_SERVER["TEMP"] => C:\DOCUME~1\DAVIDM~1.000\LOCALS~1\Temp\1
_SERVER["TMP"] => C:\DOCUME~1\DAVIDM~1.000\LOCALS~1\Temp\1
_SERVER["USERDNSDOMAIN"] => BNE.IMS.COM
_SERVER["USERDOMAIN"] => IMS
_SERVER["USERNAME"] => davidm
_SERVER["USERPROFILE"] => C:\Documents and Settings\davidm.IMS.000
_SERVER["windir"] => C:\WINDOWS
_SERVER["PHP_SELF"] =>
_SERVER["SCRIPT_NAME"] =>
_SERVER["SCRIPT_FILENAME"] =>
_SERVER["PATH_TRANSLATED"] =>
_SERVER["DOCUMENT_ROOT"] =>
_SERVER["argv"] => Array
(
)

_SERVER["argc"] => 0
_ENV["ALLUSERSPROFILE"] => C:\Documents and Settings\All Users
_ENV["APPDATA"] => C:\Documents and Settings\davidm.IMS.000\Application Data
_ENV["CLIENTNAME"] => MISU
_ENV["ClusterLog"] => C:\WINDOWS\Cluster\cluster.log
_ENV["CommonProgramFiles"] => C:\Program Files\Common Files
_ENV["COMPUTERNAME"] => DIABLO
_ENV["ComSpec"] => C:\WINDOWS\system32\cmd.exe
_ENV["FP_NO_HOST_CHECK"] => NO
_ENV["HOMEDRIVE"] => H:
_ENV["HOMEPATH"] => \
_ENV["HOMESHARE"] => \\diablo\users\davidm
_ENV["LOGONSERVER"] => \\DIABLO
_ENV["NUMBER_OF_PROCESSORS"] => 1
_ENV["OS"] => Windows_NT
_ENV["Path"] => C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32 \Wbem;c:\PHP;C:\Program Files\WatchGuard\wsm8\bin;C:\mysql\bin
_ENV["PATHEXT"] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;. LNK
_ENV["PHPRC"] => c:\PHP
_ENV["PROCESSOR_ARCHITECTURE"] => x86
_ENV["PROCESSOR_IDENTIFIER"] => x86 Family 6 Model 11 Stepping 1, GenuineIntel
_ENV["PROCESSOR_LEVEL"] => 6
_ENV["PROCESSOR_REVISION"] => 0b01
_ENV["ProgramFiles"] => C:\Program Files
_ENV["PROMPT"] => $P$G
_ENV["SESSIONNAME"] => RDP-Tcp#1
_ENV["SystemDrive"] => C:
_ENV["SystemRoot"] => C:\WINDOWS
_ENV["TEMP"] => C:\DOCUME~1\DAVIDM~1.000\LOCALS~1\Temp\1
_ENV["TMP"] => C:\DOCUME~1\DAVIDM~1.000\LOCALS~1\Temp\1
_ENV["USERDNSDOMAIN"] => BNE.IMS.COM
_ENV["USERDOMAIN"] => IMS
_ENV["USERNAME"] => davidm
_ENV["USERPROFILE"] => C:\Documents and Settings\davidm.IMS.000
_ENV["windir"] => C:\WINDOWS

[atheimer98]

This happened while upgrading my centos 4.3 servers php version to support 4.5 I just had to edit the new php.ini file
to kick the memory and upload sizes up.

[dave.mcl]

Modified
memory_limit = 32M

Still no go!

[dave.mcl]

Solved by installing a new instance of Sugar, getting it to the same version as the existing one and then pointing it at the old database.