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

eZ debug

Timing: Jan 18 2025 19:34:29
Script start
Timing: Jan 18 2025 19:34:29
Module start 'content'
Timing: Jan 18 2025 19:34:30
Module end 'content'
Timing: Jan 18 2025 19:34:30
Script end

Main resources:

Total runtime1.2956 sec
Peak memory usage4,096.0000 KB
Database Queries194

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0079 587.7266180.8359
Module start 'content' 0.00791.1628 768.5625584.8828
Module end 'content' 1.17070.1248 1,353.4453340.7813
Script end 1.2955  1,694.2266 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.3259210.0002
Check MTime0.00160.1255210.0001
Mysql Total
Database connection0.00110.083310.0011
Mysqli_queries1.192692.04491940.0061
Looping result0.00280.21571920.0000
Template Total1.260497.320.6302
Template load0.00230.178420.0012
Template processing1.258197.101520.6290
Template load and register function0.00020.018810.0002
states
state_id_array0.00160.121210.0016
state_identifier_array0.00180.138920.0009
Override
Cache load0.00230.17881810.0000
Sytem overhead
Fetch class attribute can translate value0.00130.101430.0004
Fetch class attribute name0.00140.111340.0004
XML
Image XML parsing0.00100.075830.0003
class_abstraction
Instantiating content class attribute0.00000.000940.0000
General
dbfile0.00190.1459290.0001
String conversion0.00000.000630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 19
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs