I was installing v. 2.09 today. Everything was going fine until I got to step 4. (database/ email info)
When I choose yes pertaining to the option to "insert data to MySQL data table." I then put my host name, username, password, and the database name into the required fields.
When I submitted this information the following response occurred in step 5:
"thats it! now we're ready to generate your form. if you encounter any errors, please make sure that you provided the correct database information (if any), and please maintain that everything is case sensitive. also remember to give read+write permissions to the forms directory (located under the phpformgen directory). thank you.
Now verifying MySQL database access information (some test data will be entered into the database table)...
Could not access MySQL database with information provided."
I looked at the database to verify all the info was correct but nothing still happened. Could someone please help me
Thanks,
Lesli
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It's hard to tell because the program works for so many other people without error. Can you use the generator anyway? Try it by accessing the generator folder with your browser. The gui for starting your first form should appear.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
the generator seems to work fine. its when I attempt to put in the info for the Mysql that I have the problem. I installed it and tried without using the db connections and worked fine.
What file would be responsible for connecting the db to the generator?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
While generating a form the last step uses a file called process3.php to finalize the gernation of the form. The lines below are responsible for the error message you receive. THese are simple mysql commands that work under normal circumstances. I suspect that maybe you are not providing the right information or there are other requirements for you sql db access.
You can try manually creating at least the top level db name before generating your form.
You should also check the following file:
config.inc.php
It is used to hold the db access info you have supplied when creating a form that uses sql. See if the variables below appear in the file.
$link = mysql_connect($dbhostname,$dbuser,$dbpass) or die("<br /><br />Could not establish connection to MySQL database with the information provided.");
mysql_select_db($dbname,$link) or die ("<br /><br />Could not access MySQL database with information provided.");
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This variable does appear in the process3.php file. I also spoke with my Host Admin who stated it's a configuration issue on my side. My guess is it's in my logon to my sql db.
How can I manually create a top level db name? Also is there any way to manually go into the files to establish a connection.
When I go to the config.inc.php file it has the following text:
<?php
$file_db=1
Your help is greatly appreaciated
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
A file_db variable indicates you specified a file based db instead of sql. Maybe you specified both and this can work but you will have to manage the two yourself. Otherwise generate the form again and only chose one or the other not both.
You can manually see your sql db using something like phpmyadmin. This is usually a tool made available by your host.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Variables in the config file are automatically set by the generator. Don't try manually modifying this file unless you understand php, sql, and the form generator code.
If you manually create a table byt the name "test" then during form generation if you define the table name as "test" then the last step of the form generation does not have to create the table test and it may help. Since I am not sure what your problem is it's hard for me to guess what might be going on.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Everything seems to work fine. I have been looking at all of the files extensively for the past four days so I know where everything is. I was looking at the process3.php where it gets into the database section.
Do you have any suggestions about how I can manipulate the code to work with the db I set up for the generator? I'm pretty comfortable with all the coding. I know its a small config issue because my host provider looked at it and said he could fix it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't know what to tell you since the generator works for 99.99% percent of the people using it including me. The generator takes the data that you provide and creates new databases with tables and fields that you also define when using the generator.
This can fail in only 2 ways.
1.) You provide the wrong information.
2.) Your sql db requires something that is not accounted for in the code.
If you follow the step by step proceedure for generating a form the generator should not have any problems unless you are running across case number 2.
If your provider looked at it and said that he can fix it, why didn't he either fix it or tell you what to do to fix it???
To have the generator use a db you manually setup you just need to provide the right db name, username, and password when running the generator.
If can not do much else without looking at how it runs on your host.
It should work for you as it does for literally hundreds, if not thousands, of other users.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are already paying him!
I can help but I would either need lots more detail or access to your site.
You can try this:
Create a simple db using phpmyadmin
firstname
lastname
email
Make note of the
username
password
dbname
Use these variables when you create a matching form with these 3 fields and see if you get past the issues you are having.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Send me an email through sourceforge with a link to the generator. We can communicate further once we establish the email outside this forum. Once we finish I would only ask that you post your experience back in the forum for others to benifit from whatever work we do.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello
I was installing v. 2.09 today. Everything was going fine until I got to step 4. (database/ email info)
When I choose yes pertaining to the option to "insert data to MySQL data table." I then put my host name, username, password, and the database name into the required fields.
When I submitted this information the following response occurred in step 5:
"thats it! now we're ready to generate your form. if you encounter any errors, please make sure that you provided the correct database information (if any), and please maintain that everything is case sensitive. also remember to give read+write permissions to the forms directory (located under the phpformgen directory). thank you.
Now verifying MySQL database access information (some test data will be entered into the database table)...
Could not access MySQL database with information provided."
I looked at the database to verify all the info was correct but nothing still happened. Could someone please help me
Thanks,
Lesli
It's hard to tell because the program works for so many other people without error. Can you use the generator anyway? Try it by accessing the generator folder with your browser. The gui for starting your first form should appear.
the generator seems to work fine. its when I attempt to put in the info for the Mysql that I have the problem. I installed it and tried without using the db connections and worked fine.
What file would be responsible for connecting the db to the generator?
While generating a form the last step uses a file called process3.php to finalize the gernation of the form. The lines below are responsible for the error message you receive. THese are simple mysql commands that work under normal circumstances. I suspect that maybe you are not providing the right information or there are other requirements for you sql db access.
You can try manually creating at least the top level db name before generating your form.
You should also check the following file:
config.inc.php
It is used to hold the db access info you have supplied when creating a form that uses sql. See if the variables below appear in the file.
$link = mysql_connect($dbhostname,$dbuser,$dbpass) or die("<br /><br />Could not establish connection to MySQL database with the information provided.");
mysql_select_db($dbname,$link) or die ("<br /><br />Could not access MySQL database with information provided.");
This variable does appear in the process3.php file. I also spoke with my Host Admin who stated it's a configuration issue on my side. My guess is it's in my logon to my sql db.
How can I manually create a top level db name? Also is there any way to manually go into the files to establish a connection.
When I go to the config.inc.php file it has the following text:
<?php
$file_db=1
Your help is greatly appreaciated
A file_db variable indicates you specified a file based db instead of sql. Maybe you specified both and this can work but you will have to manage the two yourself. Otherwise generate the form again and only chose one or the other not both.
You can manually see your sql db using something like phpmyadmin. This is usually a tool made available by your host.
So would I add something like
$mysql_db=1 to the config.inc.php file?
Also, if I manually set this in phpmyadmin, how will the form gen detect this db?
Variables in the config file are automatically set by the generator. Don't try manually modifying this file unless you understand php, sql, and the form generator code.
If you manually create a table byt the name "test" then during form generation if you define the table name as "test" then the last step of the form generation does not have to create the table test and it may help. Since I am not sure what your problem is it's hard for me to guess what might be going on.
Everything seems to work fine. I have been looking at all of the files extensively for the past four days so I know where everything is. I was looking at the process3.php where it gets into the database section.
Do you have any suggestions about how I can manipulate the code to work with the db I set up for the generator? I'm pretty comfortable with all the coding. I know its a small config issue because my host provider looked at it and said he could fix it.
I don't know what to tell you since the generator works for 99.99% percent of the people using it including me. The generator takes the data that you provide and creates new databases with tables and fields that you also define when using the generator.
This can fail in only 2 ways.
1.) You provide the wrong information.
2.) Your sql db requires something that is not accounted for in the code.
If you follow the step by step proceedure for generating a form the generator should not have any problems unless you are running across case number 2.
If your provider looked at it and said that he can fix it, why didn't he either fix it or tell you what to do to fix it???
To have the generator use a db you manually setup you just need to provide the right db name, username, and password when running the generator.
If can not do much else without looking at how it runs on your host.
It should work for you as it does for literally hundreds, if not thousands, of other users.
He wants to charge me. I believe the software works perfectly fine. Its on my side.
Thanks for your time
Lesli
You are already paying him!
I can help but I would either need lots more detail or access to your site.
You can try this:
Create a simple db using phpmyadmin
firstname
lastname
email
Make note of the
username
password
dbname
Use these variables when you create a matching form with these 3 fields and see if you get past the issues you are having.
No,
He wants me to pay him. Software support is not part of my server package. Besides, where's the fun in that? I want to figure out the whys.
I will try this here and see if this solves the problem. Thank you so much for your help.
Its not working and I know its something I'm doing.
What info do you need for my site?
I appreciate your help
Send me an email through sourceforge with a link to the generator. We can communicate further once we establish the email outside this forum. Once we finish I would only ask that you post your experience back in the forum for others to benifit from whatever work we do.
Sounds good.
I really appreciate the help and will gladly comment on such a helpful and insightful experience I have had on forum.
Do you want me to send you my database information too?
Thanks so much for all of your help. It works and I learned so much.
I will look carefully at your test db to fully understand it.
~All the Best