Upgrade Error - Entities/Related Items broken

[graham]

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.

[support]

You did not run step 5 from upgrade instruction
https://www.rukovoditel.net/new_release.php?version=1.8

Run /install/autoupdate/data_prepare_from_1.7_to_1.8.php
Note: wait for the response OK for all Entities

read instruction and do it step by step

[graham]

You are correct. My apologies.

Graham