Thread

I’m having an incredibly frustrating time trying to upgrade EE from 2.5.5 to 2.7.2.

Everytime I try I just get loads of PHP & database errors.

I’ve managed to update one site from 2.5.5 to 2.6.1 but am having problems with the relationships module. The site I’ve updated uses relationships, none of which now work as I believe the syntax has been changed.

When I install the new Relationships fieldtype it seems to install OK. But when I then view a page that is using it, I get the following DB error message:

Error Number: 1054

Unknown column 'L0.field_id' in 'field list'

SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`parent_id` AS L0_parent, `L0`.`child_id` as L0_id FROM (`exp_relationships` as L0) LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL WHERE `L0`.`parent_id` IN (109) ORDER BY `L0`.`order` asc

Filename: models/relationship_model.php

Line Number: 159

I’ve tried restoring and upgrading the site a number of times now, but get the same result each time. Has anyone had this problem? Is there a fix for this?

Thanks,

Nick

I have a very similar error in 2.7.2

A Database Error Occurred
Error Number: 1054

Unknown column 'child_id' in 'field list'

SELECT `child_id`, `order` FROM (`exp_relationships`) WHERE `parent_id` = '299' AND `field_id` = '144'

Filename: ~\codeigniter\system\database\DB_driver.php

Line Number: 330

Any luck on this yet?