fbpx
  Wednesday, 24 November 2021
  8 Replies
  2.1K 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
2 years ago
·
#6453
I’ve read that and it doesn’t help at all
2 years ago
·
#6454


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

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

Thank You
2 years ago
·
#6461
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?
2 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?
2 years ago
·
#6477
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?
2 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