Okay
  Public Ticket #3584917
Error saving table
Closed

Comments

  • Andy started the conversation

    Hi,

    I have followed all the instructions for Google API settings and all went well, my screens matched all the tutorial ones (on the page and youtube).

    However, every time I try to create a new table, I get the error below.

    6706192964.png

    The sheet is shared with the google account service email.

    Any ideas please?

    Thank you.

  •  1,846
    Miloš replied

    Hi Andy,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

     Can you please tell me how many rows does the source Sheet have?

    For example, if it has more than a couple thousand rows - you might be reaching the current PHP limits of the Hosting Server ( such as timeOut limit).


    When you try to link a Table from a source file like a Google Sheet;

     During this process, the plugin needs to read the entire data set coming from the spreadsheet for the initial table creation.

    For this, it takes a certain time interval ( depending on how large the data set is).

    So, what you can try is to increase the max_execution_time and max_input_time ( or in other words, to increase the timeout limit in php.ini file),

    in this way, it should prevent the table creation wizard from breaking until the table is generated.

    -


    When the table successfully generates on the back-end, if you wish to have improved performance, you can try enabling our cache and auto-load cache , in the table settings, 

    but the plugin needs to have enough time for the server to process everything/ to read the full data set of the spreadsheet and table.

    -

    If you want to check what is the current configuration, you can do this from our Plugin's Dashboard, in System Info Tab.


    8466747243.png

    And check the PHP Memory Limit.

    5437403494.png


     If it is only 128 MB, we recommend increasing it to at least 256 or 512 MB which should be enough for most websites ( depending how many other Plugins and data you plan to have on the site, etc).


    Let me know if that helps.

    If not, we can remote in and try to isolate the issue for you.



    Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.


    And please share the access to the source Sheet with my Email [email protected] so that i can inspect it - and I can try making a copy of it to reproduce/test the issue, etc.


    Thank you.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Andy replied privately
  •   Andy replied privately
  •   Andy replied privately
  •   Andy replied privately
  • Andy replied

    Could you help on the following table (I can change the rest) [wpdatatable id=19]

    How do you reduce the row and header heights please for pc/mobile?

    Also, the table centres on pc page but on mobile it is off to the side, can that be fixed to central please?

    How do I remove the white border too?

    Thanks.

    Attached files:  428176249_382228227764278_2447561406210166062_n.jpg

  •   Miloš replied privately
  •   Andy replied privately
  •   Miloš replied privately
  • Andy replied

    Milos,

    Thank you so much, that is exactly the look I was hoping for. Top work!

    One last query for now, is there a way to block a page from appearing on mobile and vice versa, having a mobile only page please?

    Thanks.

  •  1,846
    Miloš replied

    Hi Andy,

    You're welcome, i am happy to see the details were useful.smile.png

    2. In regards to your new question, I am sorry, but it seems I am not fully understanding the use-case.

    Do you mean to completely block a WordPress Page from showing if the User visits it from Mobile - to only load the WP Page if a user visits from Desktop/Tablet;

    and vice-versa, if we can block a WP Page only for a specific Device/like only visible on Mobile, but not for Desktop for example?

    -

    If that is what you meant, our Plugin does not have any capability to restrict Access to a Page or to a Table.

    For example, if you use any Membership Plugin - they can be configured to show/ or restrict certain elements on a Page or an entire WP Page depending which User Role visits it.


    Like, let's say if we had Table 1 on Page 1 which is only for a User with a VIP Custom User Role.

    You can set this up via any Membership Plugin - then only users with that Role can see it;

    for other Roles it will be blocked;


    but still, that is only to block access to the page completely, I am not aware if it's possible to block it 'per device' like that.


    You can research online for a custom workaround, at the moment we don't know of such a solution.


    3. Or, if you meant to perhaps hide some Page from a Table per device;

    We also do not have any way to achieve that, I'm afraid.


    But let me know, maybe I completely misunderstood that point.smile.png

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  1,846
    Miloš replied

    Hi Andy,

    I actually just thought of something that might be useful ( if this is something you could use, though).

    For example, the Custom CSS for Media Query i sent before, like for mobile screen only as :

    @media only screen and (max-width: 480px) {
        
    .wpdt-c .wpDataTablesWrapper table.wpDataTable > thead > tr > th {
        height: 10px !important;
        padding: 0 !important;
        }
    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-19 tr td {
        height: 10px !important;
        padding: 0px !important;
        }
     
    }


    So, anything you set wrapped inside this part as @media only screen and (max-width: 480px) {

    ... your styles here...

    }


    For example, if you wanted to completely hide a table from users who visit your Page from a mobile screen;

    you can do this CSS :


    @media only screen and (max-width: 480px) {
        
    .wpdt-c .wpDataTablesWrapper table.wpDataTable  {
       display : none !important;
        }
     
    }


    This way, if i try it on your Page in the browser's CSS - it works;

    If i load it on my PC , it loads the table;

    but if i switch to a mobile View - it hides the table.

    5017508010.png

    Let me know if that might help;

    And check out the other details from the other reply.

    Thanks.



    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables