VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: pantsuk on March 18, 2014, 19:04:27 PM

Title: Manufacturer links not showing products
Post by: pantsuk on March 18, 2014, 19:04:27 PM
I have a site based on Joomla! 2.5.19 and Virtuemart 2.0216d

The site is pantsunderwearstore.com

I hope I have posted this in the right section please forgive if i have not but please reply if you can help

Since adding a new manufacturer on Saturday none of the manufacturer links  lead to a display of products either from the top menu "brands" link (which i have currently turned off due to this problem) of from the brand slider on the home page

When a manufacturer link is clicked now all I get for any manufacturer (brand) is the following message "Message: No record found  Go to the Home Page: Home Page"

If a search is done for a manufacturer in the search box on the home page the products show up but not using the usual manufacturer page

Before I turned off the menu link I called "Brands"  clicking on a manufactuer took you to the manufacturers page showing the logo and text write up but the link to show all the manufacturers products gave the same error result

A screen grab is attached showing the page for a manufacturer

I have looked for settings that might be wrong in Virtuemart and Joomla (I am a bit of a newbie so i might have missed something)

I am using the template VP Supermart I did ask for help on the template forum and got a reply telling me it is not a template issue it must be a VM or Joomla issue

My site has been working well until this issue and I really need some help to fix this

[attachment cleanup by admin]
Title: Re: Manufacturer links not showing products
Post by: jenkinhill on March 19, 2014, 09:26:55 AM
There is an update to the manufacturer product display for the next VM2.6 version. Test with pre-release/development version 2.5.4 on a copy of your site. http://dev.virtuemart.net/projects/virtuemart/files
Title: Re: Manufacturer links not showing products
Post by: Milbo on March 19, 2014, 22:04:23 PM
Please report your experience here, test also pagination and different ordering options :-)
http://forum.virtuemart.net/index.php?topic=122785.0
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 19, 2014, 22:57:08 PM
i am not experienced enough to test a new version

I simply want to find out how to fix the problem in my current version

If use inspect element in chrome i see that there is "no product container" where manufacturer products should show

I seems that my problem is a corrupt manufacturer module in some way

Is there a way I an reinstall just the manufacturer module?

Or can i reinstall the whole virtuemart 2.026d without losing all my data?
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 22, 2014, 00:13:50 AM
Tonight tried something I went to Extension manager and went to Virtuemart Manufacturers I checked the box on the left and clicked Refresh Cache I got the following result

Failed loading XML file
/home/pantsund/public_html/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.xml
XML: Opening and ending tag mismatch: fieldset line 61 and config
XML: Opening and ending tag mismatch: fields line 60 and extension
XML: Premature end of data in tag config line 59
XML: Premature end of data in tag extension line 3
Failed loading XML file
/home/pantsund/public_html/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.xml
XML: Opening and ending tag mismatch: fieldset line 61 and config
XML: Opening and ending tag mismatch: fields line 60 and extension
XML: Premature end of data in tag config line 59
XML: Premature end of data in tag extension line 3
XML: Opening and ending tag mismatch: fieldset line 61 and config
XML: Opening and ending tag mismatch: fields line 60 and extension
XML: Premature end of data in tag config line 59
XML: Premature end of data in tag extension line 3

Can you help me to fix this please I need to urgently get my store working again I am getting no orders at all since this problem started
Title: Re: Manufacturer links not showing products
Post by: jenkinhill on March 22, 2014, 15:46:44 PM
Sounds like you need to re-install the VM aio component, byt just to be sure I'd reinstall both VM components. Use Joomla's extensions manager installer. YOur data does not get overwritten, but as ever, test this on a backup copy of your site, as should be done with all updates.
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 22, 2014, 20:14:28 PM
Thank you very much for your advice

I set up a test server uploaded the latest backup (1 day old) and reinstalled vM 2.026d and VM aio but this has not fixed my problem  I am no longer getting the error messages above so its progress

I am now completely lost

all of a manufacturers products show when a search is done on the manufacturer using the site search box , but when licking on the manufacturer link from the manufacturers list page (allbrands) on my test site the link just still shows the error as if no data is being delivered to (according to chrome) there is"no products container" on the page all other modules seen to be ok and all other links are working

Any further help you can offer will be very very welcome


Title: Re: Manufacturer links not showing products
Post by: jjk on March 22, 2014, 21:27:13 PM
On a VM 2.0.27 test site I can reproduce that if VirtueMart SEO is enabled and Joomla 'Search Engine Friendly URLs' are disabled. The manufacturer's products show again if I enable Joomla SEF URLs again.
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 24, 2014, 18:36:47 PM
Thank you for your advice I set up a copy of my site on a test server  uploaded VM2.5.4 and the not showing products when clicking on a manufacturer seems to have fixed the problem

But now if i try to create or edit a manufacturer or change a payment method  i get the following red message in the admin section

vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias.

Then below that i get

Manufacturer (or payment method) successfully saved

But in fact nothing has saved

Title: Re: Manufacturer links not showing products
Post by: jjk on March 24, 2014, 19:58:04 PM
In my VM 2.5.4 test version I have not yet been able to reproduce your "vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias."
What is the manufacturer name and it's Manufacturer Sef Alias? Perhaps there is a problem with a special character?
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 25, 2014, 11:37:38 AM
The problem occurs when adding a new manufacturer, editing an existing manufacturer, it  also happens when adding or deiting a product category  and adding or editing a payment method

it does not happen when adding or editing a product, a customer, a custom field or a product image

The problem happens if the sef alias field is left empty and it also happens if an sef alias is entered no special characeters have been used deliberately in any of the entries
Title: Re: Manufacturer links not showing products
Post by: jjk on March 25, 2014, 18:23:46 PM
Does your problem go away if you click on 'Tools & Migration' > 'Install or if necessary update tables' and eventually click also on the 'Update VM-plugin tables' at 'Components > virtuemart-aio?
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 25, 2014, 20:27:20 PM
I tried your suggestion unfortunately this makes no difference at all

I would like to say thank you for all of the advice you guys are giving me I really appreciate it
Title: Re: Manufacturer links not showing products
Post by: jenkinhill on March 25, 2014, 21:49:05 PM
The SEF alias you enter is just lower case letters with the only other character being a hyphen if needed? No other characters?
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 25, 2014, 22:07:15 PM
If I try to add a new manufacturer by clicking the + icon I enter Test Brand as the Manufacture in the field Manufacturer Name then I enter test as the Manufacturer Sef Alias associate it with a manufacturer category enter a description and then hit save all that happens is i get the following two contradictory messages at the top of the page

vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias.
Manufacturer successfully saved

and a blank manufacturer page. The same happens on payment methods etc

I am completely lost with this issue, If I go back to the previous installed version of 2.016d the problem does not happen but I m back to the missing product details that I started this thread with
Title: Re: Manufacturer links not showing products
Post by: jjk on March 26, 2014, 11:58:21 AM
Do you use K2mart like this user with the same problem?
http://www.joomlaworks.net/forum/k2mart-v2-x-for-joomla-2-5-virtuemart-2-x/12233-an-error-of-k2mart-migrator#47340
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 26, 2014, 17:29:14 PM
I have K2 installed but not K2Mart

I just set the debug to report when I try to edit a manufactuer and this is what it reported, I thought it might help

vmdebug $siteLang: en-GB self::$_jpConfig->lang en_gb
vmdebug vmTime: loadConfig db no: 0.00259518623352051
vmdebug Start used Ram 4.25M
vmdebug Check returned false VmTableData #__virtuemart_manufacturers
vmdebug vmTime: VirtueMartControllerManufacturer Finished task manufacturer: 0.0233480930328369
vmdebug End used Ram 5.25M
vmdebug Peak memory peak 5.25M
vmdebug $siteLang: en-GB self::$_jpConfig->lang en_gb
vmdebug vmTime: loadConfig db no: 0.00259304046630859
vmdebug Start used Ram 4.5M
vmdebug vmTime: VirtueMartControllerManufacturer Finished task manufacturer: 0.22674298286438
vmdebug End used Ram 10.5M
vmdebug Peak memory peak 10.5M


vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias.
Manufacturer successfully saved
Title: Re: Manufacturer links not showing products
Post by: franzpeter on March 26, 2014, 17:38:29 PM
Are you shure that the error comes from the Backend while entering a new manufacturer. I could imagine that it comes from a different place. Are all necessary data inside the shop configuration? If there is something missing in case of vendor, such an error may occur.
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 26, 2014, 17:45:14 PM
I am not sure what you mean by that,

The problem not only happens when I add or edit a manufacturer but also the manufacturer category and when i add /edit payment methods

I must admit to now being a bit out of my depth with this  but i need to get it sorted  so i can start to promote my site and add the new manufactuers  whos products i need to sell
Title: Re: Manufacturer links not showing products
Post by: franzpeter on March 26, 2014, 18:47:08 PM
I just mean, did you enter all necessary things into the shop configuration in BE and that shopowner is vendor? If there is something wrong in that Shop configuration (something mandatory is missing for example), such an error can occur. The error message is a little bit misleading in that case, because the error source is somewhere else.
Title: Re: Manufacturer links not showing products
Post by: pantsuk on March 26, 2014, 22:26:13 PM
As far as I can see all the BE settings are ok I vendor is store owner etc

These settings have not been changed  since the original site was functioning properly before the original problem of missing products mentioned at the start of the thread happened

Title: Re: Manufacturer links not showing products
Post by: pantsuk on April 10, 2014, 15:40:13 PM
Hi Guys I have still not resolved the issue and I am completely lost now

I checked that I have super administator rights  so that isnt the problem

I can delete a manufactuer, a product category, a payment method etc but I still cant edit or create new ones  without the error message

vmError: VmTableData Sef Alias in record is missing! Can't save the record with no Sef Alias.

I have a couple of hundred new products I need to add which isnt a problem but I cant create the categories or manufacturers for them

Title: Re: Manufacturer links not showing products
Post by: jenkinhill on April 10, 2014, 15:52:22 PM
WE may have some insight into this issue. What PHP version are you using on the server?
Title: Re: Manufacturer links not showing products
Post by: pantsuk on April 10, 2014, 16:33:44 PM
The problem did not exist until I upgraded to VM 2.026d and still exists on VM2.5.4

The info from our server control panel is

cPanel Version   11.42.0 (build 24)
Theme   x3
Apache version   2.2.22
PHP version   5.2.17
MySQL version   5.1.73-cll
Architecture   x86_64
Operating system   linux

Hope this helps
Title: Re: Manufacturer links not showing products
Post by: jenkinhill on April 10, 2014, 17:00:18 PM
That looks like it! Your PHP version is too old. The minimum requirement now for VM (and very soon for Joomla) is a minimum of PHP5.3.10  - and recommended for J2.5 is 5.4+

See these
http://forum.virtuemart.net/index.php?topic=123194.msg420640#msg420640
http://forum.virtuemart.net/index.php?topic=123271
Title: Re: Manufacturer links not showing products
Post by: pantsuk on April 10, 2014, 23:33:06 PM
Hi, I just wanted to update you. I have updated the PHP on our server to the latest stable version available and "fingers crossed" this seems to have solved my problem. I have also updated VM to the version

Thank you so much for your patience with me and for your invaluable help