Archive for March 2010



The Simple Press Forum plugin for Wordpress is one of the most popular and comprehensive solution to his Wordpress blog to add a forum. I also use it in my Mark Knopfler guitar style blog . This gives the option of a blog article automatically link to a forum discussion. However the Simple Press forum only possible in the preparation of an article (or vice versa to create when creating a forum thread) is automatically an associated, linked forum thread (or blog post), which will then take place in the future discussion.

Has - as has happened with me - is already a debate in the Forum is developing, which refers to an article, it is not readily possible to combine items and forum topic later. In this article I want to describe how to do this yet. Requirement is only that you have access to the database of the blog, because you need to edit this manually.

Method

1st Change in the Wordpress backend in the edit mode (Articles -> Edit) and edit the article, which should be linked to a forum thread. Bottom of the page you can link the item with a new forum thread. Tick and update article. You should now see in the article, a link to a blank, and in the same Forum Topic Forum Topic again appear as a link back to the article.

2nd Now you need to edit your database. Most providers offer the opportunity to realize this through phpmyadmin. Otherwise, should a Google search using the keywords such as "edit mysql database to help you. In the database you are looking for the key wp_sftopics (the prefix wp_ you have created your blog may vary designated administrator). Let us now display all the entries of this key, you see a table in which the rows correspond to their forum topics. Find the lowest, most recent line that the then empty, automatically meets in step 1) Forum Topic generated. There is a column called blog_post_id, most lines will be set to 0 in the, in the case linked Topics Forum, however, ID-number of the accompanying article appears. Note the number that is at the lowest entry. This you must now take place in the line (the 0) register, which stands for the Forum Topic, which you want to link to the article. In their forum then it should already be a link from this forum topic about the article.

Note here now the ID of the Forum Topics, to which you want to link.

3rd Delete the entire last line (that is the new blank forum topic). Delete this not in the Simple Press forum itself, otherwise the link will be deleted as of the article to the forum topic.

4th It must be added the link of the article are adapted to the forum topic (which has yet to empty, previously deleted topic). You open the key wp_postmeta and display them. There are probably quite a long list, look for the latest of them, who stood with me on the last page of list, so the very bottom. They see the values meta_id, post_id (the number of the item you want to link), metakey (here should already "forum link") and are meta_value. In meta_value appeared in my "2 @ 30", with 30 of the ID is linked Forum Topics. In my case I wanted to Topic link 25 instead of 30, so I had to change this value to "2 @ 25" (I do not know what the 2 stands). The number you have to use here, is the one that you have noticed in the last step of 2).
Then, should the link from the article on targeting the desired forum thread.

5th In the new investors of the Forum Topics link in step 1 was produced on the topic already, a new, blank forum post. Show example in the sidebar a list of recent forum posts, this post will appear empty even in this list, so you should remove it in the database. You see the key wp_sfposts, probably at the bottom of the list because it is one of the newest entries in chronological order. Here again delete all the appropriate line.

Interesting Articles

Comments No Comments »



Last night we were still comfortably watch a movie in our home theater (sounds so pretentious, the fact that we have no TV, but watching movies with beamer) is, but as it happened: As usual, went the lens cover flap on the beamer , but the lamp remained dark. Instead, two blinking LEDs on the device, which means broken according to instruction of "light" or "maximum life span reached the lamp. A replacement lamp we had of course not in stock - at a price of about 250, - € just for the lamp, no part, the views are just as one has to supply in the drawer (especially lamps age and not used and the warranty expires).

I then googled times the current price for a replacement lamp and by whether there could be another explanation for the Dunkelbleiben the beamer. And actually I found something in a forum, I found an indication that it in our Sanyo PLV-Z4 interior is a bimetal switch, which tends to eliminate excessive heating of the Beamer. In theory, this switch again after cooling off again, this he does not seem to do often, but he gets stuck somehow. A simple push of this switch seems to have already solved similar problems for many owners of this projector.

Figure 1: Remove these three screws on the back ...

Figure 2: ... and these three on the bottom of the Sanyo PLV-Z4

Unfortunately, the aforementioned switch is not accessible from outside so that you must open the projector. To this end, I had three screws at the back and loosen three screws at the bottom (see figures 1 and 2). The bimetal switch is in the back left (when facing the device, so the lens is front right, see Figure 3 and 4). When I pressed a finger on the switch, I heard a faint "click". Then the assembly together and try again, and - voilà ... - hit: Flawless picture, as some would never have been :) Even the successor Sanyo PLV-Z5, it seems that emergency switch give also unchanged.

Figure 3: Here sits the switch

Figure 4: Press me

I would like to stress expressly that I can accept no responsibility for, of course, such an intervention, ie you send the better the projector for a lot of money for repairs ;) Furthermore, had the overheating and hence the starting of the bimetal switch may be a specific reason, such as a clogged air filter or high ambient temperature. This reason must be placed first (for us was the air filter clogged obviously that was easy to fix by removing the relevant parts and sucking).

Our movie night could be saved in any case and the light is finally happy ... hopefully continue for a long time ...

PS: Our lamp is one of 1500 hours, the lifetime is specified with about 2000 hours.

Here's a direct link to the replacement lamp from Amazon, if it once was but the lamp itself:

Related Articles:

Comments No Comments »