Forums / Install & configuration / mysql errors on admin login after update from 3.3.5 to 3.4.0

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