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

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.

Russia defeat Netherlands (3:1)

Another off topic of me. I never thought that I will write any word about football in this blog. I’m not a football fan at all. But that Russian football (soccer) team on EM 2008 gained my attention.

Half an our ago Russia defeat Netherlands with 3 to 1! Realy good play!

The game against sweden and today’s game against Netherland had so much dynamic and tension! I hope they willl continue and will reach finale!

Congratulation Russian team, well done!

Dmitry Anatolyevich Medvedev & Nikolay Alexandrovich Romanov (Nicholas II)

Look at this! It’s incredible!

Don’t know them?

The first one is the actual President of Russian Federation – Dmitry Medvedev, the second one, is the latest Russian Tsar -Nicholas II. Nicholas II was executed by Bolsheviks in 1918.

However I found this similarity very funny but also somehow strange. Maybe beacuse of history. Nicholas II stands for last moments of non communistic Russia . History has made Nicholas II and his whole family (which was executed too)  very symbolic. It’s difficult to explain. However very strange for me.

P.S. As you see, I’m back again, have much to do, so has to wait few days or even weeks :(

I found this picture here

12 day’s sun and sea

Tonight a plane will take us to our holiday destination. That means I’m not at a PC and maybe even not reachable on telephone for at least 12 days. :) That is my first big holiday trip since two years, and a first holiday with my little son.

Nevertheless I have some ideas on improvement of W-Popularity Plug-in. I think we should give up compatibility of DB-Tables with Popularity Contest Plug in. As i think that should eliminate all possible inter-operation problems with the Plug-in of Alex King, including those activation problems, some of you have report in the comments to my ???????? ????? ????????.

I started already work on version 0.9.4 but i will release it after I’m back again.