Direct list editing

Hi
I run one of your tutorials "Direct list editing"
I performed all the steps but I can not save the list, it tells me "Save Failed"
I can not understand why
Can you help?
greetings
Fabri

There is nobody who can help me?

Hi Fasano,

I assume that this is CCv5? Please turn on the Debugger as the bottom of the Front List | Settings tab and post the debug output here.

Bob

Hi Bob
here is the Debugger
Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `iwx3p_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `iwx3p_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'visualizza_iscritti_per_categoria2' AND `Connection`.`published` = '1'
[2] => SELECT COUNT(*) AS `visualizza.count` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`eliminare` = '1' AND `visualizza`.`categoria_mista` = ' ' AND `visualizza`.`data` >= '' AND `visualizza`.`data` <= ''
[3] => SELECT `visualizza`.`cf_id` AS `visualizza.cf_id`, `visualizza`.`cf_uid` AS `visualizza.cf_uid`, `visualizza`.`cf_created` AS `visualizza.cf_created`, `visualizza`.`cf_modified` AS `visualizza.cf_modified`, `visualizza`.`cf_created_by` AS `visualizza.cf_created_by`, `visualizza`.`cf_modified_by` AS `visualizza.cf_modified_by`, `visualizza`.`cf_ipaddress` AS `visualizza.cf_ipaddress`, `visualizza`.`cf_user_id` AS `visualizza.cf_user_id`, `visualizza`.`cognome` AS `visualizza.cognome`, `visualizza`.`nome` AS `visualizza.nome`, `visualizza`.`data` AS `visualizza.data`, `visualizza`.`sesso` AS `visualizza.sesso`, `visualizza`.`comune` AS `visualizza.comune`, `visualizza`.`prov` AS `visualizza.prov`, `visualizza`.`codicefiscale` AS `visualizza.codicefiscale`, `visualizza`.`certificato` AS `visualizza.certificato`, `visualizza`.`indirizzo` AS `visualizza.indirizzo`, `visualizza`.`pv` AS `visualizza.pv`, `visualizza`.`citta` AS `visualizza.citta`, `visualizza`.`cap` AS `visualizza.cap`, `visualizza`.`telefono` AS `visualizza.telefono`, `visualizza`.`cellulare` AS `visualizza.cellulare`, `visualizza`.`mail` AS `visualizza.mail`, `visualizza`.`acconto` AS `visualizza.acconto`, `visualizza`.`accontolettere` AS `visualizza.accontolettere`, `visualizza`.`saldo` AS `visualizza.saldo`, `visualizza`.`saldolettere` AS `visualizza.saldolettere`, `visualizza`.`privacy` AS `visualizza.privacy`, `visualizza`.`accetto` AS `visualizza.accetto`, `visualizza`.`salva` AS `visualizza.salva`, `visualizza`.`reset` AS `visualizza.reset`, `visualizza`.`cognomegenitore` AS `visualizza.cognomegenitore`, `visualizza`.`nomegenitore` AS `visualizza.nomegenitore`, `visualizza`.`anno` AS `visualizza.anno`, `visualizza`.`eliminare` AS `visualizza.eliminare`, `visualizza`.`immagine` AS `visualizza.immagine`, `visualizza`.`nuovo` AS `visualizza.nuovo`, `visualizza`.`modifica` AS `visualizza.modifica`, `visualizza`.`elimina` AS `visualizza.elimina`, `visualizza`.`qualifica` AS `visualizza.qualifica`, `visualizza`.`note` AS `visualizza.note`, `visualizza`.`categoria_mista` AS `visualizza.categoria_mista`, `visualizza`.`descrizione` AS `visualizza.descrizione` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`eliminare` = '1' AND `visualizza`.`categoria_mista` = ' ' AND `visualizza`.`data` >= '' AND `visualizza`.`data` <= '' ORDER BY `visualizza`.`cognome` LIMIT 30
)

Hi Fasano,

That looks to me like the Joomla! debugger? There is no UPDATE or INSERT there to fail.

Bob

Hi Bob
is to think CCv5

Hi, Bob... Excuse me.
No idea.?

Hi Fasano,

Thank you. I don't see anything obviously wrong with these queries :-(

You might try copying and pasting them into PHPMyAdmin to see if any errors show up there - but there still is no INSERT or UPDATE query :-(

You may need to get Max to look at this
.
Bob

Hi Bob
Nothing to do ... I can not save. Yet I have followed step by step tutorial http://www.chronoengine.com/faqs/72-ccv5/5213-direct-list-editing.html but does not work. I do not understand!
I do not know how to do

Hi Fasano,

By all means email or PM me the site URL, the listing name, and a SuperAdmin login and I'll take a quick look.

Bob

Hi Fasano,

I think that this is fixed - you had two forms called 'modifica' and, even though one was unpublished, ChronoForms was using the wrong one for the edit. I renamed the unpublished one to modifica_x and the save now appears to work OK.

Bob

Hi Bob
Unfortunately not.
The list is not saved,

Hi Fasano,

?

Bob

Hi Bob
incredible
How come I do not work?
I'm going crazy-

Hi Fasano,

Sorry, I've no idea, Maybe I did something different . . . I was logged into the front-end, went to the first listing, clicked an entry to open the second listing, then clicked Edit, made a tiny change and clicked save.

Bob

Hi Bob
It certainly works with the edit.
But if I change the "elimina" (1/0) and then I click on the button "update list" does not work.
Fabri

Hi Fasano,

Sorry, I hadn't understood what the problem is :-(

I can only suggest that you ask Max using the Contact Us menu above and linking to this thread - I just don't know CCv5 well enough to know what is happening here.

Bob

Hi Bob
I will do so. Thank you.
Greetings
Fabri