Okay
  Public Ticket #3681341
server timeout error
Open

Comments

  • Steven started the conversation

    After purchasing Pro, the program worked as expected. Once the last update was installed, anytime that I try to update and old database or create a new database, I get a server 503 timeout error. I have done a plugin conflict test and the error still occurs. After consulting with the host, the WP limit values that are needed are higher than the hosting allows. Is the 2GB limit required or is there a way to use wpdatatables within the limits of my hosting?

  •  1,740
    Miloš replied

    Hi Steven,

    The 503 TimeOut is not related to the PHP Memory Limit, which I presume you checked is 2GB, right?

    It is rather related to the PHP Time Limit and Max Input Time.

    For example, if this happens when you try to make a table linked from source data :

    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, you can enable 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 go to the Tools/Site Health on your WordPress dashboard,  and go to Info/Server,

    check what is the current max_execution_time (PHP time limit)  and max_input_time :

    7205830522.png

    -

    If it is 60, for example, increase it to 300, and it should then look like this :

    4815026505.png

    If you need help on increasing this value, please check this guide.

    Let me know how it goes.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    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

  • Steven replied

    Hey Milos

    That makes sense. The PHP Time Limit and Max Input Time are both set at 360 and it still brings up the 503 timeout error. I even increased it to 9600 for both just to see if that absurd number would work and it still times out when creating and updating an existing table.

  •  1,740
    Miloš replied

    Hi Steven,

    That is strange. Yes, if you got both numbers set to 300, that should already be enough.

    Maybe our Plugin has an issue with something specific on the file you are trying as the data source.

    Can you please send me the CSV, Excel or if it is a Google sheet, you can send access to my email [email protected]?

    If it is CSV or Excel, you can try sending them here as attachment or upload to weTransfer and send a download link.

    If it has any sensitive data, please use a private reply for security reasons.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    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