Can't rei-mport component

kevincam3 commented

2017-11-09 20:49:48 +00:00

(Migrated from github.com)

So I exported the component so a friend could work on my project. He then made changes and exported the project to give back to me but when I tried to import it I got the following error

So I exported the component so a friend could work on my project. He then made changes and exported the project to give back to me but when I tried to import it I got the following error ![image](https://user-images.githubusercontent.com/870934/32628959-c024d450-c57e-11e7-8694-02905b1242f1.png)

Llewellyn commented

2017-11-09 21:39:20 +00:00

Are the two of you on the same JCB versions?

kevincam3 commented

2017-11-09 21:41:23 +00:00

(Migrated from github.com)

The import file has a field "metakey" but my database doesn't. Yes we are both on the latest version 2.6.3

stdClass::__set_state(array(
   'add_admin_event' => '0',
   'add_css' => '1',
   'add_email_helper' => '0',
   'add_javascript' => '0',
   'add_license' => '0',
   'add_php_helper_admin' => '0',
   'add_php_helper_both' => '0',
   'add_php_helper_site' => '0',
   'add_php_method_uninstall' => '0',
   'add_php_postflight_install' => '0',
   'add_php_postflight_update' => '0',
   'add_php_preflight_install' => '0',
   'add_php_preflight_update' => '0',
   'add_placeholders' => '1',
   'add_sales_server' => '0',
   'add_site_event' => '0',
   'add_sql' => '0',
   'add_update_server' => '0',
   'addfootable' => '0',
   'addreadme' => '0',
   'adduikit' => '0',
   'author' => 'Kevin Campbell',
   'bom' => 'default.txt',
   'buildcomp' => '0',
   'buildcompsql' => '',
   'companyname' => 'TCM Services, Inc.',
   'component_version' => '1.0.3',
   'copyright' => 'Copyright (C) 2017. TCM Services, Inc. All Rights Reserved',
   'creatuserhelper' => '0',
   'css' => 'LypQbGF5ZXJzIHRhYmxlIHNvcnQgY29sdW1uIGhlYWRlciBmb3JtYXR0aW5nKi8NCnRyLnNvcnRhYmxlIHRoIGltZyB7DQoJbWFyZ2luLWxlZnQ6IDVweDsNCn0NCg0KdHIuc29ydGFibGUgYSB7DQoJZGlzcGxheTogaW5saW5lLWJsb2NrOw0KCWhlaWdodDogMTAwJTsNCn0NCg0KLypCT09UU1RSQVAgTUVESUEgQ1NTKi8NCg0KLm1lZGlhIHsNCgltYXJnaW4tdG9wOiAxNXB4Ow0KICB9DQogIC5tZWRpYTpmaXJzdC1jaGlsZCB7DQoJbWFyZ2luLXRvcDogMDsNCiAgfQ0KICAubWVkaWEsDQogIC5tZWRpYS1ib2R5IHsNCgl6b29tOiAxOw0KCW92ZXJmbG93OiBoaWRkZW47DQogIH0NCiAgLm1lZGlhLWJvZHkgew0KCXdpZHRoOiAxMDAwMHB4Ow0KICB9DQogIC5tZWRpYS1vYmplY3Qgew0KCWRpc3BsYXk6IGJsb2NrOw0KICB9DQogIC5tZWRpYS1vYmplY3QuaW1nLXRodW1ibmFpbCB7DQoJbWF4LXdpZHRoOiBub25lOw0KICB9DQogIC5tZWRpYS1yaWdodCwNCiAgLm1lZGlhID4gLnB1bGwtcmlnaHQgew0KCXBhZGRpbmctbGVmdDogMTBweDsNCiAgfQ0KICAubWVkaWEtbGVmdCwNCiAgLm1lZGlhID4gLnB1bGwtbGVmdCB7DQoJcGFkZGluZy1yaWdodDogMTBweDsNCiAgfQ0KICAubWVkaWEtbGVmdCwNCiAgLm1lZGlhLXJpZ2h0LA0KICAubWVkaWEtYm9keSB7DQoJZGlzcGxheTogdGFibGUtY2VsbDsNCgl2ZXJ0aWNhbC1hbGlnbjogdG9wOw0KICB9DQogIC5tZWRpYS1taWRkbGUgew0KCXZlcnRpY2FsLWFsaWduOiBtaWRkbGU7DQogIH0NCiAgLm1lZGlhLWJvdHRvbSB7DQoJdmVydGljYWwtYWxpZ246IGJvdHRvbTsNCiAgfQ0KICAubWVkaWEtaGVhZGluZyB7DQoJbWFyZ2luLXRvcDogMDsNCgltYXJnaW4tYm90dG9tOiA1cHg7DQogIH0NCiAgLm1lZGlhLWxpc3Qgew0KCXBhZGRpbmctbGVmdDogMDsNCglsaXN0LXN0eWxlOiBub25lOw0KICB9DQovKkVORCBCT09UU1RSQVAgTUVESUEgQ1NTKi8NCg0KdGFibGUucmNzLXRhYmxlIHsNCglmb250LXNpemU6IC45ZW07DQp9DQoNCnRhYmxlLnJjcy10YWJsZSB0aGVhZCB0ciB0aCB7DQoJZm9udC1zaXplOiAxZW07DQp9DQoNCnRhYmxlLnJjcy10YWJsZSB0Ym9keSB0ciB0ZCB7DQoJbGluZS1oZWlnaHQ6IDUwcHg7DQoJdmVydGljYWwtYWxpZ246IG1pZGRsZTsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRoZWFkIHRyIHRoLnBsYXllci1yYW5rLA0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1yYW5rIHsNCgl0ZXh0LWFsaWduOiBjZW50ZXIgIWltcG9ydGFudDsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRoZWFkIHRyIHRoLnBsYXllci1pbWFnZSwNCnRhYmxlLnJjcy10YWJsZSB0Ym9keSB0ciB0ZC5wbGF5ZXItaW1hZ2Ugew0KCXdpZHRoOiA2MHB4ICFpbXBvcnRhbnQ7DQoJdGV4dC1hbGlnbjogY2VudGVyOw0KfQ0KDQp0YWJsZS5yY3MtdGFibGUgdGJvZHkgdHIgdGQucGxheWVyLWltYWdlIGltZyB7DQoJbWF4LWhlaWdodDogNTBweDsNCgltYXgtd2lkdGg6IDUwcHg7DQoJbWFyZ2luOiAwIGF1dG8gIWltcG9ydGFudDsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1uYW1lIHsNCglmb250LXdlaWdodDogYm9sZDsNCglsaW5lLWhlaWdodDogMTVweDsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1uYW1lIHNtYWxsIHsNCglkaXNwbGF5OiBibG9jazsNCglmb250LXdlaWdodDogbm9ybWFsOw0KfQ0KDQp0YWJsZS5yY3MtdGFibGUgdGhlYWQgdHIgdGgucGxheWVyLWh0LA0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1odCB7DQoJdGV4dC1hbGlnbjogY2VudGVyOw0KCW1heC13aWR0aDogNjBweDsNCn0NCg0KLmNhcmQtcGxheWVyIHsNCgltYXJnaW4tYm90dG9tOiAyNXB4Ow0KfQ0KDQouY2FyZC1wbGF5ZXIgaW1nIHsNCgltYXgtd2lkdGg6IDIwMHB4Ow0KCW1heC1oZWlnaHQ6IDIwMHB4Ow0KfQ0KDQouY2FyZC1wbGF5ZXIgLnBsYXllci1kZXRhaWxzIHsNCgliYWNrZ3JvdW5kLWNvbG9yOiByZ2JhKDI1NSwgMjU1LCAyNTUsIC4zKTsNCglwYWRkaW5nOiA1cHggOHB4Ow0KCWZvbnQtc2l6ZTogLjhlbTsNCgloZWlnaHQ6IDExNnB4Ow0KfQ0KDQouY2FyZC1wbGF5ZXIgLnBsYXllci1kZXRhaWxzIHVsIHsNCglsaXN0LXN0eWxlOiBub25lOw0KCW1hcmdpbjogMDsNCn0NCg0KLmNhcmQtcGxheWVyIC5wbGF5ZXItZGV0YWlscyB1bCBsaSB7DQoJbGluZS1oZWlnaHQ6IDMwcHg7DQoJdmVydGljYWwtYWxpZ246IG1pZGRsZTsNCn0=',
   'debug_linenr' => '0',
   'description' => 'This component is to track information about sports players, their ranking and related data.',
   'email' => 'kevin@tcmsvc.com',
   'emptycontributors' => '0',
   'export_buy_link' => '',
   'export_key' => '',
   'export_package_link' => '',
   'image' => 'images/rcs_ranking_box.jpg',
   'javascript' => '',
   'license' => 'GNU/GPL Version 2 or later - http://www.gnu.org/licenses/gpl-2.0.html',
   'license_type' => '1',
   'mvc_versiondate' => '0',
   'name' => 'RCS Sports Rankings',
   'name_code' => 'rcsrankings',
   'not_required' => '0',
   'number' => '4',
   'php_admin_event' => '',
   'php_helper_admin' => '',
   'php_helper_both' => '',
   'php_helper_site' => '',
   'php_method_uninstall' => '',
   'php_postflight_install' => '',
   'php_postflight_update' => '',
   'php_preflight_install' => '',
   'php_preflight_update' => '',
   'php_site_event' => '',
   'readme' => 'WW91IGNhbiB1c2UgYWxsIHRoZSBub3JtYWwgbWFya2Rvd24sIGluY2x1ZGluZyB0aGUgcGxhY2UtaG9sZGVycy4=',
   'sales_server_ftp' => '0',
   'short_description' => 'RCS Sports Player Rankings',
   'sql' => '',
   'system_name' => 'RCS Sports Rankings',
   'toignore' => '.git',
   'update_server' => '',
   'update_server_ftp' => '0',
   'update_server_target' => '1',
   'website' => 'http://www.tcmsvc.com',
   'whmcs_key' => '',
   'whmcs_url' => '',
   'params' => '',
   'published' => '1',
   'created_by' => '594',
   'modified_by' => '594',
   'created' => '2017-11-02 05:22:57',
   'modified' => '2017-11-09 21:08:55',
   'checked_out' => 0,
   'checked_out_time' => '0000-00-00 00:00:00',
   'version' => '32',
   'hits' => '0',
   'access' => '1',
   'ordering' => '10',
   'metakey' => '',
   'metadesc' => '',
   'metadata' => '{"robots":"","author":"","rights":""}',
))

The import file has a field "metakey" but my database doesn't. Yes we are both on the latest version 2.6.3 ``` stdClass::__set_state(array( 'add_admin_event' => '0', 'add_css' => '1', 'add_email_helper' => '0', 'add_javascript' => '0', 'add_license' => '0', 'add_php_helper_admin' => '0', 'add_php_helper_both' => '0', 'add_php_helper_site' => '0', 'add_php_method_uninstall' => '0', 'add_php_postflight_install' => '0', 'add_php_postflight_update' => '0', 'add_php_preflight_install' => '0', 'add_php_preflight_update' => '0', 'add_placeholders' => '1', 'add_sales_server' => '0', 'add_site_event' => '0', 'add_sql' => '0', 'add_update_server' => '0', 'addfootable' => '0', 'addreadme' => '0', 'adduikit' => '0', 'author' => 'Kevin Campbell', 'bom' => 'default.txt', 'buildcomp' => '0', 'buildcompsql' => '', 'companyname' => 'TCM Services, Inc.', 'component_version' => '1.0.3', 'copyright' => 'Copyright (C) 2017. TCM Services, Inc. All Rights Reserved', 'creatuserhelper' => '0', 'css' => 'LypQbGF5ZXJzIHRhYmxlIHNvcnQgY29sdW1uIGhlYWRlciBmb3JtYXR0aW5nKi8NCnRyLnNvcnRhYmxlIHRoIGltZyB7DQoJbWFyZ2luLWxlZnQ6IDVweDsNCn0NCg0KdHIuc29ydGFibGUgYSB7DQoJZGlzcGxheTogaW5saW5lLWJsb2NrOw0KCWhlaWdodDogMTAwJTsNCn0NCg0KLypCT09UU1RSQVAgTUVESUEgQ1NTKi8NCg0KLm1lZGlhIHsNCgltYXJnaW4tdG9wOiAxNXB4Ow0KICB9DQogIC5tZWRpYTpmaXJzdC1jaGlsZCB7DQoJbWFyZ2luLXRvcDogMDsNCiAgfQ0KICAubWVkaWEsDQogIC5tZWRpYS1ib2R5IHsNCgl6b29tOiAxOw0KCW92ZXJmbG93OiBoaWRkZW47DQogIH0NCiAgLm1lZGlhLWJvZHkgew0KCXdpZHRoOiAxMDAwMHB4Ow0KICB9DQogIC5tZWRpYS1vYmplY3Qgew0KCWRpc3BsYXk6IGJsb2NrOw0KICB9DQogIC5tZWRpYS1vYmplY3QuaW1nLXRodW1ibmFpbCB7DQoJbWF4LXdpZHRoOiBub25lOw0KICB9DQogIC5tZWRpYS1yaWdodCwNCiAgLm1lZGlhID4gLnB1bGwtcmlnaHQgew0KCXBhZGRpbmctbGVmdDogMTBweDsNCiAgfQ0KICAubWVkaWEtbGVmdCwNCiAgLm1lZGlhID4gLnB1bGwtbGVmdCB7DQoJcGFkZGluZy1yaWdodDogMTBweDsNCiAgfQ0KICAubWVkaWEtbGVmdCwNCiAgLm1lZGlhLXJpZ2h0LA0KICAubWVkaWEtYm9keSB7DQoJZGlzcGxheTogdGFibGUtY2VsbDsNCgl2ZXJ0aWNhbC1hbGlnbjogdG9wOw0KICB9DQogIC5tZWRpYS1taWRkbGUgew0KCXZlcnRpY2FsLWFsaWduOiBtaWRkbGU7DQogIH0NCiAgLm1lZGlhLWJvdHRvbSB7DQoJdmVydGljYWwtYWxpZ246IGJvdHRvbTsNCiAgfQ0KICAubWVkaWEtaGVhZGluZyB7DQoJbWFyZ2luLXRvcDogMDsNCgltYXJnaW4tYm90dG9tOiA1cHg7DQogIH0NCiAgLm1lZGlhLWxpc3Qgew0KCXBhZGRpbmctbGVmdDogMDsNCglsaXN0LXN0eWxlOiBub25lOw0KICB9DQovKkVORCBCT09UU1RSQVAgTUVESUEgQ1NTKi8NCg0KdGFibGUucmNzLXRhYmxlIHsNCglmb250LXNpemU6IC45ZW07DQp9DQoNCnRhYmxlLnJjcy10YWJsZSB0aGVhZCB0ciB0aCB7DQoJZm9udC1zaXplOiAxZW07DQp9DQoNCnRhYmxlLnJjcy10YWJsZSB0Ym9keSB0ciB0ZCB7DQoJbGluZS1oZWlnaHQ6IDUwcHg7DQoJdmVydGljYWwtYWxpZ246IG1pZGRsZTsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRoZWFkIHRyIHRoLnBsYXllci1yYW5rLA0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1yYW5rIHsNCgl0ZXh0LWFsaWduOiBjZW50ZXIgIWltcG9ydGFudDsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRoZWFkIHRyIHRoLnBsYXllci1pbWFnZSwNCnRhYmxlLnJjcy10YWJsZSB0Ym9keSB0ciB0ZC5wbGF5ZXItaW1hZ2Ugew0KCXdpZHRoOiA2MHB4ICFpbXBvcnRhbnQ7DQoJdGV4dC1hbGlnbjogY2VudGVyOw0KfQ0KDQp0YWJsZS5yY3MtdGFibGUgdGJvZHkgdHIgdGQucGxheWVyLWltYWdlIGltZyB7DQoJbWF4LWhlaWdodDogNTBweDsNCgltYXgtd2lkdGg6IDUwcHg7DQoJbWFyZ2luOiAwIGF1dG8gIWltcG9ydGFudDsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1uYW1lIHsNCglmb250LXdlaWdodDogYm9sZDsNCglsaW5lLWhlaWdodDogMTVweDsNCn0NCg0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1uYW1lIHNtYWxsIHsNCglkaXNwbGF5OiBibG9jazsNCglmb250LXdlaWdodDogbm9ybWFsOw0KfQ0KDQp0YWJsZS5yY3MtdGFibGUgdGhlYWQgdHIgdGgucGxheWVyLWh0LA0KdGFibGUucmNzLXRhYmxlIHRib2R5IHRyIHRkLnBsYXllci1odCB7DQoJdGV4dC1hbGlnbjogY2VudGVyOw0KCW1heC13aWR0aDogNjBweDsNCn0NCg0KLmNhcmQtcGxheWVyIHsNCgltYXJnaW4tYm90dG9tOiAyNXB4Ow0KfQ0KDQouY2FyZC1wbGF5ZXIgaW1nIHsNCgltYXgtd2lkdGg6IDIwMHB4Ow0KCW1heC1oZWlnaHQ6IDIwMHB4Ow0KfQ0KDQouY2FyZC1wbGF5ZXIgLnBsYXllci1kZXRhaWxzIHsNCgliYWNrZ3JvdW5kLWNvbG9yOiByZ2JhKDI1NSwgMjU1LCAyNTUsIC4zKTsNCglwYWRkaW5nOiA1cHggOHB4Ow0KCWZvbnQtc2l6ZTogLjhlbTsNCgloZWlnaHQ6IDExNnB4Ow0KfQ0KDQouY2FyZC1wbGF5ZXIgLnBsYXllci1kZXRhaWxzIHVsIHsNCglsaXN0LXN0eWxlOiBub25lOw0KCW1hcmdpbjogMDsNCn0NCg0KLmNhcmQtcGxheWVyIC5wbGF5ZXItZGV0YWlscyB1bCBsaSB7DQoJbGluZS1oZWlnaHQ6IDMwcHg7DQoJdmVydGljYWwtYWxpZ246IG1pZGRsZTsNCn0=', 'debug_linenr' => '0', 'description' => 'This component is to track information about sports players, their ranking and related data.', 'email' => 'kevin@tcmsvc.com', 'emptycontributors' => '0', 'export_buy_link' => '', 'export_key' => '', 'export_package_link' => '', 'image' => 'images/rcs_ranking_box.jpg', 'javascript' => '', 'license' => 'GNU/GPL Version 2 or later - http://www.gnu.org/licenses/gpl-2.0.html', 'license_type' => '1', 'mvc_versiondate' => '0', 'name' => 'RCS Sports Rankings', 'name_code' => 'rcsrankings', 'not_required' => '0', 'number' => '4', 'php_admin_event' => '', 'php_helper_admin' => '', 'php_helper_both' => '', 'php_helper_site' => '', 'php_method_uninstall' => '', 'php_postflight_install' => '', 'php_postflight_update' => '', 'php_preflight_install' => '', 'php_preflight_update' => '', 'php_site_event' => '', 'readme' => 'WW91IGNhbiB1c2UgYWxsIHRoZSBub3JtYWwgbWFya2Rvd24sIGluY2x1ZGluZyB0aGUgcGxhY2UtaG9sZGVycy4=', 'sales_server_ftp' => '0', 'short_description' => 'RCS Sports Player Rankings', 'sql' => '', 'system_name' => 'RCS Sports Rankings', 'toignore' => '.git', 'update_server' => '', 'update_server_ftp' => '0', 'update_server_target' => '1', 'website' => 'http://www.tcmsvc.com', 'whmcs_key' => '', 'whmcs_url' => '', 'params' => '', 'published' => '1', 'created_by' => '594', 'modified_by' => '594', 'created' => '2017-11-02 05:22:57', 'modified' => '2017-11-09 21:08:55', 'checked_out' => 0, 'checked_out_time' => '0000-00-00 00:00:00', 'version' => '32', 'hits' => '0', 'access' => '1', 'ordering' => '10', 'metakey' => '', 'metadesc' => '', 'metadata' => '{"robots":"","author":"","rights":""}', )) ```

kevincam3 commented

2017-11-09 21:49:13 +00:00

(Migrated from github.com)

Ok, I'm wrong, mine is 2.6.2, let me upgrade and try again.

Llewellyn commented

2017-11-09 21:52:18 +00:00

I did not see that coming... okay we added metakey to JCB components few update back... and it did not update your database with the new fields. I can give you a string to add, so that it dumps the metadata on import, or you can update your database to have those three new columns.

I think in the core I will add some SQL to add those fields if not found in the next update.

So here is the string to dump them for now on line 1476 of import_joomla_components.php model add these lines:

// remove from this metadata
unset($item->metadata);
unset($item->metadesc);
unset($item->metakey);

I did not see that coming... okay we added **metakey** to JCB components few update back... and it did not update your database with the new fields. I can give you a string to add, so that it dumps the **metadata** on import, or you can update your database to have those three new columns. I think in the core I will add some SQL to add those fields if not found **in the next update**. So here is the string to dump them for now on [line 1476](https://github.com/vdm-io/Joomla-Component-Builder/blob/master/admin/models/import_joomla_components.php#L1476) of [import_joomla_components.php](https://github.com/vdm-io/Joomla-Component-Builder/blob/master/admin/models/import_joomla_components.php#L1476) model add these lines: ``` // remove from this metadata unset($item->metadata); unset($item->metadesc); unset($item->metakey); ```

kevincam3 commented

2017-11-09 21:56:05 +00:00

(Migrated from github.com)

So now it stops with this error:
Unknown column 'access' in 'field list'

So now it stops with this error: Unknown column 'access' in 'field list'

kevincam3 commented

2017-11-09 21:56:56 +00:00

(Migrated from github.com)

Should I just keep unsetting these variables?

Llewellyn commented

2017-11-09 22:02:10 +00:00

For the meta, yes... you see it breaks on the first, so the meta stuff will still bom out once the access one is fixed.

JCB addresses new fields you create by dynamically adding it to SQL updates... but not access and metadata as yet. So when we change a view from not having metadata and not having access to now having it, JCB does not add the SQL needed to update the Database at this point. And I do not think it will be easy to detect. Hmmm painful.... I will have to spend some time on this, to build a stable fix.

Okay so for now yes the metadata stuff must be unset. Let me just check what table was changed with regards to access... so much for trying to keep the JCB packages backward compatible.

I will give you some more code in a moment.

For the meta, yes... you see it breaks on the first, so the meta stuff will still bom out once the access one is fixed. JCB addresses new fields you create by dynamically adding it to SQL updates... but not access and metadata as yet. So when we change a view from not having metadata and not having access to now having it, JCB does not add the SQL needed to update the Database at this point. And I do not think it will be easy to detect. Hmmm painful.... I will have to spend some time on this, to build a stable fix. Okay so for now yes the metadata stuff must be unset. Let me just check what table was changed with regards to access... so much for trying to keep the JCB packages backward compatible. I will give you some more code in a moment.

Llewellyn commented

2017-11-09 22:07:27 +00:00

You do realize we are doing almost the impossible here right! I mean to move a component from one JCB to another is like a crazy complex nightmare...

Since we are not only moving the Joomla Component but all the data down to the field types... and updating all the id relationships to now remap to the new JCB component. The more I work with this area... the more I am thinking it is almost just as much madness as the compiler...lol

You do realize we are doing almost the impossible here right! I mean to move a component from one JCB to another is like a crazy complex nightmare... Since we are not only moving the Joomla Component but all the data down to the field types... and updating all the id relationships to now remap to the new JCB component. The more I work with this area... the more I am thinking it is almost just as much madness as the compiler...lol

kevincam3 commented

2017-11-09 22:12:14 +00:00

(Migrated from github.com)

Hang in there, this will probably be one of the most used features by me because I have a small shop of developers and in this case I started work on the component then I gave it to one of my developers to finish and now he's giving it back to me completed.

Llewellyn commented

2017-11-09 22:15:27 +00:00

I know it is an amazing feature, and I also need it to work flawless...

Llewellyn commented

2017-11-09 22:28:51 +00:00

Here you can see the blame game...

Okay so for now unset access and metadata for all tables, since access it not so major player if you are working as Super User in Joomla. So on line 1236 of import_joomla_components.php add the following in:

// remove access for now
if (isset($item->access))
{
	unset($item->access);
}
// remove from this metadata
if (isset($item->metadata))
{
	unset($item->metadata);
}
// remove from this metadesc
if (isset($item->metadesc))
{
	unset($item->metadesc);
}
// remove from this metakey
if (isset($item->metakey))
{
	unset($item->metakey);
}

Then you don't need to add the previous unset code. Metadata is anyway not yet being used in JCB 👍

Here you can see the [blame game](https://github.com/vdm-io/Joomla-Component-Builder/blame/master/admin/sql/install.mysql.utf8.sql)... Okay so for now unset access and metadata for all tables, since access it not so major player if you are working as Super User in Joomla. So on [line 1236](https://github.com/vdm-io/Joomla-Component-Builder/blob/master/admin/models/import_joomla_components.php#L1236) of [import_joomla_components.php](https://github.com/vdm-io/Joomla-Component-Builder/blob/master/admin/models/import_joomla_components.php#L1236) add the following in: ``` // remove access for now if (isset($item->access)) { unset($item->access); } // remove from this metadata if (isset($item->metadata)) { unset($item->metadata); } // remove from this metadesc if (isset($item->metadesc)) { unset($item->metadesc); } // remove from this metakey if (isset($item->metakey)) { unset($item->metakey); } ``` Then you don't need to add the previous unset code. Metadata is anyway not yet being used in JCB :+1:

kevincam3 commented

2017-11-09 23:16:52 +00:00

(Migrated from github.com)

Ok, the import worked after that change and also the config section is correct this time as well. Maybe it has something to do with my database being different than what it should be when I did the export because my developer installed 2.6.3 for the first time while I've been constantly upgrading since the 2.5.x series

Llewellyn commented

2017-11-10 02:06:18 +00:00

Yea that is why, I mean the DB's did change, yet only slightly...

You should know the JCB package export and import is now more stable and accurate then it ever was before. I spend weeks on it since I use it extensively with all my clients and projects.

So if you run into any more issues on it please report it straight away, to insure we keep it stable 👍

Yea that is why, I mean the DB's did change, yet only slightly... You should know the JCB package export and import is now more stable and accurate then it ever was before. I spend weeks on it since I use it extensively with all my clients and projects. So if you run into any more issues on it please report it straight away, to insure we keep it stable :+1:

Can't rei-mport component #179