all products gone after update to 2.0.22b

[carsten888]

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.

[Maxim Pishnyak]

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?

[carsten888]

looks like the same to me.

before update:

18
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:

18   
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.

[Maxim Pishnyak]

There is an additional zero above KG.

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.

[carsten888]

I'm not sure what to look for here. But I can send both databases (before and after update).

[Maxim Pishnyak]

I'm not sure what to look for here.

shoppergroups, categories, manufacturers

or pm me access

[carsten888]

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.

[Maxim Pishnyak]

You could rebuild your web shop on localhost from scratch. With the help of CSVI Improved.

[carsten888]

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.

[Maxim Pishnyak]

You could pm me access to Joomla and to phpmyadmin.

[carsten888]

I pm-ed you.

[carsten888]

same issue after updating to 2.0.22c.
unfortunately, this is on a live site.

I pm-ed you.

[capewellmj]

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.

[carsten888]

@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.

[carsten888]

I enabled debug and got this output.

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

Bericht
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