janbecket
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: login page inaccessibleThree plugins had been modified in 2022, so I turned them off and the login page came up. They were Jetpack, wp-optimize and iThemes security pro. Not sure which one is the offending party. I turned them back on and the login page still appears. I probably need to shut down the computer and try logging in again. At least I know the routine now. Thanks much for the suggestion.
Forum: Fixing WordPress
In reply to: login page inaccessibleOK – thanks. Will try that. I think Iʻm using one of the twenty themes – forget which one.
Forum: Fixing WordPress
In reply to: login page inaccessibleI have not made any recent changes to my site and had been logging in with no problems. In any case, how can I disable plugins or switch themes if I cannot log into my site? I am locked out.
Forum: Fixing WordPress
In reply to: login page inaccessibleI just tried resetting my password. The login link after the new password has been saved also bypasses the login page and goes directly to the “lost your password?” page. There is no way to log in.
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)Thanks for the detailed reply, @bcworkz. I changed the charset in wp-config.php file in malamahalawa.org to ‘utf8’ – perhaps that will help. No way to tell until the next WP update, though. In the meanwhile, I repaired the site and plan to copy page text to files in Libre Office, saved as UTF-8 text. That way, if it happens again, at least the repair job will be just copy and paste.
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)While I was rooting about in my C-Panel, I did similar checks on my top-level WP installation on my janbecket.net site, just to see if there are discrepancies there. The only difference is that wp-config.php file shows a DB–CHARSET of UTF8, not UTF8mb4, as in the add-on domain malamahalawa.org. Otherwise, everything appears similar.
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)Excellent directions – I was able to verify (almost) everything:
“I’m increasingly convinced there’s a charset discrepancy in the malamahalawa.org database. Mainly based on data being corrupted during updates only on this site. First look at your wp-config.php file. Verify that the DB_CHARSET definition is either blank or utf8 [It is UTF8mb4] and that the DB_COLLATE is either blank [blank] or contains utf8 within the value, for example utf8_general_ci would be acceptable. Note the DB_NAME while you’re here for future reference.
“Now access phpMyAdmin through the malamahalawa.org hosting control panel. There should be a box titled “Database Server”, be sure the charset in the box is UTF-8. [It is UTF8] Click the Databases tab and locate the previously noted DB_NAME value in the list. Confirm the collation has utf8 in the listed value somewhere. [Did not see UTF8 listed boefore clicking on the DB name] Click on the DB name.
“You should see a list of tables. Click on wp_posts. The “wp_” may be something else, but “posts” is always the same. Click the Structure tab. Right below “Structure” tab, you want the table structure, not relation view. Scan down the Collation column. All columns are typically the same, but it’s not required, as long as the columns with visible content like post_title and post_content have “utf8” in the name somewhere. [14 of the 23 rows were UTG8mb4_unicode_ci. The rest were blank]
“At the botttom of the page should be an information box with row statistics. The collation here should also have “utf8 in it. [It had UTG8mb4_unicode_ci] Also check the wp_options table in the same manner. [Same results] For thoroughness you can check the other tables too, but a charset mismatch is less critical in the other tables. [All other tables had either blank rows or UTG8mb4_unicode_ci]“
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)Thanks much for the detailed roadmap. Itʻs at the upper limit of my pay grade, but I think I can do that. Iʻll get on it and post the results in a day or two.
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)Hello @bcworkz,
I posted this issue over at the Apple support forum and received a reply:
https://discussions.apple.com/message/31158597?ac_cid=op123456#31158597
Basically, it is not possible for the Mac to enter anything other than UTF-8 characters. The conclusion there is that WordPress is doing something to convert the characters to Latin-1 characters in UTF-8:”But there’s no way as far as I know that your mac could generate anything other than utf-8 using the Apple Hawaiian keyboard. It seems like the WordPress page edit window system must somehow be converting that to Latin one.”
Where to go from here?
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)I included both Hawaiian diacritical marks (ʻokina and kahakō) in my last post, and they look OK, at least on my Mac. If they display correctly for others here, then it seems that they should also on malamahalawa.org. Please let me know if they do not display correctly on your end. Thanks!
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)Thanks for the additional info, bcworkz. Much appreciated. The puzzling thing is that I use the same Mac/Hawaiian character set to create pages on my own site, and have had no issues there. (The malamahalawa.org site, as I mentioned earlier, is an add-on domain, a separate folder inside my public folder, with its own installation of WordPress.) Here is just one example of a page on my personal site using Hawaiian diacritical marks (ʻokina and kahakō) – some curriculum:
http://janbecket.net/wordpress/?p=82
The pages on the malamahalawa.org site all display the diacritical marks correctly on a wide range of computers, both Mac and PC, and are only changed when there is a WordPress update, as they were with the update to 4.7. The ʻokina, by the way, is just the left side of a quotation within a quotation – one that uses single quote marks instead of double ones. The long kahakō is the same as the macron in Latin.
Your reply gave me the idea of running text through Libre Office and then saving it as text only and pasting it into the site, rather than directly composing the text on the edit page window. If there is a weird issue with the character set, perhaps that will strip it out. In any case, I might post the issue on the Mac forum to see if others have experienced the same problem.
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)The character set I am using for Hawaiian diacritical marks is an option in the Mac OSX system. Hawaiian language is one of the foreign languages available on the Mac, similar to selecting French, German or Spanish. I was using that character set when I created the website. I assume that the Mac character sets all conform to UTF-8. It would be odd if just the Hawaiian diacritical marks are affected by WP updates, but not French or Spanish or German ones.
Forum: Fixing WordPress
In reply to: WP update totally messed up my site (again)Hello Davood. Any help is much appreciated. I am running theme 2015, and have very minimal plugins: UpdraftPlus and Disable Comments. I do have UpdraftPlus backups of the site on my Dropbox, although I am totally unclear on the process of rolling back the site to the previous state.
As I stated in my previous post, this is an add-on site, running under my principal site, janbecket.net. It is odd that the wordpress section of my own site is not affected by updates, but that the add-on site is affected.
By the way, I just logged on to my malamahalawa.org dashboard and have found to my relief that the “edit pages” pages are not blank as they were the last time. I had assumed that they would be blank, as before. This will save me much time in restoring the site. The messed-up Hawaiian diacritical marks, however, are as you can see them – messed up.
Forum: Fixing WordPress
In reply to: Update to 4.6.1 erases all text on page edit windows@ Jackie, thanks for the offer of help on this issue. I have had to go on an extended trip – hence the absence of a response from me. I do not have access to my .haccess files at the moment but I can confirm that the installation of WordPress that was corrupted by the update is a single installation in a separate folder within the HTML public folder on my site. Also within that folder is separate WordPress installation associated with my primary website: janbecket.net. That installation upgraded itself successfully with no problems. Thus, there are two separate WordPress installations on my site, one primary and one in the add-on domain folder.
You commented that the problem is not likely to be caused by adding WordPress in an add-on domain. That’s good to know. I hope we can come up with some other hypothesis and go from there.
Forum: Fixing WordPress
In reply to: Site hacked – cannot access database messageI think I need that plugin. Looks good.
I am still hoping that Arvixe can restore that database, although they are taking their time getting back to me. It is not a good thing that the database does not appear on the list at phpmyadmin. The other four databases appear – just not that one.
What if I 1) move the WordPress files to a new folder on my malamahalawa.org directory, 2) Re-install WordPress and 3) migrate the old pages and posts? Is there a reliable plugin that will migrate/import data on a localhost?