Notifications

Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed. We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

ad adding error

wpForo Ads Manager

Last Post by Tom 2 years ago

5 Posts

2 Users

0 Reactions

1,283 Views

RSS

Posts: 4

NatJev

Customer

Topic starter

Aug 01, 2023 10:34 am

(@natalie-jevric)

Member

Joined: 4 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

NatJev

Customer

Topic starter

Aug 02, 2023 3:48 am

(@natalie-jevric)

Member

Joined: 4 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:

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

Posts: 4

NatJev

Customer

Topic starter

Aug 02, 2023 3:49 am

(@natalie-jevric)

Member

Joined: 4 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;

Posts: 4

NatJev

Customer

Topic starter

Aug 02, 2023 3:57 am

(@natalie-jevric)

Member

Joined: 4 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??