Forums

When I hit the "Create Table" button, I get the message "You have an error in your SQL syntax; check the manual that coresponds to your MySQL server version for the right syntax to use near '`name` LONGTEXT NOT NULL,.. etc.'." MySQL version is 4.1.21. Rest of my Joomla site works fine.<br><br>Post edited by: karlos, at: 2007/04/13 17:46

Hi,

Do u have some items with the same name ? like checkboxes ? another user presented this before and its scheduled to be fixed at next version!!

Max

I am getting a similiar error, even when I only check one field to be added to the db. I had previously created the form and then added more fields. So, I deleted the form and table as suggested in another post and recreated the forms, but it will not create the table.

Sugsestions?

The error is:

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 ' `attendee_badge_name` LONGTEXT NOT NULL , PRIMARY KEY ( `cf_id` )) ENGINE = MYI' at line 1 SQL=CREATE TABLE `jos_chronoforms_3` (`cf_id` INT( 11 ) NOT NULL AUTO_INCREMENT , `recordtime` TEXT NOT NULL , , `attendee_badge_name` LONGTEXT NOT NULL , PRIMARY KEY ( `cf_id` )) ENGINE = MYISAM ;

Hi,

Which Chronoforms version are you using ?

Cheers

Max

V2.0

Hi,

I guess you have some problem inside your HTML code, however a more enhanced code has been made, Please replace the file at your server with the one attached after extraction and let me know if the problem still exists or not!!

P.S: the file is admin.chronocontact.php

Thanks

Max [file name=admin.gz size=3669]http://www.chronoengine.com/components/com_fireboard/uploaded/files/admin.gz[/file]

Post edited by: admin, at: 2007/06/15 14:57<br><br>Post edited by: admin, at: 2007/06/15 14:59

I tried replacing admin.chronocontact.php with the new file but it made no difference. This component is no good without creating its database. The problem is with chrono[list]forms[/list], anyway. i haven't even tried to use chronocontact yet.

Hi,

I agree with you but these problems happens rarely bcoz of some unregular servers configs or fault html code used at your side or special case, thousands of users never face any troubles!!🙂

anyway, lets try this : Can you please replace "ENGINE" with "TYPE" at file admin.chronocontact.php ? then let me know what happens

Cheers

Max