I have no problem just using this witht he file data structure for those with out access to MYSQL, but I am having problems setting it up to use MySQL and inserting the form data into a MYSQL table. I get the following error on step 5:
Step 5: generation status v2.0 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 creating table 'a' ...
Could not create MySQL database table. Maybe a table of the same name already exists?
I log into my ISP's MYSQL admin page and it tells me that there are no tables in the database. I don't know SQL so maybe there is something I ammissing here...
I changed the permission settings for everythign in the forms folder to read & write as instructed and even gave everything execute permission as well to see if that resolved the problem.
Can anyone give me any suggestions to resolve this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are you making sure all the DB info you entered is correct? Also, when choosing names for table columns, please make sure you don't have spaces in these names. Also, some of the names are "reserved words" in SQL. So if you 'think' that some column name you chose might be a reserved word in SQL, try adding a prefix to it like: a_delete (delete being a SQL word). In future versions, i'm adding some extensive error checking so this wouldn't be a problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Actually, it appears that it might have something to do with using a Mac. I tried the exact same set-up on my PC and it worked fine! Strange.
Anyway, I can't seem to get any results from the admin page, when using mySQL. Works fine for the data file, but when I use mySQL i get nothing. Any thoughts?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
yea.. about that, the MySQL code is commented out in the admin page :P I was testing out the filebased DB feature, and I commented out the MySQL code. See if you can locate the /* and */ in index.php in the admin directory, and remove them. That'll activate your MySQL admin feature
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
re:"table of same name",I was getting the same message and no tables created until I entered the new table name as one word, ie:customerid vs.customer id....then she worked beautifully!!!great script...is there any way to limit file types.ie:to jpg,gif etc?I've done searches on google,etc for how to filter MIME types, but not sure how to modify process.php script, ...thanks for any help,and for the script!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have no problem just using this witht he file data structure for those with out access to MYSQL, but I am having problems setting it up to use MySQL and inserting the form data into a MYSQL table. I get the following error on step 5:
Step 5: generation status v2.0 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 creating table 'a' ...
Could not create MySQL database table. Maybe a table of the same name already exists?
I log into my ISP's MYSQL admin page and it tells me that there are no tables in the database. I don't know SQL so maybe there is something I ammissing here...
I changed the permission settings for everythign in the forms folder to read & write as instructed and even gave everything execute permission as well to see if that resolved the problem.
Can anyone give me any suggestions to resolve this?
I'm having the exact same issue...
Latest version of phpformgenerator
php4.x
Apache 1.2.7x
FreeBSD 4.6
Are you making sure all the DB info you entered is correct? Also, when choosing names for table columns, please make sure you don't have spaces in these names. Also, some of the names are "reserved words" in SQL. So if you 'think' that some column name you chose might be a reserved word in SQL, try adding a prefix to it like: a_delete (delete being a SQL word). In future versions, i'm adding some extensive error checking so this wouldn't be a problem.
Actually, it appears that it might have something to do with using a Mac. I tried the exact same set-up on my PC and it worked fine! Strange.
Anyway, I can't seem to get any results from the admin page, when using mySQL. Works fine for the data file, but when I use mySQL i get nothing. Any thoughts?
yea.. about that, the MySQL code is commented out in the admin page :P I was testing out the filebased DB feature, and I commented out the MySQL code. See if you can locate the /* and */ in index.php in the admin directory, and remove them. That'll activate your MySQL admin feature
re:"table of same name",I was getting the same message and no tables created until I entered the new table name as one word, ie:customerid vs.customer id....then she worked beautifully!!!great script...is there any way to limit file types.ie:to jpg,gif etc?I've done searches on google,etc for how to filter MIME types, but not sure how to modify process.php script, ...thanks for any help,and for the script!