EE4 compatibility updates:
- Publisher is EE4 and EE5 compatible, but it does not currently support the Fluid field (it's in the works).
- Reel is EE4 and EE5 compatible, but it does not currently support the Fluid field.
Ticket: Database error when attempting to update from 1.0.15 to 1.1
| Status | Resolved |
| Add-on / Version | Publisher 1.1 |
| Severity | Critical |
| EE Version | 2.7.2 |
JohnDWells
Dec 04, 2013Hi Brian,
I just downloaded Publisher 1.1 and when running Module Updates, I get this database error:
Error Number: 1054
Unknown column ‘id’ in ‘field list’
SELECT `id` FROM (`exp_publisher_relationships`) WHERE `relationship_id` = ‘8’ AND `parent_id` = ‘83’ AND `child_id` = ‘71’ AND `field_id` = ‘61’ AND `order` = ‘0’ AND `publisher_lang_id` = ‘1’ AND `publisher_status` = ‘open’
Filename: third_party/publisher/models/publisher_model.php
Line Number: 451
Should my publisher_relationships table have an ID column?
Cheers,
John
Brian Litzinger
No, thats the insert_or_update method trying to return an primary key column. I just updated 3 sites and didn’t get that error. Did that happen during the upgrade routine or just after?
Brian Litzinger
Wait, found it.
Brian Litzinger
Change line 62 of models/publisher_relationships.php to this
$this->insert_or_update(‘publisher_relationships’, $data, $row, ‘relationship_id’);
JohnDWells
Bingo, that did it.
Thanks Brian!