VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: carsten888 on August 21, 2013, 13:46:01 PM

Title: all products gone after update to 2.0.22b
Post by: carsten888 on August 21, 2013, 13:46:01 PM
all products are still in the db, but won't display on the frontend and backend.
On another site everything seems to work just fine.
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on August 21, 2013, 14:28:32 PM
Quote from: carsten888 on August 21, 2013, 13:46:01 PM
all products are still in the db
Could you compare db rows for one product case? How did they look before update and how are they look after?
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on August 21, 2013, 15:06:36 PM
looks like the same to me.

before update:
Quote18
1
0
0.0000
KG
0.0000
0.0000
0.0000
M
0
0
0
2012-10-15 00:00:00
0
0
KG
0.0000
min_order_level=""|max_order_level=""|product_box=...
NULL
0
1
2012-10-15 07:51:33
91
2013-04-25 08:33:27
91
0000-00-00 00:00:00
0
after update:
Quote18   
1   
0      
0.0000   
KG   
0.0000   
0.0000   
0.0000   
M      
0   
0   
0   
2012-10-15 00:00:00      
0   
0   
0   
KG   
0.0000   
min_order_level=""|max_order_level=""|product_box=...   
NULL            
0   
1   
2012-10-15 07:51:33   
91   
2013-04-25 08:33:27   
91   
0000-00-00 00:00:00   
0

I placed back the vm component files for the frontend and admin back from before the update and all was working again. So files of 2.0.20b with current version db. So suspect somethings up in the code. No php errors.
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on August 21, 2013, 16:58:53 PM
There is an additional zero above KG.

Quote from: Maxim Pishnyak on August 21, 2013, 14:28:32 PM
Could you compare db rows for one product case? How did they look before update and how are they look after?
Could you try with other VM db tables? Use the same product_id of course.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on August 21, 2013, 19:58:26 PM
I'm not sure what to look for here. But I can send both databases (before and after update).
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on August 21, 2013, 20:17:55 PM
Quote from: carsten888 on August 21, 2013, 19:58:26 PM
I'm not sure what to look for here.
shoppergroups, categories, manufacturers

or pm me access
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on August 22, 2013, 12:28:36 PM
Its on localhost, so can't send you access. You wouldn't be able to debug it with what you saw anyway.
I rolled back to a previous version to get it going again and didn't update the online version.
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on August 22, 2013, 18:09:40 PM
You could rebuild your web shop on localhost from scratch. With the help of CSVI Improved.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on August 23, 2013, 08:46:56 AM
Yes I could start all over again, entering all the products etc. but I would rather fix what I got.

I can send you 2 Akeeba backups of the site. before the update and after.
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on August 23, 2013, 11:48:25 AM
You could pm me access to Joomla and to phpmyadmin.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on August 23, 2013, 17:44:52 PM
I pm-ed you.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on September 09, 2013, 11:36:48 AM
same issue after updating to 2.0.22c.
unfortunately, this is on a live site.

I pm-ed you.
Title: Re: all products gone after update to 2.0.22b
Post by: capewellmj on September 09, 2013, 18:56:29 PM
Hello. I just fixed a similar issue on one of my sites. Have you checked your product category page and the options at the bottom where it says default product page, category template, category browse page. On mine the default product details page got changed.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on September 10, 2013, 10:39:48 AM
@capewellmj
thanks for that suggestion.
All products are not in any particular category. There are no categories.

When I create a new product it shows in the admin, but only at the frontend when I (created a category and) assign it to a category. When I take the article out of the category it just disappears again.
Maybe a workaround would be to batch-assign all articles to a category, but as they are not showing in the admin I would need to code a script for that.

I am using VM in catalogus mode. But when I disable that in the main config, same issue.

I run the database update tool and got just minor alterations. Did not fix the issue.

Can someone please help.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on September 10, 2013, 10:41:34 AM
I enabled debug and got this output.

I don;t think there is anything usefull in there to fix this issue.

QuoteBericht
vmdebug My selected language by JFactory::getLanguage()->getTag() nl-NL
vmdebug self::$_jpConfig->lang en_gb
vmdebug vmTime: loadConfig db no: 0.012208938598633
vmdebug Start used Ram 6.25M
vmdebug setPaginationLimits is site and $cateid,$manid Var1:
0
Var2:
0
vmdebug Calculated $limit Var1:
60
Var2:
60
vmdebug vmTime: VirtuemartControllerCategory Finished task : 0.17642617225647
vmdebug End used Ram 11M
vmdebug Peak memory peak 11M

template overrides are disabled
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on September 12, 2013, 12:43:11 PM
Carsten888, then what do you have in
Quote from: capewellmj on September 09, 2013, 18:56:29 PM
Hello. I just fixed a similar issue on one of my sites. Have you checked your product category page and the options at the bottom where it says default product page, category template, category browse page. On mine the default product details page got changed.
template related options in your VM config?
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on September 12, 2013, 13:18:20 PM
QuoteCarsten888, then what do you have in template related options in your VM config?
I send you a login a few days ago (by PM). Please have a look.
Title: Re: all products gone after update to 2.0.22b
Post by: carsten888 on September 13, 2013, 14:07:32 PM
@Maxim
I'm a bit disappointed you did not take a look at my site after asking me for a login. I had this live site online broken for most of this week for you to check it.

Anyway. I found a solution.
Turns out the products where in the table with dutch products, while in the VM config there was only 'english' configured. This worked fine untill 2.0.22b.
I added 'dutch' to the language config and all products where back. backend and frontend.

So it seems this issue was about backward compatibility.
Title: Re: all products gone after update to 2.0.22b
Post by: Maxim Pishnyak on September 13, 2013, 20:10:54 PM
Thank you for positive criticism. I need to work better on my moderation style.