Upgrade Error - Entities/Related Items broken

Post Reply
graham
Posts: 2
Joined: 09 Feb 2017, 04:03
Name: Graham Cox
Location: Toronto

Upgrade Error - Entities/Related Items broken

Post by 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.

User avatar
support
Site Admin
Posts: 3418
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Upgrade Error - Entities/Related Items broken

Post by 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
Posts: 2
Joined: 09 Feb 2017, 04:03
Name: Graham Cox
Location: Toronto

Re: Upgrade Error - Entities/Related Items broken

Post by graham »

You are correct. My apologies.

Graham

Post Reply