MySQL mapping does’nt work
-
Hi,
I want to save dataform in external database
I have a WordPress on a hosting 1 with fixed ip address and a MySQL database on a hosting 2
On the Hosting 2, I create a user with administrator rights and I add IP right. For information 2 others IP have rights to use database.1) Tests with user and 2 others IP : OK
2) Tests on Hosting 1 with form maker : Non OK
> no error but dropdown list is empty.
3) Tests on Hosting 1 on console mode (made by Hosting 1 support team) : OKScreenshots : https://image.noelshack.com/fichiers/2018/10/4/1520502747-copies-ecran.jpg
Someone can help me ?
Thanks
-
Hi!
May I ask, do you want to take the info from a database and move it to another one?
If yes, then please note that the product does not have the mentioned functionality yet. However, the feature you wish to have would be a great addition. So could you please add your suggestion to our Submit Your Idea page?
Our development team will consider working on this for further updates.
Thanks in advance! Have a wonderful day!Hi,
No, I just want to save dataform in an external database.
Exactly like : https://web-dorado.com/wordpress-form-maker/form-options/mysql-mapping.htmlBut dropdown list is empty. See : https://image.noelshack.com/fichiers/2018/10/4/1520502747-copies-ecran.jpg
Thanks
Greetings!
May I ask, does your password include brackets (][)?
Thanks in advance!Have a nice day!
Hi,
I don’t understand your question ?
Can you give me a sample ?Thanks
Hi!
Please note that we mean the password which you are using for connecting to Remote Database in MySQL Mapping.
For instance: “gdfgf4454]vdfdf[”Thanks!
I have no “][” in the password in RemoteDatabase just letters and numbers
Why ? This is a problem to have “][” in password ?
Please note that we have a bug concerning β][β in the password. However, our development team is going to fix it in the upcoming update.
We need to have a closer look at the described issue.
Please contact our support team using the following email address:[email protected]
Also, mention the URL of this forum topic in your message. We will provide a solution as soon as possible and share it here as well.Thanks, have a nice day!
Hi,
Thanks,
Support know the problem (Support ticket #310839) since 4 days. I post here for sharing and maybe obtain solution by an other user…
Thanks.
Hi,
No news π
Here or by support (ticket #310839)
Dear Laurent,
Our support specialist has replied to your ticket on 16 March. Could you please check your spam folder?
Thanks in advance, have a nice day!
Hi Laurent,
Our support specialist has already replied to your ticket.
If you have a Gmail account, please send us your email address. We will add it to our Google Hangouts and start to communicate via chat.Thanks in advance!
1) I found the problem on march 25
“port” field don’t work to connect to external database
When click on “Connect” The QUERY is :
object(wpdb)#11954 (59) { [“show_errors”]=> bool(false) [“suppress_errors”]=> bool(false) [“last_error”]=> string(0) “” [“num_queries”]=> int(0) [“num_rows”]=> int(0) [“rows_affected”]=> int(0) [“insert_id”]=> int(0) [“last_query”]=> NULL [“last_result”]=> NULL [“result”:protected]=> NULL [“col_meta”:protected]=> array(0) { } [“table_charset”:protected]=> array(0) { } [“check_current_query”:protected]=> bool(true) [“checking_collation”:”wpdb”:private]=> bool(false) [“col_info”:protected]=> NULL [“queries”]=> NULL [“reconnect_retries”:protected]=> int(5) [“prefix”]=> string(0) “” [“base_prefix”]=> NULL [“ready”]=> bool(false) [“blogid”]=> int(0) [“siteid”]=> int(0) [“tables”]=> array(10) { [0]=> string(5) “posts” [1]=> string(8) “comments” [2]=> string(5) “links” [3]=> string(7) “options” [4]=> string(8) “postmeta” [5]=> string(5) “terms” [6]=> string(13) “term_taxonomy” [7]=> string(18) “term_relationships” [8]=> string(8) “termmeta” [9]=> string(11) “commentmeta” } [“old_tables”]=> array(3) { [0]=> string(10) “categories” [1]=> string(8) “post2cat” [2]=> string(8) “link2cat” } [“global_tables”]=> array(2) { [0]=> string(5) “users” [1]=> string(8) “usermeta” } [“ms_global_tables”]=> array(7) { [0]=> string(5) “blogs” [1]=> string(7) “signups” [2]=> string(4) “site” [3]=> string(8) “sitemeta” [4]=> string(14) “sitecategories” [5]=> string(16) “registration_log” [6]=> string(13) “blog_versions” } [“comments”]=> NULL [“commentmeta”]=> NULL [“links”]=> NULL [“options”]=> NULL [“postmeta”]=> NULL [“posts”]=> NULL [“terms”]=> NULL [“term_relationships”]=> NULL [“term_taxonomy”]=> NULL [“termmeta”]=> NULL [“usermeta”]=> NULL [“users”]=> NULL [“blogs”]=> NULL [“blog_versions”]=> NULL [“registration_log”]=> NULL [“signups”]=> NULL [“site”]=> NULL [“sitecategories”]=> NULL [“sitemeta”]=> NULL [“field_types”]=> array(0) { } [“charset”]=> NULL [“collate”]=> NULL [“dbuser”:protected]=> string(12) “XXXXXXXXXXXXXXXX” [“dbpassword”:protected]=> string(10) “XXXXXXXXXXXXXXXX” [“dbname”:protected]=> string(8) “XXXXXXXXXXXXXXXX” [“dbhost”:protected]=> string(26) “XXXXXXXXXXXXXXXX” [“dbh”:protected]=> NULL [“func_call”]=> NULL [“is_mysql”]=> bool(true) [“incompatible_modes”:protected]=> array(5) { [0]=> string(12) “NO_ZERO_DATE” [1]=> string(18) “ONLY_FULL_GROUP_BY” [2]=> string(19) “STRICT_TRANS_TABLES” [3]=> string(17) “STRICT_ALL_TABLES” [4]=> string(11) “TRADITIONAL” } [“use_mysqli”:”wpdb”:private]=> bool(true) [“has_connected”:”wpdb”:private]=> bool(false) [“error”]=> object(WP_Error)#11955 (2) { [“errors”]=> array(1) { [“db_connect_fail”]=> array(1) { [0]=> string(913) ”Theren’t “port” parameter.
2) Today, I found the workaround
Add the port in “host” field
Like : HOSTNAME:NUMBERNAME
For example : database.hostserver.net:33999Hi Laurent,
It’s wonderful that you have figured out how to solve the issue. Please use it like that until we will fix this issue.
Thank you very much for finding the issue and letting us know about it.
We highly appreciate your help which will allow us to improve our plugin.
Have a wonderful day!
The topic ‘MySQL mapping does’nt work’ is closed to new replies.