Bind Failed

Here is the debugger output from a data save

Array
(
[listed] => test
[dispatched] => test
[picked] => test
[delivered] => test
[cancelled] => test
[expired] => test
[order-number] => test
[origin] => test
[destination] => test
[vehicles] => test
[carrier_payment] => test
[estimated-ship-on] => test
[assign] => test
[input_submit_14] => Submit
[8bf1463eedf7628fad14a93794384ee3] => 1
[chronoform] => shippers
[event] => submit
[option] => com_chronoforms
[Itemid] =>
)

Debug Data

Tabledoug4r_shippers: :bind failed. Invalid source argument.

What does this mean?

Hi Doug,

You have a dash '-' in a couple of your input names (and in another post I think I saw then in the form name too). Dashes give ChronoForms and MySQL problems. Please rename the input using only [a-z], [A-Z], [0-9] or underscore '_'. No dashes, spaces or other special characters.

Bob

I only had one in this script, "company-name" which I have changed to "company_name". But, I received the same "Bind Failed" message.

Hi Doug,

In the debug data I see 'order-number' and 'estimated-ship-on' as well.

Bob

Fixed.

But still bind failed.

It appears the problem only apprears with Joomla 2.5. With Joomla 1.7.3, the database save works fine.

Doug

The update to R11 fixed it. Thanks. Here is the debugger output under 2.5.

[profession] => No
[phone] => saass
[input_submit_1] => Submit
[60e107e9b9347cdab037637e9a781c07] => 1
[option] => com_chronoforms
[chronoform] => load_one_row-from_a_db_table
[event] => submit
[Itemid] =>
[chronoform_data] => Array
(
[cf_uid] => 8f43b43fb49669bc32c81f340afcddfc
[cf_created] => 2012-01-31 15:53:49
[cf_ipaddress] => 96.25.176.37
[cf_user_id] => 0
[profession] => No
[phone] => saass
[input_submit_1] => Submit
[60e107e9b9347cdab037637e9a781c07] => 1
[option] => com_chronoforms
[chronoform] => load_one_row-from_a_db_table
[event] => submit
[Itemid] =>
[cf_id] => 5
)

[chronoform_data_cf_id] => 5

Hi Doug,

Please upgrade to V4RC3.11 and let us know.

Regards,
Max

Hi Doug,

In the example you posted in your email the dashes have crept back into the input names :-( Or perhaps you never removed them.

Bob

I have the same problem as Doug. The error message after I clicked the submit button is "Warning: array_merge() [function.array-merge]: Argument #2 is not an array in ..../public_html/sch/administrator/components/com_chronoforms/form_actions/db_save/db_save.php on line 85".

Not really sure where I made mistake and for the record, I don't have any dashes (-). All my id's and names are in underscore (_). Please help.

Please note that I changed the path for security.

And in the debug Error below:

Errors

Tablechronoforms_data_principalform: :bind failed. Invalid source argument.
Information

Backtrace
Call stack
# Function Location
1 JSite->dispatch() ..../public_html/sch/index.php:43
2 JComponentHelper::renderComponent() ..../public_html/sch/includes/application.php:191
3 require_once() ..../public_html/sch/libraries/joomla/application/component/helper.php:156
4 process() ..../public_html/sch/components/com_chronoforms/chronoforms.php:49
5 CFChronoForm->process() ..../public_html/sch/components/com_chronoforms/chronoforms.php:60
6 CFChronoForm->_processEvents() ..../public_html/sch/components/com_chronoforms/libraries/chronoform.php:175
7 CFChronoForm->_processAction() ..../public_html/sch/components/com_chronoforms/libraries/chronoform.php:200
8 CFChronoForm->runAction() /home/auworg5/..../public_html/sch/components/com_chronoforms/libraries/chronoform.php:225
9 CfactionDbSave->run() ..../public_html/sch/components/com_chronoforms/libraries/chronoform.php:249
10 JTable->bind() ..../public_html/sch/administrator/components/com_chronoforms/form_actions/db_save/db_save.php:87

Max has an update to V4 that fixes this. Download it and install it and your problem will disappear.

Hahaha I maybe just so stressed that I don't know how I missed that but thank you doug4r. Found the link and installed it. It worked great! Thanks a lot!!