When you select the user setting area, you can see the comment like “In order to install another language , Go to Extension manager and install required language pack”

But seems to be its not working or specified backend language packs are not available…

Do the following steps to add German or any other language:

  1. Choose Extension Manager , then select Menu “Translation Handlling”
  2. select the desired language
  3. save
  4. verify / update from Repository

Now you can see the new language in User settings language selection list,   the backend language. Relogin and done!

Let language ids are 1 (English) and 2 (French)

[globalVar = GP:L=1]

10 = HTML
10.value (<b>English</b>)


10 = HTML
10.value (<b>French</b>)


If we are using COA ( COBJ_ARRAY ), try include entire script in both conditions like below…

[globalVar = GP:L=1]

left = COA
left {
10 = HTML
10.value (English)
wrap = <h1>|</h1>


left = COA
left {
10 = HTML
10.value (French)
wrap = <h1>|</h1>


Let me know if there is any suggestions…

There is a slight difference from previous versions, an additional table reference for customer form fields.
Table  -  customer_form_attribute , Here we are storing customer form fields related with account add, edit, checkout etc…

The attribute adding process is same as in previous post..but need additional lines for updating the new table, see below

$customerattribute = Mage::getModel('customer/attribute')->loadByCode('customer','customcode');
$forms           = array('customer_account_edit','customer_account_create','adminhtml_customer','checkout_register');

Let me know if have any feedbacks…

Follow below step to add custom attribute in magento customer module…

Include below script some where in your template file and load it once…

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$setup->addAttribute('customer', 'customcode', array(
 'label'        => 'customcode',
 'type'        => 'varchar',
 'visible'    => true,
 'required'    => false,
'sort_order' = > 10


After run it once, please remove the above code.
Remove cache and check customer adding area in backend.

For removing any custom attributes…run below code from some where in your loading templates


$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$setup->removeAttribute('customer', 'customcode');


Once run , please remove above code…
Let me know your comments….

Use below php script and run through browser…

/* fill in your database name */
$database_name = "database";

/* connect to MySQL */
if (!$link = mysql_connect("server", "username", "password")) {
 die("Could not connect: " . mysql_error());

/* query all tables */
$sql = "SHOW TABLES FROM $database_name";
if($result = mysql_query($sql)){
 /* add table name to array */
 while($row = mysql_fetch_row($result)){
 die("Error, could not list tables. MySQL Error: " . mysql_error());

/* loop through and drop each table */
foreach($found_tables as $table_name){
 $sql = "DROP TABLE ".$database_name.".".$table_name." <br>";
 if($result = mysql_query($sql)){
 echo "Success - table $table_name deleted. <br>";
 echo "Error deleting $table_name. MySQL Error: " . mysql_error() . "<br>";

Taking Mysql Dumb :

mysqldump -u username -h localhost -ppassword database >  my_database_name.sql

To avoid lock table issue use below line of code…

mysqldump --skip-lock-tables -u username -h localhost -ppassword database >  my_database_name.sql

For easy restore

mysql -u username -h localhost -ppassword database ;

Above statement will lead to mysql console.. then execute below line

\. my_database_name.sql

Remember the file must be there in that path from where you took mysql statement.

Hope many getting the same version when trying upgrading from 1.4.2 to 1.5.
Try to follow below steps to resolve the issue…

1. Set folder permissions according to Magento Wiki

2. Clear out all downloaded extensions by running below mentioned script file…

sh /downloader/pearlib/clear
those who didn’t have shell acess to run sh, please view that file. You can see that script deletes some of the files in this folder.

3. Disable Cache, remove current session and cache files from var folder.

4. Then run magento-core/Mage_All_Latest from Magento connect manager
After first run you may get same version again (1.4.2) .  But now you can able to upgrade by manually select each package or by running below string in key field.

Feedbacks are very much helpfull…

In template Typoscript -

In setup write the below code

tt_content.stdWrap.dataWrap >
tt_content.stdWrap.prepend >


Seems to be getting much better currency exchange rate when compared to paypal. Also their transaction fee is very much less compared to Paypal.
I think paypal will lose few customers by xoom.com.
But xoom.com have some limitation for total money and number of transactions per Year.


1)  Check version release notes:

Check the version release notes from magento site. May be there is some special instructions for coming versions…

2) Backup your files

Backup all files manually or from linux shell. Before backup try to remove all cache files

3) Backup your database

mysqldump -u username -h localhost -ppassword database > my_database_name.sql

4) Disable cache from admin.

5) Delete cache and session directories  located here:

6) Execute “clean” bash script located in /downloader/pearlib directory

a) Run chmod +x clean  to be able to execute this script
b) ./clean to execute script

7) Finally go to Magento connect manager from your Magento admin
Paste this extension to upgrade Magento: magento-core/Mage_All_Latest
If its not working try below one in key field
Using: http://connect20.magentocommerce.com/community/Mage_All_Latest

After this is done, you should have new Magento, however if there was some custom coding, you should really know what is going on with your code.
Usually installation ends up with some minor problems that should be handled manually, sometimes even on default installations if you have really old version of Magento that you would like to upgrade.

8) Make proper testing before doing this production server


Step 6 is not necessary one…

Feedbacks are very helpful …

© 2014 Developers Corner Suffusion theme by Sayontan Sinha