SOLVED: Error while creating table :ENGINE = MYISAM' at line

Hi,

Trying to create a table for a form:

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_Prospects` () ENGINE = MYISAM ;

I don't know what this means other than my mySQL version may be incompatible with the syntax?

Any suggestions?

Best,

wolfix

Hi wolfix,

Please see this thread and Max's post in particular.

Bob

Thanks Bob,

I tried it again, this time without recordtime and it worked without errors...

I have connected the new table to the form but the only data I'm getting is blank 'recordtime' and 'ipaddress' after testing the form.

I have read through the 'Saving Data to the Database PDF' several times and run several test...

Any suggestions?

Best,

Gene

Update:

Even after reading about colors throwing people off in the recommend link above, when creating a table I was really thrown-off by the red and green cell background! So I figured out it was the background colors, green and red that mean Show and Hide.

so I got it working now... important to use the Green background for what you want in the table, and important to include the cf_id as one of the fields with a green background.

Best,

Gene