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

Search unused extrafield and delete them 1 week 6 days 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: 14346

Search unused extrafield and delete them 1 week 6 days 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: 22 Members and 4253 Guests Online
Beppe De Lorenzis Christophe BERTRAND CloudByte Davy Donnell Holness Fairtech Francesco Gary Hansen Goble002 Inter-Ibex Jos Larry Mitchell Mohammed Refat Reymond Startprogram Tomáš Václ Uzi YODAstudio michael razen site william white
Legend ::   Site Administrator Global Moderator Moderator Banned User Guest
  • Total Messages: 137434 | Total Subjects: 36267
  • Total Sections: 6 | Total Categories: 32
  • Today Open: 6 | Yesterday Open: 3
  • Today Total Answer: 8 | Yesterday Total Answer: 22
Powered by Kunena Forum