News:

Looking for documentation? Take a look on our wiki

Main Menu

Bug or feature?

Started by franzpeter, July 18, 2011, 12:01:16 PM

Previous topic - Next topic

franzpeter

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?

Milbo

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

franzpeter

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.

Milbo

Why should it produces errors?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

alatak

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.