Forums

When opening Chronoforms v4.0.8 on Joomla 3.8.7 I got the error "1054 Unknown column 'app' in 'field list'".
DId a database fix already, but the error is still there. Any clue how to fix this?

Hi JBS,
​
I have CFv4.0.7 on Joomla 3.8.7 and am not seeing any errors like that (or any others).
​
If this when opening the forms manager, or with a particular form?
​
Bob

Hi Bob,
​
When I open Chronoforms component (Components > Chronoforms) I get this error.
​
I am able to open the Form Wizard and Easy Form Wizard. When saving a new form, the error comes op again.

Hi JBS,
​
If you turn on site debugging temporarily you should be able to see the full query that is causing the error. Please can you copy and post that here - the table name involved and the rest of the query should give some clues.
​
Bob

Hi Bob,
​
1054 Unknown column 'app' in 'field list'
/home/vhosts/*domainname*.com/httpdocs/libraries/joomla/database/driver/mysqli.php:650
​
Is this useful?

Hi JBS,
​
Thank you - but not terribly useful. I was hoping for something that would identify the table being queried. The full query normally shows in the Joomla Debugger code - but maybe that isn't shown when there is an error like this .
​
By all means PM me the site URL and a super admin login and I'll take a quick look.
​
Bob

Hi Bob,
​
Just send you a super user username and password. Thanks in advance!

Did you have any change to take a look, Bob? :-)

Hi JBS,
​
Apologies, it slipped through the net :-(
​
It looks as if you may have an old version of the #_chronoforms table that does not include the 'app' column.
​
Here's the create statement from the table on my site

CREATE TABLE `eye0f_chronoforms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `form_type` tinyint(1) NOT NULL,
  `content` longtext NOT NULL,
  `wizardcode` longtext,
  `events_actions_map` longtext,
  `params` longtext NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `app` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8

It looks as though the app column is empty by default so it may be enough to add it your table.
​
Bob

Thanks Bob. After adding a column 'app' to the #_chronoforms table, the problem is fixed.