We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #988355
Impossible to create tables from mysql db
Closed

Comments

  •  2
    Jacques started the conversation

    I'm no more able to create a table from mysql database. It doesn't work any more. I don't know why! I have the following error:


    Error!

     {"table":{"_cacheHash":""},"table_id":9,"columns":[{"_jsFiltertype":"number","table_id":9,"orig_header":"id","display_header":"id","column_type":"int","use_in_chart":false,"chart_horiz_axis":false,"group_column":false,"pos":0,"width":"","visible":1,"possible_values":"","default_value":"","input_type":"text","input_mandatory":0,"filter_type":"text","id":192},{"table_id":9,"orig_header":"date_don","display_header":"date_don","column_type":"date","use_in_chart":false,"chart_horiz_axis":false,"group_column":false,"pos":1,"width":"","visible":1,"possible_values":"","default_value":"","input_type":"text","input_mandatory":0,"filter_type":"text","id":193},{"_jsFiltertype":"number","table_id":9,"orig_header":"montant","display_header":"montant","column_type":"int","use_in_chart":false,"chart_horiz_axis":false,"group_column":false,"pos":2,"width":"","visible":1,"possible_values":"","default_value":"","input_type":"text","input_mandatory":0,"filter_type":"text","id":194},{"_jsFiltertype":"number","table_id":9,"orig_header":"id_fiche","display_header":"id_fiche","column_type":"int","use_in_chart":false,"chart_horiz_axis":false,"group_column":false,"pos":3,"width":"","visible":1,"possible_values":"","default_value":"","input_type":"text","input_mandatory":0,"filter_type":"text","id":195},{"table_id":9,"orig_header":"no_recu","display_header":"no_recu","column_type":"string","use_in_chart":false,"chart_horiz_axis":false,"group_column":false,"pos":4,"width":"","visible":1,"possible_values":"","default_value":"","input_type":"text","input_mandatory":0,"filter_type":"text","id":196}]}



  • [deleted] replied

    Hi Jacques,

    Could you send me temporary admin credentials so I can take a look?

  •   Jacques replied privately
  • [deleted] replied

    Hi Jacques,

    Yes, if that is not a problem to you

  •   Jacques replied privately
  • [deleted] replied

    Hi Gislin,

    Could you please check your server log for possible errors?

  •   Jacques replied privately
  • [deleted] replied

    Hi Gislin,

    Easiest way to do it is to go to your cPanel where you can find it in menus

  •   Jacques replied privately
  •   Jacques replied privately
  •  2
    Jacques replied

    I don't even know the meaning of that!

  • [deleted] replied

    Hi Gislin,

    That error means that your server is not configured properly but I am not sure if this error is related to our problem. 

    I think I found what is the problem but I didn't find what is causing it because it looks like it is not related to our plugin. 

    You have UTF8 BOOM character in every ajax response as you can see in the attachment. I added one more attachemnt for you to see the difference. 

    You can Google solution for this either by "\ufeff" or UTF8 BOOM.

    Please try to resolve this first. 


  •   Jacques replied privately
  • [deleted] replied

    Hi Gislin,

    I ment web server. If you google that error you will find that it's problem is most likly with Apache setup. 

    Other problem is probably caused when files were edited and saved with wrong encoding. You should check your code editor encoding and files that you modified 

  •  2
    Jacques replied

    Hi Miljko ,

    Finally, I've found  that the problem was elsewhere.

    There were another plugin which caused that issue. I've unistalled it and the issue was solved.

    Thank you so much for the help!

  • [deleted] replied

    Hi Gislin,

    Glad to hear that you found it.