2.0.7 h: Invoice: Couldnt find customfieldtextinput Array

[vigier]

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

[Milbo]

thanks,

I am working on it,

[vigier]

Hi,

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

Kind regards,
Vigier

[Milbo]

also with this version? http://dev.virtuemart.net/attachments/download/443/com_virtuemart.2.0.7.j_extract_first.zip

[vigier]

I'll install it in a few minutes....

[vigier]

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

[vigier]

Small update: also tried it with a product that has 1 textplugin and 4 different cart variants and that also works fine!

[Milbo]

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)

[vigier]

Great! No errormessages anymore. Thanx a lot again!