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.
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.
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.
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/
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.
And my Table7 data from GoogleSheets (source)