Database error

  • Ivar Johansen
  • Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 7 months ago #145728 by Ivar Johansen
Database error was created by Ivar Johansen
There is no auto increment on the id of eb_events table. If I try to set auto increment it wouldn't allow me to, getting that the datetime format is wrong.
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.

More
2 years 7 months ago #145733 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Database error
Hello Ivar

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.

More
2 years 7 months ago #145864 by shanenefdt
Replied by shanenefdt on topic Database error
Good day, I seem to have a related error when trying to install on this particular site:

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.

More
2 years 7 months ago #145869 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Database error
Hello

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.

More
2 years 7 months ago #145876 by shanenefdt
Replied by shanenefdt on topic Database error
Yes, I've just had a look now - Events Booking was installed a few years back - it appears that not all the types were uninstalled at the the time of uninstall.

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.

More
2 years 7 months ago #145877 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Database error
Hello

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.

Moderators: Tuan Pham Ngoc