mysql errors on admin login after update from 3.3.5 to 3.4.0

Author Message

Kenneth Colwell

Wednesday 09 June 2004 11:42:46 am

Hi,

After doing the update by following the instructions here: http://ez.no/ez_publish/download/changelogs/ez_publish_3_4/upgrading I now get the following errors after entring a username and password into the admin login screen.

Any assitance would be greatly appreciated

Thanks,
Ken Colwell

eZ debug

Timing:
Jun 09 2004 13:44:41

Script start

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'user_id' in 'field list'. Query: SELECT data, user_id FROM ezsession WHERE session_key='f9d450ae41aec3c523e7e88c692be964'

Notice: eZMySQLDB::query(0.000 ms) query number per page:0
Jun 09 2004 13:44:41

SELECT data, user_id FROM ezsession WHERE session_key='f9d450ae41aec3c523e7e88c692be964'

Warning: PHP
Jun 09 2004 13:44:41

Undefined index: user_id in /var/www/pub3_test/lib/ezutils/classes/ezsession.php on line 63

Timing:
Jun 09 2004 13:44:41

Module start 'user'

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: You have an error in your SQL syntax near '' at line 6. Query: SELECT
parent_node_id
FROM
ezcontentobject_tree
WHERE
node_id =

Notice: eZMySQLDB::query(0.000 ms) query number per page:1
Jun 09 2004 13:44:41

SELECT
parent_node_id
FROM
ezcontentobject_tree
WHERE
node_id =

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'remote_id' in 'field list'. Query: SELECT id, version, name, identifier, contentobject_name, creator_id, modifier_id,
created, remote_id, modified
FROM ezcontentclass
WHERE id='4' AND version='0'
ORDER BY version ASC
LIMIT 0, 2

Notice: eZMySQLDB::query(0.000 ms) query number per page:2
Jun 09 2004 13:44:41

SELECT id, version, name, identifier, contentobject_name, creator_id, modifier_id,
created, remote_id, modified
FROM ezcontentclass
WHERE id='4' AND version='0'
ORDER BY version ASC
LIMIT 0, 2

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='28'

Notice: eZMySQLDB::query(0.000 ms) query number per page:3
Jun 09 2004 13:44:41

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='28'

Warning: PHP
Jun 09 2004 13:44:41

Invalid argument supplied for foreach() in /var/www/pub3_test/kernel/classes/ezpersistentobject.php on line 560

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: INSERT INTO eznode_assignment (remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order, is_main, from_node_id, parent_remote_id) VALUES('0', '517', '34', '12', '2', '0', '1', '0', '')

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34'

Notice: eZMySQLDB::query(0.000 ms) query number per page:4
Jun 09 2004 13:44:41

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34'

Warning: PHP
Jun 09 2004 13:44:41

Invalid argument supplied for foreach() in /var/www/pub3_test/kernel/classes/ezpersistentobject.php on line 560

Warning: eZModuleOperationInfo::execute
Jun 09 2004 13:44:41

Missing main operation memento for key: 9ad90d42bec21dafc6d0116e37627150

Warning: PHP
Jun 09 2004 13:44:41

Undefined index: user_id in /var/www/pub3_test/kernel/classes/ezworkflowprocess.php on line 155

Debug:
Jun 09 2004 13:44:41

executing publish on time event

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34' AND is_main='1'

Notice: eZMySQLDB::query(0.000 ms) query number per page:5
Jun 09 2004 13:44:41

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34' AND is_main='1'

Warning: PHP
Jun 09 2004 13:44:41

Invalid argument supplied for foreach() in /var/www/pub3_test/kernel/classes/ezpersistentobject.php on line 560

Warning: PHP
Jun 09 2004 13:44:41

Undefined offset: 0 in /var/www/pub3_test/kernel/content/ezcontentoperationcollection.php on line 318

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='28' AND is_main='1'

Notice: eZMySQLDB::query(0.000 ms) query number per page:6
Jun 09 2004 13:44:41

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='28' AND is_main='1'

Warning: PHP
Jun 09 2004 13:44:41

Invalid argument supplied for foreach() in /var/www/pub3_test/kernel/classes/ezpersistentobject.php on line 560

Warning: PHP
Jun 09 2004 13:44:41

Undefined offset: 0 in /var/www/pub3_test/kernel/content/ezcontentoperationcollection.php on line 321

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34'

Notice: eZMySQLDB::query(0.000 ms) query number per page:7
Jun 09 2004 13:44:41

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34'

Warning: PHP
Jun 09 2004 13:44:41

Invalid argument supplied for foreach() in /var/www/pub3_test/kernel/classes/ezpersistentobject.php on line 560

Error: eZMySQLDB
Jun 09 2004 13:44:41

Query error: Unknown column 'parent_remote_id' in 'field list'. Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34'

Notice: eZMySQLDB::query(0.000 ms) query number per page:8
Jun 09 2004 13:44:41

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id
FROM eznode_assignment
WHERE contentobject_id='517' AND contentobject_version='34'

Warning: PHP
Jun 09 2004 13:44:41

Invalid argument supplied for foreach() in /var/www/pub3_test/kernel/classes/ezpersistentobject.php on line 560

Debug: userid
Jun 09 2004 13:44:41

517

Timing:
Jun 09 2004 13:44:41

End

Kenneth Colwell

Wednesday 09 June 2004 1:36:01 pm

Nevermind.... I just replaced my settings folder from 3.3.5 with the default settings folder from 3.4.0 and the site started working. So, I guess I will need to rebuild my settings from the default ones.

Thanks,
Ken Colwell

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.