I need a relation with another table (also created via MySQL Query) using a FK field. I follow the steps that are explained in the videotutorial, and no error appears. However, filtering or editing the field is empty, even choosing "Selectbox" as the input type (following the tutorial).
The only difference between me and the example is the creation of the tables. I use MySQL Query and the tutorial uses Manual.
Can you please tell me is it possible for your site to go live and provide me the credentials for it because it is the best way to solve this kind of issue.
Unfortunately we do not support Skype or TeamViewer calls but if you can make a short video of the issue maybe I can see the problem and give you a solution.
I received a lot of emails daily and email support is not what we are preferring to do due to our support policy. You can write anything here on your ticket. If there are some informations that are private just check PRIVATE reply so nobody can see it except me and you.
We can investigate the issue with credentials but please delete or edit your post below because ticket is Public and everyone can see our conversation.
When you are sending the credentials
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us to avoid any issues if someone else use them to login to your site.
Hello.
I have created a table via MySQL Query.
I need a relation with another table (also created via MySQL Query) using a FK field. I follow the steps that are explained in the videotutorial, and no error appears. However, filtering or editing the field is empty, even choosing "Selectbox" as the input type (following the tutorial).
The only difference between me and the example is the creation of the tables. I use MySQL Query and the tutorial uses Manual.
How can I solve this?
Picture attached
Thanks.
Hi areaticCV,
Thank you for your purchase.
Do you have any link of that table so I can take a look and give you my suggestion.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Good morning.
A link is not possible. I attach some screenshots with the configuration. Sorry for the inconvenience.
Thanks.
Hi areaticCV,
Can you please change some of the code
in file
wp-content/plugins/wpdatatables/assets/js/wpdatatables/admin/table-settings/main.js around line 854 find this line of code
and change it to look like this
Then in file wp-content/plugins/wpdatatables/assets/js/wpdatatables/admin/table-settings/table_config_object.js around line 635 find this code
and replace it with this one
Let me know the result.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hello.
Nothing good happens. New attachment where I explain the error.
Regards.
Hi areaticCV,
Strange.
Can you please tell me is it possible for your site to go live and provide me the credentials for it because it is the best way to solve this kind of issue.
Unfortunately we do not support Skype or TeamViewer calls but if you can make a short video of the issue maybe I can see the problem and give you a solution.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi areaticCV,
I received a lot of emails daily and email support is not what we are preferring to do due to our support policy.
You can write anything here on your ticket. If there are some informations that are private just check PRIVATE reply so nobody can see it except me and you.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi areaticCV,
We can investigate the issue with credentials but please delete or edit your post below because ticket is Public and everyone can see our conversation.
When you are sending the credentials
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us to avoid any issues if someone else use them to login to your site.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi Juan,
I logged in successfully.
Now can you please tell me the ID of the tables from which you want to make relations so I can take a look.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi Juan,
I changed the code that I provided you below.
After that the issue was that your query looked like this
select id,estado from wp_custom_estado_produccion;
You will notice the " ; " sign at the end of it and that is causing the issue. I removed that sign and now as I can see everything is working fine.
If you go to your table id 11 now you will see the relation for Status Production column.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Great! What idiocy! :(
It seems to solve all my problems by now. I'm making relations correctly.
Thanks a lot! We can close the ticket.
Hi Juan,
No problem at all,glad to help you out.
You are welcome.
Best regards.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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