Installation Issues

  • Erik Edgington
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 days ago #123833 by Erik Edgington
Installation Issues was created by Erik Edgington
I keep getting errors when installing the zip. This is what I get but not sure where to go from here. Any help is appreciated.

Warning
JInstaller: :Install: Error SQL Unknown column 'show_on_public_registrants_list' in 'field list'
Extension Install: SQL error processing query: DB function failed with error number 1054
Unknown column 'show_on_public_registrants_list' in 'field list'
SQL =
INSERT IGNORE INTO `#__eb_fields` (`id`, `event_id`, `name`, `title`, `description`, `field_type`, `required`, `values`, `default_values`, `fee_field`, `fee_values`, `fee_formula`, `display_in`, `rows`, `cols`, `size`, `css_class`, `field_mapping`, `access`, `ordering`, `show_on_public_registrants_list`, `published`, `filterable`, `hide_for_first_group_member`, `not_required_for_first_group_member`, `newsletter_field_mapping`, `server_validation_rules`, `language`, `datatype_validation`, `discountable`, `extra_attributes`, `show_in_list_view`, `depend_on_field_id`, `depend_on_options`, `max_length`, `place_holder`, `multiple`, `validation_rules`, `validation_error_message`, `quantity_field`, `quantity_values`, `only_show_for_first_member`, `only_require_for_first_member`, `hide_on_email`, `hide_on_export`, `show_on_registrants`, `receive_confirmation_email`, `pattern`, `min`, `max`, `step`, `is_searchable`, `is_core`, `fieldtype`, `category_id`) VALUES
(1, -1, 'first_name', 'First Name', '', 1, 1, '', '', 0, '', '', 0, 0, 0, 0, 'input-large', '', 1, 1, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, 'validate[required]', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(2, -1, 'last_name', 'Last Name', '', 1, 1, '', '', 0, '', '', 0, 0, 0, 0, '', NULL, 1, 2, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '[]', 0, '', 0, '', '', 0, '', 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(3, -1, 'organization', 'Organization', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 3, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, '', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(4, -1, 'address', 'Address', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 4, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(5, -1, 'address2', 'Address 2', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 5, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(6, -1, 'city', 'City', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 6, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(7, -1, 'zip', 'Zip', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 7, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(8, -1, 'country', 'Country', '', 3, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 8, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Countries', -1),
(9, -1, 'state', 'State', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 9, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '[]', 0, '', 0, '', '', 0, '', 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'State', -1),
(10, -1, 'phone', 'Phone', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 10, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, '', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(11, -1, 'fax', 'Fax', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 11, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, '', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(12, -1, 'email', 'Email', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 12, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '[]', 0, '', 0, 'validate[required,custom

Please Log in or Create an account to join the conversation.

More
7 years 1 day ago #123837 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Installation Issues
Hello Erik

Look like the error happens because you have data already in database before performing installation. Please submit a support ticket sending us super admin account of your site, we are going to check to see why the issue happens and get it sorted

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #128088 by Sitiveni Nabuka
Replied by Sitiveni Nabuka on topic Installation Issues
Hi Tuan.

I have the same issue when installing the extension. Appreciate your advice please.

Error messages are as below
.........................

Warning
JInstaller: :Install: Error SQL Unknown column 'show_on_public_registrants_list' in 'field list'
Extension Install: SQL error processing query: DB function failed with error number 1054
Unknown column 'show_on_public_registrants_list' in 'field list'
SQL =
INSERT IGNORE INTO `#__eb_fields` (`id`, `event_id`, `name`, `title`, `description`, `field_type`, `required`, `values`, `default_values`, `fee_field`, `fee_values`, `fee_formula`, `display_in`, `rows`, `cols`, `size`, `css_class`, `field_mapping`, `access`, `ordering`, `show_on_public_registrants_list`, `published`, `filterable`, `hide_for_first_group_member`, `not_required_for_first_group_member`, `newsletter_field_mapping`, `server_validation_rules`, `language`, `datatype_validation`, `discountable`, `extra_attributes`, `show_in_list_view`, `depend_on_field_id`, `depend_on_options`, `max_length`, `place_holder`, `multiple`, `validation_rules`, `validation_error_message`, `quantity_field`, `quantity_values`, `only_show_for_first_member`, `only_require_for_first_member`, `hide_on_email`, `hide_on_export`, `show_on_registrants`, `receive_confirmation_email`, `pattern`, `min`, `max`, `step`, `is_searchable`, `is_core`, `fieldtype`, `category_id`) VALUES
(1, -1, 'first_name', 'First Name', '', 1, 1, '', '', 0, '', '', 0, 0, 0, 0, 'input-large', '', 1, 1, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, 'validate[required]', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(2, -1, 'last_name', 'Last Name', '', 1, 1, '', '', 0, '', '', 0, 0, 0, 0, '', NULL, 1, 2, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '[]', 0, '', 0, '', '', 0, '', 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(3, -1, 'organization', 'Organization', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 3, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, '', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(4, -1, 'address', 'Address', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 4, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(5, -1, 'address2', 'Address 2', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 5, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(6, -1, 'city', 'City', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 6, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(7, -1, 'zip', 'Zip', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 7, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(8, -1, 'country', 'Country', '', 3, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 8, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, NULL, 0, '', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Countries', -1),
(9, -1, 'state', 'State', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 9, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '[]', 0, '', 0, '', '', 0, '', 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'State', -1),
(10, -1, 'phone', 'Phone', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 10, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, '', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(11, -1, 'fax', 'Fax', '', 1, 0, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 11, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '', 0, '', 0, '', '', 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 1, 'Text', -1),
(12, -1, 'email', 'Email', '', 1, 1, '', '', 0, '', '', 3, 0, 0, 0, 'input-large', NULL, 1, 12, 0, 1, 0, 0, 0, '', '', '*', 0, 1, '', 0, 0, '[]', 0, '', 0, 'validate[required,custom

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #128113 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Installation Issues
Hello

There must be something special on your site causing the error. Please submit a support ticket sending us super admin account of your site so that I can check and install it for you

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #128117 by Sitiveni Nabuka
Replied by Sitiveni Nabuka on topic Installation Issues
Thank You.

Have created a ticket (#435475) and updated the details on the ticket.

Thanks.

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #128165 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Installation Issues
Just want to update that we worked together via support ticket and get the issue sorted

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc