Migrating J1.5->J2.5.6 + Fabrik

florisjan

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:
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
Click to expand...

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');
 
Did you do the last step?

Run Fabrik upgrade. (Click Components/Fabrik, then at the bottom right Tools, Upgrade)
attachment.php
 

Attachments

  • fabrikupgrade.JPG
    fabrikupgrade.JPG
    30.2 KB · Views: 363
Yes, it returns 'Migration alrady done' ?

Can there be an item that can be switched off, as I did migrate before, but because of some errors I deleted all fabrik-stuff.
 
I have deleted all tables and imported the old Fabrik2.1-tables after changing (state to published and attribs to params).

When I open fabrik in back-end I get an error about "loading feetdata"?? and when I open the elements-tab I get this error:
Unknown column 'jj.list_id' in 'where clause' SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM lnru2_fabrik_elements AS ee LEFT JOIN lnru2_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN lnru2_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN lnru2_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM lnru2_fabrik_elements AS e LEFT JOIN lnru2_users AS u ON checked_out = u.id LEFT JOIN lnru2_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN lnru2_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN lnru2_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) ORDER BY ordering Unknown column 'jj.list_id' in 'where clause' SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM lnru2_fabrik_elements AS ee LEFT JOIN lnru2_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN lnru2_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN lnru2_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM lnru2_fabrik_elements AS e LEFT JOIN lnru2_users AS u ON checked_out = u.id LEFT JOIN lnru2_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN lnru2_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN lnru2_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) ORDER BY ordering LIMIT 0, 20 Unknown column 'jj.list_id' in 'where clause' SQL=SELECT e.*, e.ordering AS ordering,u.name AS editor, (SELECT DISTINCT( IF( ISNULL(jj.table_join), CONCAT(ll.db_table_name, '___', ee.name), CONCAT(jj.table_join, '___', ee.name)) ) FROM lnru2_fabrik_elements AS ee LEFT JOIN lnru2_fabrik_joins AS jj ON jj.group_id = ee.group_id LEFT JOIN lnru2_fabrik_formgroup as fg ON fg.group_id = ee.group_id LEFT JOIN lnru2_fabrik_lists AS ll ON ll.form_id = fg.form_id WHERE (jj.list_id != 0 AND jj.element_id = 0) AND ee.id = e.id AND ee.group_id <> 0 LIMIT 1) AS full_element_name, g.name AS group_name, l.db_table_name FROM lnru2_fabrik_elements AS e LEFT JOIN lnru2_users AS u ON checked_out = u.id LEFT JOIN lnru2_fabrik_groups AS g ON e.group_id = g.id LEFT JOIN lnru2_fabrik_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN lnru2_fabrik_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) ORDER BY ordering
Click to expand...

This is my third try to migrate and as there are a lot of elements I cannot start of scratch!!
 
This item can be closed.
I have managed to migrate fabrik 2.1.1 to 3.0.52.
There were some errors, but the seemed to be a result of database-joins, that had to be processed again, and not to forget the right access-level for each element.
 
You may have to go into each dbjoin and re-save, the same with any left joins.

Although a tedious exercise I would further recommend re-saving all elements, lists and forms. This will ensure that all the paramters are 100% correct.
 
You must log in or register to reply here.

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    Total: 136 (members: 1, guests: 135)
    Back
    Top