Forums / Install & configuration / 3.7.0 site won't open

3.7.0 site won't open

Author Message

Allan Robinson

Tuesday 08 November 2005 7:05:12 pm

Hi
I can't get my site to open i am useing ez3.7.0 and just added the update 3.7.2 this error shows when trying to open my site.Fatal error: eZ publish did not finish its request

The execution of eZ publish was abruptly ended, the debug output is present below.
I can get to log in page for admin but it doesn't recognise my username or password. So could someone help me by maybe telling me which file i can go to to reset my password and username. I get this bug report under login.
Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Nov 08 2005 21:04:15
SET NAMES 'latin1'
Notice: eZMySQLDB::query(-1 rows, 0.353 ms) query number per page:1 Nov 08 2005 21:04:15
SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='94b4be8ecb86c38869ef9d1269fa1323'
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezsession' doesn't exist. Query: SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='94b4be8ecb86c38869ef9d1269fa1323'
Notice: eZMySQLDB::query(0 rows, 0.155 ms) query number per page:2 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:3 Nov 08 2005 21:04:15
SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='94b4be8ecb86c38869ef9d1269fa1323'
Notice: eZMySQLDB::query(-1 rows, 0.386 ms) query number per page:4 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezuser' doesn't exist. Query: SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'
Notice: eZMySQLDB::query(0 rows, 0.158 ms) query number per page:5 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:6 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'
Notice: eZMySQLDB::query(-1 rows, 862.656 ms) query number per page:7 Nov 08 2005 21:04:15
SELECT destination_url, forward_to_id
FROM ezurlalias
WHERE source_md5 = '739a748bd3c748b88deac114d318d445' AND
is_wildcard = 0
ORDER BY forward_to_id ASC, is_internal ASC
LIMIT 0, 1
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezurlalias' doesn't exist. Query: SELECT destination_url, forward_to_id
FROM ezurlalias
WHERE source_md5 = '739a748bd3c748b88deac114d318d445' AND
is_wildcard = 0
ORDER BY forward_to_id ASC, is_internal ASC
LIMIT 0, 1
Notice: eZMySQLDB::query(0 rows, 0.624 ms) query number per page:8 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:9 Nov 08 2005 21:04:15
SELECT destination_url, forward_to_id
FROM ezurlalias
WHERE source_md5 = '739a748bd3c748b88deac114d318d445' AND
is_wildcard = 0
ORDER BY forward_to_id ASC, is_internal ASC
LIMIT 0, 1
Timing: Nov 08 2005 21:04:15
Module start 'user'
Notice: eZMySQLDB::query(-1 rows, 0.337 ms) query number per page:10 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezuser' doesn't exist. Query: SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'
Notice: eZMySQLDB::query(0 rows, 0.202 ms) query number per page:11 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:12 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'
Notice: eZMySQLDB::query(-1 rows, 0.344 ms) query number per page:13 Nov 08 2005 21:04:15
SELECT contentobject_id, password_hash, password_hash_type, email, login
FROM ezuser, ezcontentobject
WHERE ( login='admin' ) AND
ezcontentobject.status='1' AND
ezcontentobject.id=contentobject_id AND
( ( password_hash_type!=4 ) OR
( password_hash_type=4 AND ( login='admin' ) AND password_hash=PASSWORD('Appl3s') ) )
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezuser' doesn't exist. Query: SELECT contentobject_id, password_hash, password_hash_type, email, login
FROM ezuser, ezcontentobject
WHERE ( login='admin' ) AND
ezcontentobject.status='1' AND
ezcontentobject.id=contentobject_id AND
( ( password_hash_type!=4 ) OR
( password_hash_type=4 AND ( login='admin' ) AND password_hash=PASSWORD('Appl3s') ) )
Notice: eZMySQLDB::query(0 rows, 0.127 ms) query number per page:14 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:15 Nov 08 2005 21:04:15
SELECT contentobject_id, password_hash, password_hash_type, email, login
FROM ezuser, ezcontentobject
WHERE ( login='admin' ) AND
ezcontentobject.status='1' AND
ezcontentobject.id=contentobject_id AND
( ( password_hash_type!=4 ) OR
( password_hash_type=4 AND ( login='admin' ) AND password_hash=PASSWORD('Appl3s') ) )
Timing: Nov 08 2005 21:04:15
Module end 'user'
Notice: eZMySQLDB::query(-1 rows, 0.966 ms) query number per page:16 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezuser' doesn't exist. Query: SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Notice: eZMySQLDB::query(0 rows, 1.981 ms) query number per page:17 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:18 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Notice: eZMySQLDB::query(-1 rows, 0.568 ms) query number per page:19 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: Table 'test.ezuser' doesn't exist. Query: SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Notice: eZMySQLDB::query(0 rows, 9.123 ms) query number per page:20 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:21 Nov 08 2005 21:04:15
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Warning: Nov 08 2005 21:04:15
User not found, returning anonymous
Warning: Nov 08 2005 21:04:15
Anonymous user not found, returning NoUser
Timing: Nov 08 2005 21:04:15
End
Notice: eZMySQLDB::query(-1 rows, 0.205 ms) query number per page:22 Nov 08 2005 21:04:15
SELECT value FROM ezpreferences WHERE user_id = AND name = 'admin_clearcache_type'
Error: eZMySQLDB Nov 08 2005 21:04:15
Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND name = 'admin_clearcache_type'' at line 1. Query: SELECT value FROM ezpreferences WHERE user_id = AND name = 'admin_clearcache_type'
Notice: eZMySQLDB::query(0 rows, 0.124 ms) query number per page:23 Nov 08 2005 21:04:15
UNLOCK TABLES
Notice: eZMySQLDB::query(0.000 ms) query number per page:24 Nov 08 2005 21:04:15
SELECT value FROM ezpreferences WHERE user_id = AND name = 'admin_clearcache_type'

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Module start 'user' 0.0000 sec 2.8311 sec 0.0000KB 0.0000KB
Module end 'user' 2.8311 sec 0.1078 sec 0.0000KB 0.0000KB
End 2.9390 sec 0.0000KB 0.0000KB
Total runtime: 3.0139 sec

Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.0262 sec 0.5592% 8 0.0033 sec
Mysql Total
Mysql_queries 0.8947 sec 19.1315% 16 0.0559 sec
Template Total 0.1931 sec 4.1% 3 0.0644 sec
Template load 0.0402 sec 0.8590% 3 0.0134 sec
Template processing 0.1515 sec 3.2397% 3 0.0505 sec
override
Cache load 0.0247 sec 0.5290% 3 0.0082 sec
Total script time: 4.6767 sec

Ɓukasz Serwatka

Tuesday 08 November 2005 11:35:49 pm

Hi Allan,

Could you give use more informations like:
- installation method (manual or by wizard)
- environment (Web Server, PHP, etc)

Did you run update SQL scripts and clear all cache files after update to 3.7.2?

Check in your database tables structure, you have errors about missing tables.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Allan Robinson

Wednesday 09 November 2005 4:56:29 am

Hi I just loaded 3.7.2 by FTP program over the top of 3.7.0 to update I am pretty sure i cleared all caches first here is a copy of the system info I just coppied it from an earlier post,it isn't in www directory anymore it is in public_html.
WWW directory /home/aboutto/public_html
Root directory /home/aboutto
Path to PERL /usr/bin/perl
Perl modules Click to view
Path to sendmail /usr/sbin/sendmail
Apache version 1.3.33 (Unix)
MySQL version 4.1.13-standard
PHP version 4.4.0
PHP info Click to view
PERL version 5.8.0
Kernel version 2.4.29-ow1
Machine Type i686
cPanel version 10.2.0-STABLE-83