Hi,
First, I am not sure what you tried to do with the config.php. Try to be exact with the name of the files, the config files for WordPress is called “wp-config.php”, there is no config.php, or maybe there is in your install and in that case it’s something unusual. Also the fact you got to the install page is irrelevant, it can’t be linked to WP/LR Sync at all, it just can’t happen. I think this is something else, maybe you tried to find a fix and things happened. But I don’t see any technical explanation to this, it’s impossible. So it’s better to focus on the real issue.
This warning is very unusual, you shouldn’t get this (first time I hear). It’s a standard query ran by PHP and it fails; basically there is a failure between a very standard function of PHP and your MySQL server (are you actually using MySQL, or a unusual install of WordPress with a different system?). WP/LR Sync doesn’t call this function (mysqli_set_charset) directly. It creates a table in the database through WordPress standard API. WordPress tries to call mysqli_set_charset() and it fails, this is what is happening. That issue will happen with many other plugins as well. But in most case it would be fine because it’s not a critical error. In WP/LR Sync case however, I don’t allow any error to happen during the process. If there is one, even a warning, the process stops (for safety).
The problem will not be easy to fix. On my side, I can’t do anything, the table is created naturally through WordPress API, so obviously I can’t correct it or make it better. On your side, the best would be to try with another hosting service. That is quite a change, but I am pretty sure that all your issues will go away. Might be linked to a server configuration issue, an old version of PHP or MySQL. It can be many things. You can also try to google the issue, there might be a way to resolve this issue (but you can’t guess what the real issue is and how to fix it exactly, so you need to try too many ways, and they are basically hacks to fix an issue of your server/config).
Don’t worry about the plugin, I can guarantee you, it works. I take care of it every day with so many users. Fix your install, you will run into issues again and again. But really, the best is to “run away” from your hosting service, I feel like something is really wrong there.
OK so I found the issue. Your plugin I’m sure works just fine.
My host does not permit the number of queries this plugin attempts to issue.
The result is: they prohibit me accessing my own site, due to my IP is blocked.
I can still access the site itself, it seems like, but not the admin side.
Host-specific issue, apparently. Plugin won’t work. Due to: I have too many images on the site, so when I try to “sync all” or whatever the menu item is called, I get IP banned for 1 hour.
-
This reply was modified 9 years, 7 months ago by
sdc9007.
-
This reply was modified 9 years, 7 months ago by sdc9007.
In that case, I see what the problem is. The previous issues are all linked to the fact that your IP was blocked.
The number of SQL queries it not the issue, the problem is the number of connections you are making to the server (1 per photo, and if you computer is fast that can be every few seconds). This number of queries isn’t actually high at all but not-so-good hosting services prefer to block them as soon as possible (might be someone trying to guess your password). That was good 4-5 years ago but now… :/
Normally, using the REST method (plugin settings in LR), there is no such issue. But using the XML/RPC method, that used to happen. You are not using REST? (normally it’s default)
In any case, your hosting service can either whitelist your IP address or allow those requests to be made and that will work 🙂
Yes I read through all the step by step instructions, I was using REST at the time, and it’s still set to that. My web host stated that the total requests per hours was limited to 75,000 — which , with about 3,600 photos seemed odd to me that I was blocked. But it seemed like I was blocked the first time I tried using the Library > Plugin Extras > Total Synchronization… I tried a few times because each time it would give me the error, I’d try changing a setting here or there. But it never got past about 80 photos in the attempt.
-
This reply was modified 9 years, 7 months ago by sdc9007.
The Total Synchronization is the most intense part of WP/LR Sync, by far, and indeed, it will perform 2-3 requests per photo (not more than that). You can set a timer between each request in the settings of the plugin in LR, like every 4-5 seconds, that will slow down the process a lot though…
