The release "Mambo 4.5.2.1 eCommerce Edition" has been updated because of a small bug. The database structure file was missing the column order_payment_code for the table mos_pshop_order_payment. There was also a hardcoded "mos_" database prefix. Both bugs have been fixed by now. You can download the new release from mamboforge.net.
Please read on to see how to quickly fix the problem...If you're already using Mambo 4.5.2.1 eCommerce Edition, you can easily update your database by running the following query on your database (with phpMyAdmin):
ALTER TABLE `mos_pshop_order_payment`
ADD `order_payment_code` VARCHAR( 30 ) NOT NULL AFTER `payment_method_id` ;
Please replace "mos_" with your individual database prefix.
UPDATE: These queries are also necessary to be able to use the FileManager for mambo-phpShop eCommerce Edition:
INSERT INTO `mos_pshop_function` VALUES ('', 2, 'uploadProductFile',
'ps_product_files', 'add', 'Uploads and Adds a Product Image/File.', 'admin,storeadmin');
INSERT INTO `mos_pshop_function` VALUES ('', 2, 'updateProductFile',
'ps_product_files', 'update', 'Updates a Product Image/File.', 'admin,storeadmin');
INSERT INTO `mos_pshop_function` VALUES ('', 2, 'deleteProductFile',
'ps_product_files', 'delete', 'Deletes a Product Image/File.', 'admin,storeadmin'); 