I am trying to connecting myphpadmin database with VM2 and I have no clue. I restored my database file into my cpanel but now the products and contents do not show in VM2. I will appreciate some input, directions, or suggested extensions.
phpMyAdmin is not a database. It is a tool to handle the administration of MySQL. I assume Joomla still connects to the database? Use phpMyAdmin to look to check that the VM tables still exist in the db.
Instructions for use are on http://www.phpmyadmin.net
I guess I am using the wrong phrase but I am still unable to get my products back into VM2 after I changed from J1.523/VM 1.5 to J1.7/VM2. Before that I backed up my database, uninstalled both old Joomla and VM, then installed the latest combo.
Then, I uploaded the database containing my products but it's not showing up in VM. So I will appreciate any help in that regard.
Did you follow the migration instructions?
http://forum.virtuemart.net/index.php?topic=95236.0
http://forum.virtuemart.net/index.php?topic=95513.0
Thank you so much jenkinhill for taking the time to reply. I did everything before except the last two steps of the migration process which I did know before. Now I did it and here is the long list of messages I got. Good thing is they are not the dreaded red lettered error messages but still, not a good message I was looking for. Here they are:
Found prior migration process, resume migration maxScriptTime 23 maxMemoryLimit 89.6
Synchronized 0 media for product in directory images/stories/virtuemart/product/
Synchronized 0 media for category in directory images/stories/virtuemart/category/
Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
_productPorter Table 'hotitem1_jml1.jml_vm_product' doesn't exist SQL=SELECT * FROM jml_vm_product AS `p` LEFT JOIN jml_vm_product_price ON jml_vm_product_price.product_id = `p`.product_id LEFT JOIN jml_vm_product_mf_xref ON jml_vm_product_mf_xref.product_id = `p`.product_id LIMIT 0,7700
Worked on migration for 0.0315039157867 seconds
Migration finished
Info: No Shoppergroup table found for migration
Info: No vm_category table found for migration
Info: Migration: 0 orders processed
I went to my phpadmin and I could find all the products and other components but they are not linking to VM2.
is the table prefix the same with the joomla installation and the _vm tables?
If not, export the old vmart tables
_vm
open with notepad. Then do a replace to change the table prefix to the same one that your joomla installation is using.
Import the file. Then run the migrator.
ALSO; also, you can try to run the migrator with ONLY "products" checked. Then with only "orders" checked
Thanks Banquet for your reply.
I did as advised but still getting the following error messages:
Found prior migration process, resume migration maxScriptTime 23 maxMemoryLimit 89.6
Synchronized 0 media for product in directory images/stories/virtuemart/product/
Synchronized 0 media for category in directory images/stories/virtuemart/category/
Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
Processed 0 vm1 shoppergroups time: 1.50203704834E-5
Looks everything worked correct, migrated 0 categories
No categories to import
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
_productPorter Table 'hotitem1_jml1.jml_vm_product' doesn't exist SQL=SELECT * FROM jml_vm_product AS `p` LEFT JOIN jml_vm_product_price ON jml_vm_product_price.product_id = `p`.product_id LEFT JOIN jml_vm_product_mf_xref ON jml_vm_product_mf_xref.product_id = `p`.product_id LIMIT 0,7600
Worked on migration for 0.132452964783 seconds
Migration finished
Info: portUsers getMigrationProgress shoppergroups
Info: Migration: 0 orders processed
vmError: port Orders db error Table 'hotitem1_jml1.jml_vm_orders' doesn't exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `jml_vm_orders` as `o` LEFT OUTER JOIN `jml_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `jml_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,7600
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,7600
It's saying products don't exist but I could find all my products listed under J17_vm but is not brought into VM2. If I know how to link this file to VM, it will be great and I think it will work.
Quote from: BanquetTables.pro on January 07, 2012, 20:27:52 PM
ALSO; also, you can try to run the migrator with ONLY "products" checked. Then with only "orders" checked
^^^^^
and keep clicking it a few times until they are all done
This is insanity. I did this over and over again for quite a while but nothing happens. No results! Guess that defines insanity. I still hope someone will have a clue to this.
are you using J1.7? do you have it set to mysql or mysqli ?
Yes, I am using J1.7 and MySQL
http://www.albanypurewaterfilters.com
Sent from my iPhone using
I am getting to close to resolving my issues but here is one I could not find after hundreds of googling. I have an sql file named j17_vm_product that I would like to jml_virtuemart_products to be able to show up in virtuemart products. I have dozens of products in this sql file but it's not showing up in VM2. Should I simply rename the file?
NO, 1.1 and 2.0 database is different.
The migrator looks for tables that start with
_vm and then convertes them to the right format for 2.0 and puts them in the _virtuemart table
So why is the j17_vm not migrating?
what is your table prefix?
I have jml_ from Joomla installation and j17_ which I imported from the previous set up
Sent from my iPhone
Quote from: BanquetTables.pro on January 07, 2012, 20:27:52 PM
is the table prefix the same with the joomla installation and the _vm tables?
If not, export the old vmart tables
_vm
open with notepad. Then do a replace to change the table prefix to the same one that your joomla installation is using.
Import the file. Then run the migrator.
ALSO; also, you can try to run the migrator with ONLY "products" checked. Then with only "orders" checked
^^^^^
Great! I will try and do that and hopefully I will have a successful report back to the forum. Thanks again.
Sent from my iPhone
Well, Thank you again BanquetTables.pro for your help. I imported the tables into a text editor as suggested and renamed all the j17 to jml. I was able to migrate most of the virtuemart tables but still had some error messages. I was able to also identify what tables were giving the errors and I have been spending most of my free times manually deleting or dropping those problem tables.
While there are no more error messages, most of my extensions did not show up in the extension manager though they are native to JM 1.7. I have Easyblog and JV-LinkDirectory which are both native to JM 1.7; I will appreciate if anyone can explain how to make them show in the extension manager.
Go to extem
Nsion manage and discover