I would like to use a separate mysql db on the localhost. I assumed I could just enter the credentials in wpdatatables, but when I try to test the connection nothing returns. Should I be using "localhost" in the mysql host field or something else?
The
500 Internal Server Error is a server-side error, meaning the problem
probably isn't with your computer, Internet connection or plug ins
but instead is a problem with the web site's server.
Can
you please investigate your server log and see if there is some
errors.
Probably because of the limitation of the php array that we have described in our documentation
The format of the serialized array should be the following: 2D-array, where the parent level is an indexed array, and the second level is an associative array. Parent array entries will be parsed as rows, child array keys will be parsed as column headers, child array values as cell values.
I was unable to make a connection to a secondary database on the localhost. I will reformat the serialized output as described, but only because I want to learn a bit about this option.
I was able to create a SQL query to the other database after granting the wordpress db user select permissions on the secondary database. For now, this is the best workaround.
Of special note. After granting permission to the wordpress db user, the newly available database objects are not listed in the mysql constructor. But writing a sql script does work.
At the moment separate connection only allows connecting to one other database but we are working to increase this functionality for future updates so more databases can be connected at the same time.
Hope that everything is working fine now.
If you have any more issues feel free to open a new ticket, we will gladly help.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
Thanks.
I would like to use a separate mysql db on the localhost. I assumed I could just enter the credentials in wpdatatables, but when I try to test the connection nothing returns. Should I be using "localhost" in the mysql host field or something else?
Hi Lalato,
Thank you for your purchase.
Yes you can use localhost in the mysql host field or you can enter your IP address.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
When I use localhost, it does not appear to work. It just spins without resolving.
I also tried to use serialized php array. But I get an error when try it.
HI Lalato,
The 500 Internal Server Error is a server-side error, meaning the problem probably isn't with your computer, Internet connection or plug ins but instead is a problem with the web site's server.
Can you please investigate your server log and see if there is some errors.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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 Lalato,
Probably because of the limitation of the php array that we have described in our documentation
The format of the serialized array should be the following: 2D-array, where the parent level is an indexed array, and the second level is an associative array. Parent array entries will be parsed as rows, child array keys will be parsed as column headers, child array values as cell values.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
I was unable to make a connection to a secondary database on the localhost. I will reformat the serialized output as described, but only because I want to learn a bit about this option.
I was able to create a SQL query to the other database after granting the wordpress db user select permissions on the secondary database. For now, this is the best workaround.
Thanks for your help.
Of special note. After granting permission to the wordpress db user, the newly available database objects are not listed in the mysql constructor. But writing a sql script does work.
Hi Lalato,
You are welcome.
At the moment separate connection only allows connecting to one other database but we are working to increase this functionality for future updates so more databases can be connected at the same time.
Hope that everything is working fine now.
If you have any more issues feel free to open a new ticket, we will gladly help.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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