VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: franzpeter on July 18, 2011, 12:01:16 PM

Title: Bug or feature?
Post by: franzpeter on July 18, 2011, 12:01:16 PM
Using MySQL 5.5.xx, all database tables become as type: MyISAM and Collation utf8_general_ci exept of one: jos_virtuemart_order_shipper_weight_countries. That table has InnoDB as engine. Is that a wrong declaration while installing the database or is it a feature to use InnoDB for that table?
Title: Re: Bug or feature?
Post by: Milbo on July 18, 2011, 12:27:26 PM
Good question.

I dont know myself. Using inndb for the small plugin table mostly used for storing orders make sense. In fact the plugin writer decides that. Valerie wrote the paypal plugin, so maybe she did that on purpose.
Title: Re: Bug or feature?
Post by: franzpeter on July 18, 2011, 14:13:52 PM
I don't think that mixture of InnoDB and MyISAM produces errors, as long as there are no foreign key constraints inside the mentioned table.
Title: Re: Bug or feature?
Post by: Milbo on July 18, 2011, 15:08:50 PM
Why should it produces errors?
Title: Re: Bug or feature?
Post by: alatak on July 19, 2011, 16:28:51 PM
Hi,

QuoteUsing MySQL 5.5.xx, all database tables become as type: MyISAM and Collation utf8_general_ci exept of one: jos_virtuemart_order_shipper_weight_countries. That table has InnoDB as engine.
No it is not on purpose...
It is a probably a mistake.