Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

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,498
    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,498
    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,498
    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,692
    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

    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