VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: guybr on April 09, 2014, 17:04:24 PM

Title: Installed latest update - unable to add products
Post by: guybr on April 09, 2014, 17:04:24 PM
Hi,
I just updated my VM 2.0.26d with the latest update (from the last 1-2 days) and now when I try to add new products (to my existing store) I receive these 2 errors plus the confirmation that the product was saved(!) - but all the data fields for that product are blank:

vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias.
vmError: You are not an administrator or the correct vendor, storing of product cancelled

Product successfully saved


Searching around I saw one possible solution to the administrator problem - but that didn't solve my problem... Any idea what I need to do?
I never fill in the Sef Alias, in the original version before the update, VM filled it in automatically.

I noticed that since the update the "product information id" is 0 - which seems odd, since I already uploaded a few hundred items.

Worst case, can I re-install the previous version of VM I had until now?
Title: Re: Installed latest update - unable to add products
Post by: jenkinhill on April 09, 2014, 17:24:54 PM
What PHP version are you using? In your product names do you have characters other that alphabet letters, numbers or hyphen?

Reinstall? Just reload your pre-update backup is the best way.
Title: Re: Installed latest update - unable to add products
Post by: enzo1 on April 09, 2014, 18:53:33 PM
I have the same problem. I use Joomla 2.5.19, VM 2.6.0 a PHP 5.2.14
Please help me!

Thanks Enzo
Title: Re: Installed latest update - unable to add products
Post by: guybr on April 09, 2014, 18:54:41 PM
I upgraded to php 5.3, worked like a charm - T H A N K S!
Title: Re: Installed latest update - unable to add products
Post by: guybr on April 09, 2014, 19:05:01 PM
FYI for godaddy hosting users: http://support.godaddy.com/help/article/3937/viewing-or-changing-your-php-language-version?locale=en
Title: Re: Installed latest update - unable to add products
Post by: jenkinhill on April 09, 2014, 20:00:16 PM
enzo1  you need a minimum of PHP5.3.10 - preferably 5.4+
Title: Re: Installed latest update - unable to add products
Post by: Kongzi on April 10, 2014, 15:12:02 PM
Hello,

php 5.3.3 is not good ? My hosting is using this version ... I have to move again ? I think that I know your answer, but ...

Thanks, All the best
Title: Re: Installed latest update - unable to add products
Post by: jenkinhill on April 10, 2014, 15:22:54 PM
No, the minimum is 5.3.10 - the same minimum that Joomla is moving towards. This is for security reasons, allowing significantly higher levels of encryption. In any case, minimum to pass most PCI scans is now PHP5.4+
Title: Re: Installed latest update - unable to add products
Post by: laurelmtgirl on April 23, 2014, 20:46:11 PM
Quote from: guybr on April 09, 2014, 17:04:24 PM
Hi,
I just updated my VM 2.0.26d with the latest update (from the last 1-2 days) and now when I try to add new products (to my existing store) I receive these 2 errors plus the confirmation that the product was saved(!) - but all the data fields for that product are blank:

vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias.
vmError: You are not an administrator or the correct vendor, storing of product cancelled

Product successfully saved

LOOK NO FURTHER FOR A FIX.....I spent alllll morning trying anything and everything, all I had to do was call godaddy hosting and have them change my php language settings from 2.0 to 3.0 and WAHLAH!!! it works!!!! All of those wasted hours. Hope it works for you too.
Searching around I saw one possible solution to the administrator problem - but that didn't solve my problem... Any idea what I need to do?
I never fill in the Sef Alias, in the original version before the update, VM filled it in automatically.

I noticed that since the update the "product information id" is 0 - which seems odd, since I already uploaded a few hundred items.

Worst case, can I re-install the previous version of VM I had until now?