fbpx

204,593+ downloads

0
  Wednesday, 24 November 2021
  8 Replies
  825 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
1 year ago
·
#6453
I’ve read that and it doesn’t help at all
1 year ago
·
#6454


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

And what about my other error?
Hi,
You need to run the query in phpmyadmin.

Thank You
1 year 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?
And copy and paste what you said the solution to the problem was into that?


can you explain what you mean by this?
12 months 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?
12 months 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