Upgrading to Mambo 4.5.1 & mambo-phpShop 1.2 beta3

We welcome Mambo 4.5.1 stable! Finally the best Mambo ever has been released. But as each new version has brought changes for mambo-phpShop's functionality it has happened again: The Component Installer has been changed and now it refuses to install the mambo-phpShop component "over" an existing installation of mambo-phpShop stating "another component is already using this directory".
So my "HOWTO Upgrade from 1.1 to 1.2" is out-of-date.
You'll find some hints on upgrading in the forums. One "hard" way is described in the >Read More< part.
btw: I just want to let you know that my Developer Notebook needs a new BIOS. :-( The development of mambo-phpShop will have to wait until the notebook is back from the Repair Center. NEVER flash your Notebooks' BIOS with an incompatible BIOS version! Now I'm smarter.

This will surely delay the release schedule of mambo-phpShop RC1 / stable. But I think mambo-phpShop can go stable in October 2004.
The hard way of Upgrading is to backup the mos_users and pshop_* database tables and your shop_image directory. Then install mambo-phpShop 1.2 beta3 in Mambo 4.5.1 and re-import the database structure and the shop_image directory. Finally run the SQL Upgrade Script. since Mambo 4.5.1 has no built-in Database Manager you can use com_phpmyadmin. Just copy and paste the following SQL queries:

ALTER TABLE `jos_pshop_shopper_group` ADD `default` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
CREATE TABLE `jos_pshop_product_reviews` (
  `product_id` varchar(255) NOT NULL default '',
  `comment` text NOT NULL,
  `userid` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `user_rating` tinyint(1) NOT NULL default '0',
  `review_ok` int(11) NOT NULL default '0',
  `review_votes` int(11) NOT NULL default '0'
) ENGINE=MyISAM;
CREATE TABLE `jos_pshop_product_votes` (
  `product_id` int(255) NOT NULL default '0',
  `votes` text NOT NULL,
  `allvotes` int(11) NOT NULL default '0',
  `rating` tinyint(1) NOT NULL default '0',
  `lastip` varchar(50) NOT NULL default '0'
) ENGINE=MyISAM;
   
ALTER TABLE `jos_pshop_category` ADD `category_browsepage` VARCHAR( 255 ) DEFAULT 'browse_1' NOT NULL AFTER `mdate` ;
ALTER TABLE `jos_pshop_category` ADD `products_per_row` TINYINT( 2 ) DEFAULT '1' NOT NULL AFTER `category_browsepage` ;
   
ALTER TABLE `jos_pshop_csv` ADD `csv_manufacturer_id` INT( 2 ) DEFAULT NULL;
UPDATE `jos_pshop_csv` SET csv_manufacturer_id='19';
   
ALTER TABLE `jos_pshop_payment_method` ADD `payment_class` VARCHAR( 50 ) NOT NULL AFTER `payment_method_name` ;
ALTER TABLE `jos_pshop_payment_method` ADD `payment_enabled` CHAR( 1 ) DEFAULT 'N' NOT NULL ;
ALTER TABLE `jos_pshop_payment_method` ADD `accepted_creditcards` VARCHAR( 128 ) NOT NULL ;
ALTER TABLE `jos_pshop_payment_method` ADD `payment_extrainfo` TEXT NOT NULL ;
   
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1, 'NEW_Authorize.net', 'ps_authorize', 5, '0.00', 0, 'AN', 'Y', 0, 'N', '1,2,6,7,', '');
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1, 'NEW_PayPal', 'ps_paypal', 5, '0.00', 0, 'PP', 'P', 0, 'N', '', '<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">\r\n<input type="image" name="submit" src="http://images.paypal.com/images/x-click-but6.gif" border="0" alt="Make payments with PayPal, it's fast, free, and secure!">\r\n<input type="hidden" name="cmd" value="_xclick" />\r\n<input type="hidden" name="business" value="<?php echo PAYPAL_EMAIL ?>" />\r\n<input type="hidden" name="receiver_email" value="<?php echo PAYPAL_EMAIL ?>" />\r\n<input type="hidden" name="item_name" value="Order Nr. <?php $db->p("order_id") ?>" />\r\n<input type="hidden" name="order_id" value="<?php $db->p("order_id") ?>" />\r\n<input type="hidden" name="invoice" value="<?php $db->p("order_number") ?>" />\r\n<input type="hidden" name="amount" value="<?php printf("%.2f", $db->f("order_total"))?>" />\r\n<input type="hidden" name="currency_code" value="<?php echo $_SESSION['vendor_currency'] ?>" />\r\n<input type="hidden" name="image_url" value="<?php echo $vendor_image_url ?>" />\r\n<input type="hidden" name="return" value="<?php echo SECUREURL ."index.php?option=com_phpshop&amp;page=checkout.result&amp;order_id=".$db->f("order_id") ?>" />\r\n<input type="hidden" name="notify_url" value="<?php echo SECUREURL ."administrator/components/com_phpshop/notify.php" ?>" />\r\n<input type="hidden" name="cancel_return" value="<?php echo SECUREURL ."index.php" ?>" />\r\n<input type="hidden" name="undefined_quantity" value="0" />\r\n<input type="hidden" name="mrb" value="NRUBJXESJTY24" />\r\n<input type="hidden" name="no_shipping" value="1" />\r\n<input type="hidden" name="no_note" value="1" />\r\n</form>');
    INSERT INTO `jos_pshop_payment_method` VALUES ('', 1, 'NEW_PayMate', 'ps_paymate', 5, '0.00', 0, 'PM', 'P', 0, 'N', '', '<script language="javascript">\r\nfunction openExpress(){\r\n   var url = 'https://www.paymate.com.au/PayMate/ExpressPayment?mid=<?php echo PAYMATE_USERNAME."&amt=".$db->f("order_total")."&currency=".$_SESSION['vendor_currency']."&ref=".$db->f("order_id")."&pmt_sender_email=".$dbbt->f("email");?>'\r\n   var newWin = window.open(url, 'wizard', 'height=580,width=500,scrollbars=1,toolbar=no');\r\n   self.name = 'parent';\r\n   newWin.focus();\r\n}\r\n</script>\r\n<div align="center">\r\n<p>\r\n<a href="javascript:openExpress();">\r\n<img src="https://www.paymate.com.au/images/paymate-PE-payment-88x31.gif" border="0" alt="Pay with Paymate Express"></a>\r\n<br />Pay with Paymate Express\r\n</p>\r\n</div>');
    INSERT INTO `jos_pshop_payment_method` VALUES ('', 1, 'NEW_WorldPay', 'ps_worldpay', 5, '0.00', 0, 'WP', 'P', 0, 'N', '', '<form action="https://select.worldpay.com/wcc/purchase" method="post">\r\n<input type="hidden" name="instId" value="<?php echo WORLDPAY_INST_ID ?>" />\r\n<input type="hidden" name="cartId" value="<?php echo $db->f("order_id") ?>" />\r\n<input type="hidden" name="amount" value="<?php echo $db->f("order_total") ?>" />\r\n<input type="hidden" name="currency" value="<?php echo $_SESSION['vendor_currency'] ?>" />\r\n<input type="hidden" name="desc" value="" />\r\n<input type="hidden" name="email" value="<?php $dbbt->p("email"); ?>" />\r\n<input type="image" scr="http://www.ecommercetemplates.com/images/worldpay.gif" alt="WorldPay" />\r\n</form>');
    INSERT INTO `jos_pshop_payment_method` VALUES ('', 1, 'NEW_2Checkout', 'ps_twocheckout', 5, '0.00', 0, '2CO', 'Y', 0, 'N', '1,2,3,', '');
   
    ALTER TABLE `jos_pshop_order_payment` ADD `order_payment_code` VARCHAR( 30 ) NOT NULL AFTER `payment_method_id` ;
   
    CREATE TABLE `jos_pshop_creditcard` (
    `creditcard_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
    `vendor_id` INT( 11 ) NOT NULL,
    `creditcard_name` VARCHAR( 70 ) NOT NULL ,
    `creditcard_code` VARCHAR( 30 ) NOT NULL ,
    PRIMARY KEY ( `creditcard_id` ));
    INSERT INTO `jos_pshop_creditcard` VALUES (1, 1, 'Visa', 'VISA');
    INSERT INTO `jos_pshop_creditcard` VALUES (2, 1, 'MasterCard', 'MC');
    INSERT INTO `jos_pshop_creditcard` VALUES (3, 1, 'American Express', 'amex');
    INSERT INTO `jos_pshop_creditcard` VALUES (4, 1, 'Discover Card', 'discover');
    INSERT INTO `jos_pshop_creditcard` VALUES (5, 1, 'Diners Club', 'diners');
    INSERT INTO `jos_pshop_creditcard` VALUES (6, 1, 'JCB', 'jcb');
    INSERT INTO `jos_pshop_creditcard` VALUES (7, 1, 'Australian Bankcard', 'australian_bc');
   
    INSERT INTO `jos_pshop_function` VALUES ('', 7, 'addReview', 'ps_reviews', 'process_review', 'This lets the user add a review and rating to a product.', 'admin,storeadmin,shopper,demo');
    INSERT INTO `jos_pshop_function` VALUES ('', '2', 'publishProduct', 'ps_product', 'product_publish', 'Changes the product_publish field, so that a product can be published or unpublished easily.', 'admin,storeadmin');
    INSERT INTO `jos_pshop_function` VALUES ('', '2', 'export_csv', 'ps_csv', 'export_csv', 'This function exports all relevant product data to CSV.', 'admin,storeadmin');
    INSERT INTO `jos_pshop_function` VALUES ('', '8', 'creditcardAdd', 'ps_creditcard', 'add', 'Adds a Credit Card entry.', 'admin,storeadmin');
    INSERT INTO `jos_pshop_function` VALUES ('', '8', 'creditcardUpdate', 'ps_creditcard', 'update', 'Updates a Credit Card entry.', 'admin,storeadmin');
    INSERT INTO `jos_pshop_function` VALUES ('', '8', 'creditcardDelete', 'ps_creditcard', 'delete', 'Deletes a Credit Card entry.', 'admin,storeadmin');