Magento m2e error: Invoice was not created. Reason: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’2300011342′ for key ‘UNQ_SALES_FLAT_INVOICE_INCREMENT_ID’

Magento M2E have problems with invoice creation, when transaction come via PayPal.

That issue happen if your last_increment_id value not synchronized in database

http://stackoverflow.com/questions/12731590/magento-1-7-2-problems-with-order-processing

However, after fixes proposed in StackOverlow, invoice still return error:
Invoice was not created. Reason: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2300011342' for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID'

Continue reading

jwplayer crossdomain remote video injection

Jwplayer used on our site to play video fragments of company yearly summit, we place videos on corporate website domain. However one problem found, Jwplayer have XSS security issue, that allow peoples to include remote video content.

For example, someone can send malicous emails, with link like this:
http://www.company.org/player.swf?file=http%3A%2F%2Fcontent.bitsontherun.com%2Fvideos%2FbkaovAYt-364766.flv

Continue reading

magento import tax_class_id not set

Sometime Magento importing tool can be tricky, and you cannot import correctly some part of data into products database. It had many issues with importing prices, images and image labels.

Now we talking about Dataflow – Import profiles, with default settings and import file placed to var/import/, plus images placed to media/import/

Today we have got problem with importing CSV data feed, tax_class_id imported incorrectly.
Actually tax_class_id was not imported at all, it’s value simply not set.
Continue reading

Magento unable to send mail + Sendmail configuration problem

exception ‘Zend_Mail_Transport_Exception’ with message ‘Unable to send mail. ‘ in /lib/Zend/Mail/Transport/Sendmail.php:137

This error I got when trying to debug contact form in Magento. After testing Magento configs all looks well, we setup all required configuration in magento admin section, headers from and headers to, looking good as well.

Continue reading