Tumblelog by Soup.io
Newer posts are loading.
You are at the newest post.
Click here to check if anything new just came in.

September 13 2016

09:17

August 03 2016

06:03

Best Release Notes .... Ever!!

The Developer of Pocket Universe just released a new version. But instead of listing the fixes and features, he writes about his concerns and hopes of how people treat each other.



Source: https://itunes.apple.com/en/app/pocket-universe-virtual-sky/id306916838?mt=8

February 28 2016

09:46

kb3035583: "Important" Update installs the annoing "Get Windows 10" App again

After hiding out those - I guess - 4 "important" updates, there again is an important update that trys to put the annoying "Get Windows 10" App again to our task-bar (https://support.microsoft.com/en-gb/kb/3035583).

I will again try to ignore the Update by right click -> Hide. But I'm afraid that won't help long.

There are several good tutorials to remove the GetWin10 App, if you happend to oversee the Easter Egg and installed it:
http://www.askvg.com/how-to-remove-get-windows-10-app-and-its-icon-from-taskbar/

I once knew a program to get rid of the GetWin10 App for the less experience user. But forgot it.
If you know one, please drop a comment below.



February 26 2016

17:28

Laser/Radar Scanner from Aliexpress ... Fail!!!

A view weeks ago I ordered a laser/radar scanner via aliexpress. After 3 weeks it arrived. So far so good, but it worked for only 1 hour or so.
During this hour it detected one known fixed speed camera, un-detected a seconds one, "found" plenty of other radar/laser sources. I suspect it didn't filter out those parksensors and infra-red motion detection shop door openers.
After stopping to work and successful raising an dispute at aliexpress, I decided to take it appart.

I know a bit of good soldering work, but I didn't find it there. On many places, the SMDs where mounted manually with big zinn drops. Some places (see coloured circles in pics) are oxidised.

One SMD fell out (see pic), that might be the reason for failing.

Lessons learned: Get a decent scanner, spend more than $44.

Product: 360 Degree Full-Band Scanning Speed Measuring Radar/Laser Detectors Auto Laser Detector Speed Testing System English Voice
(http://www.aliexpress.com/item/360-Degree-Full-Band-Scanning-Speed-Measuring-Radar-Laser-Detectors-English-Voice-Warning/1879142515.html)

Price, Dec 2015: $18


 bigger img





August 28 2013

19:34

Speed up Magento 1.6 Checkout - 124 sec to 4 sec!

I had serious performance Issues with my Magento CE 1.6.
Reason: Wrong and missing indexes. Magento fixed them is 1.6.2.
Here are the relevant DB changes. You might check if it helps you.

I reduced the checkout time for 38 lines with 73 items total from 123 sec to 4 sec !!!!

I also posted to stackoverflow.com if you want to see more response to the script:

Here it comes:


/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/* Foreign Keys must be dropped in the target to ensure that requires changes can be done*/

ALTER TABLE `core_url_rewrite`
DROP FOREIGN KEY `FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID`  ,
DROP FOREIGN KEY `FK_CORE_URL_REWRITE_STORE_ID_CORE_STORE_STORE_ID`  ;

/* Alter table in target */
ALTER TABLE `catalog_category_entity_varchar`

DROP KEY `MAGMI_CCEV_OPTIMIZATION_IDX` ;

ALTER TABLE `catalog_product_bundle_stock_index`
DROP KEY `PRIMARY`, ADD PRIMARY KEY(`entity_id`,`website_id`,`stock_id`,`option_id`) ;

/* Alter table in target */

ALTER TABLE `catalog_product_entity_media_gallery`

DROP KEY `MAGMI_CPEM_OPTIMIZATION_IDX` ;

/* Alter table in target */

ALTER TABLE `core_url_rewrite`

CHANGE `id_path` `id_path` varchar(255)  COLLATE utf8_general_ci NULL COMMENT 'Id Path' after `store_id` ,

CHANGE `request_path` `request_path` varchar(255)  COLLATE utf8_general_ci NULL COMMENT 'Request Path' after `id_path` ,

CHANGE `target_path` `target_path` varchar(255)  COLLATE utf8_general_ci NULL COMMENT 'Target Path' after `request_path` ,

CHANGE `is_system` `is_system` smallint(5) unsigned   NULL DEFAULT 1 COMMENT 'Defines is Rewrite System' after `target_path` ,

CHANGE `options` `options` varchar(255)  COLLATE utf8_general_ci NULL COMMENT 'Options' after `is_system` ,

CHANGE `description` `description` varchar(255)  COLLATE utf8_general_ci NULL COMMENT 'Deascription' after `options` ,

CHANGE `category_id` `category_id` int(10) unsigned   NULL COMMENT 'Category Id' after `description` ,

CHANGE `product_id` `product_id` int(10) unsigned   NULL COMMENT 'Product Id' after `category_id` ,

ADD KEY `FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID`(`product_id`) ,

DROP KEY `FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` ,

ADD CONSTRAINT `FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID`

FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE ,

DROP FOREIGN KEY `FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID`  ;

/* Alter table in target */

ALTER TABLE `eav_attribute`

DROP KEY `MAGMI_EA_CODE_OPTIMIZATION_IDX` ;

/* Alter table in target */

ALTER TABLE `eav_attribute_option_value`

DROP KEY `MAGMI_EAOV_OPTIMIZATION_IDX` ;

/* The foreign keys that were dropped are now re-created*/

ALTER TABLE `core_url_rewrite`

ADD CONSTRAINT `FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID`

FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE ,

ADD CONSTRAINT `FK_CORE_URL_REWRITE_STORE_ID_CORE_STORE_STORE_ID`

FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE ;


/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

December 13 2012

11:34

Shorter IDs without Site ID for Orders, Invoices and Shippments

I found it very strange that magento creates different ids for orders, invoices and shipments depending on the site_view.
Below sql statements create global ids, limit the code length to 5 plus a character prefix.
B = Orders, R = Invoices, V = Shipping
And I let all of them start with 13000.

You have to apply the script to a store without orders, invoices and shipments, otherwise you are in risk of having duplicate ids if you don't choose your prefix well.

I used http://www.magentocommerce.com/magento-connect/asperience-deleteorders.html to get rid of my test data.
 
UPDATE `magento`.`eav_entity_type` SET `increment_per_store` = '0' , `increment_pad_length` = '5' WHERE `entity_type_id` = '4';
UPDATE `magento`.`eav_entity_type` SET `increment_per_store` = '0' , `increment_pad_length` = '5' WHERE `entity_type_id` = '18';
UPDATE `magento`.`eav_entity_type` SET `increment_per_store` = '0' , `increment_pad_length` = '5' WHERE `entity_type_id` = '24';
UPDATE `magento`.`eav_entity_type` SET `increment_per_store` = '0' , `increment_pad_length` = '5' WHERE `entity_type_id` = '28';

TRUNCATE `eav_entity_store`;
ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;

insert into `eav_entity_store`(`entity_store_id`,`entity_type_id`,`store_id`,`increment_prefix`,`increment_last_id`) values (1,4,0,'B','B13000'),(2,18,0,'R','R13000'),(3,24,0,'V','V13000');
Tags: magento
11:13

Magento: Change Simple Product to Configurable Product

One of the big mysteries - at least to me - is why magento admin is not able to change a simple product to a configurable product.
It is obvious that this is a real world usecase!
Anyway: The guys from Flagbit GmbH delivered a free module to change the Attribute Set:
http://www.magentocommerce.com/magento-connect/flagbit-change-attribute-set.html

So far so good. But what is the use of a product with an different attribute set, when you still need it as configurable product.
I hacked the code. Now if you change the attribute set to 'default' then the product type is changed to 'simple'. Setting any other attribute set to the product leads to a product_type of 'configurable'.

Important: This code does not work with 'bundle' products.

What you need to do:

  • Find appcodecommunityFlagbitChangeAttributeSetcontrollersAdminhtmlCatalogProductController.php
  • Make a backup of this file
  • Find the public function changeattributesetAction()
  • Change it to:


 
public function changeattributesetAction()
{
$productIds = $this->getRequest()->getParam('product');
$storeId = (int)$this->getRequest()->getParam('store', 0);
$attribute_set = $this->getRequest()->getParam('attribute_set');

$entityTypeId = Mage::getModel('eav/entity')
->setType('catalog_product')
->getTypeId();
$attributeSetName = Mage::getModel('eav/entity_attribute_set')
->getCollection()
->setEntityTypeFilter($entityTypeId)
->addFieldToFilter('attribute_set_id', $attribute_set)
->getFirstItem()
->getAttributeSetName();
if ($attributeSetName == 'Default') { $product_type = 'simple'; } else { $product_type = 'configurable'; }

if (!is_array($productIds)) {
$this->_getSession()->addError($this->__('Please select product(s)'));
}
else {
try {
foreach ($productIds as $productId) {
$product = Mage::getSingleton('catalog/product')
->unsetData()
->setStoreId($storeId)
->load($productId)
->setAttributeSetId($this->getRequest()->getParam('attribute_set'))
->setIsMassupdate(true)
->save();
$product = Mage::getSingleton('catalog/product')
->unsetData()
->setStoreId($storeId)
->load($productId)
->setTypeId($product_type)
->setIsMassupdate(true)
->save();

}
Mage::dispatchEvent('catalog_product_massupdate_after', array('products'=>$productIds));
$this->_getSession()->addSuccess(
$this->__('Total of %d record(s) were successfully updated', count($productIds))
);
}
catch (Exception $e) {
$this->_getSession()->addException($e, $e->getMessage());
}
}
$this->_redirect('adminhtml/catalog_product/index/', array());
}


  • That's all!


Feel free to add comments.

Credits: Thanks to http://www.craftyfella.com/2010/01/syntax-highlighting-with-blogger-engine.html for the syntax highlighter tutorial.

Tags: magento

August 15 2012

13:59

Find older versions of PHP Extensions

If you search for an PHP extensions of an older PHP version and can't find it on http://downloads.php.net/pierre/ then you want to give http://www.php.net/~pierre/archives/ a chance.
I found my php_apc-3.1.4-5.2-VC6-x86.zip there.
Hope this helps someone. I searched for 2 hours for this archive. ;)

June 05 2012

15:53

Fixed: Spellcheck in Magento Admin

This is a quick solution to get spellcheck in magento working.
It worked for me with magento 1.6.2.
The best solution is the creation of an extension, but I didn't take the time.
Also beware that with the next magento update the changes will be overwritten.

 1) Add the red parts to jsmageadminhtmlwysiwyg iny_mcesetup.js
        theme_advanced_buttons1 : magentoPlugins + 'magentowidget,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,fontselect,fontsizeselect',
            theme_advanced_buttons2 : 'cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,forecolor,backcolor',
            theme_advanced_buttons3 : 'tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,iespell,media,advhr,|,ltr,rtl,|,fullscreen,|,spellchecker',
            theme_advanced_buttons4 : 'insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,pagebreak',
            theme_advanced_toolbar_location : 'top',
            theme_advanced_toolbar_align : 'left',
            theme_advanced_statusbar_location : 'bottom',
            theme_advanced_resizing : true,
            convert_urls : false,
            relative_urls : false,
            content_css: this.config.content_css,
            custom_popup_css: this.config.popup_css,
            magentowidget_url: this.config.widget_window_url,
            magentoPluginsOptions: magentoPluginsOptions,
            spellchecker_languages : 'English=en,+Deutsch=de',
            ......
Add the spellchecker_languages (see lines above) according to you needs:
This enables you to specify what languages your pspell installation can handle. The value of this option should be a comma separated name value list in the following format name1=value1,name2=value,name3=value where name is the string to present in the menu and the value is a ISO language code like sv or en. If you add a + character infront of the name it will be the default value for the spellchecker. The default value for this option is: +English=en.

 2) Go to http://www.tinymce.com/download/download.php  and get the PHP Spellchecker.

3) Put the folder spellchecker from this zip inside js iny_mceplugins

That's all. Have fun.

December 26 2010

solfd
10:47
The Age of Embedded Computing Everywhere - Keynote by Ray Kurzweil
Reposted fromscience science vialimex limex
10:47
solfd
10:46
Funny error message at userscripts.org
Reposted fromlimex limex
10:46

Commodore C64x mit Dual Core, Bluray und HDMI kommt! Träume werden wahr

Engadget German

Filed under: Rechner

Na, ist denn schon ...?! Ein Commodore 64 mit Dual Core Atom CPU, 2GB Speicher, NVIDIA Ion2 Grafikkarte, USB- und Multikartenleser und Bluray-Laufwerk? Genau. Commodore "droht" ja schon seit längerem mit Relaunches alter Weggefährten wie Amiga und C64. Nun nimmt das alles aber genauere Formen an. Außer natürlich den spannendsten Fakten, wann genau und für wieviel das Ding...

Reposted fromlimex limex
10:46

Coupon Code

Reposted fromlimex limex
solfd
10:46
Reposted fromfyi fyi vialimex limex

October 16 2010

17:59
Play fullscreen
MovieReshape: Tracking and Reshaping of Humans in Videos
Reposted fromlimex limex
17:59

Tech Support

xkcd.com

Shared by limex
This comic strip is AWESOME! Everyone who spent hours explaining first level support their job and giving them free training lessons, will agree.
I recently had someone ask me to go get a computer and turn it on so i could restart it. he refused to move further in the script until i said i had done that.
Reposted fromlimex limex

October 08 2010

solfd
20:39
Fabian Hemmert: The shape-shifting future of the mobile phone
Reposted fromlimex limex

September 18 2010

21:35

August 29 2010

solfd
19:44
Reposted fromlimex limex
Older posts are this way If this message doesn't go away, click anywhere on the page to continue loading posts.
Could not load more posts
Maybe Soup is currently being updated? I'll try again automatically in a few seconds...
Just a second, loading more posts...
You've reached the end.

Don't be the product, buy the product!

Schweinderl