When you get error : Unable to save. You have one error, when you try to view or search

When you get error : Unable to save. You have one error, when you try to view or search

When you get error : Unable to save. You have one error, when you try to view or search

check the nodetable of that class

select * from nodetable where parentid = 26947 order by description;

check for any duplicate in the name column if you see any duplicates


select* from propertytable where parentid in (59273,59278,59274,59279,59272,59277,59276,59271) order by parentid;
3206459 59271 0 2 1 0 1 30 List12
3206460 59271 0 6 1 59270 1 15 (List)
3206461 59271 0 4 1 2000008821 1 864 0
3206462 59271 0 4 1 451 1 9 0

3206463 59272 0 2 1 0 1 30 List13
3206464 59272 0 6 1 59270 1 15 (List)
3206465 59272 0 4 1 451 1 9 0
3206466 59273 0 2 1 0 1 30 List14
3206467 59273 0 6 1 59270 1 15 (List)
3206468 59273 0 4 1 451 1 9 0
3206470 59274 0 2 1 0 1 30 List15
3206471 59274 0 6 1 59270 1 15 (List)
3206472 59274 0 4 1 451 1 9 0

select* from propertytable where parentid = 27108;

create table nodetable_4 as select * from nodetable where id in (59273,59278,59274,59279,59272,59277,59276,59271);
create table propertytable_4 as select * from propertytable where parentid in (59273,59278,59274,59279,59272,59277,59276,59271);

delete from nodetable where id in (59273,59278,59274,59279,59272,59277,59276,59271);
delete from propertytable where parentid in (59273,59278,59274,59279,59272,59277,59276,59271);

select * from PSR_P2P3;

desc tableinfo

select * from tableinfo where att in (59273,59278,59274,59279,59272,59277,59276,59271);

Leave a Reply

Your email address will not be published. Required fields are marked *