Fatal error: Call to a member function bind() on a non-objec

I am using Chronoforms 3.1 RC5.5 and Chronoconnectivity V2_RC3 with Joomla 1.5.14

I setup two forms with Chronoforms that are working fine.

My second form allows users to register certain items for a fee. I want to be able to allow users to edit what they register. So I installed Chronoconnectivity for this. I got it working and it brings up the items pertaining to the user who is logged in. This all works fine. It does bring up some undefined variable errors when joomla error is set to maximum, but this hasn't seemed to keep it from working.

Now the next part I may be doing completely wrong, and I will try to explain as best as I can. I use Chronoconnectivity to show the results from the table1 that I want to edit. But when I save the edited item, I have it save to a different table2. Basically the user is editing whether the item was lost or stolen. My first table1 does not contain fields named lost or stolen. I am saving it to a new table2 because when they register the item they enter a serial number and the table1 cannot contain a matching serial. So I have some code that checks to make sure the serial is unique. When I tried editing the records from that table1 it always gave me the message saying that this serial number was already in use. I couldn't figure out how to just update the record, so i just tried saving the data to a new table2 which would contain the new fields lost and stolen.

All that to say, when I click on the Submit button, it doesn't save the record and it takes me to a page that shows me my form data in an email and an error on the bottom that says,

Fatal error: Call to a member function bind() on a non-object in TEST/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

I have looked extensively throughout the forums to find an answer. I have checked and rechecked to make sure my field names are not containing extra or wrong symbols.

Thanks in advance for any help.

Joel

Hi Joel,

This all sounds a bit complicated.

First off, you don't need ChronoConnectivity to show a single result. I'd just do it with a ChronoForms, perhaps using the Profile plugin to get the data for the current user.

Second, I don't think that you need two tables, just add the extra columns to table 1 and make your life much easier.

Without seeing the code I have no idea why your serial numbers don't savve correctly, perhaps your checking code is writing a record?

Bob

I am pretty sure I am making it more difficult than it needs to be.

I was using Chronoconnectivity because one user may have several items that he/she has registered.

The way I have it setup is that when someone logs in they can enter a new entry to register or they can edit an entry. I have entered several test items, so when I log in and click on Edit Entry is shows several rows of items with an "Edit Record" link. Then I click on the test item I want to edit and it brings up that item in a form and populates the form. Then I edit whatever, possibly checking whether it has been lost or stolen. Then once I click Save from there is when I get the error message.

I was making it harder than I needed too. I ended up making two forms that save to the same table. The first form is used when they make a new entry and has the code that makes sure the serial number is unique. The second form is used when they want to edit the info and doesn't check to see if the serial is unique.

I still may not be doing it the best way, but at least for now it is working.

Hi Joel,

Sounds good to me.

Bob