ad adding error

when looking at the error logs i see this

"

• [01-Aug-2023 22:17:53 UTC] WordPress database error Table 'ecolabsc_wp758.wpid_wpforo_ads' doesn't exist for query SELECT * FROM `wpid_wpforo_ads` WHERE `start_date` <= '2023-08-01 22:17:53' AND (`end_date` = '0000-00-00 00:00:00' OR `end_date` >= '2023-08-01 22:17:53') AND `forumids` REGEXP '(,|^)(18)(,|$)' AND `tpllocs` REGEXP '(,|^)(bottom)(,|$)' AND NOT `hide_for_groupids` REGEXP '(,|^)(4)(,|$)' AND `status` = 1 ORDER BY RAND() LIMIT 0,1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Section->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Row->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Column->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, do_shortcode, preg_replace_callback, do_shortcode_tag, wpforo\wpforo->{closure}, include('/plugins/wpforo/themes/2022/index.php'), do_action('wpforo_bottom_hook'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo_do_bottom_ads, wpForoAD->get_ads

I have tried to add the table in SQL and get this result

MySQL said: 

#1813 - Tablespace '`ecolabsc_wp758`.`wpid_wpforo_ads`' exists.

the SQL CODE I have tried is

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE `wpid_wpforo_ads` (
`adid` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` text COLLATE utf8mb4_unicode_ci,
`body` longtext COLLATE utf8mb4_unicode_ci,
`start_date` datetime DEFAULT '0000-00-00 00:00:00',
`end_date` datetime DEFAULT '0000-00-00 00:00:00',
`forumids` longtext COLLATE utf8mb4_unicode_ci,
`hide_for_groupids` longtext NOT NULL DEFAULT '',
`tpllocs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `wpid_wpforo_ads`
ADD PRIMARY KEY (`adid`),
ADD KEY `start_date` (`start_date`),
ADD KEY `end_date` (`end_date`),
ADD KEY `tpllocs` (`tpllocs`(191)),
ADD KEY `status` (`status`);

ALTER TABLE `wpid_wpforo_ads`
MODIFY `adid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

i have tried dropping the table to recreate but for some reason SQL cannot find the table wpid_wpforo_ads but if i try and create it says the table exists??

Hi @natalie-jevric,

Please pm me the administrator login details. We'll try to fix the issue.