Archive

Posts Tagged ‘Aruba’

WordPress: using MySQL repair broken links

December 29th, 2010 No comments

Checking my blog that is made WordPress 3.0.3 I noticed that in some posts / articles there were no Internet addresses of wikipedia http:// This meant that if a reader clicks on the link was redirected to www.marcobruni.info / wordpress / address that does not exist, instead of going right on the link to wikipedia.

The “guilt” chrome that is comfortable for a shorter address that starts out on his bar eliminating http:// but this means that if a copy of the bar and paste for example in the post I'm writing I will create a broken link. To solve the problem of the link does not work, I logged into my area of Aruba, and through PhpMyAdmin (Aruba, which provides for the administration of MySQL database) I did a query to find all articles that have this problem:

SELECT * FROM  `wp_posts` 
WHERE `post_content` LIKE '%href="it.wikipedia.org%' AND `post_status` =  'publish'

The query sql basically look at the table of contents (table wp_posts) those whose content (the post_content field) has within the string href =”it.wikipedia.org (without notice http://) and that the articles are published (The `post_status` = ‘publish’).
Finally, through the means of adding PhpMyAdmin I modified the post http:// before it.wikipedia.org.

Categories: Aruba, mysql, sql, wordpress Tags: , , ,

RESOLVED – WordPress: Htaccess bug about unattended in Aruba

December 18th, 2010 4 comments

Yesterday I wrote an article on my blog WordPress: personalizing the quickpress Board when I realize that by publishing the direct link to not work and if any browser was trying to write in the address gave error 404 Page Not Found.

As a good programmer and systems analyst who daily fights with the software bugs, I begin to fathom google to find a solution. The only article that I find interesting is this http://wordpress.org/support/topic/permalinks-not-working-how-to-restore when it comes to issues of file htaccess and I start to get suspicious about Aruba. My htaccess file is as follows:

RewriteEngine On #created by aruba do not touch this file!
RewriteCond %{REQUEST_URI} !^/wordpress
RewriteRule ^(.*)$ wordpress/$1 [L]

Continue to inform writing a message on the forum www.wordpress-it.it and the only answer which I give is to try to change the settings for permalinks that type the address of the blog changing www.marcobruni.info / data / item name /, This is how it works but the problem remains of the old addresses of visitors that you would find a nice message address is not Horrible ... Also in the forum recommend me a list of plugins to redirect from an old structure permalinks to the new http://is.gd/iTpk6, but none of these works, and then I return to the old structure that I have currently in use with the link of the article is not always accessible.

I do not give up and open a ticket for assistance with this problem with Aruba since yesterday trying to figure it out but groping in the dark.

I continue to do tests on evidence from good debugger, and finally….UALAAA FOUND…I'VE GOT IT if the permalink article begins with the word wordpress address is not reachable, wordpress just put the word in the middle or end and everything works.

After the amazing discovery community in the world (Forum, Aruba, friendfeed etc..) my discovery and the only people I meet are friends http://friendfeed.com/lega-nerd and begin to discuss http://friendfeed.com/filter/discussions and consolidated more and more suspicious about Aruba and its automatic installation.

[UPGRADE 18/12/2010 10:35] RESOLVED
I solved it without too many complications and without touching htaccess, I forgot to put in the General Settings as site address (URL) = Http://www.marcobruni.info/wordpress , now everything works. Of course the old permalinks do not change them otherwise unattainable.