Forums

error in creating tables

webpro 24 Dec, 2008
Hi!,

I am facing problem while creating the table after the forms creation, forms are sending emails and otherwise working except 2 things
1) when we try to create tables it gives following error
after clicking on create tables button following screen appears
http://www.ezwebpromotion.com/screens/scr1.jpg

and when we click on create coloumns all rows are checked and following screen appears
http://www.ezwebpromotion.com/screens/scr2.jpg

and when i click save tables following error occurs:
Error while creating table :Incorrect column name '' SQL=CREATE TABLE `jos_chronoforms_Call_Me` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` TEXT NOT NULL, `ipaddress` TEXT NOT NULL, `cf_user_id` TEXT NOT NULL, `link` VARCHAR(255) NOT NULL, `name` VARCHAR(255) NOT NULL, `Email` VARCHAR(255) NOT NULL, `Phone` VARCHAR(255) NOT NULL, `newsl` VARCHAR(255) NOT NULL, `` VARCHAR(255) NOT NULL, `Subject` VARCHAR(255) NOT NULL, `message` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
There is no table in the database with the name which are trying to create one

Can the Moderators help me in resolving this issue.
Also how i can make the person who submits the form recieve an Autoresponder email which is in my template
Thanks
Max_admin 24 Dec, 2008
Hi webpro,

in your form HTML, you have a field without name or with name="" which is wrong, fix this and retry creating the table, or just don't check the row with "column name" empty!

use the Dynamic TO field to send the email to the user who submit the form, add the field name which will hold the user's email on submit!

Regards
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webpro 24 Dec, 2008
Hi Max,

Thanks a lot, it has worked well i am able to create table,actually blank table was i think image verification code which was showing in the code, this is the old code which we were using in the older format of the chornoforms, we are currently migrating into new joomla version from 1.0.15

Best Regards
Webpro
webpro 24 Dec, 2008
Hi Max,

Can you guide me how in dynamic To field i have to write the field name should it be in quotes or brackets or simply write email,


Regards
Webpro
GreyHead 24 Dec, 2008
Hi webpro,

Simply write the field-name - no quotes and no brackets.

Bob
webpro 24 Dec, 2008
Thanks Bob & Max,

my forms are working now.

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