Forums

Hello

I am going through the simple process of selecting a form, then clicking the 'Create Table' icon at the top. It says it's created. However, when I go to link the table to the form in the 'On Submit' 'Save to DB', the table is not listed. Any ideas?

Also, I tried setting up a table manually and was able to link it in the 'save to db' feature. However, the results I get on previewing CC is;

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

1054 Unknown column 'stockmodel.location' in 'field list' SQL=SELECT `stockmodel`.`id` AS `stockmodel.id`, `stockmodel`.`region` AS `stockmodel.region`, `stockmodel`.`country` AS `stockmodel.country`, `stockmodel`.`state` AS `stockmodel.state`, `stockmodel`.`location` AS `stockmodel.location`, `stockmodel`.`depot` AS `stockmodel.depot`, `stockmodel`.`type` AS `stockmodel.type`, `stockmodel`.`available` AS `stockmodel.available`, `stockmodel`.`incoming` AS `stockmodel.incoming`, `stockmodel`.`contact` AS `stockmodel.contact` FROM `allstock` AS `stockmodel` LIMIT 30

I managed to get CF and CC working very easily the other week when I was trying it, now I actually need it, I can't seem to get it to do anything for me!

I have tried on two different servers (one local (WAMP) and one on a hosted server), and am getting the same responses. Which leads me to believe, it's me! Doing something simple... wrong.

Anyone have any thoughts on either of the two problems above?

Many thanks

Jo

Hi Jo,

The error message suggests that your listing is trying to load a column 'location' that doesn't exist in the table.

If the column is there then clicking the Delete Cache icon in the CC Toolbar may fix the problem. In CF and CC ChronoForms caches the table structure for 24 hours and needs to be cleared if you change the table structure.

I have no idea why a new table isn't listed. It should appear as soon as it is created. I'd suggest that you check with PHPMyAdmin to make sure that it is there.

Note: ChronoForms suggests some very long table names and sometimes I have seen these cause problems when the form name is also long.

Bob

Many thanks Bob

I cleared the cache for CC and that resolved the problem with the 'location' field not being found.

Then..... CF started creating tables!

Problems resolved.

Thanks again

Jo