Hi Sergey!
I restructered the database (application structure) by removing some tables (and data) which are used in other entities to defined things like country, department, etc. Ruko does not stop the user from deleting the tables even if records are linked to data records of other entities. There might be a inconsistency problem by allowing to delete data and/or tables which are linked to others.
Regards,
Pepe
Database Problem
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Problem
Thank you for notify about this issue. I will check it for next version.
Re: Database Problem
This error seems to be critical, some tables (entities) of current database cannot be accessed. Are you talking about 1.8 or will there be an fix for this in 1.7.2 in the near future? Please let me know.
Regards,
Pepe
Regards,
Pepe
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Problem
At the moment I can't reproduce issue with delete Entity like in your example, and nobody other report about this issue...
(there is issue if entity related to some other entity but this is not critical)
If we delete Entity then we delete record in database and Table with all item related to this entity
In your example app_entity_41 table was removed (or not created) for Kontakte
so try to remove Kontakte in Application Structure page (you will see error app_entity_41 table in this action) and create it again
Or maybe Kontakte this is report that was not removed?
So let me know what is Kontakte and if suggestion about helps you
(there is issue if entity related to some other entity but this is not critical)
If we delete Entity then we delete record in database and Table with all item related to this entity
In your example app_entity_41 table was removed (or not created) for Kontakte
so try to remove Kontakte in Application Structure page (you will see error app_entity_41 table in this action) and create it again
Or maybe Kontakte this is report that was not removed?
So let me know what is Kontakte and if suggestion about helps you
Re: Database Problem
Hi Sergey,
Kontakte is an entity on second level in the structure. There has been a report called Kontakte as well but it has been removed earlier. When tying to delete Kontakte you will get the message:
"You can't delete Kontakte because it has sub items. Delete all items first please."
However, I cannot remove the items since I get the message that triggered this post.
Regards,
Pepe
Kontakte is an entity on second level in the structure. There has been a report called Kontakte as well but it has been removed earlier. When tying to delete Kontakte you will get the message:
"You can't delete Kontakte because it has sub items. Delete all items first please."
However, I cannot remove the items since I get the message that triggered this post.
Regards,
Pepe
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Problem
It looks like something is damage:(
Can you provide screenshot from you Application Structure page?
So as I understand now you don't need Kontakte entity, right? and issue you can't delete it, correct?
Can you provide screenshot from you Application Structure page?
So as I understand now you don't need Kontakte entity, right? and issue you can't delete it, correct?
Re: Database Problem
Since I cannot get it fixed I would prefer to delete the entity Kontakte and rebuild something similar.
Screen shot of structure is enclosed.
Regards,
Pepe
Screen shot of structure is enclosed.
Regards,
Pepe
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Problem
The error on previous screenshot says app_entity_41 but at the moment you don't have entity with id 41 inlist
Can you check fields in Kontakte entity. I think there should be field with type Entity or Related Items and it linked to entity #41 that is deleted and that is why you have this error.
If this is true, then just reconfigure this filed or remove.
Let me know if I'm right.
Can you check fields in Kontakte entity. I think there should be field with type Entity or Related Items and it linked to entity #41 that is deleted and that is why you have this error.
If this is true, then just reconfigure this filed or remove.
Let me know if I'm right.
Re: Database Problem
No, there is not field ID 41 in Kontakte. But as I have mentioned in the first post of this report, I have removed entities which I replaced with others (global lists). Therefore, there may have been an link to entity or related item with ID 41. Nevertheless, I should not be allowed to remove that enitity if it still has links to other entities.
Regards,
Pepe
Regards,
Pepe
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Problem
Yes, check all fields with Type Entity and reconfigure it. It should fix the problem. Let me know.
Yes, this bug and it will be fixed in 1.8Nevertheless, I should not be allowed to remove that enitity if it still has links to other entities.