Category Archives: Website

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 !

 

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 ,

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.

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 .

 

Website search engine optimize beginner seems better than me

Yesterday talk with a new friend , he is a SEO beginner , he is selling something , here is the pics of his score

  He says he is a beginner of SEO , and it looks great business he is doing , but compare to mine , I don’t know why my site’s visitor are such a little  :-(
  Anyway to create an own business , does not only need to work hard , there must some skills .