Unsure if this is a Bug

[Uriel]

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

[Milbo]

How did you updated the store? Please use in the tools update Tables to get rid of it.

[Uriel]

Hi Milbo,

I so far have not Updated the Store...

it is on : V 2.0.22

Should I still do as you suggested ?

[jenkinhill]

Did you install the Hawkstore quickstart package and then install VM2.0.22?

[Uriel]

Hi Jenkinhill

yes I think so - rather what happened was it gave errors so I uninstalled and re-installed VM

[jenkinhill]

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?

[jenkinhill]

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?

[Uriel]

Hi Jenkinhill,

I am unsure which Tool to use there - is it :

Reset all tables and install sample data ?

[Uriel]

PHP : 5.2.17

The errors only starts happening when I use the CSVI Pro Component

[jenkinhill]

Install or if necessary update tables   - but first, in Configuration/Shop you must select "Enable database Update tools "  (it is a safety mechanism!)

[Uriel]

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

[jenkinhill]

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

[Uriel]

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

[Uriel]

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 ?

[Milbo]

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.