Forums

nI designed a simple contact form,when i test it, it has a problem like this. Who can tell me What this is happen.
How I can solve it.

I used ChronoForms 3.1, php 4.7 , linux ,joomla 1.5.10

Warning: implode() [function.implode]: Bad arguments.
/libraries/joomla/database/database/mysql.php on line 540

Hi rickyaung,

where do you see this error exactly ? when you try to open the form ?

Max

When I have filled the information in the form, I clicked the " send" button, and then the error had displayed. I checked the backend of the chronoform, I can't only the record ,but without correctly message.

So, Does anyone know how I can solved it.

Hi rickyaung,

Please post your Form HTML here - this looks like it may be caused by an invalid field name.

Bob

Hello i have this problem saving data in db:

I created a form with some fields and i create a table db with the wizard. I also connected the form with the table

Now when i submit the form, my custom fields does'nt appear in the db.

Also, i have error in exel and cvs.

Some helps?

thanks in advantage

Hi ingdade,

please show me your form code!

Regards
Max

hello Max,
thanks for your replay.

this is may form code

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label"><b>E-mail</b></label>
    <input class="cf_inputbox required validate-email" maxlength="150" size="30" id="text_0" name="text_0" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png"/></a>
				<div class="tooltipdiv">E-mail :: Presta  attenzione all'inserimento del tuo indirizzo email corretto</div>
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label">Azienda</label>
    <input class="cf_inputbox" maxlength="150" size="30" id="text_1" name="text_1" type="text" />
  
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label"><b>Referente</b></label>
    <input class="cf_inputbox required " maxlength="150" size="30" id="text_2" name="text_2" type="text" />
  
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label">Indirizzo</label>
    <input class="cf_inputbox" maxlength="150" size="30" id="text_3" name="text_3" type="text" />
  
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label">Località</label>
    <input class="cf_inputbox" maxlength="150" size="30" id="text_4" name="text_4" type="text" />
  
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label">Provincia</label>
    <input class="cf_inputbox" maxlength="150" size="30" id="text_5" name="text_5" type="text" />
  
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label"><b>Telefono</b></label>
    <input class="cf_inputbox required validate-number" maxlength="150" size="30" id="text_6" name="text_6" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png"/></a>
				<div class="tooltipdiv">Telefono :: Per contattarvi nel caso l'indirizzo email risultasse errato</div>
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label">Cellulare</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" id="text_7" name="text_7" type="text" />
  
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label">Note</label>
    <textarea class="cf_inputbox" rows="3" id="text_9" cols="30" name="text_9"></textarea>
    
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Autorizzo al trattamento dei dati personali secondo il Disposto di Legge 196/2003 per essere contattato e ricevere le informazioni da me richieste.</span> </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_checkbox">
    <label class="cf_label" style="display: none;">privacy</label>
    <div class="float_left">
      <input value="Accetto" class="radio validate-one-required" id="check00" name="check0[]" type="checkbox" />
      <label for="check00" class="check_label">Accetto</label>
      <br />
      

    </div>
    
  </div>
  <div class="clear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Invia" type="submit" />
  </div>
  <div class="clear"> </div>
</div>

and this is tha table createdby the wizard

CREATE TABLE IF NOT EXISTS `jos_chronoforms_SitoFacile` (
`cf_id` int(11) NOT NULL auto_increment,
`uid` varchar(255) NOT NULL default '',
`recordtime` text NOT NULL,
`ipaddress` text NOT NULL,
`cf_user_id` text NOT NULL,
`text_0` varchar(255) NOT NULL default '',
`text_1` varchar(255) NOT NULL default '',
`text_2` varchar(255) NOT NULL default '',
`text_3` varchar(255) NOT NULL default '',
`text_4` varchar(255) NOT NULL default '',
`text_5` varchar(255) NOT NULL default '',
`text_6` varchar(255) NOT NULL default '',
`text_7` varchar(255) NOT NULL default '',
`check0` varchar(255) NOT NULL default '',
`text_9` varchar(255) NOT NULL default '',
PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dump dei dati per la tabella `jos_chronoforms_SitoFacile`
--

INSERT INTO `jos_chronoforms_SitoFacile` (`cf_id`, `uid`, `recordtime`, `ipaddress`, `cf_user_id`, `text_0`, `text_1`, `text_2`, `text_3`, `text_4`, `text_5`, `text_6`, `text_7`, `check0`, `text_9`) VALUES
(1, 'IZTJhNWY5ZDA3NjU2', '2009-04-01 - 22:53:29', '87.10.63.47', '0', '', '', '', '', '', '', '', '', '', '');

Hi ingdade,

I tried your form code in the new RC4 and was able to create a table and save to it successfully!

Regards,
Max

Here is my cod.
When i submit the form. it has record like these.
[attachment=0]2009-04-10_165436.png[/attachment]

Here is my html.

<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item0>
<DIV class="form_element cf_heading">
<H1 class=cf_text>聯 絡 我 們</H1></DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item1>
<DIV class="form_element cf_textbox"><LABEL class=cf_label>姓 名</LABEL> <INPUT style="BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px" id=text_1 class="cf_inputbox required" maxLength=50 name=text_name> </DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item2>
<DIV class="form_element cf_textbox"><LABEL class=cf_label>學 系</LABEL> <INPUT style="BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px" id=text_2 class="cf_inputbox required" maxLength=50 size=30 name=text_major> </DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item3>
<DIV class="form_element cf_textbox"><LABEL class=cf_label>電 子 郵 件</LABEL> <INPUT style="BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px" id=text_3 class="cf_inputbox validate-email" maxLength=50 size=30 name=text_email> </DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item4>
<DIV class="form_element cf_textbox"><LABEL class=cf_label>主 旨</LABEL> <INPUT style="BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px" id=text_4 class="cf_inputbox required" maxLength=50 size=30 name=text_title> </DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item5>
<DIV class="form_element cf_textarea"><LABEL class=cf_label>內 容</LABEL> <TEXTAREA id=text_5 class="cf_inputbox required" rows=6 cols=30 name=text_content></TEXTAREA> </DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item6>
<DIV class="form_element cf_captcha"><LABEL class=cf_label>驗 證 碼</LABEL> <SPAN>{imageverification}</SPAN> </DIV>
<DIV class=clear></DIV></DIV>
<DIV style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BACKGROUND-COLOR: rgb(255,255,255); BORDER-TOP: 0px; BORDER-RIGHT: 0px" class=form_item title=form_item7>
<DIV class="form_element cf_button"><INPUT style="BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px" value="送 出" type=button><INPUT style="BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px" value=Reset type=reset> </DIV>
<DIV class=clear></DIV></DIV>

Here is the chronoform record code

[type="cf_heading"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLclass = cf_textCHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLtag = h1CHRONO_CONSTANT_EOLlabelwidth = 0CHRONO_CONSTANT_EOLlabeltext = 聯 絡 我 們CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_textbox"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_1CHRONO_CONSTANT_EOLname = text_nameCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 20CHRONO_CONSTANT_EOLmaxlength = 50CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = 姓 名CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_textbox"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_2CHRONO_CONSTANT_EOLname = text_majorCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 50CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = 學 系CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_textbox"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_3CHRONO_CONSTANT_EOLname = text_emailCHRONO_CONSTANT_EOLclass = cf_inputbox validate-emailCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 50CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = 電 子 郵 件CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_textbox"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_4CHRONO_CONSTANT_EOLname = text_titleCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 50CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = 主 旨CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_textarea"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_5CHRONO_CONSTANT_EOLname = text_contentCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLrows = 6CHRONO_CONSTANT_EOLcols = 30CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = 內 容CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_captcha"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = 驗 證 碼CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type="cf_button"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLvalue = 送 出CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLreset = 1CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 0CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL 

Hi ricky,

your form was created using an early version in IE and the code is not very good, please try to upgrade to RC4.11 and recreate the form quickly or create a test form first and see if it works ? we fix problems regularly!

please take a backup of your form before installing the new version!

Cheers
Max

I am using 3.1 RC5.1 but I canot save data to Exel from my web page. But if I am trying this in local, it is ok.

Hi hudak,

this may be a server config issue or form problem or table problem, try to search the forums for previous posts, its hard to diagnose the excel library issues, I suggest you go with CSV if it doesn't work on particular server!

Regards
Max