Okay
  Public Ticket #3571961
After updating to 6.1, Column 'pos' cannot be null error
Closed

Comments

  • Regis started the conversation

    Hello,

    I encounter 2 major problems after updating to 6.1, first error :

    Cannot redeclare is_plugin_installed() (previously declared in /htdocs/wp-content/plugins/wpdatatables/controllers/wdt_functions.php:598) in /htdocs/wp-content/plugins/royal-elementor-addons/admin/plugin-options.php on line 51'"

    For this error i found a workaround. I comment function lines in royal elementor plugin-options.php file.


    Everything seems ok after that, but i cannot update my table with an excel file as i usually do, here is the error : 

    "function":"[proxy_fcgi:error]", "request_id":"21f1d162b6545e195c3e8389ec4ec26c", "request":"/wp-admin/admin-ajax.php", "ip":"myIP:0", "message":"AH01071: Got error 'PHP message: PHP Warning:  Attempt to read property "pos" on bool in /htdocs/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php on line 1320; PHP message: WordPress database error Column 'pos' cannot be null for query INSERT INTO `wp_wpdatatables_columns` (`calc_formula`, `color`, `column_type`, `css_class`, `default_value`, `display_header`, `filter_type`, `formatting_rules`, `group_column`, `hide_on_phones`, `hide_on_tablets`, `id_column`, `input_mandatory`, `input_type`, `orig_header`, `pos`, `skip_thousands_separator`, `sort_column`, `sum_column`, `table_id`, `text_after`, `text_before`, `visible`, `width`, `advanced_settings`, `possible_values`) VALUES ('', '', 'string', '', '', 'wdt_created_by', 'text', '0', '0', '0', '0', '0', '0', 'text', 'wdt_created_by', NULL, '0', '0', '0', '2', '', '', '1', '', '{\"decimalPlaces\":-1,\"transformValueText\":\"\",\"possibleValuesAddEmpty\":0,\"possibleValuesAjax\":10,\"column_align_fields\":\"\",\"calculateAvg\":0,\"column_align_header\":\"\",\"calculateMax\":0,\"column_rotate_header_name\":\"\",\"calculateMin\":0,\"sorting\":1,\"exactFiltering\":0,\"globalSearchColumn\":1,\"filterLabel\":null...'"  }

    It crash the plugin, all i can do is to revert to 6.0 where everything is fine using the exact same excel file...

  •  2,572
    Aleksandar replied

    Hello Regis.

    I'm sorry to see you're having issues with the update.

    Can I use the email address you opened this ticket with to send you a new installation file? As this is a public ticket, I don't want to disclose it.

    If that doesn't work, we can escalate the issue to our developers, but they will probably need a staging site (a duplicate of your current environment) along with FTP and database access, so they can troubleshoot the issue.

    Kind Regards, 

    Aleksandar Vuković
    [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

  • Regis replied

    Hello Aleksandar,

    Yes you can use this email address.

    Thank you.

  •  2,572
    Aleksandar replied

    Thank you, Regis.

    The file has been shared with you via wetransfer.

    Please let me know how it goes.

    Kind Regards, 

    Aleksandar Vuković
    [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

  • Regis replied

    Thanks Aleksandar,

    I thought you were sending me a beta or something but it is the official 6.1 that i already have... I tried a few installations before posting here.

    Anyway i took the time to recreate the table, and its working as expected. (some users may have the same problem)

    But there is still a bug after updating as in this new version you introduced a new function called "is_plugin_installed" wich has the same name as a function used in royal elementor addons.

  •  2,572
    Aleksandar replied

    Hi again Regis.

    I sent you the same file, yes, but downloaded it directly from our server since there have been some issues with the store repository in the past few days and we've had customers who weren't able to install those files, but when we sent them our "versions", it worked fine. I suppose the file broke while being downloaded from the store, but I'm not certain. We fixed it now, but it seems that didn't resolve your issue.

    I passed your feedback and this entire ticket to our developers so they can check it out and I'll let you know once I hear back from them.

    Kind Regards, 

    Aleksandar Vuković
    [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

  • Regis replied

    Ok thank you.

  •  1,846
    Miloš replied

    Hi again Regis.

    We were able to reproduce this conflict with the Royal Elementor Addons Plugin/ it causes a critical error on our Test Site, when we try to activate the 6.1 update, and we have a workaround fix solution.

    Our developers isolated the bug, the fix should be added in the next Update.



    You can try this on your end first, and if it does not work, we can do it for you again remotely. ( if needed)

    Find this PHP file of our Plugin, ( via your FTP/or Hosting File Manager) in the path :

    ..wp-content/plugins/wpdatatables/controllers/wdt_functions.php

    around line 605, find this :

    function is_plugin_installed($plugin_path) {

    Change it to  :

    function wdt_is_plugin_installed($plugin_path) {

    Then, in the same file, around another line 633, find  :

    if(is_plugin_installed($plugin)){
    

    Change that to :

    if(wdt_is_plugin_installed($plugin)){

    Finally, find this around line 643 :

    if(!is_plugin_installed("ameliabooking/ameliabooking.php"))

    Change it to :

    if(!wdt_is_plugin_installed("ameliabooking/ameliabooking.php"))

    As you found, that is correct, the issue is that this Plugin is calling the same two 'methods' for "is_plugin_installed", which is creating the conflict.


    If it does not work from your end when you edit it, we can remotely edit the code for you and make sure it is fixed.

    For that, we would need access.

    If it comes to that and you wish to solve this through our Plugin's Code edit, please send us URL to your WP-Admin back-end, along with Administrator username and password,  and send us FTP Credentials or access to the Hosting Panel/ to reach the File Manager.

    If you send access, just make sure to send it in a PRIVATE reply, for security reasons, then only we can see it.


    We will be here if that is needed.

    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

  • Regis replied

    Hi Milos,

    I replaced these 3 lines (598, 626, 636 in my file) in wdt_functions.php and its working great.

    Thank you for this quick solution.

  •   Miloš replied privately