Disapproved items cannot be published

Working with Magento as we know can be frustrating, especially when you don’t know why some things happen. I guess that can be like life too. Anyway, we’ve been using Magento with Google Base (Google Merchant Center) for some time now, and every once in a while, we’d get the following error message: Expected response code 200, got 400. Type: data. Field: app:draft. Reason: Disapproved items cannot be published

Wouldn’t it be great if it gave some details as to why the items are “disapproved”? We’re not selling any adult related materials, no drugs, no body parts. We would love to tell you we discovered that on line 889 of file app/Code/Core/Mage/GoogleBase/Block/Adminhtml/Items/Renderer/Id.php had a bad section of code. Anyone that may be new to Magento, that file does exist, that deep into the file structure! SO back to the mystery. We don’t know what causes it, but it appears it has to do with using Magento’s “Duplicate” feature for product creation. Not sure why, because we don’t always get the error for every duplicated product.

So now, whenever we get the dreaded:

Expected response code 200, got 400. Type: data. Field: app:draft. Reason: Disapproved items cannot be published

We drill down through our list of Google Base items till we find the exact offender, we go to our product management section, we copy descriptions and other data to our trusty word editor and then…… We delete the offending bugger!

We then make a brand new product, plug in all our data and then goo back to Google Base management area in Magento and publish the new product.

Hey, not very glamorous or earth shattering, but it gets the job done so we can get back to work!

Stop Dr. Web Antivirus Update Emails

After tons emails about Dr. Web updates, I finally found a solution:

Log in as root (or you can use sudo) and open /etc/drweb/drweb32.ini:

Look for:

CronSummary = Yes

And change it to:

CronSummary = No

Do a restart for the Dr. Web daemon by (add sudo in the beginning if not using root):

/etc/init.d/drwebd restart

How To Get Remote File Using Apple Terminal

Okay, so this may not have anything to do directly with Magento or osCommerce, but indirectly it does. Instead of using ftp to transfer a 700M file from a server to your local machine, we like to use Terminal, Mac’s command line utility. We found this helpful hint for transferring a file from our web server to our local machine.

Open Terminal, log in if necessary.

type: curl -OL http://www.sitename.com/yourfile.ext

In this case, sitename.com is your url and yourfile.ext is the exact filename. You can also use this with your ip address in case you’ve already changed the DNS, which in our case we had.

Pretty cool tool!