Buy Now
Sign in

Error when opening Chronoforms v4: 1054 Unknown column 'app' in 'field list'

JBS , May 24 at 20:53
J
JBS
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?
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
J
JBS
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.
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
J
JBS
Hi Bob,
1054 Unknown column 'app' in 'field list'  
/home/vhosts/*domainname*.com/httpdocs/libraries/joomla/database/driver/mysqli.php:650
Is this useful?
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
J
JBS
Hi Bob,
Just send you a super user username and password. Thanks in advance!
J
JBS
Did you have any change to take a look, Bob? :-)
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
J
JBS
Thanks Bob. After adding a column 'app' to the #_chronoforms table, the problem is fixed.