Serailized Php Array does not accept wpdb datasource

  • Resolved wprmayne

    (@wprmayne)


    2 years, 7 months ago

    The standard wpdb datasource return string array, also for Id. When your serialize the array the value of the ID is indetify as string. (s:1:”1″) even it’s a integer.
    In this case to plugin does not see any record and it’s impossible to save the table.

    Why you does not accept string as Id?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter wprmayne

    (@wprmayne)

    I realy don’t know why it does not work. I try the example from the site and it work correctly. The output was copied to a other php programm and echo. In this case the same output is not accepted.
    What’s wrong?
    the output.
    a:10:{i:0;a:2:{s:2:"Id";i:484;s:5:"Title";s:16:"Privé : import";}i:1;a:2:{s:2:"Id";i:473;s:5:"Title";s:5:"CLUBS";}i:2;a:2:{s:2:"Id";i:468;s:5:"Title";s:6:"NATURE";}i:3;a:2:{s:2:"Id";i:464;s:5:"Title";s:6:"CHASSE";}i:4;a:2:{s:2:"Id";i:462;s:5:"Title";s:7:"AGILITY";}i:5;a:2:{s:2:"Id";i:368;s:5:"Title";s:20:"INSTITUTIONS CANINES";}i:6;a:2:{s:2:"Id";i:298;s:5:"Title";s:10:"Les tiques";}i:7;a:2:{s:2:"Id";i:286;s:5:"Title";s:8:"Conseils";}i:8;a:2:{s:2:"Id";i:283;s:5:"Title";s:40:"éducation à la propreté chez le chien";}i:9;a:2:{s:2:"Id";i:240;s:5:"Title";s:12:"Lu pour vous";}}

    Plugin Author wpDataTables

    (@wpdatatables)

    Hello there.

    Sorry for the late response.

    The issue is caused by the encoding. You’ve got special (language) characters in the array, so they’re not being counted properly (é, à, é).

    Those characters are not supported by serialized PHP arrays, so you would need to change them to E, a, e. Alternately, you would need to adjust the charset to iso-8859-1, but we haven’t done this before, so we can’t say exactly how you can approach this.

    Our developers will be looking at possible solutions in the future, but since they aren’t being recognized in online unserializers (like https://www.unserialize.com/), we can’t promise anything.

    Kind regards.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Serailized Php Array does not accept wpdb datasource’ is closed to new replies.