I'm getting empty 'white pages' when trying to use Views 5.x-1.6 & CCK 5.x-1.5. At first I thought it was due to the Date Field module, but I got the same error when using the basic Text Field. After some testing I find that I can make a successful View with CCK off, but get errors (white pages) as soon as I turn it on. Here are the steps I went through to test a few permutations. I'm new to Drupal so I hope I'm just making a common mistake somewhere! Thanks in advance for your help.

*Fresh install of Drupal 5.1 on MacBook Pro in latest MAMP environment:
Apache 2.0.59
MySQL 5.0.37
PHP 4.4.6 & 5.2.1
*Backed up database with phpMyAdmin

1. Turned on Content 5.x-1.5 -> OK
2. Turned on Date API 5.x-1.6 -> OK
3. Turned on Date 5.x-1.6 -> OK
4. Created 'Test' content type with a date field -> OK
5. Created 'Test' node -> OK
6. Turned on Views 5.x-1.6 -> ERROR - WHITE PAGE
This page URL returns totally white/empty:
http://mamp.localhost:8888/?q=admin/build/modules/list/confirm
7. Hit 'back' on browser, tried base URL -> WHITE PAGE

* Dropped all tables in database using phpMyAdmin
* Restored initial database from backup

1. Turned on Views & Views UI 5.x-1.6 -> OK
2. Turned on Date API 5.x-1.6 -> OK
3. Turned on Content 5.x-1.5 -> ERROR - WHITE PAGE
This page URL returns totally white/empty:
http://mamp.localhost:8888/?q=admin/build/modules/list/confirm
4. Hit 'back' on browser -> I can see the Modules page
5. Turn off Content 5.x-1.5 -> ERROR - WHITE PAGE
6. Hit 'back' on browser -> I can see the Modules page
7. Turned on Content 5.x-1.5 -> ERROR - WHITE PAGE
8. Hit 'back' on browser -> I can see the Modules page
9. Turned on Date 5.x-1.6 -> ERROR - WHITE PAGE
10. Hit 'back' on browser -> ERROR - WHITE PAGE

* Dropped all tables in database using phpMyAdmin
* Restored initial database from backup

1. Turned on Content 5.x-1.5 -> OK
2. Turned on Text 5.x-1.5 -> OK
3. Created 'Test' content type with a text field -> OK
4. Created 'Test' node -> OK
5. Turned on Views & Views UI 5.x-1.6 -> ERROR - WHITE PAGE
6. Clicked 'back' a few times -> Admin Page appears
http://mamp.localhost:8888/?q=admin
7. Click over to admin/build/views/add -> OK
8. Start creating view, click on 'add field' -> ERROR WHITE PAGE

* Dropped all tables in database using phpMyAdmin
* Restored initial database from backup

1. Turned on Views & Views UI 5.x-1.6 -> OK
2. Created a Page node -> OK
3. Created a View with Node Title & Body -> OK

Comments

voidengine’s picture

voidengine commented
Title: Views 5.x-1.6 & CCK 5.x-1.5 not working together » Views 5.x-1.6 & CCK 5.x-1.5 not working together (with php 5.2.1)
Priority: Critical » Normal
Status: Active » Fixed

I just discovered that my MAMP was running php 5.2.1. I switched it to 4.4.6 and everything works fine.

merlinofchaos’s picture

merlinofchaos commented

That's not fixed; it should work with PHP 5.2.1.

Are you able to switch back for testing? Because it would be really valuable to look at the apache error log and see if it output a PHP error causing the whitescreen. (It may possibly be memory related).

voidengine’s picture

voidengine commented
Status: Fixed » Active

ok.... here's what happened... any ideas?

* Set MAMP to run php 5.2.1
* Dropped all tables in database using phpMyAdmin
* Restored initial database from backup

1. Turned on Content 5.x-1.5 -> OK
2. Turned on Views & Views UI 5.x-1.6 -> OK
3. Turned on Date API 5.x-1.6 -> WHITE PAGE

Nothing in the Apache or MySQL logs, but this was in the php log:

[18-Jul-2007 13:17:58] PHP Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 107953 bytes) in /Applications/MAMP/htdocs/drupal/includes/database.mysql.inc on line 380

[18-Jul-2007 13:17:58] PHP Warning: include_once(./themes/engines/phptemplate/phptemplate.engine) [function.include-once]: failed to open stream: No such file or directory in /Applications/MAMP/htdocs/drupal/includes/theme.inc on line 78

[18-Jul-2007 13:17:58] PHP Warning: include_once() [function.include]: Failed opening './themes/engines/phptemplate/phptemplate.engine' for inclusion (include_path='.:/Applications/MAMP/bin/php5/lib/php') in /Applications/MAMP/htdocs/drupal/includes/theme.inc on line 78

[18-Jul-2007 13:17:58] PHP Warning: Table 'watchdog' was not locked with LOCK TABLES
query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Table &amp;#039;sessions&amp;#039; was not locked with LOCK TABLES\nquery: SELECT sid FROM sessions WHERE sid = &amp;#039;657b690fe0b018a90238d5c69d263c7e&amp;#039;</em> in <em>/Applications/MAMP/htdocs/drupal/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://mamp.localhost:8888/?q=admin/build/modules/list/confirm', 'http://mamp.localhost:8888/?q=admin/build/modules', '127.0.0.1', 1184779078) in /Applications/MAMP/htdocs/drupal/includes/database.mysql.inc on line 172

[18-Jul-2007 13:17:58] PHP Warning: Table 'watchdog' was not locked with LOCK TABLES
query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Table &amp;#039;sessions&amp;#039; was not locked with LOCK TABLES\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;657b690fe0b018a90238d5c69d263c7e&amp;#039;, 1, 0, &amp;#039;127.0.0.1&amp;#039;, &amp;#039;form|a:3:{s:32:\\&amp;quot;6344da407cd27419d0c3958faa2d8d5c\\&amp;quot;;a:2:{s:9:\\&amp;quot;timestamp\\&amp;quot;;i:1184779061;s:4:\\&amp;quot;args\\&amp;quot;;a:1:{i:0;s:14:\\&amp;quot;system_modules\\&amp;quot;;}}s:32:\\&amp;quot;30ed112410889984fe20b2a7ab55900f\\&amp;quot;;a:2:{s:9:\\&amp;quot;timestamp\\&amp;quot;;i:1184779066;s:4:\\&amp;quot;args\\&amp;quot;;a:1:{i:0;s:14:\\&amp;quot;system_modules\\&amp;quot;;}}s:32:\\&amp;quot;5f0e192a3dc13f601ffb37e5ec05 in /Applications/MAMP/htdocs/drupal/includes/database.mysql.inc on line 172

merlinofchaos’s picture

merlinofchaos commented

Allowed memory size of 8388608 bytes exhausted (tried to allocate 107953 bytes)

Ahh, ok, that's the problem.

You need a little more memory for PHP. See http://drupal.org/node/76156 for more info. I usually go with 24 or 32K depending on what I'm doing. CCK & Views, right now, can chew up a fair bit of memory.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

Thanks for the followup. It's good to know that was the problem.

voidengine’s picture

voidengine commented

I switched memory in php.ini to 24M and it worked just fine, plus I just learned a tiny bit about using error logs.

Thank *you* Mr. Merlin!

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)