Forums

Error on query

parsifaltheking 11 Oct, 2016
Hi, i've created with chronoconnectivity more query and it works.. but after i clicked on sortable field named "Aperte" i've the error screen attached.
I haven't nothing field that names DATA, i've delete cache chronoconnectivity, delete joomla cache but the messages remain.
If i change the data name, it show the data but when click on Aperte i obtain the same error.
What is wrong?

Thanks
GreyHead 11 Oct, 2016
Hi parsifaltheking,

Your attachment didn't make it; please click Upload before you Submit the post.

Bob
parsifaltheking 11 Oct, 2016
I've found the error... in the sortables field i've write datiaperte.dataarrivo:DATE instead of datiaperte.dataarrivo.

Sorry the post.
parsifaltheking 11 Oct, 2016
Sorry... the problems remains.
So if i use different Model title and with the previous correction the order works; but when i click on edit filed date are not pas to a chronoforms field because the forms expect a data array that names "data" but the new model title are "datax".

If i use the same Model title for all the 10 chronoconnectivity different connection it goes me the previous error but the date are passed from chronoconnectivity to chronoforms.

How i can use different model title for all 10 chronoconnectivity that connect to the same chronoforms forms without duplicate for 10 the chronoforms and change data passing because on load action i have:
<?php
$user =& JFactory::getUser();
$form->data['nome'] =$user;
$form->data['refcode'] =$form->data['dati']['id'];
$form->data['uniq_id'] =$form->data['dati']['uniq_id'];
$form->data['anno'] =$form->data['dati']['anno'];
$form->data['cognome'] =$form->data['dati']['competente'];


that work if Model title is dati for all the chronoconnectivity connection but in this situation order by filed not work and goes the previous error.
GreyHead 12 Oct, 2016
Hi parsifaltheking,

Have you clicked the Delete Cache icons in CF & CC after changing the table structures? That might be the problem here - otherwise I'm afraid that I don't understand the question.

Bob
This topic is locked and no more replies can be posted.