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.

Problem with WPforo Ads

wpForo Ads Manager

Last Post by Astghik 5 years ago

2 Posts

2 Users

0 Reactions

1,013 Views

RSS

Posts: 2

Nikita Klimov

Customer

Topic starter

Apr 19, 2020 5:48 pm

(@niklimoff01)

Member

Joined: 6 years ago

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

1 Reply

Posts: 6444

Astghik

Admin

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;