- Posts: 1
- Thank you received: 0
Database error
- Ivar Johansen
- Topic Author
- Offline
- New Member
Joomla 3.9.28
Event Booking 3.16.2,
mysql 8.0.6
php 7.4.21
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
I would say that it causes by something special on your server, I saw 2 or 3 customers had that issue few years ago
For this, please submit a support ticket sending us:
- Super admin account of your site
- Give me access to your site database via PHPMYADMIN
I will look at it, add the primary key for you manually
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- shanenefdt
- Offline
- New Member
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
Kindly assist...
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
Base on the error message, I guess you install the extension on a site which has Events Booking data in database already?
Could you please submit a support ticket sending us super admin account of your site so that I can get the extension installed properly for you ?
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- shanenefdt
- Offline
- New Member
I was to begin implementing the newer version as I'm impressed with the simplicity and efficiency.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
Please follow my instructions in the support ticket and the issue should be sorted
Regards,
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.