I've got a problem with the internet shop: there are no categories or items. And when I open VirtueMart in Control panel, then go for example to categories, I see some error in top of the page, something written in MySQL.
Can you fix it please?:) I don't know what happened
Best wishes
AS Templates
POSTED: 2014-07-21
Hello MERKULOV,
It looks like you have deleted all categories in your Joomla admin panel, because after we installed the quick-start package for you everything worked fine. If you have backup our suggestion is to restore it, otherwise it should be reinstalled.
Regards, AS Team.
merkulov
POSTED: 2014-07-30
Okay, so we'd like to ask you to reinstall it (When to pay?)
And also please tell me, what should we not to do to avoid this happening again?
AS Templates
POSTED: 2014-07-30
Hello MERKULOV,
Our suggestion is to make backup before making changes in the content.
Regards, AS Team.
merkulov
POSTED: 2014-07-30
Yes, of course, but what changes did we do? Deleted all the categories? So in future we should't delete them or what?
I just don't know what happened, and that person who did it - doesn't remember
AS Templates
POSTED: 2014-07-30
Hello MERKULOV,
Yes, you or somebody deleted all categories, what exactly was done we don't know, but it is necessary to have good knowledge in Joomla.
Regards, AS Team.
merkulov
POSTED: 2014-07-30
The thing is - may I create my own new categories and then delete default? Or should I keep them? Or rename to what I need?
Thanks!
AS Templates
POSTED: 2014-07-30
Hello MERKULOV,
The best is just to rename the default categories and add if needed new.
Regards, AS Team.
merkulov
POSTED: 2014-07-30
Okay, thank you very much!
When to expect the reinstalling?
AS Templates
POSTED: 2014-07-30
Hello MERKULOV,
For installation services please use the following page:
http://www.astemplates.com/installationservices
Regards, AS Team.
merkulov
POSTED: 2014-08-01
Hello!
I asked for an reinstallation, and it was made, but Virtuemart still doesn't work
When I open Product Categories or Products in CP, there are no categories or products and there are some errors on the top of the page, they say:
vmError: exeSortSearchListQuery Table 'serz41_jmvm.as002047_virtuemart_categories_ru_ru' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `as002047_virtuemart_categories_ru_ru` l JOIN `as002047_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `as002047_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC
vmError: vmTable loadTable 'serz41_jmvm.as002047_virtuemart_vendors_ru_ru' doesn't exist SQL=SELECT `as002047_virtuemart_vendors_ru_ru`.* ,`as002047_virtuemart_vendors`.* FROM `as002047_virtuemart_vendors_ru_ru` JOIN as002047_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE as002047_virtuemart_vendors_ru_ru.`virtuemart_vendor_id` = "1"
And I tried to create a category or product, but it didn't work.
Just like before the reinstallation: I click Save and nothing appears.
AS Templates
POSTED: 2014-08-01
Hello MERKULOV,
We are checking this issue.
Regards, AS Team.
AS Templates
POSTED: 2014-08-02
Hello MERKULOV,
Our developers sent you an request for access to your Control panel, but still not received answer, please check your email.
Regards, AS Team.
merkulov
POSTED: 2014-08-09
Hello
Now everything works fine, and I wanted to make sure that changing language wouldn't break the Virtuemart again, because we still don't know why it happened. May I change it?
Thank you
AS Templates
POSTED: 2014-08-10
Hello MERKULOV,
We are checking this option, sorry, it will take some time.
Regards, AS Team.
AS Templates
POSTED: 2014-08-10
Hello MERKULOV,
We installed Russian package and configured the VirtueMart component, everything is working. Please perform backup before making any changes: all files and database.
Regards, AS Team.
merkulov
POSTED: 2014-08-10
Thank you
But now the internet shop page says "Category id 0 not published"
What's that? I didn't do anything at all yet
And why is that: for example the Services page (main menu item) had the "services" alias before, like "http://vannas.ru/index.php/services", and now it is "http://vannas.ru/index.php?option=com_content&view=article&id=73&Itemid=468"
merkulov
POSTED: 2014-08-10
In my second question I meant that I'll have to change all the links that are made by now to the new ones, those with long URLs.
For ex. on this page http://vannas.ru/index.php?option=com_content&view=article&id=73&Itemid=468 all the links now became wrong
Maybe there is some way to fix it fast?
Thank you
AS Templates
POSTED: 2014-08-11
Hello MERKULOV,
On which page we can see this message please:
"Category id 0 not published".
The issue with SEF fixed.
Regards, AS Team.
merkulov
POSTED: 2014-08-11
This one:
http://vannas.ru/index.php/internet-shop
I see it like this: http://cs618324.vk.me/v618324901/15924/fS6ZKKK4VtU.jpg
When some category or products is opened - everything is fine, but the main page doesn't show the categories of products
Get an access to all 94 items designed and developed by AS Designing team plus all the future items
which will be released over the course of your club subscription.
Price starting from $59.00
I've got a problem with the internet shop: there are no categories or items. And when I open VirtueMart in Control panel, then go for example to categories, I see some error in top of the page, something written in MySQL.
Can you fix it please?:) I don't know what happened
Best wishes
It looks like you have deleted all categories in your Joomla admin panel, because after we installed the quick-start package for you everything worked fine. If you have backup our suggestion is to restore it, otherwise it should be reinstalled.
Regards, AS Team.
And also please tell me, what should we not to do to avoid this happening again?
Our suggestion is to make backup before making changes in the content.
Regards, AS Team.
I just don't know what happened, and that person who did it - doesn't remember
Yes, you or somebody deleted all categories, what exactly was done we don't know, but it is necessary to have good knowledge in Joomla.
Regards, AS Team.
Thanks!
The best is just to rename the default categories and add if needed new.
Regards, AS Team.
When to expect the reinstalling?
For installation services please use the following page:
http://www.astemplates.com/installationservices
Regards, AS Team.
I asked for an reinstallation, and it was made, but Virtuemart still doesn't work
When I open Product Categories or Products in CP, there are no categories or products and there are some errors on the top of the page, they say:
vmError: exeSortSearchListQuery Table 'serz41_jmvm.as002047_virtuemart_categories_ru_ru' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `as002047_virtuemart_categories_ru_ru` l JOIN `as002047_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `as002047_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC
vmError: vmTable loadTable 'serz41_jmvm.as002047_virtuemart_vendors_ru_ru' doesn't exist SQL=SELECT `as002047_virtuemart_vendors_ru_ru`.* ,`as002047_virtuemart_vendors`.* FROM `as002047_virtuemart_vendors_ru_ru` JOIN as002047_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE as002047_virtuemart_vendors_ru_ru.`virtuemart_vendor_id` = "1"
And I tried to create a category or product, but it didn't work.
Just like before the reinstallation: I click Save and nothing appears.
We are checking this issue.
Regards, AS Team.
Our developers sent you an request for access to your Control panel, but still not received answer, please check your email.
Regards, AS Team.
Now everything works fine, and I wanted to make sure that changing language wouldn't break the Virtuemart again, because we still don't know why it happened. May I change it?
Thank you
We are checking this option, sorry, it will take some time.
Regards, AS Team.
We installed Russian package and configured the VirtueMart component, everything is working. Please perform backup before making any changes: all files and database.
Regards, AS Team.
But now the internet shop page says "Category id 0 not published"
What's that? I didn't do anything at all yet
And why is that: for example the Services page (main menu item) had the "services" alias before, like "http://vannas.ru/index.php/services", and now it is "http://vannas.ru/index.php?option=com_content&view=article&id=73&Itemid=468"
For ex. on this page http://vannas.ru/index.php?option=com_content&view=article&id=73&Itemid=468 all the links now became wrong
Maybe there is some way to fix it fast?
Thank you
On which page we can see this message please:
"Category id 0 not published".
The issue with SEF fixed.
Regards, AS Team.
http://vannas.ru/index.php/internet-shop
I see it like this: http://cs618324.vk.me/v618324901/15924/fS6ZKKK4VtU.jpg
When some category or products is opened - everything is fine, but the main page doesn't show the categories of products
About SEF - thanks a lot!