Database / Tables / Custom field storage

This support ticket is created 3 years, 7 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 1 reply, has 2 voices.

Last updated by Minesh 3 years, 7 months ago.

Assisted by: Minesh.

Author

Posts

September 9, 2021 at 7:14 am #2164227

Kevin

Tell us what you are trying to do?
I would like to create a query to copy address data from one table into the table that stores the Toolset custom fields. The toolset custom fields I created need to be filled with that address data. The address data in the other table was stored by a different WordPress plugin.

What database (DB) tables store the custom fields?

September 9, 2021 at 10:34 am #2164443

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Basically, Toolset store the custom field data as per the WordPress standard.

The post custom Address fields values are stored into the postmeta table with metakey and metavalue.

In addition to that, Toolset stores the address to custom table namely: toolset_maps_address_cache

However - with latest version of Map we offer a button at Toolset => Settings => Maps tab => "Cached data" section and you can click on the button "Check for missing cache entries" this will automatically add the missing address field entries to the cache table.