Author Topic: Bug or feature?  (Read 2592 times)

franzpeter

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 467
    • 2in1-online | Software, Mac, PC, Netzwerk, Drucker, Pad, Display
  • VirtueMart Version: Virtuemart 3.2.6
Bug or feature?
« 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?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9743
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Bug or feature?
« Reply #1 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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

franzpeter

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 467
    • 2in1-online | Software, Mac, PC, Netzwerk, Drucker, Pad, Display
  • VirtueMart Version: Virtuemart 3.2.6
Re: Bug or feature?
« Reply #2 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.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9743
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Bug or feature?
« Reply #3 on: July 18, 2011, 15:08:50 pm »
Why should it produces errors?
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

alatak

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2047
    • alatak.net
Re: Bug or feature?
« Reply #4 on: July 19, 2011, 16:28:51 pm »
Hi,

Quote
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.
No it is not on purpose...
It is a probably a mistake.