Okay
  Public Ticket #3753755
Php compatibility
Open

Comments

  • Philippe Caron started the conversation

    When accessing external MS SQL Server tables, apparently PHP 8.3 shows an error when trying to modify a table line.

    The message is :
    There was an error trying to insert a new row !

    I notice this problem has been documented earlier.
    Which PHP version is fully compatible ?

    When will you yupdate it to PHP 8.3 ?

    Thanks.

  •  1,825
    Miloš replied

    Hello,

    Our QA Team is testing our Plugin and they can't find any issues up to, I believe, version 8.1 / 8.2, but I will double-check with them to make sure.

    I am personally doing tests with PHP 8.3.0 and 8.3.4 though, and I am not able to see any issues on my Site, here is a screenshot of my currently installed versions on the server :

     

    3457099032.png
    But that is on my WordPress Hosting server, I am not sure if you meant that you have PHP 8.3 installed on the WP Hosting or on the external MS SQL server where the DB is stored?

    In any case, our Plugin should be fully compatible in terms of functionalities;
    Only some PHP warnings/notices can happen if you have WP_DEBUG enabled, and that should be disabled on live Sites.

    Can you please record a Video of your screen to show us more details - what are you trying to modify in a table exactly and how the error comes up?

    If the Video can't be sent here, you can upload it anywhere like WeTransfer and send a download link.
    If it shows any sensitive data, you can send it as a PRIVATE reply, so only we can see it.

    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

  • Philippe Caron replied

    Hello, thank you for your reply.I just tested this again.
    My wbesite is hosted en I can change the PHP version via a control panel any time.

    The website, or better your wpdatatables plugin, connects to an external sql server database correctly.
    If I use PHP 7.4 I can modify a

  • Philippe Caron replied

    Sorry hit the post button too quickly.

    If I use PHP 7.4 for the website I can modify a cell with no problem. The popup confirms the change.

    If I use PHP 8.3 I get a popup saying "there is an error when trying to insert a new line" and the screen hangs with an turning icon in the middle.
    The popup appears only briefly so it is difficult to make a screenshot.
    Actually, the change is  made when i look after reloading the page.

    Do you have enough info with this ?

  •  1,825
    Miloš replied

    Hi Philippe,

    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.

     

    If I understood, basically, you are editing an SQL Query table which pulls data from the external Database - and for the PHP 7.4 it works without any issues;
    while when you switch to PHP 8.3 on the WP Hosting server, then you get the visual popup with the error "there is an error when trying to insert a new line", but when you refresh, it does save the editing?

    That is strange - we can't seem to reproduce it here, so we would need to investigate this on your Site remotely.

    1. Could you please first record a Video of your screen - so that we can see the exact steps, such as which Table you are editing, which row/column(s) etc, when the issue happens?

    ( If the Video can't be sent here - you can upload it to weTransfer and send a download link. If it shows anything sensitive, make sure to mark the reply as PRIVATE for security reasons)


    Then, if you can confirm if we have permission to remote in, make a duplicate of that table, and try to do the same row edit and inspect the issue remotely on your Site?


    We don't wish to mess up any sensitive/important data/row from your data source.

    Maybe it's best if you can make a duplicate of the source SQL table on that remote Database - then make a new SQL Query table via our Plugin which we can use for troubleshooting, this way we can completely avoid messing up your original source table.



    2. As for our remote access :

    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 confirm the Table ID that we can use for testing.

    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

  • Philippe Caron replied

    Yes this is correct except that the modification appears immediately, not after refresh. 

    I enclose a video, taken with PHP 8.3.

    Kindly have a look at my other ticket, far more important to me.

    Thanks and best regards.

    Attached files:  chrome_7TIOB0wbHz.mp4

  • Philippe Caron replied

    Problem is the same with PHP 8.0, 8.1 and 8.2 !

  •  1,825
    Miloš replied

    Hi Philippe,

    Thank you for sending that Video.

    I am not able to reproduce this issue, on my Site I tested all the PHP versions such as 7.4, then 8.0 , 8.1, 8.2 and 8.3 and I am unable to see any error during table editing.

    Maybe you configured something specific which we haven't tried, with your table and columns etc.

    We have Admin access, but can you confirm which is the Table ID from your Video - so we can check out that table on your Site?

    If that is an SQL Query based table - can you send me an SQL Dump from that table, so I can import it here and do some tests with PHP 8+ versions to double-check, too?

    You can use weTransfer to upload the SQL dump from the table source and send me a download link.

    If the table source is sensitive - just mark the reply as PRIVATE, 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

  •   Philippe Caron replied privately