Notifications
Clear all

ad adding error

5 Posts
2 Users
0 Reactions
802 Views
Posts: 4
Customer
Topic starter
(@natalie-jevric)
Member
Joined: 3 years ago

I have issues with WPFORO ads manager

I have put in my new key for version Version 3.0.2 when i go into plugins i see there is a new version 3.0.3 however i cannot install this on my version of wordpress WordPress 6.2.2

if i just try and make a ad i get the "ad adding error" i have tried the text mode as well and just put in test for the heading and body.. no luck.

I have checked the database and have the table "wp_wpforo_ads"

thank you in advance.

4 Replies
Posts: 4
Customer
Topic starter
(@natalie-jevric)
Member
Joined: 3 years ago

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: Documentation

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

Reply
Posts: 4
Customer
Topic starter
(@natalie-jevric)
Member
Joined: 3 years ago

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;

 

Reply
Posts: 4
Customer
Topic starter
(@natalie-jevric)
Member
Joined: 3 years ago

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??

Reply
Posts: 4208
 Tom
Admin
(@tomson)
Famed Member
Joined: 9 years ago

Hi @natalie-jevric,

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

Reply
Share:
Scroll to top