Forums

Hi Everybody,

Connectivity 2 is out, its more tidy in the core and in the admin area layout, its Chronoforms dependent from now on too, you must have Chronoforms V3.1 RC5.1 or later installed or the new version will not work and may report errors too!

Cheers,
Max

You have a problem with the xml install file.
the field "OnSaveJSCode" is missing in the query.

<install>
<queries>
<query>CREATE TABLE IF NOT EXISTS `#__chronoconnectivity` (
`id` INT NOT NULL AUTO_INCREMENT,
`name` TEXT NOT NULL,
`tablenames` LONGTEXT NOT NULL,
`SQL` LONGTEXT NOT NULL,
`head` LONGTEXT NOT NULL,
`body` LONGTEXT NOT NULL,
`footer` LONGTEXT NOT NULL,
`paramsall` LONGTEXT NOT NULL,
`Config` LONGTEXT NOT NULL,
`ClassCode` LONGTEXT NOT NULL,
`ccCache1` LONGTEXT NOT NULL,
`ccCache2` LONGTEXT NOT NULL,
`published` TINYINT(1) NOT NULL,
PRIMARY KEY (`id`) )
</query>
</queries>
</install>

Thanks for your great component 😀

Hi Inetis,

Great catch. Thanks for spotting this. The SQL code to use in PHPMyAdmin is . . . or there's an updated xml file attached for people who prefer to re-install. Open the zip file replace the existing chronoconnectivity.xml file and re-zip. Unistall ChronoConnectivity, then Re-install with the amended package.

NB Uninstalling will delete any saved connections so only do this with new installations.

Oops commented this out - I didn't understand what had changed in the new version.
Bob

Hi Inetis,Bob,

Thank you, but indeed this field is not needed any more, it has been removed because we are using a Chronoform now for the edit and on submitting this form the usual JS code in the form runs!

Regards,
Max

Hi Max,

first of all, can't you increase the logon time? After typing a previous version of this post I tried to "Preview", but appeared no longer logged in, so I lost everything.

I installed V2 RC1 (and I'm happy I did so on a copy site using a copy database!). I have several connections with a reasonable amount of work put into the {edit_record} facility (also using "OnSaveCode"), but it all seems gone now. From the previous post I understand that {edit_record} now results into calling a form. That seems like a lot of work for me, what doesn't make me happy right now!
I tried to specify as form-to-be-called the form I use for adding records to the same table, but all its fields remain empty. I use CF 3.1 RC5.0 (03-05-2009), but the form itself is probably created using a previous version.
How can I get this right?

---- added later:
Oops, I overlooked the requirement for CF 3.1 RC5.1.
But RC5.1 was never announced, that's why I missed it completely - and there was no error message during installation of CC V2 RC1 either.
I will install it and see which of the above will vanish (but certainly not the logon remark!).

Regards,
Peter

Hi Peter,

The session time here is pretty long, I've made best part of 30 posts here today without re-logging on. Sorry you lost your post though, that's never good news.

I don't know much about the CC upgrade except that it now requires CF to create edit forms. I had thought it was non-destructive but I haven't yet tried upgrading a live site.

Bob

Hi Bob/Max,

[Bob]: the upgrade is not destructive, the OnSaveCodeFront that I created is still in the database, and I can still reach it using phpMyAdmin, but no longer via the back-end. I'll have to crate a new form now for editing a record, and put (probably) roughly the same code in there - manually.

[General]: After installing CF 3.1 RC5.1 the record data DOES appear in a correctly created form - the previously reported problem does no longer exist.

I do however have a more serious problem now. At several places in this forum it is shown how you can access record fields in PHP code that is included in the Body part: $row->record_field. That is no longer possible, although several of my connetions use it by now. Did the name change? Of course using such a feature is risky, but I don't know an alternative and I DO need the value sometimes in PHP. When you write

 <?php
  $v = "{record_field}";
  echo $v;
  if ($v == "{record_field}") {
    ...

the correct value will be echoed, but the if expression will be false, due to the order of evaluating things. So I can get the field values in PHP, but I can hardly use them.
Is there a solution in the new version? Things worked nicely with $row->field, so I hope that it is just a name change.

Regards,
Peter

Hi Peter49,

I found this post that suggests it's now $MyRow->field_name This will be better in the long run because $row is overused and can cause problems.
For a quick fix putting $row =& $MyRow; at the start of your code should work OK.

Bob

Thanks Bob, works fine (for the time being).
I would prefer a stable solution however.

Regards,
Peter

Hi Peter49,

Go through your code and replace all $row-> with $MyRow-> . . .?

Bob

Hi Bob,

are you kidding?
I was more thinking towards a (nonexisting yet!) contruct like

$v = JRequest::getVar('field_name', 'record');

or - if necessary -

$v = JChrono::getVar('field_name', 'record');

Regards,
Peter

Hello,

I'm sorry to ask you this...
But can you offer to dowload the latest version without dependence ?

The possibility to interact with ChronoForms is interesting...
But ChronoConnectivity 1.2 offers enough options... (well, if i exclude the csv exports...)

Best regards.

Hi mar.mack,

To add an edit forms at either the admin or frontend you need a Chronoform, because Chronoforms can do everything with forms, its better to use it instead of making a basic form for editing!

Cheers
Max

Hi
I am a newbie and would like to know if this can be used with wordpress? Does it take over the whole blog or is it a code of some kind? Sorry for the stupid question but I'm not a coder.

Hi RWC,

It's a Joomla! extension, not designed for WordPress.

Bob

oh, i see it's a joomla. thank you

Is this the latest update of chrono?

Hi Joey,

The new one is under development, Firstly Chronoforms but the others to follow soon hopefully.

Regards,
Max

Great information! I’ve been looking for something like this for a while now. Thanks!

Hi there,
Iknow that ChronoEngine is a great component & just recently launched your V2 RC1. Just want to ask if this is available in Southeast Asia? I have friends over there & they're interested to try this out.

Are there any plans to release a Joomla 1.7 version?

Hi russojar,

Not as far as I know. A lot (but not all) of the functionailty is now built in to ChronoForms v4. See the tutorial and threads on the DB Multi Record Loader.

Bob

Hi,

Max has just released a new version for Joomla! 1.5 and 1.6/1.7/2.5

Bob