- Issue created by @dineshreddymathuku
- Status changed to Needs review
almost 2 years ago 8:28am 24 January 2023 - ๐ฎ๐ณIndia dineshreddymathuku Bangalore
Login in to your DB admin
Then RUN this query to create a table CREATE TABLE statement for search_api_task:CREATE TABLE `search_api_task` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) DEFAULT NULL,
`server_id` varchar(50) DEFAULT NULL,
`index_id` varchar(50) DEFAULT NULL,
`data` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for search_api_task entities.';After creating this table clear cache it would be fixed.
- ๐ฎ๐ณIndia dineshreddymathuku Bangalore
using above solution we can avoid the issue but need some permanent solution
- ๐ฎ๐ณIndia dharmeshbarot Gujarat
Try to run update.php it may work!
- ๐ฎ๐ณIndia dineshreddymathuku Bangalore
Hi dharmeshbarot tried that as well but no use still facing same issue thats why need to run above query
- Status changed to Postponed: needs info
over 1 year ago 4:06pm 4 March 2023 - ๐ฆ๐นAustria drunken monkey Vienna, Austria
The
search_api_task
table should be created when installing the Search API module, and it definitely works in almost all cases. (For instance, most of our automated tests โ would fail if that werenโt the case. But also, there would be a lot more issues complaining about this.) So, it appears there is something specific about your setup that causes the installation to not work as expected.
Have you tried uninstalling and then reinstalling the Search API module? If so, and it didnโt work, are there any error log messages? Do you have any special modules installed that affect how content entities are stored, or that modify database functionality in a fundamental way?