fbpx
  Wednesday, 24 November 2021
  8 Replies
  2.4K Visits
  Subscribe
I’m getting 2 errors

“SQLSTATE[HY000]: General error: 1 near "(": syntax error” when I go to the products page

And

“Warning #__sellacious_seller_timings doesn’t exist” when I select a seller
3 years ago
·
#6450
Hi,
pls refer to this thread. https://www.sellacious.com/community-support/4909-sellacious-beta3-warning-__sellacious_seller_timings-doesn-t-exist

thanks
3 years ago
·
#6453
I’ve read that and it doesn’t help at all
3 years ago
·
#6454
Quoted from Indresh Maurya on Wednesday, 24 November 2021
Hi,
pls refer to this thread. https://www.sellacious.com/community-support/4909-sellacious-beta3-warning-__sellacious_seller_timings-doesn-t-exist

thanks


How would I create the tables tho? I’m very new to this.

And what about my other error?
3 years ago
·
#6455
Hi,
You need to run the query in phpmyadmin.

Thank You
3 years ago
·
#6461
Quoted from Indresh Maurya on Thursday, 25 November 2021
Hi,
You need to run the query in phpmyadmin.

Thank You


And copy and paste what you said the solution to the problem was into that?
3 years ago
·
#6469
And copy and paste what you said the solution to the problem was into that?


can you explain what you mean by this?
3 years ago
·
#6477
Quoted from Indresh Maurya on Monday, 29 November 2021
And copy and paste what you said the solution to the problem was into that?


can you explain what you mean by this?


What do I put into the query?
3 years ago
·
#6478
Hi, pls run this query after changing the table prefix

CREATE TABLE IF NOT EXISTS `#__sellacious_seller_timings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`seller_uid` int(11) NOT NULL,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`week_day` int(11) NOT NULL,
`from_time` time NOT NULL DEFAULT '00:00:00',
`to_time` time NOT NULL DEFAULT '00:00:00',
`full_day` tinyint(1) DEFAULT NULL,
`slot_window` int(11) NOT NULL,
`slot_window_unit` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`today_availability` time NOT NULL DEFAULT '00:00:00',
`state` tinyint(1) NOT NULL DEFAULT 1,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) NOT NULL,
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) NOT NULL,
`params` text COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__sellacious_product_seller_slot_limits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`seller_uid` int(11) NOT NULL,
`product_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,
`slot_limit` int(11) NOT NULL,
`slot_count` int(11) 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