• Fred
  • Fred's Avatar
  • New Member
  • Posts: 5

Search unused extrafield and delete them 2 months 1 week ago #164036

Hello community,

I'm working on a website I didn't make and I'm tryin to clean it up right now.
The previous developper went crazy and created hundreds of extrafields. I'm pretty sure many are not used and I'm trying to find a way to know which one they are. I went to the database and try a SQL query but I don't really know what to look for.
I'm not really good at SQL either.

Do you think there is a quicker way to find the unused extrafields ?
  • Krikor
  • Krikor's Avatar
  • Moderator
  • Posts: 14734

Search unused extrafield and delete them 2 months 1 week ago #164044

Hello there,

The extrafields are stored in the #__k2_items table in JSON format, if an id is unused, then you can delete it (keep a backup just in case)
IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Moderators: william white

Who Is Online

Total users online: 8 Members and 3681 Guests Online
František Kříž Glathe HOURQUEBIE Romain Kaposvar University Marian Wężycki Peter Mathews djsmooth5 piet
Legend ::   Site Administrator Global Moderator Moderator Banned User Guest
  • Total Messages: 138508 | Total Subjects: 36476
  • Total Sections: 6 | Total Categories: 32
  • Today Open: 4 | Yesterday Open: 3
  • Today Total Answer: 5 | Yesterday Total Answer: 31
Powered by Kunena Forum