Chronoforms V4 DB Record Loader page Not Found

I am new with chronoforms trying my first DB Record Loader. MyConnectivity works fine and retrieves all records.

My Chronoforms with DB Record Loader fails. I am trying to get a single record from the Joomla sgj_users table. I have added a new field named "unit"

Here are my settings.

Chronoforms V4
SQL TABLE: sgj_users
id
name
username
email
unit (new field added by Brad)
password
block
sendmail
registerDate
lastvisitDate
activation
params
lastResetTime
resetCount

Chronoforms - form wizard
form name: loadoneuser
DB LOADER
DB Field: unit
Table: sgj_users
Request Param: unit
Model ID: Blank
Load Under Model ID: Blank

Advanced Tab:all blank

If I go back and add unit='E101' to the WHERE box, the correct record is retrieved and populates the form.

-----------------------------------------------------------------------------------------
I get this error when the WHERE is left balnk.

The requested page cannot be found.

An error has occurred while processing your request.

You may not be able to visit this page because of:
•an out-of-date bookmark/favourite
•a mistyped address
•a search engine that has an out-of-date listing for this site
•you have no access to this page

Go to the Home Page

! Home P

If difficulties persist, please contact the System Administrator of this site and report the error below.

0 SQL=SELECT * FROM `sgj_users` AS `SgjUsers` WHERE

age

--------------------------------------------------------------------------------

Hi Brad,

How are you passing the unit value to the form with the loader? Usually you'd add &unit=101 to the calling URL. Does that work?

Bob

I am using the newly added field named UNIT. That is I have defined these in the Chronoform. This is now included in the SQL table sgj_users. The unit numbers are unique.

I have not added a hidden field to the form at this point.

If I make an entry to the WHERE, unit="E101", the form opens and populates the record and info. Without a WHERE, the form opens blank.

Will the loader work when there is no cf_uid? My standard Joolma table (sgj_users) has a new field named unit. The UNIT field is unique. Unit is loaded during the application installation. When users register, they enter their UNIT number.

If I login, can I extract (for editing) from the sgj_users when the login UNIT matches the sgj_users UNIT?

Likewise, can I extract from the sgj_address_book table when the login UNIT matches the login UNIT?

The address_book table is a Chronoforms table with a cf_uid field etc.. However, if I correctly understand how that is created, it will never match the cf_uid.

The reason is all of the condo addresses are created and added when the application is installed. After the installation, condo owners (sgj_users) will be able to login and edit thier own condo information (in the address book) like emails, phones, etc.

Thanks for any response

Hi Brad,

Trying again: How are you passing the unit value to the form with the loader? Usually you'd add &unit=101 to the calling URL. Does that work?

Bob

I am not a programmer and I am following the tutorial and have done a lot of trial and error things.

I am trying to fill in only those fields described in the tutorial. Per tutorial, if the token field is left blank, the test form should return a form with no data. I get a blank page.

When I use "unit" instead cf_uid and "unit" instead of token, I get a page not found and the error message has nothing for the WHERE

I do get results if I hard-code the WHERE like unit='E101' or id=277 so I know I am connected but doing something wrong with filling in the boxes.

Thanks for your patience with such clumsy newbie.

Brad

Hi,

If this is J3 then please download the new V4.0.1 for J3 and install it OVER yours, it should fix this issue.

Regards,
Max

Thanks for hanging in there with me. I understand how trying it can be when working with newbies.
I installed 4.0.1 over my existing Chronoforms on Joomla 3

Nothing changed.

I created a fresh new Chronoform named dbrecordloader and populated as few fields as possible - per tutorial. Per tutorial, this looks like it should be very simple. I notice the tutorial has a "Load Fields" that differs from the live application.

The results remain a form with no data.

I tried using the "id" field and I tried using the "unit" field.
The reults remain a form with no data.

Is there a correct syntax that will make this work?
It works if I enter unit='E101' in the WHERE In other words, what syntax can I use to replace 'E101' or in the case of id='277' replace the '277'

I am still unable to get this simple dbrecordloader to work.

Joomla 3 with Chronoforms 4.0.1

DB Recordloader > configure > basic

DB Field = id
Table = sgj_users
Request Param = id
Model ID = blank
Load Under Model ID = no

Log into applcation with user who has id 276 in sgj_users

I have a menu item to launch Chronoforms form named dbrecordloader

This opens a the form with all blanks (from menu or "test Form").

If I reconfigure the db loader and change the WHERE to id="276" and then launch from the menu or test form, the forms opens with the correct data.

I am not a PHP programmer but it seems like that paramenter is unknow when the form opens.

What am I doing wrong?

RESOLVED: I was not able to the seemly simple record loader to work per the tutorial.

However, I was able to get it to work by adding custom code prior to the db record loader.

Here is the code:

<?php
$user =& JFactory::getUser();
$form->data['id'] = $user->id;
?>