As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #3762119
Cache not updating
Closed

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.


    _____


    8976338998.png

    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)

    DateAcer (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 TreeTree TotalGrass TotalTree & Grass TotalAmbrosia (Ragweed)Artemisia (Sage)Asteraceae (Aster)Cyperaceae (Sedge)Plantago (Plantain)Rumex (Sheep Sorel)Typha (Cattail)Urticaceae (Nettle)Chenopodiaceae/ Amaranthaceae (Amaranth)Other WeedWeed TotalPollen TotalAlgaeAlternariaAscomycetesBasidiomycetesCercosporaCladosporiumCurvulariaDrechslera/Helmintho.EpicoccumNigrosporaOidium/Erysiphe(Powdery Mildew)Penicillium/AspergillusPericoniaPithomycesRustSmuts/MyxomyceteSpegaziniaStemphylliumTetraploaTorulaMold Total
    11/5/2024000000000000000002002002034000000008426281636935919535886416232036488616602228663
    11/6/2024000000120000000000640764804000000000444124040578363330920935020842011986825100029372
    11/7/2024000000400000000009601000100420000000085015001434021579184426062202380299884238604410132
    11/8/202400000020000000000240266322200000000022540555407145813261543522285024328210122000013755
    11/12/202400000000000000000808816320000000023450016729020228746473616020238810412107222014663
    11/13/20240000000000000000080808300000000003038241844841382744794341513828952211171611642222882620655
    11/14/202400000048000000000020068168416000000000161000445254523873568924168951613188956228662734061416423



  • Amer Ahmed replied
    January 27, 2025 at 4:31pm

    This bug has persisted since I wrote this.  Any update?

    Why would you close this ticket without responding at all?

  •   Miloš replied privately