Okay
  Public Ticket #2905547
Error! There was an error while trying to import table
Closed

Comments

  • Subhash started the conversation

    Hi,

    I purchased the plugin yesterday

    you can see below basic details of version
    1. My wordpress version is 5.8.1
    2. wpdatatable plugin - 3.6
    3. My Postgres version is 14
    4. php version is 7.4.10

    Manual and Import Excel data tables are not created
    The table is not generated, I need help

    Screenshot of postgresql
    Postgresql pgadmin - screenshot

  • [deleted] replied

    Hi Subhash

    Thank you for reaching out to us.

    Do you have any issues creating SQL tables from that separate database? Do you have any issues creating other table types when you select WP connection from the dropdown menu?

    2958675530.png
  • Subhash replied

    Hi Blazenka,

    Thanks for reply.

    Database connection is successful but does not work when we go to create data table from wpdatatable plugin. I have already sent all the screenshots related to the problem. Postgresql database connection successfully.

    I am a WordPress developer, running fine in MYSQL database but does not work in postgresql database. The table is generated in the postgresql database but no entry is made in the main table.

    As I saw the table in the database, there is no entry in your 2 main tables
    - wpdatatables
    - wpdatatables_columns

    Please help me.


    Thanks
    Subhash Patel

  •  472
    Isidora replied

    Hi Subhash

    Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.

    Please provide me a temporary WP-admin (administrator) user for your site where this happens and also phpMyAdmin credentials for database where is installed WordPress, 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.

    Also an you please tell which hosting are you using? Is it DigitalOcean maybe?

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  • Subhash replied

    Hi Milan,

    I am currently working on a local system and postgresql database is installed in my local system. Your plugin works in mysql database. I want to create charts and tables from the postgresql database.

    I have not uploaded to the server but I want to get the data from postgresql database

    If you want to check in my system I can give you anydesk.

    Thanks
    Subhash Patel

  • [deleted] replied

    Hi Subhash

    I'm afraid we can't provide this kind of support and since we don't have remote access we will have to ask you to add this to wp_config.php file to display errors so we can see what exactly the issue is

    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);

    if debugging is set to false please change it to true or if it doesn't exist please add this to the wp_config.php file

    define( 'WP_DEBUG', true );

    When you add that please go to the table wizard, select the connection again and go to create a new manual table. Before you click on create the table button please open Inpsect element->Network and select only XHR. When you click on create the table you will see an ajax call being made so please send us a screenshot of that ajax response, or any errors you see appear.

    Most likely the issue is here

    wp-content/plugins/wpdatatables/controllers/wdt_admin_ajax_actions.php:596

    $newTableId = $constructor->generateManualTable($tableData);

    because both wpdatatable and wpdatatable_columns are being updated in the database when a manual table is created.

    Looking forward to hearing from you.