VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Development & Testing => Topic started by: vigier on June 24, 2012, 21:03:08 PM

Title: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: vigier on June 24, 2012, 21:03:08 PM
Hi,

for products where I used CustomTextPlugin, the invoice (mail and PDF) give the following text instead of the user typed values: "Couldnt find customfieldtextinput Array".

Kind regards,
Vigier
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: Milbo on June 25, 2012, 21:37:59 PM
thanks,

I am working on it,
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: vigier on June 25, 2012, 23:41:31 PM
Hi,

Now I see it happens with other thingies like Cart Variants too. "Couldnt find customfield13".
Good luck with it!

Kind regards,
Vigier
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: Milbo on June 27, 2012, 22:24:43 PM
also with this version? http://dev.virtuemart.net/attachments/download/443/com_virtuemart.2.0.7.j_extract_first.zip
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: vigier on June 27, 2012, 23:22:13 PM
I'll install it in a few minutes....
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: vigier on June 27, 2012, 23:29:50 PM
I got an error while installing the AIO. Actually I did get this message also when I installed a previous subrelease of 2.0.7.

        vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `tblSR_virtuemart_payment_plg_standard` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(1) UNSIGNED, `order_number` char(64), `virtuemart_paymentmethod_id` mediumint(1) UNSIGNED, `payment_name` varchar(5000), `payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` char(3), `cost_per_transaction` decimal(10,2), `cost_percent_total` decimal(10,2), `tax_id` smallint(1), `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
        vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `tblSR_virtuemart_shipment_plg_weight_countries` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(11) UNSIGNED, `order_number` char(32), `virtuemart_shipmentmethod_id` mediumint(1) UNSIGNED, `shipment_name` varchar(5000), `order_weight` decimal(10,4), `shipment_weight_unit` char(3) DEFAULT 'KG', `shipment_cost` decimal(10,2), `shipment_package_fee` decimal(10,2), `tax_id` smallint(1), `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

After ignoring that, I tested it and it shows up in the confirmation mail and invoice again.
With 2 plugins (Width and Height) it still shows 4 values, but that's a different story, see topic http://forum.virtuemart.net/index.php?topic=104336.0

Thnx for the fix!
Kind regards, Vigier
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: vigier on June 27, 2012, 23:31:52 PM
Small update: also tried it with a product that has 1 textplugin and 4 different cart variants and that also works fine!
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: Milbo on June 28, 2012, 14:38:18 PM
When this is not a live store, then delete this tables and install the aio again.

you can also delete the problematic columns, the tables should be fixed then (in case you have already important data)
Title: Re: 2.0.7 h: Invoice: Couldnt find customfieldtextinput Array
Post by: vigier on June 28, 2012, 22:20:23 PM
Great! No errormessages anymore. Thanx a lot again!