Ok, I have read the other forums on this issue, but I am still coming to a halt.
I am tying to create a new table in a already created DB to no avail. I am getting the following error -- 'Could not create MySQL database table. Maybe a table of the same name already exists?'
The table does not exist and and all of my login information is correct.
I have even tried creating the DB and having just insert information into it, but I get this error -- 'Database table does not exist, or columns entered are invalid.'
I have checked my colums and they are correct.
You help is greatly appreciated.
Thanks,
eshriner
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Not there is a difference between a database and a table. You must have the database created. Then you have an option of either letting the program create the table for you, or you can precreate one yourself and just provide it with the table name and columns for it to fill.
The error you are getting is due to 3 things. 1) Check your login info. 2) Make sure there is no table created by the same name! You would think that it is not, but it might be! If your form generation process fails at some other point, it may create the table anyway! and therefore on the next try, the table already exists. So make sure the table you are trying to create does not already exist. 3) Lastly, check your column names. The names should not contain any special characters or spaces. They should be one word names. This is very important because the database does not accept anything else.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I had this problem and all my information was correct. However I changed the column names from the default ones that it had entered automatically and it worked.... its like the column names cant be the same as the original forms names you entered in previous steps... or they are 2 long.
Who knows! it worked for me.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-09-18
Wow! I'm glad this solution was posted. This same issue was driving me nuts!
Sure enough I followed Melanie's instructions, changed my field names, and Voila! It works perfectly.
Does anyone have any idea what I should be looking for, in order to avoid this in the future?
Other than this one glitch, the script works perfectly.
Thanks Ali!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, I have read the other forums on this issue, but I am still coming to a halt.
I am tying to create a new table in a already created DB to no avail. I am getting the following error -- 'Could not create MySQL database table. Maybe a table of the same name already exists?'
The table does not exist and and all of my login information is correct.
I have even tried creating the DB and having just insert information into it, but I get this error -- 'Database table does not exist, or columns entered are invalid.'
I have checked my colums and they are correct.
You help is greatly appreciated.
Thanks,
eshriner
Not there is a difference between a database and a table. You must have the database created. Then you have an option of either letting the program create the table for you, or you can precreate one yourself and just provide it with the table name and columns for it to fill.
The error you are getting is due to 3 things. 1) Check your login info. 2) Make sure there is no table created by the same name! You would think that it is not, but it might be! If your form generation process fails at some other point, it may create the table anyway! and therefore on the next try, the table already exists. So make sure the table you are trying to create does not already exist. 3) Lastly, check your column names. The names should not contain any special characters or spaces. They should be one word names. This is very important because the database does not accept anything else.
I had this problem and all my information was correct. However I changed the column names from the default ones that it had entered automatically and it worked.... its like the column names cant be the same as the original forms names you entered in previous steps... or they are 2 long.
Who knows! it worked for me.
Wow! I'm glad this solution was posted. This same issue was driving me nuts!
Sure enough I followed Melanie's instructions, changed my field names, and Voila! It works perfectly.
Does anyone have any idea what I should be looking for, in order to avoid this in the future?
Other than this one glitch, the script works perfectly.
Thanks Ali!