Problem with WPforo Ads

✦ Summarize Topic

wpForo Ads Manager

Last Post by Astghik 6 years ago

2 Posts

2 Users

0 Reactions

1,426 Views

RSS

Posts: 2

Nikita Klimov

Customer

Topic starter

Translate ▼

Apr 19, 2020 5:48 pm

(@niklimoff01)

Member

Joined: 6 years ago

[#5766]

Hi!

I have a problem with ads plugin. It's calls apache error with database requests. I tivate this plugin, but error repeats. It's calls error 504 with some users.

There are apache logs:

Apr 18 00:00:02 vh240 apache_error[12352]: www.egmrm.ru [Sat Apr 18 00:00:02 2020] [notice] [pid 31866] sapi_apache2.c(351): [client 2a01:4f8:192:8108::2:34974] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Table '******_***.wp_wpforo_ads' doesn't exist \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT count(*) FROM `wp_wpforo_ads` WHERE `start_date` <= '2020-04-17 21:00:02' AND (`end_date` = '0000-00-00 00:00:00' OR `end_date` >= '2020-04-17 21:00:02') AND `forumids` REGEXP '(,|^)(2)(,|$)' AND `tpllocs` REGEXP '(,|^)(top)(,|$)' AND NOT `hide_for_groupids` REGEXP '(,|^)(4)(,|$)' AND `status` = 1, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/backstreet/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, wpforo_load, wpforo_init_template, include('/plugins/wpforo/wpf-themes/classic/index.php'), include('/plugins/wpforo/wpf-themes/classic/header.php'), do_action('wpforo_top_hook'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo_do_top_ads, wpForoAD->get_ads

I was disabled plugin, but it's continued to generate this error.

Than I was added table wp_wpforo_ads to database, and than server was generates that:

www.egmrm.ru [Sat Apr 18 21:34:30 2020] [warn] [pid 13024] sapi_apache2.c(351): [client 186.2.160.209:58574] PHP Warning: vsprintf(): Too few arguments in /****/*/******/***/*****/wp-includes/wp-db.php on line 1397
www.egmrm.ru [Sat Apr 18 21:34:30 2020] [warn] [pid 13024] sapi_apache2.c(351): [client 186.2.160.209:58574] PHP Warning: mysqli_query(): Empty query in /*/*/******/***/********/wp-includes/wp-db.php on line 2030

Than in /wpforo-ad-manager/wpforoad.php I was commented function 'get_ads', but problem doesn't solved.

Help please!

My forum link is: https://egmrm.ru/forums

Topic Tags

1 Reply

Posts: 6645

Astghik

Admin

Translate ▼

Apr 20, 2020 11:54 am

(@astgh)

Illustrious Member

Joined: 8 years ago

Hi@niklimoff01,

Please deactivate the addon then activate it again. Delete all caches and check again. The issue should be solved. If it doesn't help Use the Hosting Service cPanel > phpMyAdmin database manager tool and execute this SQL:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `wp_wpforo_ads` (
	`adid` bigint unsigned NOT NULL AUTO_INCREMENT,
	`title` varchar(255) DEFAULT NULL,
	`code` text,
	`body` longtext,
	`start_date` datetime DEFAULT '0000-00-00 00:00:00',
	`end_date` datetime DEFAULT '0000-00-00 00:00:00',
	`forumids` longtext NOT NULL DEFAULT '',
	`tpllocs` varchar(255)  NOT NULL DEFAULT '',
	`hide_for_groupids` longtext NOT NULL DEFAULT '',
	`status` tinyint(1) unsigned NOT NULL DEFAULT 1,
	PRIMARY KEY (`adid`),
	KEY `start_date` (`start_date`),
	KEY `end_date` (`end_date`),
	KEY `tpllocs` (`tpllocs`),
	KEY `status` (`status`)
)ENGINE=INNODB;