hi
i have just upgraded from 1.9.8 M to 2.0 via the component. i have upgraded the AIO as well. my entire shop, products and categories has disappeared! could someone please help? i am using joomla 1.7.3.
Please specify: is it about front-end or back-end?
did you choose your default language first?
both front end and back end. i selected multilanguage? is that what you referring to?
go to database tools and "install or update tables"
just did that, still nothing. tried to download the installation files but for some reason the link is dead? http://dev.virtuemart.net/projects/virtuemart/files (http://dev.virtuemart.net/projects/virtuemart/files)
You do not see products and categories NOT in your language.
This is not an installation problem.
Are the products in the same as the default language?
When you save a product, it should appear right?
all my products and categories are in the same language. i do not have any products in a different language. the shop was working fine until i did the upgrade. now there are no products and no categories...
http://forum.virtuemart.net/index.php?topic=95456.msg313535#msg313535
hi
just followed the steps listed in the link you posted. still i have no products or categories.... for some reason i still cannot download a new version of virtuemart. the link http://dev.virtuemart.net/attachments/download/370/com_virtuemart.2.0.0_extract_first.zip (http://dev.virtuemart.net/attachments/download/370/com_virtuemart.2.0.0_extract_first.zip) seems to be dead. could it be that when i tried to do the update it somehow did not pull down the entire component update?
the link works now
redownloaded both the AIO and main component. i updated the modules and plugins manually but still nothing?
ronin75
send me your login details via pm. This is going to be something small.,
look in your database for these
attached. all the products in the products table, should also be in the products_en_gb table.
[attachment cleanup by admin]
also, if you are not going to use more than one language you dont have to check english in vmart admin.
Run the migrator and see what happens.
RUN a backup first
hi thank you for your help so far. i looked at the table structure and there are no products in the virtuemart_product_en_gb table. so i exported the data in the virtuemart_product table and tried an import in the virtuemart_product_en_gb table, however i get the following error: #1062 - Duplicate entry '1' for key 'PRIMARY'. this is because a record with the same id already exists.
does the data in the virtuemart_product_en_gb table not have to be exactly the same? if so how are the primary keys set in this table?
the main products table holds most the into
the en_gb tabel only has like 5 fields
ok so i copied the products table and created a new products_en_gb table. (the old one renamed just in case). my products are now showing in the backend but no product name, price, etc.. basically only the sku and image. i tried a migration but no luck too...
Quote from: BanquetTables.pro on December 27, 2011, 18:49:01 PM
also, if you are not going to use more than one language you dont have to check english in vmart admin.
^^^^^^ you are enabling multilangiage when you choose english in virtuemart/configuration. DISABLE multilangiuage
The default joomla language will take care of that for you
I had this same problem. All of my products categories and some other fields have been deleted. When I used the automated updated I received an error message but didn't copy it down.
Hopefully I can revert to a backed up version. I updated another one of my sites and had no issues with that one.
I have no multi langiage updated.
Quote from: BanquetTables.pro on December 27, 2011, 21:32:26 PM
Quote from: BanquetTables.pro on December 27, 2011, 18:49:01 PM
also, if you are not going to use more than one language you dont have to check english in vmart admin.
^^^^^^ you are enabling multilangiage when you choose english in virtuemart/configuration. DISABLE multilangiuage
The default joomla language will take care of that for you
Oh that is a missunderstanding. It is other way round. VirtueMart 2 is always multilanguage. To migrate the data you must choose the right language in joomla, because there is no vm language tag.
After migration, the new tables get created, when you store them in the config.
So you should choose your main language and store the config. The right tables should be generated then. Maybe we wrote a fallback method, when no language is chosen (sorry I dont remember is atm also not really important).
When you your data is missing after migration, you need the backup. Because all lang related stuff is deleted after the porting the data.
Quote from: ronin75 on December 27, 2011, 21:00:58 PM
ok so i copied the products table and created a new products_en_gb table. (the old one renamed just in case). my products are now showing in the backend but no product name, price, etc.. basically only the sku and image. i tried a migration but no luck too...
^^ ?
I think there is a missunderstanding. The language tables hold all data like product names, description, etc, ... So you cant get doubled names. When you get doubled entries it means there was a kind of data port.
In general the id is the same,... both tables use the same id for their primary key. btw you should update to RC2 M first! Hmm that stands in the topic. Maybe your script time is too short... not enough ram.
Hi Milbo
thank you for clarifying that. however, at present i have no real backup for this specific site to fall back onto (personal system crashed, busy restoring) i will get a backup from my host. regardless, all my data is in the products table. is there no other way to get it into the products_en_gb table?
When alll your data is in the products table, the whole upgrade process was not executed.
Quote from: ronin75 on December 28, 2011, 05:52:27 AM
Hi Milbo
thank you for clarifying that. however, at present i have no real backup for this specific site to fall back onto (personal system crashed, busy restoring) i will get a backup from my host. regardless, all my data is in the products table. is there no other way to get it into the products_en_gb table?
ronin, please install akeeba backup for future use.
I'm using JM 1.7.0 and VM 1.9.8G
I'm having the same problem. I've fixed some of it, but not all. Here's where I am:
I could not get the VM2 upgrade to install by clicking on the upgrade button from inside the component. I kept receiving errors and freeze-ups. So I first exported up my VM sql tables and ran an Akeeba backup. I had to use phpmyadmin/mysql and drop all VM tables then click on the upgrade button in the component, to get VM to update from 1.9.8G to 2.0.
Once the component had updated, I chose English (UK) from the Configuration page (I did not have a language selected prior to the upgrade, as I could not find the option in 1.9.8G). Next I imported the sql file that I had previously exported, to replace all of my data. The tables were all recreated correctly, but the products still did not show up in the front-end or back-end. I checked and the 'virtuemart_products' table was complete but the 'virtuemart_products_en_gb' table was empty and only showed about 7 fields (as ronin75 described)
I then dropped the 'virtuemart_products_en_gb' table and went into VM Tools & Migration and clicked on 'Install tables or if necessary update them'. This created the 'virtuemart_products_en_gb' table with the correct number of fields in place, but there were no entries. I then ran a migration and still there were no entries. I then exported the 'virtuemart_products' table as an .sql file then imported it as the 'virtuemart_products_en_gb' table, after modifing it so it would write to the correct table. That finally allowed all the products to show up in the back-end, but I still have nothing showing up in the front-end. I can click on the shop and see the categories and category images, but there are no products showing up under any of the categories. How can I get the site to populate correctly? I can not send you a link to the site, because I'm running the tests on my local machine, until I get the whole thing to work properly, then I'll just upload a working Akeeba file to the live site.
Thanks for your help!
This cant work.
Why you do not use the instructions? Here http://forum.virtuemart.net/index.php?topic=94183.0
You should NOT export the tables and then re import them.
Just go in the joomla installation, and install vm2 over the old one, do NOT uninstall vm2, do NOT delete tables and so on.
hi Milbo
just tried that... nothing! it doesnt work.
ronin, was this a migration?
you could do what this guy did
http://forum.virtuemart.net/index.php?topic=95557.0;topicseen
AFTER you backup with akeeba
this was an upgrade.
Quote from: Milbo on December 29, 2011, 16:19:42 PM
This cant work.
Why you do not use the instructions? Here http://forum.virtuemart.net/index.php?topic=94183.0
You should NOT export the tables and then re import them.
Just go in the joomla installation, and install vm2 over the old one, do NOT uninstall vm2, do NOT delete tables and so on.
Milbo, I can't install vm2 over vm1.9.8g, it starts the process then goes to a white screen and freezes up. I've tried it through the VM component upgrade button and through Joomla's installer and get the same results. I tried the steps you listed in the link above but I still get the same problem. The ONLY way I've been able to get a successful upgrade from 1.9.8G to 2.0 is to completely remove the VM tables first. I can send you a Dropbox link to my Akeeba backup so you can see the issue (but it's 1.5GB) How else can this be done? I can't go from 1.9.8g to anything else without removing my tables first, so is there a script or something I can run which will put my products back in, other than the way I'm doing it now?
Quote from: ronin75 on December 29, 2011, 18:47:55 PM
this was an upgrade.
BUT, was it an upgrade AFTER you migrated 1.1 products? or did you start from 2.0 scratch?
BanquetTables.Pro, i started the shop in 1.9.8H then upgraded through the releases - last version was 1.9.8M. then i did the automatic upgrade from the backend 1.9.8M to 2.0.0 which led my current predicament. following the advice so far i have :
looked at the virtuemart_products table and found all my data there
looked at virtuemart_products_en_gb table and found only 7 rows there with standard fields in it.
enabled the multi-language checkbox, selected "enable data update tools" and tried an "install tables and if necessary update them" - no result
tried migrating, increase max-execution time - no result
tried installing over current installation then "install tables and if necessary update them" - no result
i'm at my wits end...
Ok, I've followed all of my previous steps (removing tables to do the upgrade, etc.) but this time I completely uninstalled both Akeeba and VM first. Then I did a VM2 install (component and aio), then imported my tables back to the DB, then added the fields from my 'virtuemart_products' table into my 'virtuemart_products_en_gb' table, (which put them back into my front-end but not my back-end) then clicked on the 'Synchronize Media' button and finally the 'Renew Config by File' button and IT WORKED!!!!! My products are now visible in the front-end as well!!
The only issues are:
1. VM does not appear in the backend menu under components, I have to type in the url manually to get to the VM component.
2. I can't access the Shipping menu. When I click on it, I get the following error: Fatal Error in maincontroller admin.virtuemart.php: Couldnt find file shippingcarrier
It also does not appear properly in the menu. Instead of displaying the icon and normal text, it displays COM_VIRTUEMART_SHIPPINGCARRIEER_S (as pictured in the attachement)
3. I can't access the Credit Card menu. When I click on it, I get the following error: Fatal Error in maincontroller admin.virtuemart.php: Couldnt find file creditcard
It also does not appear properly in the menu. Instead of displaying the icon and normal text, it displays COM_VIRTUEMART_CREDIT_CARD_S (as pictured in the attachement)
Do you know how I can fix these last three issues?
[attachment cleanup by admin]
I just found one more issue: Under the Vendor page, if I make changes to the Terms of Service, the changes go away after I click Save and it reverts to the previous state.
Quote from: atedder on December 29, 2011, 20:29:39 PM
I just found one more issue: Under the Vendor page, if I make changes to the Terms of Service, the changes go away after I click Save and it reverts to the previous state.
are you super admin? vendor?
Superadmin.
try going to migration,. and set the storeowner id to yours
BanquetTables.pro, I went to migration and set the storeowner id to mine, and now the entire tab under 'Store' (I think it's called vendor) where you enter the language, terms, etc., is now completely gone. How can I get it back?
I'm experiencing the same issue upgrading from 1.98.M on JM 1.7.3.
I attached a screenshot of am getting error which I think has to to with the products not showing.
I've done the step describe here http://forum.virtuemart.net/index.php?topic=95456.msg313535#msg313535.
I'm going to restore my backup again and try to do this manually.
Anyone solve this yet?
Thanks .
Kory
www.2wheeladventures.com (http://www.2wheeladventures.com)
[attachment cleanup by admin]
The manual install worked.
Keep in mind, it overwrites your views so any changes you made, you have to redo.
Take care and Happy New Year!
Kory
Quote from: kory27 on December 31, 2011, 22:58:56 PM
Keep in mind, it overwrites your views so any changes you made, you have to redo.
you should do a template override
Quote from: BanquetTables.pro on December 29, 2011, 22:01:23 PM
try going to migration,. and set the storeowner id to yours
BanquetTables.pro, I went to migration and set the storeowner id to mine, and now the entire tab under 'Store' (I think it's called vendor) where you enter the language, terms, etc., is now completely gone. How can I get it back? Please reply, it's been several days and I really need to get this site running for my client.
go back to shoppers and click "is vendor"
Thank you, that brought it back. My previous issues are still unaddressed however. Do you have a fix for the following:
1. VM does not appear in the backend menu under components, I have to type in the url manually to get to the VM component.
2. I can't access the Shipping menu. When I click on it, I get the following error: Fatal Error in maincontroller admin.virtuemart.php: Couldnt find file shippingcarrier
It also does not appear properly in the menu. Instead of displaying the icon and normal text, it displays COM_VIRTUEMART_SHIPPINGCARRIEER_S (as pictured in the attachement of previous post)
3. I can't access the Credit Card menu. When I click on it, I get the following error: Fatal Error in maincontroller admin.virtuemart.php: Couldnt find file creditcard
It also does not appear properly in the menu. Instead of displaying the icon and normal text, it displays COM_VIRTUEMART_CREDIT_CARD_S (as pictured in the attachement of previous post)
Do you know how I can fix these last three issues?
attached is an sql of the admin menu entries.
You could try to run it. the table prefix is ppp_
Make sure you backup first
[attachment cleanup by admin]