"Cache not updating" (#3762119) / TMS-Plugins

Comments

Amer Ahmed started the conversation
November 12, 2024 at 4:18pm
This was a private ticket but nobody was answering me. I am using a temporary solution by having to update each table manually when I cache it. It's a terrible temporary solution.

_____

I am using Google Sheets to feed my wpDataTables and I'm getting these errors: Auto update error message: Data array from source and cache do not have same keys(columns).

I know for a fact that the columns aren't changing in the tables and I've verified that the columns are correct in each table. I'm not sure why I'm getting this error.

What information do you need?

Here's a link to one my Google Sheets: https://docs.google.com/spreadsheets/d/1v9_2cDaQ39BS3ZoLc-x6afoQHQiZkQK-ic18xJG73lg/edit?gid=1192460929#gid=1192460929

https://docs.google.com/spreadsheets/d/1v9_2cDaQ39BS3ZoLc-x6afoQHQiZkQK-ic18xJG73lg/edit?usp=sharing

In an effort to figure it out, I manually set each column to FLOAT type from Int type. That didn't work. One more thing is that my data frequently has zero values in the columns. However, it's stupid if that's the reason why my tables aren't caching from Google Sheets. I don't want the values to be imported as strings because the data is being used to generate charts. Here's where the 7 day chart data gets used, as an example.

https://houstonpollen.com/common-allergens/

Amer Ahmed replied

November 14, 2024 at 5:36pm

Error still persists after updating to 7.01.

Note that it's always different tables on different refreshes.

table_id updated_time log_errors
7 11/14/2024 10:53 AM 2024-11-14 11:30:30 - Auto update error message: Data array from source and cache do not have same keys(columns).
8 11/14/2024 10:53 AM 2024-11-14 11:30:31 - Auto update error message: Data array from source and cache do not have same keys(columns).
16 11/14/2024 04:56 PM
19 11/14/2024 04:57 PM
20 11/14/2024 05:00 PM
21 11/14/2024 05:01 PM
24 11/14/2024 10:53 AM
25 11/14/2024 10:53 AM
27 11/14/2024 10:53 AM 2024-11-14 11:30:32 - Auto update error message: Data array from source and cache do not have same keys(columns).
29 11/14/2024 10:53 AM 2024-11-14 11:30:33 - Auto update error message: Data array from source and cache do not have same keys(columns).
30 11/14/2024 10:53 AM 2024-11-14 11:30:34 - Auto update error message: Data array from source and cache do not have same keys(columns).
31 11/14/2024 10:53 AM

Using Table7 as an example:There's no reason why the column keys should be erroring out.

, here's my Table7 data from WPDataTables.

Date	Acer (Maple)	Alnus (Alder)	Betula (Birch)	Carya (Hickory/Pecan)	Celtis (Hackberry)	Corylus (Hazelnut)	Cupressaceae (Cedar)	Fraxinus (Ash)	Juglans (Walnut)	Liquidambar (Sweet Gum)	Morus (Mulberry)	Pinaceae (Pine)	Platanus (Sycamore)	Populus (Cottonwood)	Quercus (Oak)	Salix (Willow)	Tilia (Linden)	Ulmus (Elm)	Other Tree	Tree Total	Grass Total	Tree & Grass Total	Ambrosia (Ragweed)	Artemisia (Sage)	Asteraceae (Aster)	Cyperaceae (Sedge)	Plantago (Plantain)	Rumex (Sheep Sorel)	Typha (Cattail)	Urticaceae (Nettle)	Chenopodiaceae/ Amaranthaceae (Amaranth)	Other Weed	Weed Total	Pollen Total	Algae	Alternaria	Ascomycetes	Basidiomycetes	Cercospora	Cladosporium	Curvularia	Drechslera/Helmintho.	Epicoccum	Nigrospora	Oidium/Erysiphe(Powdery Mildew)	Penicillium/Aspergillus	Periconia	Pithomyces	Rust	Smuts/Myxomycete	Spegazinia	Stemphyllium	Tetraploa	Torula	Mold Total
11/5/2024	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20	0	20	0	20	34	0	0	0	0	0	0	0	0	8	42	62	8	16	3693	591	95	3588	64	16	2	32	0	364	8	8	6	166	0	2	2	2	8663
11/6/2024	0	0	0	0	0	0	12	0	0	0	0	0	0	0	0	0	0	64	0	76	4	80	40	0	0	0	0	0	0	0	0	4	44	124	0	40	5783	633	309	2093	50	20	8	42	0	119	8	6	8	251	0	0	0	2	9372
11/7/2024	0	0	0	0	0	0	4	0	0	0	0	0	0	0	0	0	0	96	0	100	0	100	42	0	0	0	0	0	0	0	0	8	50	150	0	14	3402	1579	184	4260	62	20	2	38	0	299	8	8	4	238	6	0	4	4	10132
11/8/2024	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	24	0	26	6	32	22	0	0	0	0	0	0	0	0	0	22	54	0	55	5407	1458	132	6154	35	22	2	85	0	243	28	2	10	122	0	0	0	0	13755
########	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8	0	8	8	16	32	0	0	0	0	0	0	0	0	2	34	50	0	16	7290	2022	87	4647	36	16	0	20	2	388	10	4	12	107	2	2	2	0	14663
########	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8	0	8	0	8	30	0	0	0	0	0	0	0	0	0	30	38	24	184	4841	3827	447	9434	151	38	28	95	22	1117	161	16	4	222	2	8	8	26	20655
########	0	0	0	0	0	0	48	0	0	0	0	0	0	0	0	0	0	20	0	68	16	84	16	0	0	0	0	0	0	0	0	0	16	100	0	445	2545	2387	356	8924	168	95	16	131	8	895	62	28	66	273	4	0	6	14	16423

And my Table7 data from GoogleSheets (source)

Date	Acer (Maple)	Alnus (Alder)	Betula (Birch)	Carya (Hickory/Pecan)	Celtis (Hackberry)	Corylus (Hazelnut)	Cupressaceae (Cedar)	Fraxinus (Ash)	Juglans (Walnut)	Liquidambar (Sweet Gum)	Morus (Mulberry)	Pinaceae (Pine)	Platanus (Sycamore)	Populus (Cottonwood)	Quercus (Oak)	Salix (Willow)	Tilia (Linden)	Ulmus (Elm)	Other Tree	Tree Total	Grass Total	Tree & Grass Total	Ambrosia (Ragweed)	Artemisia (Sage)	Asteraceae (Aster)	Cyperaceae (Sedge)	Plantago (Plantain)	Rumex (Sheep Sorel)	Typha (Cattail)	Urticaceae (Nettle)	Chenopodiaceae/ Amaranthaceae (Amaranth)	Other Weed	Weed Total	Pollen Total	Algae	Alternaria	Ascomycetes	Basidiomycetes	Cercospora	Cladosporium	Curvularia	Drechslera/Helmintho.	Epicoccum	Nigrospora	Oidium/Erysiphe(Powdery Mildew)	Penicillium/Aspergillus	Periconia	Pithomyces	Rust	Smuts/Myxomycete	Spegazinia	Stemphyllium	Tetraploa	Torula	Mold Total
11/5/2024	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20	0	20	0	20	34	0	0	0	0	0	0	0	0	8	42	62	8	16	3693	591	95	3588	64	16	2	32	0	364	8	8	6	166	0	2	2	2	8663
11/6/2024	0	0	0	0	0	0	12	0	0	0	0	0	0	0	0	0	0	64	0	76	4	80	40	0	0	0	0	0	0	0	0	4	44	124	0	40	5783	633	309	2093	50	20	8	42	0	119	8	6	8	251	0	0	0	2	9372
11/7/2024	0	0	0	0	0	0	4	0	0	0	0	0	0	0	0	0	0	96	0	100	0	100	42	0	0	0	0	0	0	0	0	8	50	150	0	14	3402	1579	184	4260	62	20	2	38	0	299	8	8	4	238	6	0	4	4	10132
11/8/2024	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	24	0	26	6	32	22	0	0	0	0	0	0	0	0	0	22	54	0	55	5407	1458	132	6154	35	22	2	85	0	243	28	2	10	122	0	0	0	0	13755
11/12/2024	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8	0	8	8	16	32	0	0	0	0	0	0	0	0	2	34	50	0	16	7290	2022	87	4647	36	16	0	20	2	388	10	4	12	107	2	2	2	0	14663
11/13/2024	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8	0	8	0	8	30	0	0	0	0	0	0	0	0	0	30	38	24	184	4841	3827	447	9434	151	38	28	95	22	1117	161	16	4	222	2	8	8	26	20655
11/14/2024	0	0	0	0	0	0	48	0	0	0	0	0	0	0	0	0	0	20	0	68	16	84	16	0	0	0	0	0	0	0	0	0	16	100	0	445	2545	2387	356	8924	168	95	16	131	8	895	62	28	66	273	4	0	6	14	16423