By ErikJanVens on

Hi,

My site uses Dutch as it's primary language, so in localization I enabled Dutch and disabled English. For the upgrade I reversed this: disabled Dutch, enabled English and made it the default. I also turned off cache.

Next, I set the site to maintenance-mode and disabled all contributed modules in the admin section. Then I deleted those modules from the directory. I set the theme to Garland and deleted the contributed theme.

Then I uploaded drupal 6.6 and added the $update_free_access = TRUE; line to settings.php

I loaded update.php and got the blank page. If I try to load the frontpage I get:

Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM url_alias WHERE dst = 'actueel' AND language IN('en', '') ORDER BY language DESC in /home/oldambt/igsd-oldambt.net/includes/database.mysql.inc on line 128

Fatal error: Call to undefined function: user_access() in /home/oldambt/igsd-oldambt.net/includes/menu.inc on line 2418

I have tried several options, going back and forth with the backup. But whatever I do this is where it stops.

Any pointers?

Thanks in advance, Erik-Jan

phpinfo gives:

PHP Version 4.3.10-22

System Linux malta 2.6.18-3-xen-686 #1 SMP Fri Dec 15 08:22:55 CET 2006 i686
Build Date Jun 30 2007 14:37:17
Configure Command '../configure' '--prefix=/usr' '--with-apxs=/usr/bin/apxs' '--with-config-file-path=/etc/php4/apache' '--enable-memory-limit' '--disable-debug' '--with-regex=php' '--disable-rpath' '--disable-static' '--with-pic' '--with-layout=GNU' '--with-pear=/usr/share/php' '--enable-calendar' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-bcmath' '--with-bz2' '--enable-ctype' '--with-db4' '--with-iconv' '--enable-exif' '--enable-filepro' '--enable-ftp' '--with-gettext' '--enable-mbstring' '--with-pcre-regex=/usr' '--enable-shmop' '--enable-sockets' '--enable-wddx' '--disable-xml' '--with-expat-dir=/usr' '--with-xmlrpc' '--enable-yp' '--with-zlib' '--without-pgsql' '--with-kerberos=/usr' '--with-openssl=/usr' '--with-zip=/usr' '--enable-dbx' '--with-mime-magic=/usr/share/misc/file/magic.mime' '--with-exec-dir=/usr/lib/php4/libexec' '--without-mm' '--with-curl=shared,/usr' '--with-dom=shared,/usr' '--with-dom-xslt=shared,/usr' '--with-dom-exslt=shared,/usr' '--with-zlib-dir=/usr' '--with-gd=shared,/usr' '--enable-gd-native-ttf' '--with-jpeg-dir=shared,/usr' '--with-xpm-dir=shared,/usr/X11R6' '--with-png-dir=shared,/usr' '--with-freetype-dir=shared,/usr' '--with-imap=shared,/usr' '--with-imap-ssl' '--with-ldap=shared,/usr' '--with-mcal=shared,/usr' '--with-mhash=shared,/usr' '--with-mysql=shared,/usr' '--with-unixODBC=shared,/usr' '--with-recode=shared,/usr' '--enable-xslt=shared' '--with-xslt-sablot=shared,/usr' '--with-snmp=shared,/usr' '--with-sybase-ct=shared,/usr' '--with-ttf=shared,/usr' '--with-t1lib=shared,/usr'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php4/apache/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.bzip2, compress.zlib

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

PHP Credits
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen Off Off
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_prepend_file no value no value
browscap no value no value
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 On On
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 On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2039 2039
expose_php On On

extension_dir /usr/lib/php4/20020429 /usr/lib/php4/20020429
file_uploads On On
gpc_order GPC GPC
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 On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 30 30
max_input_time 60 60
memory_limit 20M 20M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
register_argc_argv On On
register_globals Off Off
report_memleaks On On
safe_mode Off On
safe_mode_exec_dir /dev/null /dev/null
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
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 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On

apache
APACHE_INCLUDE no value
APACHE_TARGET no value
Apache Version Apache/1.3.33 (Debian GNU/Linux) PHP/4.3.10-22 mod_ssl/2.8.22 OpenSSL/0.9.7e mod_perl/1.29 DAV/1.0.3 mod_choke/0.06
Apache Release 10333100
Apache API Version 19990320
Hostname:Port www.igsd-oldambt.net:80
User/Group www-data(33)/33
Max Requests Per Child: 500 - Keep Alive: on - Max Per Connection: 300
Timeouts Connection: 300 - Keep-Alive: 5
Server Root /etc/apache
Loaded Modules mod_rpaf, mod_php4, mod_ssl, mod_perl, mod_dav, mod_choke, mod_setenvif, mod_expires, mod_proxy, mod_auth_digest, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_cgi, mod_dir, mod_autoindex, mod_status, mod_negotiation, mod_mime, mod_mime_magic, mod_log_config, mod_macro, mod_so, http_core

Directive Local Value Master Value
child_terminate 0 0
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
DOCUMENT_ROOT /home/oldambt/igsd-oldambt.net
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_CONNECTION keep-alive
HTTP_COOKIE SESScd52c6f03c351abc4a211f2ab99fedb9=06854f36e41330ac5aafbbeee300cabb; SESS394f9cb7b4c5b6b1e6277c06022e6ca1=e955c1b252d01e0c31388929c426a080
HTTP_HOST www.igsd-oldambt.net
HTTP_KEEP_ALIVE 300
HTTP_USER_AGENT Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.4) Gecko/2008111318 Ubuntu/8.04 (hardy) Firefox/3.0.4
PATH /bin:/usr/bin:/usr/local/bin
REMOTE_ADDR 212.238.240.127
REMOTE_HOST concentrator.demon.nl
REMOTE_PORT 47251
SCRIPT_FILENAME /home/oldambt/igsd-oldambt.net/aapje.php
SERVER_ADDR 195.35.176.141
SERVER_ADMIN webmaster@localhost
SERVER_NAME www.igsd-oldambt.net
SERVER_PORT 80
SERVER_SIGNATURE Apache/1.3.33 Server at www.igsd-oldambt.net Port 80
SERVER_SOFTWARE Apache/1.3.33 (Debian GNU/Linux) PHP/4.3.10-22 mod_ssl/2.8.22 OpenSSL/0.9.7e mod_perl/1.29 DAV/1.0.3 mod_choke/0.06
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /aapje.php
SCRIPT_NAME /aapje.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /aapje.php HTTP/1.1
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding gzip,deflate
Accept-Language en-us,en;q=0.5
Connection keep-alive
Cookie SESScd52c6f03c351abc4a211f2ab99fedb9=06854f36e41330ac5aafbbeee300cabb; SESS394f9cb7b4c5b6b1e6277c06022e6ca1=e955c1b252d01e0c31388929c426a080
Host www.igsd-oldambt.net
Keep-Alive 300
User-Agent Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.4) Gecko/2008111318 Ubuntu/8.04 (hardy) Firefox/3.0.4
HTTP Response Headers
X-Powered-By PHP/4.3.10-22
Keep-Alive timeout=5, max=300
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html; charset=iso-8859-1

--
Erik-Jan

⋅ Categories: Drupal 5.x

Comments

ambientdrup’s picture

ambientdrup commented

Take a look at my posts here:

http://drupal.org/node/333840

They might help. I had these similar issues.

-backdrifting

cog.rusty’s picture

cog.rusty commented

Also try increasing the PHP memory_limit from 20M to 32M, because Drupal 6 has higher memory requirements.

gpk’s picture

gpk commented

>Any pointers?
After the failed update you get the PHP warning (unknown column..) because the database has not been updated. No surprises there.
May be worth checking your Apache error log for any clues, but increasing memory limit is a good place to start.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

gpk’s picture

gpk commented

>Any pointers?
After the failed update you get the PHP warning (unknown column..) because the database has not been updated. No surprises there.
May be worth checking your Apache error log for any clues, but increasing memory limit and checking everything uploaded correctly are good places to start.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

ErikJanVens’s picture

ErikJanVens commented

Thanks all. I hadn't mentioned that I checked the Apache error-log but there is nothing there.

I've download a new copy of drupal-6.6. It is 1071507 bytes and extracts without problems.

I've increased the memory to 64M and it still doesn't work. I've run out of options and feel stuck.

--
Erik-Jan

cog.rusty’s picture

cog.rusty commented

Does running update.php, with increased memory, still give you a blank page?

Some more random ideas: Try to empty all cache tables, sessions, watchdog and search tables in the database, before taking the backup. Also, if you used to have the update status module (now in core), make sure to disable it.

gpk’s picture

gpk commented

Hmmm may be worth turning on PHP's log_errors, and temporarily possibly also display_startup_errors. You should be able to do these via php_flag in .htaccess since it looks like you are running PHP as Apache module.

http://uk2.php.net/manual/en/errorfunc.configuration.php#ini.log-errors

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

ErikJanVens’s picture

ErikJanVens commented

Thanks gpk,

I didn't know about that. Now I have several log-entries like this: [Sat Nov 22 22:32:49 2008] [error] PHP Warning: Unknown column & #039;serialized& #039; in 'field list'\nquery: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = & #039;variables& #039; in /home/oldambt/igsd-oldambt.net/includes/database.mysql.inc on line 128

I am not an expert but does this mean that ' gets translated into & #039;? When I type the query in cache.inc: $cache = db_fetch_object(db_query("SELECT data, created, headers, expire, serialized FROM {". $table ."} WHERE cid = '%s'", $cid)); in mysql as SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' I get normal results.

Where does this get translated? And how can I prevent it?

The contents of cache are:

Full Texts cid data expire created headers serialized
Edit Delete acidfree_types [BLOB - 748 B] 0 1227389143 0
Edit Delete locale:nl [BLOB - 196.9 KiB] 0 1226652725 0
Edit Delete variables [BLOB - 21.7 KiB] 0 1227389624 1

Thanks in advance, Erik-Jan
--
Erik-Jan
P.S. I had to enter a space in & #039; because I didn't know how to copy this verbatim.

gpk’s picture

gpk commented

What were you doing when you got the PHP Warning message? Looks like that query was run against the D5 DB (which doesn't have the serialized column), whereas you ran the query against a D6 DB.

Also, when you get the blank screen during update, how far had you got in the update process?

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

ErikJanVens’s picture

ErikJanVens commented

I truncated the cache-, sessions- and watchdog-tables and tried update.php again.

It switched to install and I soon discovered

Your MySQL Server is too old. Drupal requires at least MySQL 4.1.1. (Currently using MySQL database 4.0.24_Debian)

I guess this is the culprit. Anyhow it's a show-stopper.

Thanks everybody. I'll talk to my hoster before I try another upgrade.
--
Erik-Jan

gpk’s picture

gpk commented

Interesting. http://api.drupal.org/api/function/update_check_requirements/6 should have caught that (see near the bottom of http://api.drupal.org/api/file/update.php/6/source). Possibly a fatal error occurred before the problem was notified to you, but reporting of errors was suppressed by the line ini_set('display_errors', FALSE); some lines above hence the fatal error caused the blank screen?.

So the behaviour you have experienced looks like a bug. Any chance you could help tracking it down? What happens if you comment out the ini_set line and run update.php again (take a backup of update.php first if you want)?

Also note that the 'serialized' column gets added to all cache tables and the batch table gets created * before any updates "proper" are run, but after the requirements check. (So if the requirements check failed I'm not quite clear how the serialized column got added to your DB cache tables ...!) (* These are needed in order for update.php to work, and don't break the database if it subsequently needs to be used again with D5.)

install.php does some similar stuff to update.php, i.e. the requirements checking, and displays any problems using theme('install_page', ...) where update.php uses theme('update_page', ...) - can't imagine that's significant.

For info, the sequence (abbreviated) when visiting update.php is, display_errors gets turned off [to prevent some unavoidable but harmless errors from showing], the requirements get checked, if there are any problems then they are reported (on a page with a Continue button, which takes you to update.php?op=info) using theme('update_page', ...) and the script exits. If not then you are redirected to update.php?op=info (and the URL in the browser changes accordingly).

On the ?op=info page the sequence is: display_errors gets turned off, full Drupal bootstrap, batch table created, display_errors turned back on, check for permission to continue, some messing with cache tables, all modules checked for compatibility with D6, and you reach the main update info page with a Continue button.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

davecormier’s picture

davecormier commented

I am a bit of a bad drupal user... i have a tendency to not follow the upgrade instructions to the letter... and, in this case, my 'php white screen of death' was caused by having forgotten about the drupal 5 modules that I had in the local multisite drupal folder.

lee20’s picture

lee20 commented

I had this issue on 6.9. I got a white screen whenever I tried update.php. I had removed the Garland theme from the codebase as it was not in use. I restored the theme, and it works fine now. I guess the Garland theme is a requirement these days? Or perhaps I just need to adjust my admin theme.

gpk’s picture

gpk commented

Yes you should really leave Garland there, since if the default theme is not available then Drupal falls back to Garland automatically.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk