Deleting Old 1.x Group issue

[Ranger375]

When I try to delete groups from 1.x this is what happens:

 

[Truonglv]

Does you uninstall the add-on then delete nodes?

 

[Ranger375]

I uninstalled the addon but it won’t let me delete those nodes for some reason. I get that error in the screen shot above.

 

[Truonglv]

I uninstalled the addon but it won’t let me delete those nodes for some reason. I get that error in the screen shot above.

Ranger375Can you run some mysql queries to know the issue? I guess that nodes was assigned to wrong type.

 

[Ranger375]

Sure thing, what queries should I run?

 

[Truonglv]

Sure thing, what queries should I run?

Ranger375

select *
FROM xf_node_type
WHERE node_id = 'the node in your url'

Hint: Press the Reply button to make sub replies

 

[Ranger375]

There's only a reply button for you on the initial post fyi. This is the error I got from the query:
#1054 - Unknown column 'node_id' in 'where clause'

 

[Truonglv]

There's only a reply button for you on the initial post fyi. This is the error I got from the query:
#1054 - Unknown column 'node_id' in 'where clause'

Ranger375Oops sorry. The table should be xf_node

 

[Ranger375]

Oops sorry. The table should be xf_node

truonglv


Sorry for the late reply, ive been outta town. So I ran the query, but it didn't do anything. It looks like I'm trying to get rid of these, but I can't from the admin panel:

 

[Truonglv]

Sorry for the late reply, ive been outta town. So I ran the query, but it didn't do anything. It looks like I'm trying to get rid of these, but I can't from the admin panel:

View attachment 2583

Ranger375Okey run this query.

update xf_node
set node_type_id = 'Forum'
where node_type_id = 'nobita_Teams_Forum'

 

[Ranger375]

Okey run this query.

update xf_node
set node_type_id = 'Forum'
where node_type_id = 'nobita_Teams_Forum'

truonglv
That worked and allowed me to delete those nodes. Thanks!