People, i need help testing 1.1.9 BETA

(1/1)

zanardi:
Hello guys, a BETA package for 1.1.9 is ready but since almost everyone in the team is working hard on VirtueMart 2 i need some testers to release this new package.
Can somebody help? The BETA package is available at:
http://dev.virtuemart.net/issues/362

Thank you.

franzpeter:
Did try to test it, but it does not install with MYSQL 5.5, because of wrong declaration in database. Should be engine= instead of type=.
Another bug:
Defining product type and parameter with virtuemart creates new tables for every product type (jos_vm_product_type_1,jos_vm_product_type_1 a.s.o.). With MYSQL 5.5 and above that does not work any more. VM uses a deprecated way to create those tables. Before MYSQL 4.0.18 a table creation was done with TYPE=MYISAM. Never database versions from 4.0.18 on can use ENGINE = MYISAM, from MYSQL 5.5... and above the declaration with TYPE = MYISAM is deprecated. So the database throws an error, which prevents the creation of those new tables jos_vm_product_type_xx. A simple patch is necessary to make it work again. We need to change one word in the file: administrator/components/com_virtuemart/classes/ps_product_type.php to make it work again. It is around line 124 from:
         // Make new table product_type_<id>
         $q = "CREATE TABLE `#__{vm}_product_type_";
         $q .= $product_type_id . "` (";
         $q .= "`product_id` int(11) NOT NULL,";
         $q .= "PRIMARY KEY (`product_id`)";
         $q .= ") TYPE=MyISAM;";
         $db->setQuery($q);

to:
         // Make new table product_type_<id>
         $q = "CREATE TABLE `#__{vm}_product_type_";
         $q .= $product_type_id . "` (";
         $q .= "`product_id` int(11) NOT NULL,";
         $q .= "PRIMARY KEY (`product_id`)";
         $q .= ") ENGINE=MyISAM;";
         $db->setQuery($q);

jenkinhill:
My understanding is that a lot of Joomla 1.5 extensions have similar issues with MySQL5.5 and some have commented that J1.5 itself can have issues on 5.5

My webhost will not be "upgrading" to 5.5 until the vast majority of scripts (Drupal, Nuke, Concrete etc) are updated to be compatible.

SO far I have found no 1.1.9 issues, but have had too little time for testing.

franzpeter:
Joomla itself is installable with MYSQL 5.5. But it too has some wrong declarations. By default, MYSQL 5.5 use InnoDB as default database engine. Because the Joomla database install script does not declare the engine, all Joomla tables receive InnoDB. But it works with InnoDB too. There are no foreign key constraints in Joomla so it does not matter. But the way to make everything work is to simply use ENGINE=MyISAM instead of TYPE=MyISAM. There is another problem with jos_vm_waiting_list while installing.

Navigation

[0] Message Index