Tag Archives: magento

Solved Magento 1.6 MySQL core_session table size grows fast

After upgrade magento from 1.4.0.1 to 1.6.2.0

In Phpmyadmin I just notice the size of core_session table grows fast than normal

I trustate data in core_session now , before , it reach 450MB and 250MB ….

Unknow what happen , at last have to ask a friend , he told me :

We do not recommend storing sessions in the database unless running a multi-store. You should see a performance benefit from storing sessions in the file-system. You can do this by editing your app/etc/local.xml, line 51 below.

<session_save><![CDATA[db]]></session_save>

Change to:

<session_save><![CDATA[files]]></session_save>

You may need to clear var/cache and can potentially truncate the core_session table subsequent to this change. This will be our only recommended solution to the issue you are describing.

I do according he says , it is work !

Now , I have my author name : Winsion Liang  🙂  , link here Winsion Liang

 

Magento 1.6 install google content api issue

Recently install the google content API module into my magento 1.6.2.0

My idea is to upload some products to google base only , the installation is not easy , I have to create lots of attributes to meet google feed’s requirement ,

Uncategorized-Magento 1.6 install google content api issue -1

But finally when i finish everything I get error code :

Error code: auth/frontend/whitelisted. Internal reason: Customer xxxxxxx has not been whitelisted for the Content API for Shopping.

Uncategorized-Magento 1.6 install google content api issue -2

I search info and know that I need to apply the whitelist permission from google ( Unknow why they create such a useful API but not allow people use it ! )

But after writing a long email , google staffs just reply as below :

Dear winsion,

Thanks for contacting us. Your request for using Content API for Shopping has been declined. Please upload your product with data feed. Please find more information about data feed as follows.

http://support.google.com/merchants/bin/answer.py?hl=en&answer=188478

Regards,

Google Shopping Team

The answer is polite but without any explains on why not allow . 🙁  That make me quite disappoint .