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.