Virtuemart 3 testing

[fmlk4u]

I have tested VM 2.9.9e on a staging copy of the live website and in the backend I see no real problems sofar. But on the frontend I have layout artifacts despite the fact that I use css overiride (VM css in template.css)

For example compare page http://staging1.keyboard-centrum.nl/nl/winkel/keyboards with the live site http://keyboard-centrum.nl/nl/winkel/keyboards and see "Prijs", "Basisprijs", "Verkoopprijs (incl. 21% BTW) and "Artikelegegevens" moving around while on the live site everything is nicely aligned.

I hope I get it fixed in time, since I am not a css expert and it already took quite some time.

Regards, Fred

[jenkinhill]

We are now at VM2.9.9.2 so try that one.

[fmlk4u]

Hello,

I am currently installing and let you know the outcome. Installing gives a "big message" and I wonder what it means and if I should do something with it:

alterTable CHANGE kbc_virtuemart_categories.virtuemart_vendor_id : ALTER TABLE `kbc_virtuemart_categories` CHANGE COLUMN `virtuemart_vendor_id` `virtuemart_vendor_id` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'BELONGS TO VENDOR' AFTER `virtuemart_category_id`
alterTable CHANGE kbc_virtuemart_customs.custom_value : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `custom_value` `custom_value` VARCHAR(2000) COMMENT 'DEFAULT VALUE' AFTER `custom_tip`
alterTable CHANGE kbc_virtuemart_customs.field_type : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `field_type` `field_type` CHAR(2) NOT NULL DEFAULT '0' COMMENT 'S:STRING,I:INT,P:PARENT, B:BOOL,D:DATE,T:TIME,H:HIDDEN' AFTER `custom_desc`
alterTable ADD kbc_virtuemart_customs.is_input : ALTER TABLE `kbc_virtuemart_customs` ADD is_input tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Add input to cart' AFTER `is_cart_attribute`
alterTable CHANGE kbc_virtuemart_customs.custom_params : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `custom_params` `custom_params` VARCHAR(17000) NOT NULL DEFAULT '' AFTER `layout_pos`
alterTable CHANGE kbc_virtuemart_customs.shared : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `shared` `shared` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'VALID FOR ALL VENDORS?' AFTER `custom_params`
alterTable CHANGE kbc_virtuemart_medias.file_params : ALTER TABLE `kbc_virtuemart_medias` CHANGE COLUMN `file_params` `file_params` VARCHAR(17000) NOT NULL DEFAULT '' AFTER `file_is_forSale`
alterTable CHANGE kbc_virtuemart_medias.file_lang : ALTER TABLE `kbc_virtuemart_medias` CHANGE COLUMN `file_lang` `file_lang` VARCHAR(500) NOT NULL DEFAULT '' AFTER `file_params`
alterTable CHANGE kbc_virtuemart_orders.virtuemart_vendor_id : ALTER TABLE `kbc_virtuemart_orders` CHANGE COLUMN `virtuemart_vendor_id` `virtuemart_vendor_id` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `virtuemart_user_id`
alterTable ADD kbc_virtuemart_order_userinfos.tos : ALTER TABLE `kbc_virtuemart_order_userinfos` ADD tos tinyint(1) NOT NULL DEFAULT '0' AFTER `agreed`
alterTable ADD kbc_virtuemart_order_userinfos.customer_note : ALTER TABLE `kbc_virtuemart_order_userinfos` ADD customer_note varchar(2500) NOT NULL DEFAULT '' AFTER `tos`
alterTable ADD kbc_virtuemart_product_customfields.disabler : ALTER TABLE `kbc_virtuemart_product_customfields` ADD disabler INT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `customfield_price`
alterTable ADD kbc_virtuemart_product_customfields.override : ALTER TABLE `kbc_virtuemart_product_customfields` ADD override INT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `disabler`
alterTable CHANGE kbc_virtuemart_product_customfields.customfield_params : ALTER TABLE `kbc_virtuemart_product_customfields` CHANGE COLUMN `customfield_params` `customfield_params` VARCHAR(17000) NOT NULL DEFAULT '' COMMENT 'PARAM FOR PLUGINS' AFTER `override`
alterTable ADD kbc_virtuemart_product_customfields.product_sku : ALTER TABLE `kbc_virtuemart_product_customfields` ADD product_sku char(64) AFTER `customfield_params`
alterTable ADD kbc_virtuemart_product_customfields.product_gtin : ALTER TABLE `kbc_virtuemart_product_customfields` ADD product_gtin char(64) AFTER `product_sku`
alterTable ADD kbc_virtuemart_product_customfields.product_mpn : ALTER TABLE `kbc_virtuemart_product_customfields` ADD product_mpn char(64) AFTER `product_gtin`
alterTable CHANGE kbc_virtuemart_product_prices.product_price : ALTER TABLE `kbc_virtuemart_product_prices` CHANGE COLUMN `product_price` `product_price` DECIMAL(15,6) AFTER `virtuemart_shoppergroup_id`
alterTable CHANGE kbc_virtuemart_shoppergroups.shopper_group_name : ALTER TABLE `kbc_virtuemart_shoppergroups` CHANGE COLUMN `shopper_group_name` `shopper_group_name` CHAR(128) AFTER `virtuemart_vendor_id`
alterTable CHANGE kbc_virtuemart_shoppergroups.shopper_group_desc : ALTER TABLE `kbc_virtuemart_shoppergroups` CHANGE COLUMN `shopper_group_desc` `shopper_group_desc` CHAR(255) AFTER `shopper_group_name`
alterTable ADD kbc_virtuemart_shoppergroups.sgrp_additional : ALTER TABLE `kbc_virtuemart_shoppergroups` ADD sgrp_additional tinyint(1) NOT NULL DEFAULT '0' AFTER `default`
alterTable ADD kbc_virtuemart_userfields.cart : ALTER TABLE `kbc_virtuemart_userfields` ADD cart tinyint(1) NOT NULL DEFAULT '0' AFTER `account`
alterTable CHANGE kbc_virtuemart_userfields.userfield_params : ALTER TABLE `kbc_virtuemart_userfields` CHANGE COLUMN `userfield_params` `userfield_params` VARCHAR(17000) NOT NULL DEFAULT '' AFTER `sys`
alterTable ADD kbc_virtuemart_userinfos.tos : ALTER TABLE `kbc_virtuemart_userinfos` ADD tos tinyint(1) NOT NULL DEFAULT '0' AFTER `agreed`
alterTable ADD kbc_virtuemart_userinfos.customer_note : ALTER TABLE `kbc_virtuemart_userinfos` ADD customer_note varchar(2500) NOT NULL DEFAULT '' AFTER `tos`
alterTable ADD kbc_virtuemart_vendors_nl_nl.vendor_invoice_free1 : ALTER TABLE `kbc_virtuemart_vendors_nl_nl` ADD vendor_invoice_free1 char(255) NOT NULL DEFAULT '' AFTER `customtitle`
alterTable ADD kbc_virtuemart_vendors_nl_nl.vendor_invoice_free2 : ALTER TABLE `kbc_virtuemart_vendors_nl_nl` ADD vendor_invoice_free2 char(255) NOT NULL DEFAULT '' AFTER `vendor_invoice_free1`
alterTable ADD kbc_virtuemart_vendors_nl_nl.vendor_mail_free1 : ALTER TABLE `kbc_virtuemart_vendors_nl_nl` ADD vendor_mail_free1 char(255) NOT NULL DEFAULT '' AFTER `vendor_invoice_free2`
alterTable ADD kbc_virtuemart_vendors_nl_nl.vendor_mail_free2 : ALTER TABLE `kbc_virtuemart_vendors_nl_nl` ADD vendor_mail_free2 char(255) NOT NULL DEFAULT '' AFTER `vendor_mail_free1`
alterTable ADD kbc_virtuemart_vendors_nl_nl.vendor_mail_css : ALTER TABLE `kbc_virtuemart_vendors_nl_nl` ADD vendor_mail_css char(255) NOT NULL DEFAULT '' AFTER `vendor_mail_free2`

Thanks for feedback. Together we will make it work

Regards, Fred

[fmlk4u]

The result of upgrade from 2.6.10 to 2.9.9.2:

See the screenshots in the attached pdf

[attachment cleanup by admin]

[fmlk4u]

More problems: see again screenshots as pictures tell more than words often: why do I suddenly have "Laatste modellen" (latest models) on the frontend?? And why am I notified that there are updates while there aren't really.

[attachment cleanup by admin]

[fmlk4u]

I also installed the latest 2.9.9.2 version in the test website on the server. Attached is the result. Again I wonder about the quality of the release candidate. Who can help me with the layout errors??

Compare the layout of products on the test site versus live site:

Test site: http://staging1.keyboard-centrum.nl/nl/winkel/keyboards
Live site: http://keyboard-centrum.nl/nl/winkel/keyboards

Why is the structure corrupted?? And how do I get rid of the footer with "Laatste modellen" ?

Thanks for helping me. I am slowly getting desperate, since I have to upgrade few other websites to Joomla 3.3.6, all as volunteer in private time.

Regards, Fred

[attachment cleanup by admin]

[Milbo]

Usually using update tables again solves the problem.

[fmlk4u]

Hello,

What do you mean by Update Tables? How can I do that?

Thanks for explanation, Fred

[Milbo]

install again or use the tools.

[fmlk4u]

Still very STENO/cryptic. Which tools?

[jenkinhill]

See the pic.

[attachment cleanup by admin]

[fmlk4u]

Hello Jenkin,

The result of updating tables is attached. Errors again and in the frontend it didn't help.



[attachment cleanup by admin]

[fmlk4u]

I made a new staging copy and upgraded directly from 2.6.10 to 2.9.9.2 without errors this time. And I managed to fix the corrupted template.

But now HOW CAN I GET RID OF THE SAW AND HAND SHOVEL IN THE BOTTOM OF EACH PAGE?

[PRO]

I made a new staging copy and upgraded directly from 2.6.10 to 2.9.9.2 without errors this time. And I managed to fix the corrupted template.

But now HOW CAN I GET RID OF THE SAW AND HAND SHOVEL IN THE BOTTOM OF EACH PAGE?

thats the sample date, remove those products

[fmlk4u]

When I remove the sample data (which I never installed !!!!) then I still keep "Laatste modellen" but instead of saw and hand shovel I see two grey thumbnails showing missing images. I want the whole 'featured products, latest models, or whatsever, out.