Magento 1 Front controller reached 100 router match iterations

a:5:{i:0;s:52:"Front controller reached 100 router match iterations";i:1;s:499:"#0 /www/sites/*/app/code/core/Mage/Core/Controller/Varien/Front.php(183): Mage::throwException('Front controlle...')

#1 /www/sites/*/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()

#2 /www/sites/*/app/Mage.php(683): Mage_Core_Model_App->run(Array)

#3 /www/sites/*/index.php(90): Mage::run('gloso_public', 'website')

#4 {main}";s:3:"url";s:17:"/admin";s:11:"script_name";s:16:"/index.php";s:4:"skin";s:17:"default";}

https://github.com/convenient/magento-ce-ee-config-corruption-bug#the-fix

Spanish Vocabulary 1

la manzana – apple

el mono – monkey

vegetariano/vegetariana – vegetarian

el cangrejo – crab

el cerdo – pig

el conejo – rabbit

el pengüino – penguin

tú – you (informal)

desayuno – breakfast

sí – yes

el pájaro – bird

la sopa – soup

beber – to drink

leer – to read

querer – to want, love, wish, will, like, cherish

comer – to eat

perdón – excuse me, sorry

la comida – food

tu – your (informal)

usted – you (formal)

nosotros – we

nuestras – our

la leche – milk

hablar – to speak

ser – to be (soy, eres, es, somos, sois, son)

el arroz – rice

los vegetales – vegetables

el león – lion

la pasta – pasta

la tortuga – turtle

el tomate – tomato

el vino – wine

la cerveza – beer

su – his/her

el hombre – man

el huevo – egg

más – more

el limón – lemon

el sal – salt

el jugo – juice

beber – to drink

el ratón – mouse

almuerzo – lunch

azúcar – sugar

el gato – cat

la persona – person

escribir – to write

la fruta – fruit

la salsa – sauce

la naranja – orange

el pato – duck

la mujer – woman

el agua – water

cocinar – to cook

el caballo – horse

ell pollo – chicken

el queso – cheese

la cebolla – onion

el carne – meat

necesitar – to need

cena – dinner

el pan – bread

suyo – your

 

 

Spanish Idioms

Del tal palo tal astilla.

Like father like son.

Consejos vendo y para mí no tengo.

Do as I say, not as I do.

En tierra de ciegos, el tuerto es rey.

In the land of the blind, the one-eyed is king.

Soldado avisado no muere en guerra.

Forewarned is forearmed.

Borrón y cuenta nueva.

Let bygones be bygones.

En boca cerrada no entran moscas.

A closed mouth gathers no flies.

Donde hay humo, hay fuego.

Where there’s smoke there’s fire.

Más vale tarde que nunca.

Better late than never.

Mucho ruido y pocas nueces.

All talk and no action.

Cada loco con su tema.

To each their own.

Camarón que se duerme, se lo lleva la coriente.

You snooze, you lose.

El amor es ciego, pero los vecinos no.

Love is blind, but the neighbors aren’t.

Barriga llena, corazón contento.

A fully belly, happy heart.

 

 

comparing core_config_data

Find core_config_data differences between a production and development db.

SELECT path, value FROM (
SELECT path, value FROM your_dev_db.core_config_data
UNION ALL
SELECT path, value FROM your_prod_db.core_config_data
) tbl
GROUP BY path, value
HAVING count(*) = 1
ORDER BY path


query("select * from core_config_data where path in (
'admin/url/custom',
'admin/url/use_custom',
'carriers/ups/access_license_number',
'carriers/ups/allowed_methods',
'carriers/ups/dest_type',
'carriers/ups/dest_type',
'carriers/ups/negotiated_active',
'carriers/ups/negotiated_active',
'carriers/ups/password',
'carriers/ups/username',
'dev/css/merge_css_files',
'dev/js/merge_files',
'payment/authorizenet/cgi_url',
'payment/authorizenet/cgi_url_td',
'payment/authorizenet/login',
'payment/authorizenet/merchant_email',
'payment/authorizenet/test',
'payment/authorizenet/trans_key',
'payment/cashondelivery/active',
'payment/paypal_direct/cctypes',
'payment/paypal_direct/payment_action',
'payment/paypal_direct/sort_order',
'paypal/general/business_account',
'paypal/wpp/api_password',
'paypal/wpp/api_signature',
'paypal/wpp/api_username',
'paypal/wpp/sandbox_flag',
'shipping/origin/postcode',
'shipping/origin/region_id',
'system/currency/installed',
'web/cookie/cookie_domain',
'web/cookie/cookie_path',
'web/secure/base_js_url',
'web/secure/base_media_url',
'web/secure/base_skin_url',
'web/secure/base_url',
'web/unsecure/base_js_url',
'web/unsecure/base_media_url',
'web/unsecure/base_skin_url',
'web/unsecure/base_url')");

foreach ($result as $row) {
echo "update `core_config_data` set `value` = '" . $row['value'] . "' where `path`='" . $row['path'] . "';" . PHP_EOL;
}
?>

Magento 2 Simple Products and Virtual Products and Hey, There’s No Weight Attribute!

So you’re loving your new Magento 2 store when all of a sudden you realize, your simple products have started turning themselves into virtual products. Magento 2 automagically freely converts simple products to virtual and virtual products to simple based on whether or not the product has a weight.

All you have to do to turn those virtual products back into simple products is provide a value for weight. When you go in to edit the product, though, you may find there is no weight attribute on the screen!

Look in eav_attribute for the weight attribute_code and get its attribute_id (entity_type_id is probably 4). Look in catalog_eav_attribute where attribute_id is the one you just looked up from eav_attribute and set apply_to NULL. Reload product edit page, and you should see weight now

Weight Restored
Weight Restored