I have upgraded two databases to 1.8 from 1.7. I have followed the instructions and run the php scripts for both the main and extensions.
However, global lists, entities and related items drive errors like the the following when I try to filter or edit/add new item.
This error is for a table with a global list field, where 21 is the table and 267 is the drop-down list driven by a global list.
Database Error: 1146 - Table 'tradejus.app_entity_21_values' doesn't exist
Query: delete from app_entity_21_values where items_id='131' and fields_id='267'
Page: /projects/index.php?module=items/&action=save&id=131
This error is for a table with an entity, where 27 is the table and 272 is the entity list driven by an entity.
Database Error: 1146 - Table 'tradejus.app_entity_27_values' doesn't exist
Query: delete from app_entity_27_values where items_id='1' and fields_id='272'
Page: /cais/index.php?module=items/&action=save&id=1
Or this error where there are related items and/or entities:
Database Error: 1146 - Table 'tradejus_ruko382.app_entity_27_values' doesn't exist
Query: select count(e.id) as total from app_entity_27 e where e.id>0 and ((select count(*) from app_entity_27_values as cv where cv.items_id=e.id and cv.fields_id='307' and cv.value in (39)) >0)
Page: /cais/index.php?module=items/listing
I cannot currently edit any of the fields in my databases.
Upgrade Error - Entities/Related Items broken
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Upgrade Error - Entities/Related Items broken
You did not run step 5 from upgrade instruction
https://www.rukovoditel.net/new_release.php?version=1.8
https://www.rukovoditel.net/new_release.php?version=1.8
read instruction and do it step by stepRun /install/autoupdate/data_prepare_from_1.7_to_1.8.php
Note: wait for the response OK for all Entities
Re: Upgrade Error - Entities/Related Items broken
You are correct. My apologies.
Graham
Graham