Guys I have a problem....
I installed Virtuemart Together with a Quickstart from a Joomlart Template...
I Imported products with CSVI Pro and now have these errors :
getProductCustomsFieldCart Unknown column 'show_title' in 'field list' SQL=SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden` FROM `wwb0z_virtuemart_customs` AS C LEFT JOIN `wwb0z_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id` Where `virtuemart_product_id` =20 and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z" and is_cart_attribute = 1 group by virtuemart_custom_id ORDER BY field.`ordering`
The URL is : http://www.mmawarehouse.co.za/index.php/shop
Please can you tell me if :
a) this is a Virtuemart Bug
b) A problem with CSVI pro
c) A template Problem
The template guy is blaming the CSV pro guy and the CSV guy is blaming the Template guy...
I just urgently need to get to the bottom of this and build this clients website
How did you updated the store? Please use in the tools update Tables to get rid of it.
Hi Milbo,
I so far have not Updated the Store...
it is on : V 2.0.22
Should I still do as you suggested ?
Did you install the Hawkstore quickstart package and then install VM2.0.22?
Hi Jenkinhill
yes I think so - rather what happened was it gave errors so I uninstalled and re-installed VM
The quickstart package already has VM installed, 2.0.20b or earlier. If you did not do a complete uninstall through Joomla's extensions manager for component, modules & plugins followed by a check with ftp for remaining files I guess I would call this an upgrade.
Have you tried the table updater?
I just installed the Hawkstore quickstart and then updated it to VM2.0.22 - no errors there at all. What PHP version are you running?
Hi Jenkinhill,
I am unsure which Tool to use there - is it :
Reset all tables and install sample data ?
PHP : 5.2.17
The errors only starts happening when I use the CSVI Pro Component
Install or if necessary update tables - but first, in Configuration/Shop you must select "Enable database Update tools " (it is a safety mechanism!)
I now get this Error when I try :
Parse error: syntax error, unexpected T_PAAMAYIM_NEKUDOTAYIM in /home/mmawareh/public_html/administrator/components/com_virtuemart/models/updatesmigration.php on line 303
That tells us you are using PHP5.2 and not the recommended for Joomla 2.5 version, PHP5.3
VM2.0.22a will be available very soon which is backwards compatible with the old PHP version. Or possible fix: http://forum.virtuemart.net/index.php?topic=117072.msg395217#msg395217
Just to make sure :
I replace : updatesmigration.php in : /administrator/components/com_virtuemart/models
Download VM 2.0.22 and install that manually ?
Thank you for your help so Far Jenkinhill
Ok I tried this Solution : http://forum.virtuemart.net/index.php?topic=117072.msg395217#msg395217
I Replaced : updatesmigration.php in : /administrator/components/com_virtuemart/models
VM now seems to be on Version : 2.0.22a but I got an Invalid Token in Store Configuration message when I clicked on Upgrade...
So it seems to have upgraded but my Store front is blank... The initial Error message is no longer Displaying.
I also tried : Install or if necessary update tables under Tools and its still not displaying any Categories ?
Please Help?
Do I uninstall and re-install VM Latest Version ? Then re-import the Products via CSV Pro ?
You never should reinstall, always do updates!
The new version 2.0.22a is released and the T_PAAMAYIM_NEKUDOTAYIM is solved there. Just download the package, use the normal joomla extension installer. Done.
Moving the files manually and using "update tables if necessary" is the same as using the extension installer.
Hi Milbo,
will this solve my initial issue?
The Errors Displaying, Stocakble Variants not showing etc ?
What is : T_PAAMAYIM_NEKUDOTAYIM ?
It is an old version PHP error using a Hebrew name where it cannot handle something in the PHP code - the code VM was written and tested using PHP5.3+ and this issue did not appear until some users updated their VM version while on PHP5.2 servers. A fix has been included for that in VM2.0.22a so that it is backwards compatible with PHP5.2
Hi Jenkhill,
Thanks again for your reply...
Is there a possibility that this could have broken the rest of my site at all ?
After trying this the rest of the site is also displaying Blank Pages like the Shop page... www.mmawarehouse.co.za
Not likely that this would break anything else. Blank pages is usually the result of a 500 error. See http://forum.virtuemart.net/index.php?topic=117042.0
You can just install the 2.0.22a component, com_virtuemart.2.0.22a.zip, the aio component will not need updating too as it is the same as 2.0.22
If in doubt all files are here: http://dev.virtuemart.net/projects/virtuemart/files
Uriel, are you shure that Virtuemart is the problem with the 'blank pages'? If I click on the shop and take a look into the source code, it is a visual problem. Inside the sourcecode it seems to produce something. I see some javascripts and something called 'megamenu'. Can you try to switch those additional things off to see if you get the page visible. Could it be a css issue with z-index, so everything is covered by black background?
Thanks Franzpeter,
That was a Template Issue.
Ok Errors are gone (thank you very much to both Jenkhill & Milbo) - but Stockable Variants are still not displaying price Change when XL is selected
Please have a look at : http://www.mmawarehouse.co.za/index.php/component/virtuemart/hitman/urban-warfare-black-detail?Itemid=0
When I add a Product to Cart - it does not get added...
Would it be an option to NOT use the Hawkstore Template Only on the Virtuemart Part? if yes how would this be done in VM 2.0 ?
Uriel, there is a javascript conflict in case of add to cart. Therefore it seems to not work. It does not matter which size I select (l,m,s,xl or xx). I do not know that template, but I use for example Virtueplanet Supermart. With that template it is necessary to switch off for example the following things in the VM configuration (in backend) Configuration -> Templates -> ... I did switch off: Using the VirtueMart CSS, Using the VirtueMart jQuery, Use external google jQuery library because the template itself has those scripts already built in.
Another thing would be that there is something misconfigured in case of shopper groups. For example I am not logged in inside your website. So I am anonymous user. Maybe an anomymous user cannot add something into cart. If you login yourself with admin privileges into the frontend, can you add something into cart. That would be another issue.
Sorry for those try and error methods, but maybe it helps.
Hi Franzpeter,
Im afraid in the Template its not possible to switch those things off...
I have logged in and same issues happen - dont see price change when I select XL and cant Add to Cart...
This Client wants this template so I am not sure what to do...
Is there no way of using this Template but installing another Theme for VM like before ?
When I swap to the Normal Beez template everything works fine
Uriel, do you mean it is not possible inside the template to try to switch off. In the virtuemart configuration tab for templates it is possible to switch off, it has nothing to do with the template settings of the template itself. It is just in the VM configuration to exclude Javascript issues which may occur between the template and the VM scripts. So for example if the template itself has the necessary scripts included, you load double scripts, which may produce the described problem. By default, I do not know the used template, it should be possible to rename the overrides. Go to your templates folder -> your template name -> html -> and try to locate the com_virtuemart folder. You may rename it to bak_virtuemart. It provokes that VM uses the default VM template, because it does not find the overrides from the template makers. You may try know in the shop frontend about the add to cart functions. If that does not help, so that the add to cart is still not working rename the folder back to com_virtuemart and try to rename the folder mod_virtuemart_cart. Try again in the frontend.
About the other question to use just another virtuemart theme. That depends on the template. I am pretty shure that your template uses a framework. It may be very tricky to get a theme work with another framework. I would first try out with the described way above to rename the overrides for com_virtuemart, the find out what is going wrong. If even the default VM theme, which is loaded by renaming the com_virtuemart inside the template folder, does not work, the template company should think about an update.
Quote from: franzpeter on July 17, 2013, 10:53:07 AM
Uriel, do you mean it is not possible inside the template to try to switch off. In the virtuemart configuration tab for templates it is possible to switch off, it has nothing to do with the template settings of the template itself. It is just in the VM configuration to exclude Javascript issues which may occur between the template and the VM scripts. So for example if the template itself has the necessary scripts included, you load double scripts, which may produce the described problem. By default, I do not know the used template, it should be possible to rename the overrides. Go to your templates folder -> your template name -> html -> and try to locate the com_virtuemart folder. You may rename it to bak_virtuemart. It provokes that VM uses the default VM template, because it does not find the overrides from the template makers. You may try know in the shop frontend about the add to cart functions. If that does not help, so that the add to cart is still not working rename the folder back to com_virtuemart and try to rename the folder mod_virtuemart_cart. Try again in the frontend.
About the other question to use just another virtuemart theme. That depends on the template. I am pretty shure that your template uses a framework. It may be very tricky to get a theme work with another framework. I would first try out with the described way above to rename the overrides for com_virtuemart, the find out what is going wrong. If even the default VM theme, which is loaded by renaming the com_virtuemart inside the template folder, does not work, the template company should think about an update.
Hi Franzpeter,
We are half way there... Your suggestions with doing the Settings in Virtuemart helped with changing the prices when I select a more expensive size.
Renaming the Directories did not help and the problem I am still left with is the Add to Cart Function not working...
I am starting to think the Only other option is to try another Template :-[
Uriel, what happens if you switch off 'Display modal popup upon 'Add to cart''? It is in the configuration -> Checkout in the backend administration of VM. Does it show the cart with the added products or does the cart on the cart page remains empty?
It remains Empty - I tried your suggestion
Uriel, can you send me the backend login to at my private message mail?
I have done so Franzpeter.
thank you for being prepared to have a look - let me know if you get my message?
Uriel, did receive the message.
Did sent you a private message