VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Development & Testing => Topic started by: Milbo on February 14, 2013, 23:37:54 pm

Title: [Updated] Release 2.0.18c
Post by: Milbo on February 14, 2013, 23:37:54 pm
Changes from 2.0.16c -d
- added cdata for javascript
- synchronising media got new break
- installation script, set max limit to 140 only if set lower already
- fixed that canonical cat is always a published one
- fixed problem with pagination, using manufacturer id as filter in category view
- prevent overwrite of child products if non price is set, if the parent is stored with more than one price
- opening a product, with a zero price is not anylonger storing the price as 0.0

Changes from 2.0.16d - 2.0.18a
- Front end editing : Adding Joomla text filtering when saving product description
- allow simple html for vendors
- Added default values to prevent error in registry.php
- breadcrumbs are more robust
- fixed category bulk, missing shopfunctionsf.php
- fixed canonical links

Changes from 2.0.18a - 2.0.18b (14. February)
- small fix in BE/tmpl/order.php, should show now first_name . last_name
- set the filter for customplugin data for the cart less strict
- added calculation per category for rules per cart
- added correct reducing of tax when a discount is used and different vattaxes are used for the products (thanks to Maik Künnemann)
- custom prices in dropdown applied all vattaxes in the list, should be fixed
- fixed ordering BE product list (thanks to David jardin)
- added if isset check in shoppergoup model to prevent notice
- Email subject price displayed in the correct currency
- Fixed displayed several times payment/shipment methods when a shopper is in several shopper group-
- fix in convertDimensionUnits
- fixed the doubled & in pagination routing
- stocklevel for stockindicator is now $product->product_in_stock - $product->product_ordered;
- moved TOS to top of check in cart.
- unpublished related products are not creating an empty div anylonger.
- vmtables, added a table fixer for the userfields (checking in modifytable if the column is actually there)
- Fixed an error which let rules count as vaild without customer input.
- added that shipment and tax, use generic rule, if only one product vat is used
- added step_order_level by Székely Dénes (thank you)
- added small function in the config view, which is testing if the vendorId of the storeowner is correctly set
- Added cancelTax to avalara
- added vmcalculation to trigger in order for avalara
- small adjustments to avalara userfields
- avatax,  country validation configuration
- avatax,  tax type with categories (prefix avatax-)

Changes from 2.0.18b - 2.0.18c (1. March)
- fix by kkmediaproduction (Maik Künnemann) and Max for cart rules per category.
- added ordering for child products
- added manufacturer for rules per product, thanks to <mediaDESIGN> St.Kraft, but wont work for rules per bill despite the categories
- RSS feed for homepage and category
- Fix for bug, that an admin changing address of a user could lost its own address, if the user was not a vm user already
- taxes for shipment selection view.html.php
- fix for email (thanks stan)
- exchanged calculateSalesPrice against setCartPrices (proxy function for legacy still there)
- fix, step_order_level by Székely Dénes was not working with old overwrites, compatibility enhanced
- removed non working cloning function of the prices
- fixed category sharing
- little fix in router, for standard listing
- new option for avalara, option to disable taxes if it is not the cart.
- avalara caching
- avalara added purchase order number,

Changes from 2.0.18c - 2.0.20a (13. March)
- added unified way of tcpdf , thanks Reinhold Kainhofer
- updated tcpdf
- removed fixed width in emails
- small fix for router, if used in 3rd party
- fix for unknown mathop
- For 2.0.20 added change of #__virtuemart_medias' 'file_params' to prevent notice doing update.
- Added min_order_level in default_addtocart.php to the quantity input box
- RSS feed topten
- fix to store the category depended results in the order
- Multilingual images (different images for each language)
- fixed setStoreOwner function (you can actually fix your store now with it)
- small Klarna fix (link corrected)
- Heidelpay, added missing arguement
- Country name libya changed to 'Libyan Arab Jamahiriya' and a few typos in language files
- added use vendor email address to the shopconfig, so you can activate the stan fix or not
- jquery.validationEngine-xx.js loaded by language
- increased size of userfield names to avoid problems with tooo long language keys
- fixed the problem that childs using price of parent had no prices in the cart
- added cache for getVendorCurrency function
- fixed displayed currency in orderslist. Now using the currency of the order
- moneybookers small fixes
- Added checks if invoice folder is writeable

http://dev.virtuemart.net/projects/virtuemart/files
Title: Re: Release 2.0.18b
Post by: lipes on February 16, 2013, 19:41:32 pm
Hallo! i've did the update from 2.0.18 a to b

and in the first file (com_virtuemart.2.0.18b.zip) give me this error:
vmError: alterTable CHANGE nl94_virtuemart_medias.file_url_thumb :

PS: another litle problem that i've detect is that in the VM Product module if we work with the default CSS and set "NO" in the option "Show Add-to-cart Link?" the products  will appear in column and not in row. If enabled the add to cart link the products will appear in row...

Some prevision about the VM 2.1 release date ?
Will be possible to VM dev team give a "new life" to VM product module... with multiple category selection in 2.1 (with using the category filter option)?
Title: Re: Release 2.0.18b
Post by: r_ekkie on February 16, 2013, 22:28:48 pm
and in the first file (com_virtuemart.2.0.18b.zip) give me this error:
vmError: alterTable CHANGE nl94_virtuemart_medias.file_url_thumb :

Same problem over here
Title: Re: Release 2.0.18b
Post by: BaidareW on February 17, 2013, 11:59:37 am
vmError: alterTable CHANGE yy5qv_virtuemart_medias.file_url_thumb :

Is this means something ?
Title: Re: Release 2.0.18b
Post by: Milbo on February 17, 2013, 12:29:01 pm
Is not a big thing, the table stays then as it was before, which is also okey. I just increased the length of the url.

new version is up, two small notices fixed.
Title: Re: Release 2.0.18b
Post by: lindapowers on February 17, 2013, 22:45:40 pm
We had the same warning but testing the site works perfectly and we have not noticed any serious bug, actually we have not noticed any bug yet.

Great work although we are still completely pissed by the checkout but we still hope you look in to it for the future, at least the TOS are moved to their logic place.

Looking forward for the 2.1 version.
Title: Re: Release 2.0.18b
Post by: rodfarrell on February 28, 2013, 13:14:49 pm
Does this solve the vat tax calculations when shopper groups have different rates?
Title: Re: Release 2.0.18b
Post by: Milbo on February 28, 2013, 22:51:56 pm
When shoppergroups have different rates? This should work since a long time. But the upcoming version has a calculator which can now use different rules per category. in the 2.0.18b the fix is not working :-(
Title: Re: Release 2.0.18b
Post by: rodfarrell on February 28, 2013, 22:56:07 pm
No, it doesn't work at all and may require me to scrap the whole site and start again with other software as it is a core requirement for my client.

The only way to have different tax rates for different shopper groups appears to be to assign one vattax to a usergroup and then assign a billtax for another group.  If you have two vattax rates everyone is charged the higher rate.  I don't know what you would do if you need three tax rates.
Title: Re: Release 2.0.18b
Post by: Milbo on March 01, 2013, 19:24:29 pm
I am quite sure you do not use it correct. We use this construction ourself since August in our own shop, so ....
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 02, 2013, 18:58:16 pm
Sorry guys, I forgot a file, new version is uploaded.
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 03, 2013, 21:38:02 pm
Still dont understand how updates work here, if 2.0.18b and 2.018c are marked as stable why is my system telling me:

A new version is available
Installed version 2.0.18b
Latest version 2.0.18a

I never know what is the latest official release.

Edit, read your reply here http://forum.virtuemart.net/index.php?topic=113103.0;topicseen
Title: Re: [Updated] Release 2.0.18c
Post by: BaidareW on March 05, 2013, 20:51:42 pm
Hello,

 updated from 2.0.18b to 18c and got this message on checkout :
 "Info: Unrecognised mathop  in calculation rule found, seems you created this rule with plugin not longer accesible (deactivated, uninstalled?)"

 Using istraxx quantity plugin and OPC module.
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 06, 2013, 02:19:22 am
Almost impossible. I mean, I have no clue how this message is connected to the update
Title: Re: [Updated] Release 2.0.18c
Post by: Nils on March 08, 2013, 12:17:28 pm
We also updated from 2.0.18b to 18c and got this message on checkout :
 "Info: Unrecognised mathop  in calculation rule found, seems you created this rule with plugin not longer accesible (deactivated, uninstalled?)"

So, clearly this has something to do with the 2.0.18c version
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 08, 2013, 19:10:23 pm
and what happens if you enter your calculation rule and select a new math op? Do you use also the quantity plugin nils?
Title: Re: [Updated] Release 2.0.18c
Post by: BaidareW on March 09, 2013, 15:11:52 pm
I changes shipping tax rules to "use default" and the problem seems gone but now shipping prices are without VAT (without taxes).
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 10, 2013, 19:00:26 pm
Using default, should show the tax for shipment. Which method of tax calculation do you use? by product? or by bill?
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 11, 2013, 10:09:16 am
2.0.20
Message:

Info: Your Virtuemart installation contains an error: No user as marked as vendor. Please fix this in your phpMyAdmin and set #__virtuemart_vmusers.user_is_vendor = 1 and #__virtuemart_vmusers.virtuemart_vendor_id = 1 to one of your administrator users. Please update all users to be associated with virtuemart_vendor_id 1.

What do you mean?

1 = ? superadministrator ID or what?
Whena I set 1 noting ...
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 11, 2013, 19:25:00 pm
and this error on product page:

vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `xsnib_virtuemart_products` as `p` JOIN `xsnib_virtuemart_products_bg_bg` as `l` using (`virtuemart_product_id`) JOIN `xsnib_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `xsnib_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 2 and `slug` < "анцунг-манцунг" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `xsnib_virtuemart_products` as `p` JOIN `xsnib_virtuemart_products_bg_bg` as `l` using (`virtuemart_product_id`) JOIN `xsnib_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `xsnib_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 2 and `slug` > "анцунг-манцунг" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price ASC LIMIT 0,1
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 11, 2013, 21:17:48 pm
Servlet, your installation is broken, please use the set store owner in the tools. Go in the config and store it,... logoff and logon.
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 12, 2013, 06:52:36 am
Thank you, I'll try it
Title: Re: [Updated] Release 2.0.18c
Post by: testa on March 12, 2013, 15:32:51 pm
Can we get an changelog and an updated language file ?
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 12, 2013, 16:50:09 pm
The changelog is at begin of the post. If you wanna have it more detailed, look here http://dev.virtuemart.net/projects/virtuemart/repository
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 12, 2013, 19:50:16 pm
I tryed to uninstall and there is an error:

Warning: include(/home/rabel/public_html/25/administrator/components/com_virtuemart/install/uninstall.virtuemart.html.php) [function.include]: failed to open stream: No such file or directory in /home/rabel/public_html/25/administrator/components/com_virtuemart/install/script.virtuemart.php on line 570

Warning: include() [function.include]: Failed opening '/home/rabel/public_html/25/administrator/components/com_virtuemart/install/uninstall.virtuemart.html.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rabel/public_html/25/administrator/components/com_virtuemart/install/script.virtuemart.php on line 570

is there something wrong?
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 12, 2013, 20:25:12 pm
After new instal again this NOTE:

Info: Your Virtuemart installation contains an error: No user as marked as vendor. Please fix this in your phpMyAdmin and set #__virtuemart_vmusers.user_is_vendor = 1 and #__virtuemart_vmusers.virtuemart_vendor_id = 1 to one of your administrator users. Please update all users to be associated with virtuemart_vendor_id 1.

This is when is no filled information in Shop -> Shop about shop administrator
I think this message is not correct. Better will be if there is a link to Shop -> Shop to fill the information about administrator!!
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 12, 2013, 21:23:33 pm
Thanks Servlet, we found it. This problem appears only, when you install it fresh. Looks like we must directly release it as an "a" version, grml.
Title: Re: [Updated] Release 2.0.18c
Post by: BaidareW on March 12, 2013, 21:27:29 pm
Also post somewhere what is new in 2.0.20. Because now it is always a little bit scary to update - always new problems together with good things :)
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 12, 2013, 22:53:59 pm
Heavens, do you read please the begin of hte post? there is it written, should I copypaste it here? again, in the same thread?
Title: Re: [Updated] Release 2.0.18c
Post by: gpessoa on March 13, 2013, 02:31:25 am
Hi Max,
You go wrong idea from BaidareW
You got there from 2.0.16c till 2.0.18c
But no 2.0.20, what’s new/ bug correction!
Title: Re: [Updated] Release 2.0.18c
Post by: atrus on March 13, 2013, 07:26:25 am
Indeed, we cannot also see update log for 2.0.20 in the first post.

Sent from my BlackBerry 9360 using Tapatalk
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 13, 2013, 13:12:56 pm
Hi Max,
You go wrong idea from BaidareW
You got there from 2.0.16c till 2.0.18c
But no 2.0.20, what’s new/ bug correction!

LoL fuck, yes you are right. Yehye forgive me please.

- added unified way of tcpdf , thanks Reinhold Kainhofer
- updated tcpdf
- removed fixed width in emails
- small fix for router, if used in 3rd party
- fix for unknown mathop
- For 2.0.20 added change of #__virtuemart_medias' 'file_params' to prevent notice doing update.
- Added min_order_level in default_addtocart.php to the quantity input box
- RSS feed topten
- fix to store the category depended results in the order
- Multilingual images (different images for each language)
- fixed setStoreOwner function (you can actually fix your store now with it)
- small Klarna fix (link corrected)
- Heidelpay, added missing arguement
- Country name libya changed to 'Libyan Arab Jamahiriya' and a few typos in language files
- added use vendor email address to the shopconfig, so you can activate the stan fix or not
- jquery.validationEngine-xx.js loaded by language
- increased size of userfield names to avoid problems with tooo long language keys
- fixed the problem that childs using price of parent had no prices in the cart
- added cache for getVendorCurrency function
- fixed displayed currency in orderslist. Now using the currency of the order
- moneybookers small fixes
- Added checks if invoice folder is writeable

Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 13, 2013, 17:18:02 pm
"- removed fixed width in emails"

Thanks thanks and thanks! finally, this little thing was pissing me so much :D

2.018a works pretty well and is quite stable but I see a lot of interesting fixes and changes in the taxes in this latest versions, any official release comming?
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 17:31:48 pm
Something else about this:

Quote
Info: Your Virtuemart installation contains an error: No user as marked as vendor. Please fix this in your phpMyAdmin and set #__virtuemart_vmusers.user_is_vendor = 1 and #__virtuemart_vmusers.virtuemart_vendor_id = 1 to one of your administrator users. Please update all users to be associated with virtuemart_vendor_id 1.

If you have a fresh install and if you fill fields in Shop -> Shop -> Additional Information -> Bill To Information, and press SAVE button INFO MESSAGE disappear, but you dont have access to Shop -> Shop -> Vendor. If you want access to Shop -> Shop -> Vendor you must manualy do this: Please fix this in your phpMyAdmin and set #__virtuemart_vmusers.user_is_vendor = 1 and #__virtuemart_vmusers.virtuemart_vendor_id = 1
If you dont do this, you cant set currency in Shop -> Shop -> Vendor, and your shop cannt work.
It needs a new a,b,c Release if you want more users to test 2.0.20 Release. or if they must do all the things I write.
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 17:43:40 pm
ANDDDD a bigg error again... new crash...

I can not figure out definitively what causes this error, but I guess due to the change in the primary language. If you change the default language, the store is broken because VM can not find in the database the same information for the products of the other language. And boom.

But... If you restore default language everything is good. Oh, I dont need new installation of VM.
I dont use multililanguage site, I just shift beck-end language.

Whats next?
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 17:51:05 pm
The next is ... I cant find where can I fill product information about other language to prevent crash if some admin change default language or I think is better to prevent crash if someone change back-and language when is not filled product info about other languages...
Title: Re: [Updated] Release 2.0.18c
Post by: lipes on March 13, 2013, 18:47:22 pm
I've instaled last version 2.0.20 in my localhost and now i get an error when i try to see Product Detail!

Code: [Select]
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `gui45_virtuemart_products` as `p` JOIN `gui45_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `gui45_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `gui45_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 15 and `slug` < "Sapato-8800" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id`= "3" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `gui45_virtuemart_products` as `p` JOIN `gui45_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `gui45_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `gui45_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 15 and `slug` > "Sapato-8800" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id`= "3" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price ASC LIMIT 0,1


Edit: BTW my Admin backend it's in English (sometimes i change to PT), BUT my localhost website front end it's in Portuguese.
MORE: I've did the downgrade until com_virtuemart.2.0.18a!
ALL VERSIONS -> 2.0.18b, 2.0.18c ... until 2.0.20 i get that problem! taking Zip and tar.gz files
And i did the instalations in English and Portuguese 2 times for each file... and get that error..

com_virtuemart.2.0.18a it's working without that kind of problem!
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 19:09:26 pm
CSS problem in cart table
Dont display table header
Font color is white, background color is white and you know...


[attachment cleanup by admin]
Title: Re: [Updated] Release 2.0.18c
Post by: lipes on March 13, 2013, 19:33:36 pm
servlet: hi, what kind of VM version are you using? I dont know that icons, did you change your template.. VM2 icons are in the vm2-sprite.png file.. so maybe you got a problem with all your css file, because maybe you're not using the default VM files ...
http://dev.virtuemart.net/svn/virtuemart/trunk/virtuemart/components/com_virtuemart/assets/images/vm2-sprite.png

Check your css here:
localhost/administrator/index.php?option=com_virtuemart&view=config
Configuration > Templates > and then: Using the VirtueMart CSS (X)
Shopfront Settings -> no override
VirtueMart Home Page Settings -> no override

and then test it again


PS: Milbo check my post please!

best regards to all
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 19:48:18 pm
Last VM
Default template of VM
I dont change anything just testing
Thist si not from me I thing because some headers are displayed some not

Using the VirtueMart CSS (X)
Shopfront Settings -> no override
VirtueMart Home Page Settings -> no override
That's right
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 19:58:46 pm
Payment and Shipment description is NOT FOR CART TABLE
In cart table must be only the name of payment and shipment eg BANK TRANSFER and DHL
I have 15 rows with shipment description and 10 rows for bank transfer description, what we do? This is no good. There arent e-shop with that cart table!!!

Payment and Shipment description must be in confirmation e-mail!!!

see attachment

[attachment cleanup by admin]
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 13, 2013, 21:12:52 pm
The same is in confirmation mail
See attachment

Payment and Shipment description is NOT FOR CART TABLE
They must be UNDER cart table
In cart table must be only the name of payment and shipment

[attachment cleanup by admin]
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 13, 2013, 21:24:38 pm
Something else about this:

Quote
Info: Your Virtuemart installation contains an error: No user as marked as vendor. Please fix this in your phpMyAdmin and set #__virtuemart_vmusers.user_is_vendor = 1 and #__virtuemart_vmusers.virtuemart_vendor_id = 1 to one of your administrator users. Please update all users to be associated with virtuemart_vendor_id 1.

If you have a fresh install and if you fill fields in Shop -> Shop -> Additional Information -> Bill To Information, and press SAVE button INFO MESSAGE disappear, but you dont have access ..............

The correct method is to go to the tools and set the id of yourself as shopowner. This function was before only working when the shop was NOT broken. But people use this function to fix a broken store, so I changed it. It removes first all connections of the mainvendor and set it then new to the id set in the form.

But I removed the insert, so it did not work for a new installation. This is already fixed since last friday, time to upload the next version.

.....If you change the default language, the store is broken because VM can not find in the database the same information for the products of the other language. And boom.

This is a completly known "problem". I use "" because it is not a real problem just a thing of knowledge. The multilingual function in vm2 is the fastest, but has this nasty trouble. But I just see it is often written in posts, but not in the official manual yet. It is very important to change the language before you start to enter your products. Virtuemart creates tables for every language. Virtuemart has its own language setting in the BE. So you can use VM only in russian, but joomla in all languages, or viceversa.

I cannot reproduce your CSS problem

Hmm the description is not for the cart? This is a matter of taste and what you write in your description. For this purpose we have the template overwrites. But similar to the width in the emails, just get some more... arguments. It is a matter of taste. So start a poll about it,.. if your idea has more than 50% we are very likely todo it,.. if you have more than 75% we will do it that way almost 100% (I never can give a guarantee, sorry).


I've instaled last version 2.0.20 in my localhost and now i get an error when i try to see Product Detail!

Code: [Select]
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `gui45_virtuemart_products` as `p` JOIN `gui45_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `gui45_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `gui45_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 15 and `slug` < "Sapato-8800" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id`= "3" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `gui45_virtuemart_products` as `p` JOIN `gui45_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `gui45_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `gui45_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 15 and `slug` > "Sapato-8800" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id`= "3" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price ASC LIMIT 0,1


Edit: BTW my Admin backend it's in English (sometimes i change to PT), BUT my localhost website front end it's in Portuguese.
MORE: I've did the downgrade until com_virtuemart.2.0.18a!
ALL VERSIONS -> 2.0.18b, 2.0.18c ... until 2.0.20 i get that problem! taking Zip and tar.gz files
And i did the instalations in English and Portuguese 2 times for each file... and get that error..

com_virtuemart.2.0.18a it's working without that kind of problem!


The only thing I can do is to select this ordering and try myself.
Title: Re: [Updated] Release 2.0.18c
Post by: lipes on March 13, 2013, 21:45:57 pm

I've instaled last version 2.0.20 in my localhost and now i get an error when i try to see Product Detail!
Code: [Select]
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `gui45_virtuemart_products` as `p` JOIN `gui45_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `gui45_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `gui45_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 15 and `slug` < "Sapato-8800" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id`= "3" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `gui45_virtuemart_products` as `p` JOIN `gui45_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `gui45_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `gui45_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 15 and `slug` > "Sapato-8800" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id`= "3" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price ASC LIMIT 0,1

Edit: BTW my Admin backend it's in English (sometimes i change to PT), BUT my localhost website front end it's in Portuguese.
MORE: I've did the downgrade until com_virtuemart.2.0.18a!
ALL VERSIONS -> 2.0.18b, 2.0.18c ... until 2.0.20 i get that problem! taking Zip and tar.gz files
And i did the instalations in English and Portuguese 2 times for each file... and get that error..
com_virtuemart.2.0.18a it's working without that kind of problem!


The only thing I can do is to select this ordering and try myself.

Ok! no hurry :)
I was just reporting because i try to did the update to last version.. from 2.0.16... but i'll stay in 2.0.18a .. ( it's working normal )
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 09:31:06 am
Thank you Milbo

1) But I have a fresh install not migration from older version. "Write here the new store owner id" is in migration tab :) In new fresh install there isnt vendor automaticly or I dont understand something ;) I can fix my shop but other users? :)

2) Where can I start a poll - in Feature requests?
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 10:06:33 am
There is an option "Use the vm1 order id as vm2 order number" in Tools -> Tools & Migration -> Migration, but there isnt SAVE buton for all settings?!? How can I use Order ID as Order number?
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 11:19:32 am
"Show product images" Dont work. Dont display mini thumb in the cart.
Configuration - Configuration - Checkout - Show product images

There is no problem in 2.0.20a
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 11:26:45 am
"Show checkout steps" Dont work. Nothing happen?!? For what is this opion. In older VM we have steps - shipping method select, payment method select on single page. If this option is for this dont work.

Configuration - Configuration - Checkout - Show checkout steps
Title: Re: [Updated] Release 2.0.18c
Post by: reinhold on March 14, 2013, 11:44:58 am
How can I use Order ID as Order number?

For new orders, I don't think there is any way short of a core hack (i.e. manually changing the virtuemart code). The reason is that all the hooks that VirtueMart provides to modify the order number happen before the order is saved to the database. On the other hand, the order id is created only when the order is stored to the database (i.e. long after the order number has been created)...
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 12:16:53 pm
How can I use Order ID as Order number?

For new orders, I don't think there is any way short of a core hack (i.e. manually changing the virtuemart code). The reason is that all the hooks that VirtueMart provides to modify the order number happen before the order is saved to the database. On the other hand, the order id is created only when the order is stored to the database (i.e. long after the order number has been created)...

It needs Order ID = Order number only for confirmation e-mail and thank you message. First order is stored in database, second e-mail and thank you
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 12:59:34 pm
Show Terms of Service on the cart/checkout? - dont work correct!!! See attached file
If is unchecked only hide the text "Click here to read terms of service and check the box to accept them.", but there is a check box. Why there is a check box will ask every customer? And will they check? And what if check? :) :)

If option "Show Terms of Service on the cart/checkout?" is unchecked in cart must not contain both - check box and text.

Configuration - Configuration - Checkout - Show Terms of Service on the cart/checkout?

[attachment cleanup by admin]
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 14, 2013, 13:02:04 pm
lol Servlet, this is discussed already since years. the order id is an internal data, which should NEVER be exposed. A customer should work with the order number, the store owner should only work with the order number.

The option you see there is for migration of old vm1 stores. To set the ID, just use the button. Dont enter anything. But easier it is to load the 2.0.20a
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 13:19:07 pm
lol Servlet, this is discussed already since years. the order id is an internal data, which should NEVER be exposed. A customer should work with the order number, the store owner should only work with the order number.

The option you see there is for migration of old vm1 stores. To set the ID, just use the button. Dont enter anything. But easier it is to load the 2.0.20a

Good for product ID but what can you say about other of my notes? Some options dont work?

Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 14, 2013, 23:52:02 pm

Hmm the description is not for the cart? This is a matter of taste and what you write in your description. For this purpose we have the template overwrites. But similar to the width in the emails, just get some more... arguments. It is a matter of taste. So start a poll about it,.. if your idea has more than 50% we are very likely todo it,.. if you have more than 75% we will do it that way almost 100% (I never can give a guarantee, sorry).


Ok, which files I have to modify? I am searching more then 2h, and cannot find them. Two time I read row by row every one VM file.... There is not string shipment_desc in view folders only in admin files for storing in databese.
I cannot separate Shipment Name form Shipment Desc, for Payment too. Why there isnt this string in the template? What can we do if we want to display only Shipment/Payment name without Desc? We have no choice to do this manualy in tha template. It would bi nice if there are a check boxes in shipment/payment option to show/hide shipment/payment desc in shopping cart, thank you message, and confirmation mail.
There is no poll option in the forum. And in which folder in the forum I have to write, I cant understand?
Show me which big e-shop have the same shopping cart where payment and shippment desc. are in cart table.
Yes, shipment/payment desc is important. I LIKE this option, which is new for VM 2. I waited years for it, but this is not the correct way. shipment/payment desc must be outside of the table. Every one can make own chois where to put desc if there is a single string for desc.

Thank you in advance. I need your help, realy!
Title: Re: [Updated] Release 2.0.18c
Post by: reinhold on March 15, 2013, 00:06:19 am

Hmm the description is not for the cart? This is a matter of taste and what you write in your description. For this purpose we have the template overwrites.

Ok, which files to modify? I am searching more then 2h, and cannot find them. Two time I read row by row every one VM file.... There is not string shipment_desc in view folders only in admin files for storing in databese.
ou in advance.

Stop searching, you won't find it.
Actually, Milbo's suggestion to use template overrides to show the shipment description below the item table (which I would prefer, too; but it's a quite more complicated to implement) is not that straightforward.
The thing is that the shipment plugins already return the name of the plugin with the description APPENDED (function vmPSPlugin::renderPluginName in administrator/components/com_virtuemart/plugins/vmpsplugin.php). The best you can do is to hide the span with class shipment_desc in the template CSS...

Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 15, 2013, 00:24:55 am
reinhold
Thank you verry much
I find it, but I have only to remove desc :(
No way. I cannt believe it. :(
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 15, 2013, 00:37:46 am
OMG is an e-drama seriously.

Use rupostel's one page checkout and reinholds shipping by rules plugin like we do and configure the checkout as you want

You need a description for the payment? and a description for the shipment?

lol

Cant you just write UPS,DHL etc etc

and paypal, credit card etc etc

???

Title: Re: [Updated] Release 2.0.18c
Post by: reinhold on March 15, 2013, 00:55:30 am
Quote
OMG is an e-drama seriously.
But it also has its fun factor  ;)

Use rupostel's one page checkout and reinholds shipping by rules plugin like we do and configure the checkout as you want

You need a description for the payment? and a description for the shipment?

For payment methods like Bank transfer it actually makes a lot of sense to provide the full bank account data in the description... The only drawback is that it blows up the invoice layout.

Similarly, if you want to let your customers pick up the order at your shop, the shipping description of the "Pickup at the store" shipping method will contain the full address and maybe even driving directions. Again, this does not really fit in a table row between the items and the order total. But it would be very useful to have it at the bottom of the order confirmation and/or invoice.
And if you want to let your customers pay when they pickup the order at the store, it makes sense to tell them in the payment description of the payment method that you e.g. only accept cash and debit cards, but no creditcards. Etc, etc.

So, there are many good uses for the shipment and payment descriptions, but the fact that they are shown in table row between the order items and the order total makes it impossible to use descriptions longer than one or two lines, even though some situations would need a description of 10-15 lines...
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 15, 2013, 01:07:22 am
Fun indeed :D

For bank transfer what we use is the payment information, which appears once the order is confirmed and below the payment details at the email order.
Actually we find that place the correct one, but must be a matter of taste.

I guess we are confusing with payment description and payment information, these last one is the one we use for all that information that you comment in those cases, thats were we put our bank details etc

BTW the payment information can't be translated and uses the same text for all languages... which makes me think if:

a: im using the payment information when i should use the description
b: payment information should be translatable to all languages?

Regards
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 15, 2013, 01:22:17 am
But it would be very useful to have it at the bottom of the order confirmation and/or invoice.
.....
So, there are many good uses for the shipment and payment descriptions, but the fact that they are shown in table row between the order items and the order total makes it impossible to use descriptions longer than one or two lines, even though some situations would need a description of 10-15 lines...

There is trigger to display something like that, example is in the klarna payment method.

It may be better to provide as standard a layout without description. We could do a poll about it.
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 15, 2013, 10:36:55 am

For payment methods like Bank transfer it actually makes a lot of sense to provide the full bank account data in the description... The only drawback is that it blows up the invoice layout.


Exactly. I need this option for bank transfer. I don't want to display 6-7 rows with bank details between rows with prices. This is not user friendly. Something more I dint want to display it during checkout process. I will display it in confirmation mail and thank you message.


BTW the payment information can't be translated and uses the same text for all languages... which makes me think if:

a: im using the payment information when i should use the description
b: payment information should be translatable to all languages?

Regards

Really? This must be translatable in all cases!!!


Thank you Milbo :)
This is a first step :) I am happy :)
Just show where is that poll :)
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 15, 2013, 17:16:29 pm
Hi

I have just tested in virtuemart 2.020a and the payment information uses the same text for all languages (message when order is confirmed and inside the email)

Would be nice if you could make it translatable, really needed.

Regards
Title: Re: [Updated] Release 2.0.18c
Post by: lipes on March 15, 2013, 18:51:47 pm
(about payments) my opinion:
I use "bank transfer" because it's simple and easy to my fathers and to costumers. So in my own case dont need more kind of data information, because the costumer if will want to buy something will send us a bank email after buy something... and then we confirm the product stock manual + if the value it's correct.
If he/she dont send bank email we will contact costumer by email to send us a report if he/she really want to buy something (or not).

So if VM team put the needed obligation of filling the Costumers more Bank Data with tradicional Bank Transfers what client could do?
Maybe close the website and go to any other store. What i could do to stop that? change the file to put it simple again :)
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 15, 2013, 22:51:29 pm
Hi Lipes

you can see a screenshot here http://forum.virtuemart.net/index.php?topic=113942.0 I wrote a topic about it.

Virtuemart handles some translations in a way we can't understand. Works fine for most basic things but having to write translations of personal matters like payment details or shopper fields in language files makes no sense.

Translating order status, shopper fields and now these payment information seems a nightmare as we have to follow this tutorial http://docs.virtuemart.net/tutorials/36-multilingual-store/105-using-language-keys-in-form-fields.html

I hope they come up with a solution for it in the future, translating these basic fields shouldn't be so complicated.
Title: Re: [Updated] Release 2.0.18c
Post by: Milbo on March 16, 2013, 00:48:38 am
http://docs.virtuemart.net/tutorials/36-multilingual-store/105-using-language-keys-in-form-fields.html

and http://virtuemart.net/news/list-all-news/440-relaunch-of-virtuemart-portal
Title: Re: [Updated] Release 2.0.18c
Post by: lipes on March 17, 2013, 04:48:57 am
Serius BUG until 2.0.20a, or fail, or a error, or anything else that someone want to call it..
damm! http://forum.virtuemart.net/index.php?topic=100311.msg383647#new
Title: Re: [Updated] Release 2.0.18c
Post by: servlet on March 19, 2013, 12:15:57 pm
What are the chenges inf 20b?
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 19, 2013, 23:34:53 pm
Hello, after updating from 2.018a to 2.020b all the states are missing (they appear in backend) but not at front end, the dropdown list is empty for countries that have states like spain, germany, italy etc, they are published and were working in 2.018a.

We didnt get any errors or problems after updating, all seem to went smooth.

Any solution or idea?

Thanks

EDIT: Solved, Jquery for virtuemart was disabled in configuration, now works perfectly, sorry.
Title: Re: [Updated] Release 2.0.18c
Post by: lipes on March 22, 2013, 06:21:11 am
Does any one have any kind of captcha solution? Or someone in the VM Dev Team know if will be in the VM 2.1 ?

I've tryed some of them but no one it's working (or maybe need a hard hack code that it's far away from my knowledge ...)
Sorry for ask this here, because i cant find any integration that works since the VM 2.0.16 until now
(and i'am getting many spam emails like "99395 online blackjack ..." from the ask a question ...  :-\
Title: Re: [Updated] Release 2.0.18c
Post by: lindapowers on March 24, 2013, 14:18:03 pm
http://docs.virtuemart.net/tutorials/36-multilingual-store/105-using-language-keys-in-form-fields.html

and http://virtuemart.net/news/list-all-news/440-relaunch-of-virtuemart-portal

Tested but can't find a way to translate the payment information, even following that tutorial, using a languagekey etc

It just displays the language key and not it's text.
Title: Re: [Updated] Release 2.0.18c
Post by: bobchain on May 15, 2013, 16:39:17 pm
Hello everyone,
I wanted to undergo some changes made that I think are useful bring them in future releases of this wonderful product highly flexible and usable.

1)
Implementation done on my website: multimanufacturers for each product (like category)
Below is the link to the post author. The modification indicated was also performed and tested. If you need you can also see the result on online site.
https://forum.virtuemart.net/index.php?topic=100170.msg331099#msg331099 (https://forum.virtuemart.net/index.php?topic=100170.msg331099#msg331099)

2)
Implementation done on my website: change default ASC ordering with DESC (great for created date, but wrong for alphabetical ordering )
implementation that would be much appreciated.
make the setting dynamic ordering (ASC-DESC): for each enabled field to search.
possibility of giving weight to the fields on which to search, so that the result is conditional:
i) all the results found with keywords on the title
ii) all the results with keywords in the name of manufacturer
iii) all the results with keywords in product descriptions


I hope these tips will be useful for the next release

thanks for your works!!