Forums

error while creating database table

alias2211 08 Jan, 2010
Good morning!

I was able to install the chronoforms component and get my first form up and running great! I really like this component a lot, I can tell a lot of time and thought has gone into it to get it working great.

After I tested my form and confirmed that everything was configured correctly, I wanted to also connect the form to a database table for tracking/backups. So, I found the documentation PDF for "5 Saving Data to the database.pdf"
from this URL:

http://www.chronoengine.com/tutorials.html

I follow the steps, but when I go to save the table, the admin panel shows the following error:

Error while creating table :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_ContactUs` () ENGINE = MYISAM ;


I looked at our DB and can confirm that the table was not created. Do you have any suggestions for how I should proceed?

Thank you!
Alias
alias2211 08 Jan, 2010
Hello-

Another round of searching your forums and I was able to find this helpful post:

http://chronoengine.com/forums.html?cont=posts&f=3&t=15627&start=0

From it, I learned that the convention of enable/disable that I'm used to in Joomla is a little backwards here. So once I tried again - this time enabling all the fields - it worked successfully. I guess the error was a result of me trying to define a table w/ no fields.
GreyHead 08 Jan, 2010
Hi Alias,

Well found - that's exactly the problem :-(

Bob
This topic is locked and no more replies can be posted.