ejm
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Upgrading from Legacy 2.0.11 to 2.8.xThank you, JoniMueller. This is essentially what I ended up doing – my placeholder file just has a different name. I used my 404 page as the template and when I was working on the site renamed to index.html
The only thing I couldn’t decide about was whether to put a robots meta tag with “noindex, nofollow” or not. If the index file is marked “noindex, nofollow”, does that affect search engine placement?
EMorris etherwork.net/blog 2.8.4 (WindowsXP, firefox) … steeling myself for the upgrade to 2.8.5 – sigh. This is EXACTLY why I left it in the legacy mode for so long. No need for upgrading every ten minutes.
Forum: Fixing WordPress
In reply to: Dashboard CSS not loading in FirefoxThis issue is resolved with my free host as well. Their tech department made the necessary changes to php.ini files that are not accessible to the general public. (I do not know exactly what was done.)
Forum: Plugins
In reply to: [Plugin: Get Recent Comments] It doesnt work with WordPress 2.8Excuse me for appearing to reply to myself. I asked about this problem on Krischan’s “Get Recent Comments” pages and he suggested the following:
disable the cache option of the plugin
That did the trick and the recent comments are now automatically updating on the sidebar of my 2.8.4 wordpress.
(Go to settings » recent comments » miscellaneous and uncheck “cache the output” that appears near the bottom of the page. )
Forum: Fixing WordPress
In reply to: Dashboard CSS not loading in FirefoxOne of my wordpresses is hosted on a free server that adds an ad link bar to any file with the extension of .html or .php.
.htaccess has very limited permissions so there is no hope that an alteration of the .htaccess file will do anything at all. (any .htaccess files are pretty much ignored)
The attached ad coding, of course, causes the server to misinterpret the php file, sending it as text/html instead of text/css (even though it says in the coding that it is text/css).
Firefox error message:
Error: The stylesheet /wordpress/wp-admin/load-styles.php?c=0&dir=ltr&load=global,wp-admin&ver=ba4d987ec2b562bd22e5da70fe38318d was not loaded because its MIME type, “text/html”, is not “text/css”.
Source File: /wordpress/wp-admin/post.php?action=edit&post=110
Line: 0The admin area did show up correctly in wp 2.7. Unfortunately, I have no idea what was different about the coding that allowed this to happen.
While it’s all very well to be able to move things around, it would be nice if there were a static css that would display things correctly.
Amazingly, (or not, depending on your point of view) the admin panel is rendered correctly in IE. Too bad I rarely use IE….
I really liked Category Visibility-iPeat too. But it broke my wordpress when I upgraded to 2.8.4
I’ve switched to
http://wordpress.org/extend/plugins/advanced-category-excluder/Forum: Fixing WordPress
In reply to: how to Convert Database Character Sets to utf-8Apparently, there IS an easier way to learn what the types are. If the following coding is put into the sql window
SHOW COLUMNS FROM databasename;the type(s) will be displayed.
Cool.
Forum: Fixing WordPress
In reply to: how to Convert Database Character Sets to utf-8Okay. I finally got my wordpress tables to be altered from latin1 to utf-8. I followed the instructions here:
However, I did run into difficulties because my sql version is at 4.1 and I was getting error messages
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
Having no idea where the manual was OR how to read it if I found it, I asked the folks at codingforums.com and one kind soul answered my pathetic pleas for help. It turns out that I had to include the “type” beside the name – something like VARCHAR(100) or tinytext or…
I looked in my backup files to find out what each of the types were for all the various tables. (Yes, it was rather labour intensive. There MUST be a better way.)
Thank goodness it’s done (I hope). No explosions yet….
Forum: Plugins
In reply to: [Plugin: Get Recent Comments] It doesnt work with WordPress 2.8I have just recently upgraded to 2.8 from the legacy 2.0.11. I thought that the recent comments plugin was working in the first couple of days after the upgrade. But as of today, the sidebar doesn’t update unless I go into the plugin settings and hit “update recent comments options”.
Does anyone know of a better way to deal with this than by going into the settings each day?
(Excuse me for replying to myself.)
RATS!! I stared at various pages about FULLTEXT indexes and then decided to just go ahead and try following the steps at http://www.mydigitallife.info/2007/06/23/how-to-convert-character-set-and-collation-of-wordpress-database/
After dealing (not without some difficulty) with several sql errors, I finally had all the tables in utf-8. I undid the “maintenance mode” page. Alas, all posts were truncated anywhere that there had been an extended character.
I restored the database to the previous version. The Âs that I had used the “search and replace” plugin had reared their ugly heads again. All the tables (except 3) are once again in latin1-swedish-ci collation.
Sigh. Back to the drawing board….
Any suggestions for how to get all the database tables in utf-8 without causing explosions would be most welcome.
Forum: Fixing WordPress
In reply to: how to Convert Database Character Sets to utf-8You might give this a try:
I haven’t yet tried using those instructions yet though; the only glitch I’ve run into is not knowing how to find out if fields belong to indexes or FULLTEXT indexes. (My question about that is here.)
If switching the collation to utf-8 doesn’t work to get rid of all the strange letters, you might try using the Search and Replace Plugin. (At this point, on your wordpress, you would use “ to replace “ and †and ‘ to replace ’.)
Forum: Plugins
In reply to: Avatar (Gravatar?)To turn the display to an anonymous avatar or to turn the avatars off entirely, go to your wp-admin » settings » discussion.
Scroll to the bottom of that page to see the avatar settings area.
Forum: Fixing WordPress
In reply to: how to Convert Database Character Sets to utf-8Because I couldn’t seem to wrap my mind around how to follow the steps at wp codex Converting_Database_Character_Sets and encouraged by the thread “Convert database to UTF-8“, I threw caution to the wind and decide to try running http://wordpress.org/extend/plugins/utf-8-database-converter/
First, I installed ‘Search & Replace’ Plugin and made an attempt to find all the instances of extended characters and replace them with their character entities.
I should have paid even closer attention to the following in the thread entitled “[Plugin: UTF-8 Database Converter] All entries chopped“
it appears that [UTF-8 Database Converter plugin] truncates the posts at the first non-latin character.
Alas, I didn’t get all the extended characters before running UTF-8 Database Converter. Quel disaster!!
Luckily, I HAD made a backup. And thank goodness for this tutorial on how to restore using phpMyAdmin:
http://tamba2.org.uk/wordpress/restore/
(The wp-codex restore tutorial is just as incomprehensible as the one on how to convert database character sets.)
I have now restored my wordpress to pretty much what it was before ( except now I have some double letters on the sidebar… û instead of ü and é instead of é). And alas, I still have a mix of latin1-swedish-ci and utf-8 in the tables. Sigh.
Please excuse my shouting but IF YOU HAVE ANY ACCENTED LETTERS OR EXTENDED CHARACTERS ON YOUR WORDPRESS, DO NOT USE utf-8-database-converter PLUGIN!!!
Forum: Fixing WordPress
In reply to: how to Convert Database Character Sets to utf-8I have to confess that I’m terrified of making a mistake. (I KNEW there was a reason I didn’t want to upgrade from 2.0.11!!) The only thing I know about PHPmyadmin is how to open it up and collect the backups.
The following is an excerpt from http://codex.wordpress.org/Converting_Database_Character_Sets
1. Place notice that blog is out of service
2. Backup database
3. ALTER TABLE wp_users MODIFY display_name BLOB;
4. …ALTER TABLE commands for all other tables/columns…
5. ALTER DATABASE wordpress charset=utf8;
6. ALTER TABLE wp_users charset=utf8;
7. …ALTER TABLE command for all other tables…
8. ALTER TABLE wp_users MODIFY display_name TEXT CHARACTER SET utf8;
9. …ALTER TABLE for all other tables/columns…
10. Add DB_CHARSET and DB_COLLATE definitions to wp-config.php
11. Place blog back on-linePlease excuse me for having to have this absolutely spelled out. With regards to #4, does this mean that every table in the wordpress database should follow the same format? Along the following lines:
ALTER TABLE wp_comments MODIFY display_name BLOB;
ALTER TABLE wp_links MODIFY display_name BLOB;Do I do these commands one at a time? Or can I do them all at once in the sql command window?
and after ALL the wp-tables have been modified to “display_name BLOB” do I then follow step #5?
Forum: Fixing WordPress
In reply to: how to Convert Database Character Sets to utf-8Thank you for your reply, samboll. At this point, I’m not completely comfortable with using plugins that are not compatible with 2.8.4. Both wordpresses are at this point, for the most part, readable and I worry about blindly using the plugins in case something really goes bad.
I have not yet had to restore a wordpress from a backup and REALLY don’t want to have to do that.
Forum: Installing WordPress
In reply to: Upgrading from Legacy 2.0.11 to 2.8.xOkay, now that that is out of my system (sorry about that – please do feel free to dump the above post if it is too offensive), here is my question.
I’m stuck on the very first step at http://codex.wordpress.org/Converting_Database_Character_Sets
Place notice that blog is out of service
How do I put the blog out of service? Is there some place in the wordpress dashboard that I can check to say “maintenance mode”?
EMorris etherwork.net/blog 2.8.4 (WindowsXP, firefox)