florisjan
Member
I have migrated my website from J 1.5 to J 2.5.6 and installed Fabrik3.0.
I followed this (http://fabrikar.com/forums/showthread.php?t=27406 ) and now I get this error opening the farik-component/lists:
When I try to open other parts (forms, lements) I get a similar error.
I cannot find the cause of it.
Is there anyone who can help me?
I followed this (http://fabrikar.com/forums/showthread.php?t=27406 ) and now I get this error opening the farik-component/lists:
Unknown column 'l.published' in 'where clause' SQL=SELECT l.* FROM lnru2_fabrik_lists AS l WHERE (l.published IN (0, 1)) ORDER BY label asc Unknown column 'l.published' in 'where clause' SQL=SELECT l.* FROM lnru2_fabrik_lists AS l WHERE (l.published IN (0, 1)) ORDER BY label asc LIMIT 0, 20 Unknown column 'l.published' in 'where clause' SQL=SELECT l.* FROM lnru2_fabrik_lists AS l WHERE (l.published IN (0, 1)) ORDER BY label asc
When I try to open other parts (forms, lements) I get a similar error.
I cannot find the cause of it.
Is there anyone who can help me?
Code:
CREATE TABLE IF NOT EXISTS `lnru2_fabrik_lists` (
`id` int(11) NOT NULL auto_increment,
`label` varchar(255) NOT NULL,
`introduction` text NOT NULL,
`form_id` int(4) NOT NULL,
`db_table_name` varchar(255) NOT NULL,
`db_primary_key` varchar(255) NOT NULL,
`auto_inc` int(1) NOT NULL,
`connection_id` int(6) NOT NULL,
`created` datetime default NULL,
`created_by` int(4) NOT NULL,
`created_by_alias` varchar(255) NOT NULL,
`modified` datetime default NULL,
`modified_by` int(4) NOT NULL,
`checked_out` int(4) NOT NULL,
`checked_out_time` datetime default NULL,
`state` int(1) NOT NULL default '0',
`publish_up` datetime default NULL,
`publish_down` datetime default NULL,
`access` int(4) NOT NULL,
`hits` int(4) NOT NULL,
`rows_per_page` int(5) NOT NULL,
`template` varchar(255) NOT NULL,
`order_by` varchar(255) NOT NULL,
`order_dir` varchar(255) NOT NULL default 'ASC',
`filter_action` varchar(30) NOT NULL,
`group_by` varchar(255) NOT NULL,
`private` tinyint(1) NOT NULL default '0',
`attribs` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
--
-- Gegevens worden uitgevoerd voor tabel `lnru2_fabrik_lists`
--
INSERT INTO `lnru2_fabrik_lists` (`id`, `label`, `introduction`, `form_id`, `db_table_name`, `db_primary_key`, `auto_inc`, `connection_id`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `state`, `publish_up`, `publish_down`, `access`, `hits`, `rows_per_page`, `template`, `order_by`, `order_dir`, `filter_action`, `group_by`, `private`, `attribs`) VALUES
(1, 'Events', 'This table is used to store the calendar visualization events. Only super administrators can see and edit it in administration. ', 1, 'lnru2_fabrik_calendar_events', '`lnru2_fabrik_calendar_events`.`id`', 1, 1, '0000-00-00 00:00:00', 62, 'fabrik', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 1, 10, 'default', 'lnru2_fabrik_calendar_events.start_date', 'DESC', 'onchange', '', 1, 'admin_template=admin\ndetaillink=0\r\n empty_data_msg=sorry no data found\r\n advanced-filter=0\r\n show-table-nav=1\r\n pdf=\r\n rss=0\r\n feed_title=\r\n feed_date=\r\n rsslimit=150\r\n rsslimitmax=2500\r\n csv_import_frontend=0\r\n csv_export_frontend=0\r\n csvfullname=0\r\n access=0\r\n allow_view_details=0\r\n allow_edit_details=18\r\n allow_add=18\r\n allow_delete=20\r\n group_by_order=\r\n group_by_order_dir=ASC\r\n prefilter_query=\nisview=0\n'),
(17, 'Open huis', '', 23, 'fab_openhuis', '`fab_openhuis`.`id`', 1, 1, '2011-03-04 15:37:04', 62, '', '2011-03-04 15:38:28', 62, 0, '0000-00-00 00:00:00', 1, '2011-03-04 15:37:04', '0000-00-00 00:00:00', 0, 5, 10, 'default', '', '', 'onchange', '', 0, 'show-table-filters=1\nadvanced-filter=0\nsearch-mode=AND\nsearch-mode-advanced=0\nsearch-all-label=All\nrequire-filter=0\nfilter-dropdown-method=0\najax_nav=post\nshow-table-add=1\nshow-table-nav=1\nshowall-records=0\nshow-total=0\nsef-slug=\nadmin_template=admin\nempty_data_msg=U heeft niet alle gevraagde gegevens ingevuld!\npdf=\npdf_template=admin\nshow-title=1\ndetaillink=0\ndetailurl=\ndetaillabel=\neditlink=0\nediturl=\neditlabel=\nmerge_edit_details=0\nnote=\nalter_existing_db_cols=notset\nprocess-jplugins=1\nenable_big_selects=0\nenable_single_sorting=default\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\ncsv_export_step=100\nnewline_csv_export=nl2br\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=-1\nisview=0\n'),
(7, 'Reas Reizen', '', 8, 'fab_reas', '`fab_reas`.`fabrik_internal_id`', 1, 1, '2009-07-13 11:38:08', 62, '', '2010-10-17 16:33:20', 62, 0, '0000-00-00 00:00:00', 1, '2009-07-13 11:38:08', '0000-00-00 00:00:00', 0, 46, 10, 'default', '', 'ASC', 'onchange', '', 0, 'admin_template=admin\ndetaillink=0\nempty_data_msg=\ndetailurl=\nadvanced-filter=0\nshow-table-nav=1\nsearch-mode=AND\nrequire-filter=0\npdf=\npdf_template=admin\nnote=\nalter_existing_db_cols=1\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=0\n\nisview=0\n\nisview=0\n'),
(6, 'Fietstocht', '', 7, 'fab_fietstocht', '`fab_fietstocht`.`fabrik_internal_id`', 1, 1, '2009-07-11 23:00:00', 62, '', '2011-06-06 15:27:53', 62, 0, '0000-00-00 00:00:00', 1, '2009-07-11 23:00:00', '0000-00-00 00:00:00', 0, 432, 20, 'default', 'fab_fietstocht.fiets_naam', 'ASC', 'onchange', '', 0, 'show-table-filters=1\nadvanced-filter=0\nsearch-mode=AND\nsearch-mode-advanced=0\nsearch-all-label=All\nrequire-filter=0\nfilter-dropdown-method=2\najax_nav=post\nshow-table-add=1\nshow-table-nav=1\nshowall-records=1\nshow-total=1\nsef-slug=\nadmin_template=admin\nempty_data_msg=\npdf=\npdf_template=admin\nshow-title=1\ndetaillink=0\ndetailurl=\ndetaillabel=\neditlink=0\nediturl=\neditlabel=\nmerge_edit_details=0\nnote=\nalter_existing_db_cols=1\nprocess-jplugins=1\nenable_big_selects=0\nenable_single_sorting=default\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\ncsv_export_step=100\nnewline_csv_export=nl2br\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\njoin-display=default\ndelete-joined-rows=0\nisview=0'),
(11, 'Sint Nicolaas', '', 13, 'fab_sinterklaas', '`fab_sinterklaas`.`fabrik_internal_id`', 1, 1, '2010-08-24 15:43:50', 62, '', '2010-10-17 15:49:56', 62, 0, '0000-00-00 00:00:00', 1, '2010-08-23 23:00:00', '0000-00-00 00:00:00', 0, 351, 10, 'default', 'fab_sinterklaas.Naam', 'ASC', 'onchange', '', 0, 'admin_template=admin\ndetaillink=0\nempty_data_msg=\ndetailurl=\nadvanced-filter=0\nshow-table-nav=1\nsearch-mode=AND\nrequire-filter=0\npdf=\npdf_template=admin\nnote=\nalter_existing_db_cols=1\nrss=0\nfeed_title=\nfeed_date=168\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=0\n\nisview=0\n\nisview=0\n'),
(10, 'Wegnahetwerk', '', 12, 'fab_reas', '`fab_reas`.`fabrik_internal_id`', 1, 1, '2009-07-30 20:34:36', 62, '', '2010-08-24 15:40:56', 62, 0, '0000-00-00 00:00:00', 1, '2009-07-30 20:34:36', '0000-00-00 00:00:00', 0, 21, 10, 'default', 'fab_reas.time_date', 'ASC', 'onchange', '', 0, 'admin_template=admin\ndetaillink=0\nempty_data_msg=\ndetailurl=\nadvanced-filter=0\nshow-table-nav=1\nsearch-mode=AND\nrequire-filter=0\npdf=\npdf_template=admin\nnote=\nalter_existing_db_cols=1\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=24\nallow_edit_details2=\nallow_add=0\nallow_delete=24\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=0\n\nisview=0\n\nisview=0\n'),
(12, 'Sint Nicolaas locatie Nieuwegein', '', 18, 'fab_sinterklaas', '`fab_sinterklaas`.`fabrik_internal_id`', 1, 1, '2010-09-10 10:24:50', 62, '', '2010-09-20 09:08:56', 62, 0, '0000-00-00 00:00:00', 1, '2010-09-10 10:24:50', '0000-00-00 00:00:00', 0, 221, 10, 'default', 'fab_sinterklaas.Naam', 'ASC', 'onchange', '', 0, 'admin_template=admin\ndetaillink=0\nempty_data_msg=\ndetailurl=\nadvanced-filter=0\nshow-table-nav=1\nsearch-mode=AND\nrequire-filter=0\npdf=\npdf_template=admin\nnote=\nalter_existing_db_cols=1\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=0\n\nisview=0\n\nisview=0\n'),
(16, 'Musicalkortingen', '', 22, 'fab_korting', '`fab_korting`.`fabrik_internal_id`', 1, 1, '2010-11-11 13:01:43', 62, '', '2010-11-11 13:03:47', 62, 0, '0000-00-00 00:00:00', 1, '2010-11-11 13:01:43', '0000-00-00 00:00:00', 0, 223, 10, 'default', 'fab_korting.time_date', 'ASC', 'onchange', '', 0, 'admin_template=admin\ndetaillink=0\nempty_data_msg=\ndetailurl=\nadvanced-filter=0\nshow-table-nav=1\nsearch-mode=AND\nrequire-filter=0\npdf=\npdf_template=admin\nnote=\nalter_existing_db_cols=1\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=0\n\nisview=0\n\nisview=0\n'),
(14, 'Contact Us Data', 'This table stores the data submitted in the contact us for', 20, 'lnru2__fb_contact_sample', '`lnru2__fb_contact_sample`.`fabrik_internal_id`', 1, 1, NULL, 0, '', NULL, 0, 0, NULL, 1, NULL, NULL, 0, 0, 10, 'default', '', 'ASC', '', '', 0, 'admin_template=admin\r\ndetaillink=0\r\nempty_data_msg=No data found\r\nadvanced-filter=0\r\nshow-table-nav=1\r\npdf=\r\nrss=0\r\nfeed_title=\r\nfeed_date=\r\nrsslimit=150\r\nrsslimitmax=2500\r\ncsv_import_frontend=0\r\ncsv_export_frontend=0\r\ncsvfullname=0\r\naccess=0\r\nallow_view_details=0\r\nallow_edit_details=0\r\nallow_add=0\r\nallow_delete=0\r\ngroup_by_order=\r\ngroup_by_order_dir=ASC\r\nprefilter_query=\r\nrequire-filter=0'),
(15, 'Reizen', '', 21, 'fab_reizen', '`fab_reizen`.`fabrik_internal_id`', 1, 1, '2010-11-04 13:56:14', 62, '', '2010-11-04 13:57:58', 62, 0, '0000-00-00 00:00:00', 1, '2010-11-04 13:56:14', '0000-00-00 00:00:00', 0, 37, 10, 'default', '', 'ASC', 'onchange', '', 0, 'admin_template=admin\ndetaillink=0\nempty_data_msg=\ndetailurl=\nadvanced-filter=0\nshow-table-nav=1\nsearch-mode=AND\nrequire-filter=0\npdf=\npdf_template=admin\nnote=\nalter_existing_db_cols=1\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\nisview=0\n\nisview=0\n\nisview=0\n'),
(18, 'AutoRAI 2011', '', 24, 'autorai', '`autorai`.`id`', 1, 1, '2011-03-11 13:13:44', 62, '', '2011-10-09 20:38:55', 62, 0, '0000-00-00 00:00:00', 1, '2011-03-11 13:13:44', '0000-00-00 00:00:00', 0, 12, 10, 'default', '', 'ASC', 'onchange', '', 0, 'show-table-filters=1\nadvanced-filter=0\nsearch-mode=AND\nsearch-mode-advanced=0\nsearch-all-label=All\nrequire-filter=0\nfilter-dropdown-method=0\najax_nav=post\nshow-table-add=1\nshow-table-nav=1\nshow_displaynum=1\nshowall-records=0\nshow-total=0\nsef-slug=\nadmin_template=admin\nempty_data_msg=Niet alle in te vullen gegevens zijn opgegeven!\npdf=\npdf_template=admin\nshow-title=1\ndetaillink=0\ndetailurl=\ndetaillabel=\ndetailurl_attribs=\neditlink=0\nediturl=\neditlabel=\nediturl_attribs=\nmerge_edit_details=0\naddurl=\naddlabel=\nnote=\nalter_existing_db_cols=notset\nprocess-jplugins=1\nenable_big_selects=0\nenable_single_sorting=default\nshow_related_add=0\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\ncsv_export_step=100\nnewline_csv_export=nl2br\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\njoin-display=default\ndelete-joined-rows=0\nisview=0'),
(19, 'Dinerjaarkaart', '', 25, 'fab_dinerkaart', '`fab_dinerkaart`.`id`', 1, 1, '2011-06-20 14:58:11', 62, '', '2011-06-21 21:42:16', 62, 0, '0000-00-00 00:00:00', 1, '2011-06-20 14:58:11', '0000-00-00 00:00:00', 0, 76, 10, 'default', 'fab_dinerkaart.date_time', 'ASC', 'onchange', '', 0, 'show-table-filters=1\nadvanced-filter=0\nsearch-mode=AND\nsearch-mode-advanced=0\nsearch-all-label=All\nrequire-filter=0\nfilter-dropdown-method=0\najax_nav=post\nshow-table-add=1\nshow-table-nav=1\nshowall-records=0\nshow-total=0\nsef-slug=\nadmin_template=admin\nempty_data_msg=Er zijn geen aanvragen\npdf=\npdf_template=admin\nshow-title=1\ndetaillink=0\ndetailurl=\ndetaillabel=\neditlink=0\nediturl=\neditlabel=\nmerge_edit_details=0\nnote=\nalter_existing_db_cols=notset\nprocess-jplugins=1\nenable_big_selects=0\nenable_single_sorting=default\nrss=0\nfeed_title=\nfeed_date=\nrsslimit=150\nrsslimitmax=2500\ncsv_import_frontend=0\ncsv_export_frontend=0\ncsvfullname=0\ncsv_export_step=1000\nnewline_csv_export=nl2br\nsearch_use=0\nsearch_title=\nsearch_description=\naccess=0\nallow_view_details=0\nallow_edit_details=20\nallow_edit_details2=\nallow_add=0\nallow_delete=20\nallow_delete2=\nallow_drop=26\ngroup_by_order=\ngroup_by_template=\ngroup_by_order_dir=ASC\nprefilter_query=\njoin-display=default\ndelete-joined-rows=0\nisview=0');