Tigr
Forum Replies Created
-
Forum: Plugins
In reply to: [WP Activity Log] Syntax error (%d not replaced)Can you already fix it, please? The logs are filling up with the errors:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%d ORDER BY created_on ASC LIMIT 1470' at line 1 for query SELECT * FROM x_wsal_occurrences WHERE created_on < %d ORDER BY created_on ASC LIMIT 1470 made by do_action_ref_array, call_user_func_array, WpSecurityAuditLog->CleanUp, call_user_func, WSAL_Loggers_Database->CleanUp, WSAL_DB_OccurrenceQuery->DeleteTurned out that the provider’s servers are sometimes super slow. Most of the time, the hosting DNS will return an answer immediately:
real 0m0.012sBut sometimes, and I managed to catch it, the DNS will return very slowly. This couple of times, just over 10 seconds:
root@wp:/etc# time nslookup www.google.com 213.133.99.99 Server: 213.133.99.99 Address: 213.133.99.99#53 Non-authoritative answer: Name: www.google.com Address: 173.194.112.16 ... real 0m10.010s user 0m0.008s sys 0m0.004sI guess that’s what causes the timeouts to happen. I think curl’s default timeout is five seconds, isn’t it? And the problem is intermittent, so it is hard to catch (and believe). Most of the time things work but sometimes they just fail unpredictably.
So I changed my resolv.conf to use the servers of Google and OpenDNS. Hopefully, this will finally resolve the problem.
nameserver 208.67.222.222 nameserver 208.67.220.220 nameserver 8.8.8.8 nameserver 8.8.4.4Nope. Sorry. I was in too much hurry to celebrate 🙁 The errors started again.
The annoying thing is that there are two sites on the same server, under the same apache, running the same SNAP. One of them gives these errors while the other doesn’t. It must be some plugins or theme difference then, what else?
For me, the problem seems to have been that the server configuration forbids url_fopen calls but the fact is somehow not reflected in the ini_get(‘allow_url_fopen’) variable. Setting the allow_url_fopen to Off in the .htaccess
php_value allow_url_fopen off
convinced the server that fopen is not available and stopped the annoying messages. At least I did not see any for the past few hours…Ah, there is a separate set of settings for custom posts:
2056 E_NOTICE User creates a custom field for a custom post
2057 E_NOTICE User updates a custom field for a custom post
2058 E_NOTICE User deletes a custom field from a custom post
2063 E_NOTICE User updates a custom field name for a custom postI did not realize that and I have custom posts. Thank you, that should take care of the problem.
Forum: Plugins
In reply to: [WP RSS Multi Importer] Duplicate posts in AutoPostAll posts have unique permalink, it is exactly the same in duplicates. I am not seeing duplicates in the RSS feed, only in autoposted items. Besides, the posts of WP sees duplicates while the AutoPost list of posted items does not see duplicates, it thinks there is only a single post. I upgraded to 3.13, hopefully that solves everything, I will report. The server is running UNIX cron, by the way, so there should not be a problem of concurrency.
Forum: Fixing WordPress
In reply to: Run wp-cron.php from cron: correct syntax?Hi!
AFAIK, you do not need any parameters to wp-cron.php. If that doing_wp_cron parameter is not set, the WP will understand you are calling it from an external script and will try to get a lock and continue its job.
Tigr
Forum: Plugins
In reply to: [WP Activity Log] Logs are not truncatedHi!
The wp-cron function has not been altered in any way, it is stock. Other automated jobs operate normally.
I did truncate the two tables, removing all old alerts.
Tigr
Forum: Plugins
In reply to: [WP Activity Log] Logs are not truncatedAnd the same goes on in non-multisite environment. Plugin simply does not truncate logs. I am going to truncate the DB tables now as I do not see what else I can do, there are over a million rows and inserts are becoming slow. Can you guys fix it or something, please?
Forum: Plugins
In reply to: [WP Activity Log] Logs are not truncatedOkay… and when plugin is deleted, the logs are not removed either. Any thoughts on why?
Forum: Themes and Templates
In reply to: [Wix] AJAX or Javascript error – wp-admin/load-scripts.phpHi, Tschuliaaa!
I am sorry, I did not look into it. I just noticed that the way they load theme options into the admin panel broke things, so I disabled that. I do not need theme options anyhow.
Cheers,
AlbertForum: Themes and Templates
In reply to: [Wix] AJAX or Javascript error – wp-admin/load-scripts.phpComment out this line in functions.php:
require_once('theme-option/fasterthemes.php');and everything will be back to normal (if not – rename the theme-option directory to something else to be sure). You don’t need those options probably anyway.
Forum: Fixing WordPress
In reply to: Resolving XMLRPC.PHP DDOS attack with htaccess redirect?I have a botnet attacking my site. I noticed that all of the requests have a particular agent:
"Mozilla/4.0 (compatible; Win32; WinHttp.WinHttpRequest.5)"So I redirect them in .htaccess all back to themselves:
# Block attackers by agents <IfModule mod_rewrite.c> RewriteCond %{HTTP_USER_AGENT} ^.*WinHttp\.WinHttpRequest\.5.*$ RewriteRule .* http://%{REMOTE_ADDR}/ [R,L] </IfModule>Forum: Plugins
In reply to: [Subscribe2 - Form, Email Subscribers & Newsletters] Changelog for 10.6?The log has labels for releases, the latest label is 10.3. How do I know what changes went into the transition 10.5->10.6?
Forum: Plugins
In reply to: [Subscribe2 - Form, Email Subscribers & Newsletters] Changelog for 10.6?It’s even worse there, the log stops at 10.3.