gVectors Team

Professional WordPress Plugins and Services. wpDiscuz, WooDiscuz, Advanced Post Pagination

Forums
wpForo Addons Suppo...
wpForo Official Add...
wpForo Ads Manager
Problem with WPforo...
 
Notifications
Clear all

Problem with WPforo Ads

 
wpForo Ads Manager
Last Post by Astghik 5 years ago
2 Posts
2 Users
0 Reactions
967 Views
RSS
Posts: 2
 Nikita Klimov
Customer
Topic starter
Apr 19, 2020 5:48 pm
(@niklimoff01)
Member
Joined: 5 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
Astghik
Posts: 6332
 Astghik
Admin
Apr 20, 2020 11:54 am
(@astgh)
Illustrious Member
Joined: 7 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;
Reply
Forum Jump:
  Previous Topic
Next Topic  
Share:
Scroll to top