fbpx
  Friday, 18 September 2020
  1 Replies
  3K Visits
  Subscribe
Hi there

When i go to update to Beta3 from Beta2 I get the folllowing error:

Warning
JInstaller: :Install: Error SQL Table 'yoop_jonny.#__sellacious_order_delivery_slot' doesn't exist
Extension Update: SQL error processing query: DB function failed with error number 1146
Table 'yoop_jonny.#__sellacious_order_delivery_slot' doesn't exist
SQL =
ALTER TABLE `#__sellacious_order_delivery_slot`
ADD `source` VARCHAR(25) NOT NULL AFTER `full_day`;
Package Update: There was an error installing an extension: com_sellacious.zip

Thanks
3 years ago
·
#5084
Hey,

I have checked in our local system by updating beta3, there is no such error is showing. However, if error is still showing on your system, please create a table manually:

CREATE TABLE IF NOT EXISTS `#__sellacious_order_delivery_slot` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_item_id` int(11) NOT NULL,
`slot_from_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`slot_to_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`full_day` TINYINT(1) NOT NULL,
`source` VARCHAR(25) NOT NULL,
`status` tinyint(1) NOT NULL,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


Hope this helps,
Thanks
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
  • +1 (408) 821-8283
  • Email hello@sellacious.com