Software problems in WFB 2.9

User 2796380 Photo


Registered User
94 posts

Access denied problem, Your software was not putting (") around port number 3306. We manually inserted the (").
Now form is making contact with database but there is still some other problem in saving the data.
Below is part of file form.cfg.php.........where we added (")

Not knowing what to put into Table name: I put "name"
What is suppose to go in Storing Results>MySQL>Table name: "?"

I have tried several times to attach a file and get error 403 This file show error log for the above problem.
Larry Penny
User 103173 Photo


VP of Software Development
0 posts

Access denied problem, Your software was not putting (") around port number 3306. We manually inserted the (").

That is not required.

What is suppose to go in Storing Results>MySQL>Table name: "?"

Just the table name that you want the scripts to create. Do not wrap them in any quotes. Also make sure not to create the table as well. Let the software do this.

Review this article:
http://www.coffeecup.com/help/articles/ … m-builder/

I have tried several times to attach a file and get error 403 This file show error log for the above problem.

You should upload files to your server and post links to it. However for this particular issue, the project file would not help as we do not want to have any access to your database info. Big security risk there positing that data publicly. ;)
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 2796380 Photo


Registered User
94 posts

Have been playing with WFB off and on most of the day. I am with A2Hosting using c-panel & MySQL database. For your information if I go to your php file, form.cfg.php inside the folder WFB created and remove the (") around port 3306 [that I had to manually add] when submitting form data I get error access is denied to MySQL data base. "Problems connecting to MySQL: [1045] SQLSTATE[28000] [1045] Access denied for user 'ezorb1xxxxxx'@'localhost' (using password: YES)".
After I put the (") back around 3306 and it will work fine.
I called my ISP and they also said it was needed.

So to run another test. I deleted the database and recreated it. I gave the Table name: form-results (a new name) exported manual again and uploaded to server. Filed out form again and access denied. Went into you file above and added the (") and WFB works fine.
WFB in not adding the (") around 3306. It appears a slight bug need to be fixed.
Hope this helps.
Great software as usual.
Larry Penny
User 103173 Photo


VP of Software Development
0 posts

This morning I spent re-testing MySQL to see if I can replicate what you are describing and unfortunately I cannot. I configured three different servers using the same data, never adding quotes to the port and the submissions always went through. The strange part is I had the opposite issue as you. If I did add quotes around the port number, the form submission would fail to post.

For my testing, I used these three providers:
Godaddy
1&1
A Small Orange

To me, this appears to be a problem with A2Hosting. At least you know now how to make it work when using their hosting platform. I also have to say that if it works on Godaddy which always has issues, it should work anywhere. ;-)
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 2796380 Photo


Registered User
94 posts

@Scott
When you were testing did you only have WFB database on there server and server was not localhost? I am using localhost, website, database, everything is on localhost server instead of ip address. Maybe that is the difference.
You got that right on GoDaddy.
Question --- Since the data is stored how do your read it? Is that part of WFB? Haven't got that far yet?
Thanks
Larry Penny
User 103173 Photo


VP of Software Development
0 posts

EZorb wrote:
@Scott
When you were testing did you only have WFB database on there server and server was not localhost? I am using localhost, website, database, everything is on localhost server instead of ip address. Maybe that is the difference.
You got that right on GoDaddy.
Question --- Since the data is stored how do your read it? Is that part of WFB? Haven't got that far yet?
Thanks

I used localhost as the server name. To get data out, I used PHPMyAdmin which is installed through the Control Panel.
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 187934 Photo


Senior Advisor
20,181 posts

Reading data can be done with a simple php mysql selection script to loop through the rows in the table. Google pdo mysql select html table.
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

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.