VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: webbie65 on September 21, 2012, 15:32:55 PM

Title: Kundenfelder/Custom fields
Post by: webbie65 on September 21, 2012, 15:32:55 PM
Maybe someone can help me, because there are some fields in my virtuemart installation, which have not the right name.
So because i just copied my tables and did not migrate them, i put the users into virtuemart from my old installation with some new  fields, i think.
So my fieldnames are now:

      bank_iban    PHPSHOP_ACCOUNT_LBL_BANK_IBAN    
   bank_account_type    PHPSHOP_ACCOUNT_LBL_ACCOUNT_TYPE    
   bank_name    PHPSHOP_ACCOUNT_LBL_BANK_NAME    text    
   bank_sort_code    PHPSHOP_ACCOUNT_LBL_BANK_SORT_CODE    
   bank_account_nr    PHPSHOP_ACCOUNT_LBL_BANK_ACCOUNT_NR    
   bank_account_holder    PHPSHOP_ACCOUNT_LBL_BANK_ACCOUNT_HOLDER    
   delimiter_bankaccount    PHPSHOP_ACCOUNT_BANK_TITLE

Is there any way to change the name maybe? I tried in virtuemart, but it did not work.
Than i tried to make new items in the language file, but that wasnt also not possible!

So maybe you have any idear?

If i try to change this fields, i have following error:
Quote

        vmError: TableOrder_userinfos::modify table - Unknown column 'delimiter_bankaccount' in 'jos25_virtuemart_order_userinfos' SQL=ALTER TABLE `jos25_virtuemart_order_userinfos` CHANGE delimiter_bankaccount delimiter_bankaccount VARCHAR(255)
        vmError:

Title: Re: Kundenfelder/Custom fields
Post by: bytelord on September 21, 2012, 18:36:48 PM
Hello,

i think PHPSHOP_ refers to VM 1. If that language strings comes from a previous plugin that you was used with VM1, i don't think will be compatible with VM2 or you should use VM2 plugins.

btw, a solution is to disable that fields from shopper fields

But because i am not sure you should take a look over here you find some more information regarding your migration:
http://dev.virtuemart.net/projects/virtuemart/wiki/Upgrading_VM1_to_VM2_with_provided_packages
http://forum.virtuemart.net/index.php?topic=95236.0
http://www.ostraining.com/blog/joomla/virtuemart-11-to-version-2/

Regards
Title: Re: Kundenfelder/Custom fields
Post by: webbie65 on September 21, 2012, 21:30:12 PM
Yes, i know, that the error is because of copiing the tables, but there was no other solution for me,
because migration does not work and i always got an server error. I had 14.00 products, so you
understand maybe, what i mean!

No one with an idear how to change this fields?
In the database tables maybe?
Title: Re: Kundenfelder/Custom fields
Post by: bytelord on September 21, 2012, 22:46:30 PM
Hi,

Did you try to disable them from the BE under the shopper fields menu?