In the section save to a Mysql server I am not too sure what to put in that section
Having gone through all the common alternatives I am getting bored with the error:
Failed to open database [2005] SQLSTATE[HY000] [2005] Unknown MySQL server host XXXXXXXXX
I Have tried localhost
The website address: http://www.fredblogswebsite
etc
any input gratefully recived
Connection to Sql Server
Bernard Gale
Registered User
10 posts
Bernard Gale
Registered User
10 posts
OK I have a connection as my error has now changed:
"Failed to execute query associated to this form"
as this is just a basic form with no special modification just the submit button I am guessing I must be missing something else
"Failed to execute query associated to this form"
as this is just a basic form with no special modification just the submit button I am guessing I must be missing something else
Eric Rohloff
Senior Advisor
20,271 posts
What's the actual location of your site. .com, .net, .org?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Bernard Gale
Registered User
10 posts
Eric Rohloff
Senior Advisor
20,271 posts
Here's some guidance.
Server:local host
Port: 3306
username: User name you added on your server to give access to the database.
Password: Password assigned to the username above.
Database name: The database you setup on your host that the user above has access to.
Table name: What ever you want because the form builder will make the table. Don't bother making the table on the server let the form builder do it.
If you still have problems contact your host because some of these settings are very specific with each host Mysql.
Server:local host
Port: 3306
username: User name you added on your server to give access to the database.
Password: Password assigned to the username above.
Database name: The database you setup on your host that the user above has access to.
Table name: What ever you want because the form builder will make the table. Don't bother making the table on the server let the form builder do it.
If you still have problems contact your host because some of these settings are very specific with each host Mysql.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Bernard Gale
Registered User
10 posts
Hi yes I seem to have got through that but still get that error it must be close to working as the server sends out the e-mail saying the form has been completed with the results filled in
Eric Rohloff
Senior Advisor
20,271 posts
Look on your host for an error.log file for a better description of the error. It might be in the storage folder.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Bernard Gale
Registered User
10 posts
Thanks for all your help, much appreciated.
The problem was I was using too many text area fields so ran into the
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
Which was as you say in the Error log file.
So all corrected now and working....On to the next problem I am sure soon.
The problem was I was using too many text area fields so ran into the
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
Which was as you say in the Error log file.
So all corrected now and working....On to the next problem I am sure soon.
Eric Rohloff
Senior Advisor
20,271 posts
Great! Thanks for posting back. So mySql hasn't updated to what excel can do.
So mySql hasn't updated to what excel can do.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Prism
Ambassador
1,611 posts
Remember that flat file system I told you about Eric, well that can. A csv file can have one entry linked to the main one. a MySQL database is really a csv file with a text manipulator. as you surmise an online version of excel. It is the data recovery software that makes a great database .
The Guy from OZ
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.
