118 Posts
webchun
8 years ago
Topic

Hi guys,

Assuming when we create a new 'blank' content type seblod will generate a new table __cck_store_form_content-type-name in the database, is it safe to delete this table manually? I was creating a content type with a wrong name and decided to delete it, but when I delete the content type, the table for this content type is not automatically deleted from database.

Get a VIP membership
1283 Posts
Bucklash
8 years ago
5
Level 1

Hi

There's more than one table you need to delete/change...

Quick check = 

#__cck_core

#__cck_core_types

#_assets

#_content (cck stuff in introtext)

#_ucm_history

Also, you have to either change any fields that are locked to that content type in the db or by opening and saving them again (or something like that)

118 Posts
webchun
8 years ago
4
Level 2

I see.. So, is there any native (seblod) way to clean my database from unused content type?

4229 Posts
Kadministrator
8 years ago
3
Level 3

First delete all fields created for this content type (from fields editor - don't delete fields like article title etc that are used in multiple ct) and content type itself from content types admin interface. Then I think it is safe to delete your table.

118 Posts
webchun
8 years ago
2
Level 4

@klas Ah ok. Then how about checking others tables as mentioned by bucklash? If there's any relation available on those tables then they should be removed automatically when we removed the fields, right? Thanks!

4229 Posts
Kadministrator
8 years ago
1
Level 5

Entry should be removed from mentioned tables when you delete fields and content type itself.

118 Posts
webchun
8 years ago
0
Level 6

ok. thanks!

Get a VIP membership