Upgrade PHP 7.2 to 7.4

cpshart · October 2020

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

Hi

I have just upgraded my PHP from 7.2 to 7.4 using PHP Selector on my cPanel wrongly expecting it to maintain the extensions checked when using 7.2. I should have created a screenshot of all the extensions, so I am experiencing unusual behaviour on some of my datatables.

Before detailing the issues which are likely to be as a result of not including necessary PHP extensions, I have attached my current PHP set-up on the server. Can someone advise me if I am missing any obvious essential extensions.

Note reverting back to 7.2 still results in issues, so I must be missing some extensions is my guess.

Any help is much appreciated.

Many Thanks

Colin

cpshart · October 2020

The majority of my datatables are working bar one in Edit Mode it is not showing the fields in the modal, which would indicate the PHP upgrade to 7.4 may be a red herring so to speak, apologies if I have wasted anyones time. I will keep investigating ...

Thanks

Colin

cpshart · October 2020

I am getting an error on one of my datatables when adding a new entry using the editor on a very simple table, which from a google search appears to be an issue with PHP 7.4, as it was not happening before my upgrade from 7.2->7.4.

Notice: Trying to access array offset on value of type bool in /home/ukincome/public_html/Editor-PHP-1.9.5/controllers/dview-stock_portfolios.php on line 85
{"data":[{"DT_RowId":"row_29","dm_portfolios":{"user_id":1,"code":"GBUJKKB","name":"gbuhku","portfolio_type":"DEA","reporting_status":"yes"}}],"debug":[{"query":"SELECT * FROM `dm_portfolios` WHERE

so I may roll out PHP 7.4 to PHP 7.3 unless anyone has any suggestions on how to fix the issue with datatables.net.

Many Thanks

Colin

tangerine · October 2020

Notice: Trying to access array offset on value of type bool in /home/ukincome/public_html/Editor-PHP-1.9.5/controllers/dview-stock_portfolios.php on line 85

So what does line 85 of your controller look like?

cpshart · October 2020

Hi tangerine

Line 85 is the switch statement below, I can PM you access to my system if you need it, let me know..

I was going to drop back to PHP 7.2 temporarily to confirm it was working before as an option to confirm the issue is related to PHP 7.4. I have spoken to my hosting provider, guru and they have confirmed that PHP 7.4 is a stable release.

        Field::inst( 'dm_portfolios.reporting_status' )
            ->validator( Validate::notEmpty( ValidateOptions::inst()
                ->message( 'A reporting status is required' )
            ) )
            )


    ->validator( function ( $editor, $action, $data ) use ($userid) {
        global $subscription_plan_id;
        global $portfolio_limit;
        
        
        if ( $action === Editor::ACTION_CREATE || $action === Editor::ACTION_EDIT ) { //1
           foreach ( $data['data'] as $pkey => $values ) { //2
                    $count = $editor
                            ->db()
                            ->query('select')
                            ->get('*')
                            ->table('dm_portfolios')
                            ->where( function ( $q ) use ( $userid) {
                            $q->where( 'user_id', $userid);
                            } )
                            ->exec()
                            ->count();

                            $subscription_plan_id = $editor
                            ->db()
                            ->query('select')
                            ->get('subscription_plan_id')
                            ->table('wp_pms_member_subscriptions')
                            ->where( function ( $q ) use ( $userid) {
                            $q->where( 'user_id', $userid);
                            } )
                            ->exec()
                            ->fetch();
                            
                    switch ($subscription_plan_id['subscription_plan_id']) {
                        case "18649": /* Bronze Plan */
                            $portfolio_limit = 12;
                            break; 
                        case "18650": /* Silver Plan */
                            $portfolio_limit = 13;
                            break; 
                        case "18651": /* Gold Plan */
                            $portfolio_limit = 14;
                            break; 
                        default: 
                            $portfolio_limit = 12;
                            break; 
                    }

                        // subscription_plan_id     description     portfolio limit
                        // 18649                    Bronze Plan     6, 12
                        // 18650                    Silver Plan     7, 13
                        // 18651                    Gold Plan       8, 14
                        
                    if ($count == $portfolio_limit){ //3
                        return 'Upgrade to add more than '. $portfolio_limit . ' portfolios.';
                    } //3

let me know if you need more information.

Many Thanks

Colin

cpshart · October 2020

Hi

If I add a new Entry and then attempt to delete the entry the system produces the following error

Notice: Undefined index: data in /home/ukincome/public_html/Editor-PHP-1.9.5/lib/Editor.php on line 1275

Warning: Invalid argument supplied for foreach() in /home/ukincome/public_html/Editor-PHP-1.9.5/lib/Editor.php on line 1275
{"data":[],"debug":[]}

It also refers to deleting 0 rows, as if it is not aware of the id of the row ?

Are you sure you wish to delete 0 rows?

When I attempt to edit a row it does not display the data in the form

Other datatables appear to work ok on my system.

Regards

Colin

cpshart · October 2020

Hi tangerine

I have sent you a PM with full access to my system and the problem, if you need it.

Thanks

Colin

tangerine · October 2020

What are the contents of $subscription_plan_id at this point:

switch ($subscription_plan_id['subscription_plan_id'])

?

cpshart · October 2020

Hi tangerine

subscription_plan_id :
Notice: Trying to access array offset on value of type bool in /home/ukincome/public_html/Editor-PHP-1.9.5/controllers/dview-stock_portfolios.php on line 85

Notice: Trying to access array offset on value of type bool in /home/ukincome/public_html/Editor-PHP-1.9.5/controllers/dview-stock_portfolios.php on line 86

If you google the above error

Trying to access array offset on value of type bool in PHP 7.4

there are a number of people who have experienced the same issue when switch to PHP 7.4

I have been trying to upgrade the libraries to the latest datatables.net libraries on my system at the same time, but I am unable to create or delete records from any of my tables or those that I have tested, so although I am not live yet I very keen to get it resolved.

Thanks Colin

cpshart · October 2020

Hi tangerine

If I comment out the whole validator section in the server script. I then add a new row say TEST and refresh, it displays the row, then if I Edit no data is shown on the form and if I Delete, the message above ... delete 0 rows is shown and pressing delete results in an error

Notice: Undefined index: data in /home/ukincome/public_html/Editor-PHP-1.9.5/lib/Editor.php on line 1275

Warning: Invalid argument supplied for foreach() in /home/ukincome/public_html/Editor-PHP-1.9.5/lib/Editor.php on line 1275
{"data":[],"debug":[]}

Colin

cpshart · October 2020

Hi

Can someone help here as a matter of urgency please as the datatables aspect of my website which is the core element is broken, I cannot add and delete rows using the Editor for any of my tables after upgrading from PHP 7.2 to PHP 7.4, I have now reinstated the PHP to 7.2 default values as per the previous settings, but my tables editor is still not working as expected.

Ultimately I will need to upgrade to PHP 7.4 being the latest stable version, this may be a red herring in relation to the problem.

Any help or guidance would be much appreciated, I can provide online access to my system.

Best Regards

Colin

cpshart · October 2020

Hi

To summarise the current status
Rolled back to PHP 7.2, default extensions as previously set confirmed by my host
Using Latest libraries given by debugger

I have commented out the Global Validator Section, although it has been in place for months working.

Some Datatable Editor scripts are working normally where Parent Child set-up exists
Other Simple Datatable PHP scripts not working as expected

If I can get the Stock Portfolios working a very simple table, then I should be able to fix the other ones which are failing

https://www.dividendview.co.uk/stock-portfolios/

I will need to send a PM to provide access to anyone investigating the problem on my system

On adding a record and then deleting the record I am getting the error message

Are you sure you wish to delete 0 rows?

then in Chrome, Developer Tools, Preview

Notice: Undefined index: data in /home/ukincome/public_html/Editor-PHP-1.9.5/lib/Editor.php on line 1275

Warning: Invalid argument supplied for foreach() in /home/ukincome/public_html/Editor-PHP-1.9.5/lib/Editor.php on line 1275
{"data":[],"debug":[]}

If I edit a row, it does not populate the Code and Name in the form, it just populates the default values, not the values set on the row.

client script

<html>
<head>
<title>Stock Portfolios</title>

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.22/css/jquery.dataTables.min.css" />
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.6.5/css/buttons.dataTables.min.css" />
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/searchpanes/1.2.0/css/searchPanes.dataTables.min.css" />    
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.3.1/css/select.dataTables.min.css" />
<link rel="stylesheet" type="text/css" href="https://www.dividendview.co.uk/Editor-1.9.5/css/editor.dataTables.min.css" />
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.2/css/select2.min.css">

<script type="text/javascript"   src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script type="text/javascript"   src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script> 
<script type="text/javascript"   src="https://cdn.datatables.net/searchpanes/1.2.0/js/dataTables.searchPanes.min.js"></script>  
<script type="text/javascript"   src="https://cdn.datatables.net/buttons/1.6.5/js/dataTables.buttons.min.js"></script>
<script type="text/javascript"   src="https://cdn.datatables.net/select/1.3.1/js/dataTables.select.min.js"></script>
<script type="text/javascript"   src="https://www.dividendview.co.uk/Editor-1.9.5/js/dataTables.editor.js"></script>    
<script type="text/javascript"   src="https://cdn.datatables.net/responsive/2.2.6/js/dataTables.responsive.min.js"></script>
<script type="text/javascript"   src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.2/js/select2.min.js"></script> 

<script type="text/javascript"   src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript"   src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script type="text/javascript"   src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script type="text/javascript"   src="https://cdn.datatables.net/buttons/1.5.4/js/buttons.html5.min.js"></script>
<script type="text/javascript"   src="https://cdn.datatables.net/buttons/1.5.4/js/buttons.print.min.js"></script>       
    
    
</head>

<table id="stock_portfolios" class="display compact" style="width:100%">
<thead>
... etc
<script type="text/javascript">
(function($) {
/* 
* change when upgrading the Version of the datatables.net PHP files
*/  
var EDITOR_DIR = 'Editor-PHP-1.9.5';    
    
var editor; // use a global for the submit and return data rendering in the examples
var table;
    
$(document).ready(function() {
    editor = new $.fn.dataTable.Editor( {
        ajax: {
            url: "../../" + EDITOR_DIR + "/controllers/dview-stock_portfolios.php",
            type: 'POST',
            data: function ( d ) {
                d.userid = $('#passuserid').val();
            }
        },
        table: table,
        fields: [ {
                label: "Portfolio:",
                name: "dm_portfolios.code"
            }, {
                label: "Name:",
                name: "dm_portfolios.name"
            }, {
                label: "Portfolio Type:",
                name: "dm_portfolios.portfolio_type",
                type:  "radio",
                options: [
                    { label: "Dealing", value: "DEA" },
                    { label: "ISA",   value: "ISA" },
                    { label: "SIPP",   value: "SIPP" }
                    ],
                def: "DEA"
            }, {
                label: "Reporting Status:",
                name: "dm_portfolios.reporting_status",
                type:  "radio",
                options: [
                    { label: "Yes", value: "yes" },
                    { label: "No",   value: "no" }
                    ],
                def: "yes"
            }
        ]
    } );

    table = $('#stock_portfolios').DataTable( {
        ordering: true,
        order:          [[ 0, 'asc' ]],     
        
        dom: 'lBfrtip',
        "scrollY":      true,
        "scrollX":      true,
        
        ajax: {
            url: "../../" + EDITOR_DIR + "/controllers/dview-stock_portfolios.php",
            type: 'POST',
            data: function ( d ) {
                d.userid = $('#passuserid').val();
                                }
            },
        columns: [
            { data: "dm_portfolios.code" },
            { data: "dm_portfolios.name" },
            { data: "dm_portfolios.portfolio_type" },
            { data: "dm_portfolios.reporting_status" }
        ],
/***********************************************************************
* export buttons 
************************************************************************/       
        select: true,
        buttons: [
            { 
                extend: "create", 
                editor: editor, 
                formButtons: [
                    'Create',
                    { text: 'Cancel', action: function () { this.close(); } }
                ]
            },
            { 
                extend: "edit",   
                editor: editor, 
                formButtons: [
                    'Edit',
                    { text: 'Cancel', action: function () { this.close(); } }
                ]
            },
            {
                extend: "selected",
                text: 'Duplicate',
                action: function ( e, dt, node, config ) {
                    // Start in edit mode, and then change to create
                    editor
                        .edit( table.rows( {selected: true} ).indexes(), {
                            title: 'Duplicate record',
                            buttons: 'Create from existing'
                        } )
                        .mode( 'create' );
                }
            },          
            { 
                extend: "remove", 
                editor: editor, 
                formButtons: [
                    'Delete',
                    { text: 'Cancel', action: function () { this.close(); } }
                ]
            },
                    {
                extend: 'collection',
                text: 'Export',
                buttons: [
                    'copy',
                    'excel',
                    'csv',
                    'pdf',
                    'print'
                ]
            }
        ],
/***********************************************************************
* export buttons 
************************************************************************/               
/***********************************************************************
* lengthMenu 
************************************************************************/   
        iDisplayLength: 5,
        lengthMenu:     [ [1, 5, 10, 25, 50, 100, -1], [1, 5, 10, 25, 50, 100, "All"] ],
        language: {
           decimal:     ".",
           thousands:   ","
       },
/***********************************************************************
* lengthMenu 
************************************************************************/                   
} );    
} );    
    
}(jQuery));</script>

server script

<?php

/*
 * stock_portfolios.php
 */
 
// DataTables PHP library
include( "../lib/DataTables.php" );
 
// Alias Editor classes so they are easy to use
use
    DataTables\Editor,
    DataTables\Editor\Field,
    DataTables\Editor\Format,
    DataTables\Editor\Mjoin,
    DataTables\Editor\Options,
    DataTables\Editor\Upload,
    DataTables\Editor\Validate,
    DataTables\Editor\ValidateOptions;

$userid = $_POST['userid'];

// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'dm_portfolios' )
    ->debug(true)
    ->fields(
        Field::inst( 'dm_portfolios.user_id' )
// default the value of the userid to $userid        
            ->setValue( $userid ),            
        Field::inst( 'dm_portfolios.code' )
                ->validator( Validate::notEmpty( ValidateOptions::inst()
                    ->message( 'A portfolio code is required' )
            ) ),
        Field::inst( 'dm_portfolios.name' )
            ->validator( Validate::notEmpty( ValidateOptions::inst()
                ->message( 'A portfolio name is required' )
            ) ),
        Field::inst( 'dm_portfolios.portfolio_type' )
            ->validator( Validate::notEmpty( ValidateOptions::inst()
                ->message( 'A portfolio type is required' )
            ) ),
        Field::inst( 'dm_portfolios.reporting_status' )
            ->validator( Validate::notEmpty( ValidateOptions::inst()
                ->message( 'A reporting status is required' )
            ) )
            )

    
->where( function ( $q ) use ( $userid) {
$q->where( 'user_id', $userid);
} )
->debug(true)
->process( $_POST )
->json();

any help much appreciated

Thanks Colin

allan · October 2020

Hi Colin,

There isn't anything obvious in the above code that would cause a problem, but possibly I'm just missing it. Can you PM me the login details please?

Allan

cpshart · October 2020

Hi Allan

PM sent

Thanks Colin

Upgrade PHP 7.2 to 7.4

Upgrade PHP 7.2 to 7.4

Answers

Howdy, Stranger!

Categories

DataTables

Upgrade PHP 7.2 to 7.4

Upgrade PHP 7.2 to 7.4

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables