My Pagerank is back!
My google page-rank is back today. Some days ago I that blog to the new domain. I’ve placed a .htaccess redirect Rewrite Rule
^(.*)$ http://alexander.holbreich.org/$1 [R=301,L]
to the old domain to preserve some humble SEO result of this page. But for some weeks new Blog had no page-rank. Now he is here and the effect of Permanent redirect on google is proved!
Folder Monitr a Flickr Upload tool
Folder Monitr allows automatically upload of Pictures to the Flickr. This tool is very useful to me because it can work automatically in the background and therefore reduce one manual step in my picture processing. So basically i can now use only Lightroom end export my developed pictures to the “watched” folder and they will automatically upload to flickr in the background. All tags are taken and even Set can be specified by subfoldering, which is also cool..
There is just one drawback of this method. Uploaded images become automatically description, which say that that picture where uploaded by Folder Monitr (with a link) and a tag “FolderMonitr”. So I don’t like stuff like this. Unfortunately mass edit (or delete i my case) of tags and description is not so comfortable in flickr as it could be.
However I will use FolderMonitr further maybe the description and tag problem cannot outbalance the use of that tool.
P.S. If anybody knows the working way haw too upload pictures to flickr direct out of Lightroom in the version 2.0 is welcome to give me a hint
thanks!
Found solution for Magento – “SQLSTATE[HY000]: General error” on installation
I wrote already in the past about eCommerce System. I play with Magento till now from time to time. Unfortunately I had some problems with the installation and I could not find help in the web. Therefore maybe this post can be useful for some of you how is dealing whis Magento too.
The Problem
Every time on the installation of Magento i saw following exception.
Error in file: ".... app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php" - SQLSTATE[HY000]: General error: 1005 Can't create table './db203484_1/#sql-1dd4_17baf.frm' (errno: 121)
Trace:
#0 .../app/code/core/Mage/Core/Model/Resource/Setup.php(286): Mage::exception('Mage_Core', 'Error in file: ...')
#1 ...app/code/core/Mage/Core/Model/Resource/Setup.php(166): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.8.11')
#2 .../app/code/core/Mage/Core/Model/Resource/Setup.php(154): Mage_Core_Model_Resource_Setup->_installResourceDb('0.8.11')
#3 .../app/code/core/Mage/Core/Model/Resource/Setup.php(120): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 .../app/code/core/Mage/Core/Model/Config.php(215): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 .../app/code/core/Mage/Core/Model/App.php(236): Mage_Core_Model_Config->init(Array)
#6 .../app/Mage.php(424): Mage_Core_Model_App->init('', 'store', Array)
#7 .../app/Mage.php(443): Mage::app('', 'store', Array)
#8 .../index.php(52): Mage::run()
#9 {main}
I tried installation with version 1.1.3, 1.1.4, 1.1.6 and 1.1.8 nothing helped…
You can find many threads on Magentocommere Forum to this issue. Some hints may help you once but do not solve the problem. I guess I don’t have solved problem globally. But I found the cause of the problem so everybody can solve it on his own way.
Cause of the exception
During the installation routine many DB-Tables should be created in your Database. We talk here about MySQL Database. So Magento begins with SQL-Statement that are holded in the mysql4-install-0.8.0.php. This file is also pintet in the Exception message as the causes of the problem.
I analysed the Statement and this came out..
Before any CREATE-Statement – Magento executes this:
SET SQL_MODE='' SET @OLD_FOREIGN_KEY_CHECKS=@@ FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
Then, after all tables and indexes defined in mysql4-install-0.8.0.php are created, magento executes following Statement.:
SET SQL_MODE=IFNULL(@OLD_SQL_MODE,'') SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS,0)
An the last row causes #1231 – Variable ‘foreign_key_checks’ can’t be set to the value of ‘0’ Exception which is finely identified by me as the cause of such installation problems!
Solution
I did’n spend much time to find out why the Varibale SET FOREIGN_KEY_CHECKS can’t be set to ‘0′, because it looks like MySQL bug.
However, it’s maybe not the finest solution but it helps. If you can drop the whole the database and create new one, then the installation works. It seems to set all the before settings back and installtion works fine on “vergin-Databases”.
If you feel experienced in MYSQL and has an Idea how to overcome this problem without creating new Databases please make your comment !
2009: Happy new Year!

New Year
I wish all of you happy new year! May all your wishes come true in 2009!
I wish to learn a perfect time management to made all of the thing that I have to do, and spend enough time with my family. Also I wish to achieve new level in project management and maybe new career level!
Why not? I feel ready!
Good luck!
Pictures are lost
As Simon mentioned before, all pictures are lost on the blog.
That is because their URL are stored as absolute path by WP which are currently refer to old domain. Can anyone write an SQL (MySQL) procedure that looks through all post, searching for some URL lieke http://holbreich.de and then changes them to http://alexander.holbreich.org?
Can anyone of the readers do somethng like this? Is there maybeeven some kind of plug-In which doe simmilar job?
Successfull switch to alexander.holbreich.org
As you see, from now on you will find my blog at Alexander.Holbreich.org.
Why the movement
Primary it had to be done because of some problems with hosting service provider. But that is a long story, which I won’t tell you here. However ORG domain is much nicer? What do you think?
wPopularity Plug-In
Please excuse me for not maintaining it. I just have time to keep this site alive, not really for a writing Plug-ins i free time. But I promise i try to find some hours in the winter holidays, to answer all your questions and maybe even to release new version. Thank you for you patience.
One cause why I don’t like journalists
This blog should not be political.. But here is one cause why i don’t like journalists nearly as much as politicans. e.g. for writing a bullshit like:
Russia’s use of strategic bombers and ballistic missiles against Georgia’s civilians outside of the South Ossetian conflict is “far disproportionate” to Georgia’s alleged attack on Russian peacekeepers, a senior U.S. official said Saturday.
rent a car bulgaria
CNN
I need hard proves by such serious statements!
Bad journalism, good brainwashing.
WPopularity progress
Hello friends, I’m pleasure to report progress in development of wPopularity plug-in. Yesterday I took some time just for me and wPopularity.
After hours of bootstrap debugging (change, ftp upload, look ofr changes) of wPopularity I finally understood why activation problems occurred.
Also I refactored the plugin. But i’m still not at the and. The next released version is at least 1.0.0. I do not plan to test it on Wordpress version below 2.5.
Furthermore I took a dessision to be independet of Alex King Populatiry Contest Plugin, therefore my next Plugin version will use own DB tables. As you maybe noitice my Popular List has changed, that is because of using new tables which means drop of old popularity statistic
Finaly, i consider to maintan all of my Worpdpress and similar stuff includig wPopularity on other Blog with some friend of my. Of cause I tell you about it, when it’s done.

